pgBadger-
Global information
- Generated on Thu May 18 23:50:33 2023
- Log file: /var/log/postgresql/postgresql-14-main.log
- Parsed 155,520 log entries in 31s
- Log start from 2023-05-17 00:04:23 to 2023-05-17 23:59:10
-
Overview
Global Stats
- 949 Number of unique normalized queries
- 55,820 Number of queries
- 5h53m11s Total query duration
- 2023-05-17 00:04:23 First query
- 2023-05-17 23:59:10 Last query
- 56 queries/s at 2023-05-17 17:15:45 Query peak
- 5h53m11s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 5h53m11s Execute total duration
- 1,566 Number of events
- 11 Number of unique normalized events
- 811 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 0 Total number of sessions
- 0 sessions at Session peak
- 0ms Total duration of sessions
- 0ms Average duration of sessions
- 55,820 Average queries per session
- 5h53m11s Average queries duration per session
- n/a Average idle time per session
- 0 Total number of connections
- 1 Total number of databases
SQL Traffic
Key values
- 56 queries/s Query Peak
- 2023-05-17 17:15:45 Date
SELECT Traffic
Key values
- 56 queries/s Query Peak
- 2023-05-17 17:15:45 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 11 queries/s Query Peak
- 2023-05-17 14:57:04 Date
Queries duration
Key values
- 5h53m11s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 17 00 614 0ms 7s990ms 311ms 11s548ms 12s501ms 14s300ms 01 291 0ms 3s465ms 192ms 7s881ms 8s424ms 8s424ms 02 370 0ms 345ms 159ms 11s741ms 13s145ms 13s145ms 03 381 0ms 289ms 159ms 8s189ms 8s658ms 8s658ms 04 215 0ms 907ms 163ms 5s706ms 6s748ms 6s748ms 05 391 0ms 367ms 165ms 4s917ms 5s797ms 14s255ms 06 422 0ms 289ms 161ms 6s668ms 8s835ms 10s994ms 07 303 0ms 7s994ms 200ms 6s57ms 6s199ms 9s103ms 08 362 0ms 2s454ms 170ms 5s111ms 6s465ms 7s674ms 09 638 0ms 3m36s 1s50ms 58s987ms 1m6s 3m59s 10 269 0ms 21s330ms 487ms 7s268ms 21s264ms 33s157ms 11 2,518 0ms 4s887ms 388ms 33s20ms 54s434ms 1m30s 12 5,883 120ms 10s721ms 363ms 1m2s 1m6s 1m34s 13 6,329 120ms 7s464ms 355ms 1m3s 1m14s 1m30s 14 6,047 120ms 44s380ms 398ms 1m12s 1m26s 1m57s 15 6,468 120ms 11s615ms 376ms 1m18s 1m31s 1m38s 16 4,108 120ms 7s99ms 374ms 47s712ms 52s274ms 57s725ms 17 6,102 120ms 12s868ms 389ms 1m5s 1m16s 1m33s 18 5,443 120ms 18s499ms 429ms 1m8s 1m12s 1m32s 19 4,727 120ms 13s800ms 405ms 57s932ms 1m15s 1m28s 20 1,989 0ms 3s214ms 394ms 26s99ms 36s646ms 50s144ms 21 736 121ms 32s294ms 398ms 16s186ms 19s849ms 39s902ms 22 557 0ms 1s387ms 212ms 8s806ms 12s260ms 16s450ms 23 657 0ms 7s992ms 220ms 9s79ms 12s58ms 12s837ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 17 00 608 0 275ms 8s703ms 9s140ms 12s488ms 01 286 0 166ms 6s600ms 7s229ms 7s881ms 02 370 0 159ms 10s377ms 11s741ms 13s145ms 03 381 0 159ms 7s67ms 8s189ms 8s658ms 04 213 0 161ms 5s109ms 5s706ms 6s748ms 05 391 0 165ms 4s193ms 4s917ms 14s255ms 06 422 0 161ms 4s359ms 6s668ms 10s994ms 07 299 0 165ms 3s340ms 6s39ms 6s199ms 08 360 0 170ms 4s144ms 5s111ms 7s674ms 09 448 68 1s179ms 11s689ms 58s987ms 3m59s 10 219 0 310ms 3s538ms 4s383ms 19s162ms 11 1,931 0 396ms 17s699ms 27s718ms 1m 12 3,991 0 361ms 35s775ms 46s703ms 52s220ms 13 4,049 0 342ms 30s379ms 38s623ms 55s596ms 14 3,842 0 383ms 35s279ms 51s166ms 1m18s 15 4,568 0 360ms 45s67ms 56s542ms 1m22s 16 3,073 0 354ms 26s733ms 32s492ms 44s679ms 17 3,349 0 366ms 29s756ms 36s268ms 43s590ms 18 3,389 0 413ms 35s44ms 40s534ms 57s831ms 19 2,813 0 360ms 25s508ms 30s103ms 41s332ms 20 1,473 0 389ms 17s388ms 19s471ms 32s76ms 21 457 0 337ms 4s897ms 6s820ms 22s627ms 22 506 0 201ms 4s6ms 6s67ms 15s783ms 23 630 0 196ms 4s940ms 8s805ms 12s837ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 17 00 0 0 6 0 3s948ms 0ms 0ms 7s597ms 01 0 0 5 0 1s684ms 0ms 0ms 8s424ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 2 0 0 337ms 0ms 0ms 674ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 4 0 2s813ms 0ms 0ms 2s152ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 120 0 0 508ms 219ms 498ms 24s342ms 10 0 26 14 0 1s526ms 0ms 1s571ms 16s880ms 11 56 506 5 0 369ms 2s382ms 5s127ms 15s189ms 12 85 1,622 19 0 384ms 10s420ms 14s833ms 29s773ms 13 102 1,964 13 0 396ms 14s236ms 20s166ms 31s939ms 14 97 1,907 18 0 444ms 13s813ms 22s817ms 41s859ms 15 54 1,568 21 0 448ms 11s894ms 19s230ms 38s579ms 16 46 875 16 0 457ms 6s489ms 11s764ms 19s232ms 17 88 2,399 22 0 436ms 19s701ms 28s571ms 43s538ms 18 100 1,760 66 0 473ms 14s133ms 23s146ms 36s597ms 19 76 1,604 44 0 499ms 12s59ms 23s601ms 45s390ms 20 7 439 1 0 434ms 2s448ms 6s796ms 12s378ms 21 2 272 3 0 501ms 445ms 7s428ms 11s597ms 22 10 41 0 0 322ms 0ms 805ms 1s827ms 23 0 19 6 0 815ms 0ms 0ms 3s155ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare May 17 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second May 17 00 0 0.00/s 01 0 0.00/s 02 0 0.00/s 03 0 0.00/s 04 0 0.00/s 05 0 0.00/s 06 0 0.00/s 07 0 0.00/s 08 0 0.00/s 09 0 0.00/s 10 0 0.00/s 11 0 0.00/s 12 0 0.00/s 13 0 0.00/s 14 0 0.00/s 15 0 0.00/s 16 0 0.00/s 17 0 0.00/s 18 0 0.00/s 19 0 0.00/s 20 0 0.00/s 21 0 0.00/s 22 0 0.00/s 23 0 0.00/s Day Hour Count Average Duration Average idle time May 17 00 0 0ms 0ms 01 0 0ms 0ms 02 0 0ms 0ms 03 0 0ms 0ms 04 0 0ms 0ms 05 0 0ms 0ms 06 0 0ms 0ms 07 0 0ms 0ms 08 0 0ms 0ms 09 0 0ms 0ms 10 0 0ms 0ms 11 0 0ms 0ms 12 0 0ms 0ms 13 0 0ms 0ms 14 0 0ms 0ms 15 0 0ms 0ms 16 0 0ms 0ms 17 0 0ms 0ms 18 0 0ms 0ms 19 0 0ms 0ms 20 0 0ms 0ms 21 0 0ms 0ms 22 0 0ms 0ms 23 0 0ms 0ms -
Connections
Established Connections
Key values
- 0 connections Connection Peak
- Date
Connections per database
Key values
- unknown Main Database
- 0 connections Total
Connections per user
Key values
- unknown Main User
- 0 connections Total
-
Sessions
Simultaneous sessions
Key values
- 0 sessions Session Peak
- Date
Histogram of session times
Key values
- duration
Sessions per database
Key values
- unknown Main Database
- 0 sessions Total
Sessions per user
Key values
- unknown Main User
- 0 sessions Total
Sessions per host
Key values
- unknown Main Host
- 0 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 0 buffers Checkpoint Peak
- Date
- seconds Highest write time
- seconds Sync time
Checkpoint write buffers (5 minutes period)
NO DATASET
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- Date
Checkpoint Wal files usage (5 minutes period)
NO DATASET
Checkpoints distance
Key values
- 0 Mo Distance Peak
- Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time May 17 00 0 0s 0s 0s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 0 0s 0s 0s 04 0 0s 0s 0s 05 0 0s 0s 0s 06 0 0s 0s 0s 07 0 0s 0s 0s 08 0 0s 0s 0s 09 0 0s 0s 0s 10 0 0s 0s 0s 11 0 0s 0s 0s 12 0 0s 0s 0s 13 0 0s 0s 0s 14 0 0s 0s 0s 15 0 0s 0s 0s 16 0 0s 0s 0s 17 0 0s 0s 0s 18 0 0s 0s 0s 19 0 0s 0s 0s 20 0 0s 0s 0s 21 0 0s 0s 0s 22 0 0s 0s 0s 23 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 17 00 0 0 0 0 0s 0s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 0 0 0s 0s 04 0 0 0 0 0s 0s 05 0 0 0 0 0s 0s 06 0 0 0 0 0s 0s 07 0 0 0 0 0s 0s 08 0 0 0 0 0s 0s 09 0 0 0 0 0s 0s 10 0 0 0 0 0s 0s 11 0 0 0 0 0s 0s 12 0 0 0 0 0s 0s 13 0 0 0 0 0s 0s 14 0 0 0 0 0s 0s 15 0 0 0 0 0s 0s 16 0 0 0 0 0s 0s 17 0 0 0 0 0s 0s 18 0 0 0 0 0s 0s 19 0 0 0 0 0s 0s 20 0 0 0 0 0s 0s 21 0 0 0 0 0s 0s 22 0 0 0 0 0s 0s 23 0 0 0 0 0s 0s Day Hour Count Avg time (sec) May 17 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate May 17 00 0.00 kB 0.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 0.00 kB 0.00 kB 04 0.00 kB 0.00 kB 05 0.00 kB 0.00 kB 06 0.00 kB 0.00 kB 07 0.00 kB 0.00 kB 08 0.00 kB 0.00 kB 09 0.00 kB 0.00 kB 10 0.00 kB 0.00 kB 11 0.00 kB 0.00 kB 12 0.00 kB 0.00 kB 13 0.00 kB 0.00 kB 14 0.00 kB 0.00 kB 15 0.00 kB 0.00 kB 16 0.00 kB 0.00 kB 17 0.00 kB 0.00 kB 18 0.00 kB 0.00 kB 19 0.00 kB 0.00 kB 20 0.00 kB 0.00 kB 21 0.00 kB 0.00 kB 22 0.00 kB 0.00 kB 23 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size May 17 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs May 17 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 43 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 30 1m52s 1s74ms 10s837ms 3s740ms update account_move set write_date = write_date where id = ( select id from account_move where journal_id = ? and name != ? and sequence_prefix !~ ? and move_type not in (...) and id != ? and sequence_prefix = ( select sequence_prefix from account_move where journal_id = ? and name != ? and sequence_prefix !~ ? and move_type not in (...) and id != ? order by id desc limit ?) order by sequence_number desc limit ?) returning name;-
UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 641433 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 641433 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;
Date: 2023-05-17 12:33:20
2 8 28s320ms 1s21ms 9s97ms 3s540ms update "account_move" set "message_main_attachment_id" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);-
UPDATE "account_move" SET "message_main_attachment_id" = 2530305, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (641608);
Date: 2023-05-17 12:58:25
3 3 12s940ms 1s264ms 7s948ms 4s313ms update "account_move" set "access_token" = ?, "is_move_sent" = true, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);-
UPDATE "account_move" SET "access_token" = 'ac7c6869-82ee-48fc-9a68-f1822f466092', "is_move_sent" = true, "write_uid" = 971, "write_date" = (now() at time zone 'UTC') WHERE id IN (641462);
Date: 2023-05-17 12:41:59
4 1 2s453ms 2s453ms 2s453ms 2s453ms select "ir_model_fields".id from "ir_model_fields" where ("ir_model_fields"."model" = ?) order by "ir_model_fields"."name";-
SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.template') ORDER BY "ir_model_fields"."name";
Date: 2023-05-17 08:12:27
-
SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.template') ORDER BY "ir_model_fields"."name";
Date: 2023-05-17 08:12:27
5 1 2s396ms 2s396ms 2s396ms 2s396ms update "account_move" set "access_token" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);-
UPDATE "account_move" SET "access_token" = 'f27457d9-4528-4de4-92bb-a981ad4f02a0', "write_uid" = 1035, "write_date" = (now() at time zone 'UTC') WHERE id IN (642522);
Date: 2023-05-17 15:08:47
Queries that waited the most
Rank Wait time Query 1 10s837ms UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 641659 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 641659 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2023-05-17 13:02:36 ]
2 9s97ms UPDATE "account_move" SET "message_main_attachment_id" = 2531222, "write_uid" = 958, "write_date" = (now() at time zone 'UTC') WHERE id IN (642040);[ Date: 2023-05-17 13:51:45 ]
3 7s948ms UPDATE "account_move" SET "access_token" = '9fb0e905-b2b2-4da8-94f2-d765430eff5b', "is_move_sent" = true, "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (642216);[ Date: 2023-05-17 14:30:21 ]
4 7s813ms UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 627257 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 627257 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2023-05-17 15:57:17 ]
5 7s54ms UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 642179 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 642179 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2023-05-17 14:22:53 ]
6 6s320ms UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 641571 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 641571 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2023-05-17 12:56:53 ]
7 6s189ms UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 642687 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 642687 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2023-05-17 15:34:05 ]
8 5s791ms UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 641607 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 641607 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2023-05-17 12:58:25 ]
9 5s472ms UPDATE "account_move" SET "message_main_attachment_id" = 2530987, "write_uid" = 994, "write_date" = (now() at time zone 'UTC') WHERE id IN (641884);[ Date: 2023-05-17 13:31:19 ]
10 5s172ms UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 643445 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 643445 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2023-05-17 17:47:27 ]
11 4s987ms UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 642783 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 642783 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2023-05-17 15:51:59 ]
12 4s227ms UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 641524 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 641524 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2023-05-17 12:50:09 ]
13 4s103ms UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 641929 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 641929 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2023-05-17 13:40:13 ]
14 3s993ms UPDATE "account_move" SET "message_main_attachment_id" = 2530305, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (641608);[ Date: 2023-05-17 12:58:25 ]
15 3s946ms UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 643995 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 643995 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2023-05-17 19:16:19 ]
16 3s727ms UPDATE "account_move" SET "access_token" = '16197e0c-f21e-4ae9-b273-c7a05b2077f8', "is_move_sent" = true, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (641547);[ Date: 2023-05-17 12:54:44 ]
17 3s547ms UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 641842 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 641842 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2023-05-17 13:23:41 ]
18 3s287ms UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 641433 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 641433 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2023-05-17 12:33:20 ]
19 3s233ms UPDATE "account_move" SET "message_main_attachment_id" = 2531721, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (642290);[ Date: 2023-05-17 14:42:12 ]
20 3s54ms UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 642191 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 642191 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2023-05-17 14:23:57 ]
-
Queries
Queries by type
Key values
- 38,068 Total read queries
- 17,752 Total write queries
Queries by database
Key values
- unknown Main database
- 55,820 Requests
- 5h53m11s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 55,822 Requests
User Request type Count Duration unknown Total 55,822 5h53m13s copy to 68 8m10s cte 1,574 5m38s delete 265 8m8s insert 723 4m select 38,068 3h39m58s update 15,124 1h47m16s Duration by user
Key values
- 5h53m13s (unknown) Main time consuming user
User Request type Count Duration unknown Total 55,822 5h53m13s copy to 68 8m10s cte 1,574 5m38s delete 265 8m8s insert 723 4m select 38,068 3h39m58s update 15,124 1h47m16s Queries by host
Key values
- unknown Main host
- 55,822 Requests
- 5h53m13s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 55,820 Requests
- 5h53m11s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2023-05-17 17:53:54 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 41,426 100-500ms duration
Slowest individual queries
Rank Duration Query 1 3m36s COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2023-05-17 09:06:35 ]
2 1m5s COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;[ Date: 2023-05-17 09:02:58 ]
3 1m4s COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;[ Date: 2023-05-17 09:01:50 ]
4 44s380ms SELECT "mail_message".id FROM "mail_message" WHERE ((unaccent ("mail_message"."subject"::text) ilike unaccent ('%[email protected]%')) OR (unaccent ("mail_message"."body"::text) ilike unaccent ('%[email protected]%'))) ORDER BY "mail_message"."id" DESC LIMIT 80;[ Date: 2023-05-17 14:38:27 ]
5 32s294ms DELETE FROM sale_order_line WHERE id IN (153984, 153987, 153997, 154024, 154029, 154030, 154031, 154033, 154034, 154039, 154047, 154048, 154052, 154054);[ Date: 2023-05-17 21:27:28 ]
6 21s330ms DELETE FROM account_move_line WHERE id IN (2314753, 2314754, 2314755, 2314756, 2314757, 2314758, 2314759, 2315084, 2315085, 2315086, 2315087, 2315088, 2315089, 2315090, 2315091, 2315092, 2315093, 2315094, 2315095, 2315096, 2315097, 2315098, 2315099, 2315100, 2315101, 2315102, 2315103, 2315104, 2315105, 2315106, 2315107, 2315108, 2315109, 2315110, 2315111, 2315112, 2315113, 2315114, 2315115, 2315116, 2315117, 2314894, 2314895);[ Date: 2023-05-17 10:23:34 ]
7 20s784ms COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage) TO stdout;[ Date: 2023-05-17 09:07:30 ]
8 19s611ms COPY public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) TO stdout;[ Date: 2023-05-17 09:08:18 ]
9 18s499ms UPDATE "stock_move" SET "date" = '2023-05-17 18:25:16', "state" = 'done', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (411027, 411028, 411029, 411030, 411031, 411035, 411052, 411053, 411055, 411065, 411067, 422589, 411069, 411071, 411072, 411073, 411074, 411077, 411078, 411086, 411087, 411093, 411096, 411102, 411103, 411105);[ Date: 2023-05-17 18:25:39 ]
10 13s800ms DELETE FROM sale_order_line WHERE id IN (42986, 43016, 43019, 43020, 43036, 43079);[ Date: 2023-05-17 19:07:25 ]
11 13s127ms UPDATE "stock_move" SET "date" = '2023-05-17 19:46:31', "state" = 'done', "write_uid" = 1237, "write_date" = (now() at time zone 'UTC') WHERE id IN (415541, 415542, 415544, 415545, 415546, 415547, 415548, 415549, 415550, 415551, 415554, 415555, 415556, 415557, 415558, 415559, 415560, 415561, 415562, 415563, 415564, 415565, 415566);[ Date: 2023-05-17 19:46:45 ]
12 13s2ms UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = true, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (404608, 404481, 404483, 404484, 404613, 404489, 404636, 404648, 404650, 404651, 404652, 404653, 404654, 404655, 404656, 404529, 404530, 404531, 404532, 404533, 404534, 404657, 404658, 404662, 404673, 404680, 404681, 404682, 404556, 404557, 404476, 404561, 404479, 422749, 422750, 404595, 404471, 404472, 404473, 404603, 404604, 404605, 404607);[ Date: 2023-05-17 19:06:54 ]
13 12s868ms UPDATE "stock_move" SET "date" = '2023-05-17 17:50:45', "state" = 'done', "write_uid" = 1006, "write_date" = (now() at time zone 'UTC') WHERE id IN (415569, 415570, 415571, 415572, 415574, 415575, 415576, 415577, 415579, 415580, 415581, 415582, 415583, 415584, 415585, 415586, 415587, 415588, 415589, 415590, 415591, 415592);[ Date: 2023-05-17 17:50:58 ]
14 11s967ms COPY public.account_move_line (id, move_id, move_name, date, ref, parent_state, journal_id, company_id, company_currency_id, account_id, account_root_id, sequence, name, quantity, price_unit, discount, debit, credit, balance, amount_currency, price_subtotal, price_total, reconciled, blocked, date_maturity, currency_id, partner_id, product_uom_id, product_id, reconcile_model_id, payment_id, statement_line_id, statement_id, tax_line_id, tax_group_id, tax_base_amount, tax_exigible, tax_repartition_line_id, tax_audit, amount_residual, amount_residual_currency, full_reconcile_id, matching_number, analytic_account_id, display_type, is_rounding_line, exclude_from_invoice_tab, create_uid, create_date, write_uid, write_date, expected_pay_date, internal_note, next_action_date, followup_line_id, followup_date, is_anglo_saxon_line, purchase_line_id, branch_id, branch_name, vehicle_id, move_options, sign_product_qty, sign_price_subtotal, new_product_qty, sale_line_id, child_sale_line_id, main_invoice_line_id, core_bank_transaction, is_rtv_line, core_qty, rebate_amount, cost_price, is_visible_in_report, is_labour, can_be_paid, bal_core_bank_id, repair_line_id, inv_back_order_qty, sale_back_order_qty, product_pricelist_item_id) TO stdout;[ Date: 2023-05-17 09:00:21 ]
15 11s886ms COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;[ Date: 2023-05-17 09:07:58 ]
16 11s615ms UPDATE "stock_move" SET "date" = '2023-05-17 15:53:12', "state" = 'done', "write_uid" = 1007, "write_date" = (now() at time zone 'UTC') WHERE id IN (418720, 418721, 418722, 418723, 418724, 418725, 418726, 418727, 418728, 418729, 418730, 418731, 418732, 418733, 418734, 418735, 418736, 418737, 418739);[ Date: 2023-05-17 15:53:23 ]
17 11s485ms UPDATE "stock_move" SET "branch_id" = 48, "picking_id" = 146907, "related_core_purchase_line_id" = NULL, "related_core_repair_line_id" = NULL, "related_core_sale_line_id" = NULL, "scrapped" = false, "state" = 'confirmed', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (421683, 421684, 421685, 421686, 421687, 421688, 421689, 421690, 421691, 421692, 421693, 421694, 421695, 421696, 421697, 421698, 421699, 421700, 421701, 421702, 421703, 421704, 421705);[ Date: 2023-05-17 14:56:58 ]
18 11s135ms UPDATE "stock_move" SET "date" = '2023-05-17 17:36:28', "state" = 'done', "write_uid" = 1007, "write_date" = (now() at time zone 'UTC') WHERE id IN (417921, 417922, 417923, 417924, 417925, 417926, 417927, 417928, 417929, 417930, 417931, 417932, 417933, 417934, 417935, 417936, 417937, 417940, 417941);[ Date: 2023-05-17 17:36:39 ]
19 11s122ms UPDATE "stock_move" SET "date" = '2023-05-17 09:48:02', "state" = 'done', "write_uid" = 1018, "write_date" = (now() at time zone 'UTC') WHERE id IN (420928, 420929, 420930, 420931, 420932, 420933, 420914, 420917, 420920, 420921, 420922, 420923, 420924, 420927);[ Date: 2023-05-17 09:48:14 ]
20 11s48ms UPDATE "stock_move" SET "date" = '2023-05-17 15:53:41', "state" = 'done', "write_uid" = 1007, "write_date" = (now() at time zone 'UTC') WHERE id IN (418720, 418721, 418722, 418723, 418724, 418725, 418726, 418727, 418728, 418729, 418730, 418731, 418732, 418733, 418734, 418735, 418736, 418737, 418739);[ Date: 2023-05-17 15:53:52 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 42m59s 4,390 537ms 1s8ms 587ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where ((("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and ("product_product__product_tmpl_id"."sale_ok" is not null and "product_product__product_tmpl_id"."sale_ok" != false)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 17 09 96 55s156ms 574ms 11 275 2m38s 576ms 12 568 5m34s 588ms 13 661 6m32s 593ms 14 551 5m25s 591ms 15 445 4m20s 586ms 16 369 3m34s 581ms 17 413 4m4s 591ms 18 353 3m28s 589ms 19 421 4m8s 590ms 20 124 1m12s 582ms 21 91 51s560ms 566ms 22 23 13s466ms 585ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%361168%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%361-168%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%361-168%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 17:43:06 Duration: 1s8ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%qplae%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%qpl-a-e%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%qpl-a-e%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 19:36:49 Duration: 947ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%tv13%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%tv13%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%tv13%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 16:54:22 Duration: 941ms
2 26m40s 7,199 120ms 582ms 222ms select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 17 00 104 17s892ms 172ms 01 30 5s427ms 180ms 02 19 3s243ms 170ms 03 28 4s871ms 173ms 04 33 5s610ms 170ms 05 160 28s926ms 180ms 06 168 28s644ms 170ms 07 107 19s314ms 180ms 08 139 24s702ms 177ms 09 86 15s911ms 185ms 10 83 16s575ms 199ms 11 201 37s570ms 186ms 12 395 1m18s 197ms 13 741 2m33s 207ms 14 603 2m17s 227ms 15 771 2m49s 220ms 16 767 3m13s 252ms 17 662 2m30s 227ms 18 588 2m36s 266ms 19 579 2m38s 274ms 20 398 1m34s 237ms 21 128 23s725ms 185ms 22 149 27s206ms 182ms 23 260 48s353ms 185ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-17 15:51:37') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_990"', '["pointspring_master","calendar.alarm",19528]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",74]', '["pointspring_master","mail.channel",75]', '["pointspring_master","mail.channel",76]', '["pointspring_master","mail.channel",77]', '["pointspring_master","mail.channel",339]', '["pointspring_master","mail.channel",473]', '["pointspring_master","res.partner",19528]', '["pointspring_master","ir.needaction",19528]'))) ORDER BY "bus_bus"."id";
Date: 2023-05-17 15:52:27 Duration: 582ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-17 15:51:37') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1017"', '["pointspring_master","calendar.alarm",19555]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",36]', '["pointspring_master","mail.channel",41]', '["pointspring_master","mail.channel",42]', '["pointspring_master","mail.channel",503]', '["pointspring_master","res.partner",19555]', '["pointspring_master","ir.needaction",19555]'))) ORDER BY "bus_bus"."id";
Date: 2023-05-17 15:52:27 Duration: 575ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-17 15:51:37') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1015"', '["pointspring_master","calendar.alarm",19553]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",51]', '["pointspring_master","mail.channel",52]', '["pointspring_master","mail.channel",53]', '["pointspring_master","mail.channel",346]', '["pointspring_master","mail.channel",347]', '["pointspring_master","mail.channel",457]', '["pointspring_master","res.partner",19553]', '["pointspring_master","ir.needaction",19553]'))) ORDER BY "bus_bus"."id";
Date: 2023-05-17 15:52:27 Duration: 575ms
3 18m51s 6,579 160ms 656ms 171ms select "ir_attachment".id from "ir_attachment" where (("ir_attachment"."res_field" is null and (unaccent ("ir_attachment"."url"::text) like unaccent (?))) and (not ((unaccent ("ir_attachment"."url"::text) like unaccent (?))))) order by "ir_attachment"."id" desc;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 17 00 49 8s216ms 167ms 01 12 1s963ms 163ms 02 12 1s967ms 163ms 03 133 21s801ms 163ms 04 8 1s308ms 163ms 05 36 6s590ms 183ms 06 43 7s310ms 170ms 07 23 3s802ms 165ms 08 39 6s584ms 168ms 09 58 9s564ms 164ms 10 55 9s43ms 164ms 11 395 1m6s 169ms 12 977 2m49s 173ms 13 858 2m29s 174ms 14 662 1m53s 171ms 15 651 1m53s 174ms 16 432 1m13s 169ms 17 472 1m21s 173ms 18 542 1m34s 174ms 19 481 1m22s 171ms 20 361 1m 168ms 21 89 14s607ms 164ms 22 70 11s470ms 163ms 23 121 19s951ms 164ms -
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-9ded8a0/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-05-17 19:19:38 Duration: 656ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.report_assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-5826980/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-05-17 18:06:10 Duration: 604ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-fb6cd24/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-05-17 15:35:18 Duration: 539ms
4 12m24s 1,264 543ms 966ms 589ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where (("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 17 12 51 29s697ms 582ms 13 91 54s10ms 593ms 14 173 1m43s 595ms 15 114 1m7s 590ms 16 24 14s519ms 604ms 17 285 2m48s 589ms 18 305 2m59s 589ms 19 190 1m50s 581ms 20 26 14s887ms 572ms 23 5 2s808ms 561ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%43029%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%43029%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%43029%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 14:42:06 Duration: 966ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%119%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%119%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%119%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 15:20:50 Duration: 952ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%2531%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%2-53-1%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%2-53-1%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 14:59:01 Duration: 863ms
5 12m3s 1,715 288ms 817ms 421ms select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 17 10 1 349ms 349ms 11 113 36s973ms 327ms 12 246 1m30s 367ms 13 1 289ms 289ms 14 257 1m50s 429ms 15 1,047 7m50s 448ms 16 50 15s37ms 300ms -
select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;
Date: 2023-05-17 14:54:13 Duration: 817ms
-
select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;
Date: 2023-05-17 15:35:18 Duration: 737ms
-
select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;
Date: 2023-05-17 15:35:19 Duration: 735ms
6 11m45s 957 688ms 1s292ms 737ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (("product_template"."is_core" is null or "product_template"."is_core" = false) and (("product_template"."type" in (...)) and (((((unaccent ("product_template"."default_code"::text) ilike unaccent (?)) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null)))) or unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?)) or false) or (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent (?)))))) and (("product_template"."company_id" in (...)) or "product_template"."company_id" is null) order by coalesce("product_template__name"."value", "product_template"."name") limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 17 10 4 2s862ms 715ms 11 59 43s121ms 730ms 12 128 1m34s 734ms 13 122 1m30s 738ms 14 120 1m28s 738ms 15 118 1m28s 748ms 16 100 1m12s 729ms 17 61 45s19ms 738ms 18 111 1m22s 746ms 19 82 59s979ms 731ms 20 43 31s566ms 734ms 21 1 728ms 728ms 22 8 5s688ms 711ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%e-9524-r%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%e-9524-r%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%e-9524-r%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%e-9524-r%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-05-17 15:18:08 Duration: 1s292ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%565f%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%565f%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%565f%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%565f%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-05-17 15:18:10 Duration: 1s120ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%169107%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%169107%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%169107%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%169107%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-05-17 12:54:29 Duration: 1s78ms
7 8m13s 920 144ms 4s704ms 536ms update "stock_quant" set "quantity" = ?.?, "reserved_quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 17 09 9 6s508ms 723ms 10 5 2s14ms 402ms 11 12 7s47ms 587ms 12 105 56s362ms 536ms 13 170 1m33s 549ms 14 149 1m27s 584ms 15 76 40s137ms 528ms 16 48 28s990ms 603ms 17 148 1m8s 465ms 18 94 51s712ms 550ms 19 80 38s86ms 476ms 20 23 12s758ms 554ms 21 1 412ms 412ms -
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (295686, 295688, 296108, 295536, 295953, 295955, 295957, 295670, 295960, 295962, 295964);
Date: 2023-05-17 18:25:50 Duration: 4s704ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (140899, 234820, 269095, 141064, 145900, 275468, 276594, 141299);
Date: 2023-05-17 14:58:00 Duration: 4s82ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (298385, 298387, 295039);
Date: 2023-05-17 14:05:29 Duration: 2s525ms
8 7m27s 534 531ms 2s628ms 837ms update "stock_move" set "current_warehouse_qty" = ?.?, "date" = ?, "is_done" = true, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 17 10 1 706ms 706ms 11 5 4s31ms 806ms 12 71 57s996ms 816ms 13 93 1m25s 919ms 14 91 1m18s 858ms 15 65 54s527ms 838ms 16 26 23s75ms 887ms 17 68 53s178ms 782ms 18 33 25s555ms 774ms 19 42 31s440ms 748ms 20 38 32s495ms 855ms 21 1 707ms 707ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 1.0, "date" = '2023-05-17 13:01:55', "is_done" = true, "state" = 'done', "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (420968, 420966, 420975);
Date: 2023-05-17 13:02:01 Duration: 2s628ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 10.0, "date" = '2023-05-17 13:19:59', "is_done" = true, "state" = 'done', "write_uid" = 1028, "write_date" = (now() at time zone 'UTC') WHERE id IN (421329, 421331);
Date: 2023-05-17 13:20:09 Duration: 2s349ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "date" = '2023-05-17 14:12:56', "is_done" = true, "state" = 'done', "write_uid" = 1000, "write_date" = (now() at time zone 'UTC') WHERE id IN (421484, 421486);
Date: 2023-05-17 14:13:02 Duration: 2s292ms
9 6m40s 2,585 120ms 386ms 154ms select count(distinct (so.id)) as total_orders from sale_order as so left join sale_order_line as sol on sol.order_id = so.id left join product_warehouse_inventory as pwi on pwi.product_id = sol.product_id left join stock_warehouse as sw on sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= ?::timestamp and so.date_order <= ?::timestamp and sol.product_id = ? and so.state in (...) and so.warehouse_id = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 17 00 257 40s228ms 156ms 01 240 37s851ms 157ms 02 339 53s985ms 159ms 03 220 34s51ms 154ms 04 171 26s552ms 155ms 05 195 29s346ms 150ms 06 208 31s877ms 153ms 07 167 25s602ms 153ms 08 179 27s75ms 151ms 09 157 23s988ms 152ms 22 234 35s902ms 153ms 23 218 33s908ms 155ms -
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-11-17T22:30:01.838094'::timestamp and so.date_order <= '2023-05-17T22:30:01.838094'::timestamp and sol.product_id = 203207 and so.state in ('done', 'sale') and so.warehouse_id = 44;
Date: 2023-05-17 22:33:14 Duration: 386ms
-
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-11-17T00:30:09.593526'::timestamp and so.date_order <= '2023-05-17T00:30:09.593526'::timestamp and sol.product_id = 186487 and so.state in ('done', 'sale') and so.warehouse_id = 41;
Date: 2023-05-17 00:31:35 Duration: 368ms
-
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-11-17T02:30:06.402873'::timestamp and so.date_order <= '2023-05-17T02:30:06.402873'::timestamp and sol.product_id = 221179 and so.state in ('done', 'sale') and so.warehouse_id = 36;
Date: 2023-05-17 02:30:49 Duration: 345ms
10 6m21s 162 284ms 18s499ms 2s352ms update "stock_move" set "date" = ?, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 17 09 1 11s122ms 11s122ms 10 3 2s197ms 732ms 11 3 2s859ms 953ms 12 16 28s621ms 1s788ms 13 23 44s209ms 1s922ms 14 22 55s514ms 2s523ms 15 17 49s781ms 2s928ms 16 3 6s128ms 2s42ms 17 42 1m14s 1s781ms 18 14 48s520ms 3s465ms 19 15 53s713ms 3s580ms 20 3 3s619ms 1s206ms -
UPDATE "stock_move" SET "date" = '2023-05-17 18:25:16', "state" = 'done', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (411027, 411028, 411029, 411030, 411031, 411035, 411052, 411053, 411055, 411065, 411067, 422589, 411069, 411071, 411072, 411073, 411074, 411077, 411078, 411086, 411087, 411093, 411096, 411102, 411103, 411105);
Date: 2023-05-17 18:25:39 Duration: 18s499ms
-
UPDATE "stock_move" SET "date" = '2023-05-17 19:46:31', "state" = 'done', "write_uid" = 1237, "write_date" = (now() at time zone 'UTC') WHERE id IN (415541, 415542, 415544, 415545, 415546, 415547, 415548, 415549, 415550, 415551, 415554, 415555, 415556, 415557, 415558, 415559, 415560, 415561, 415562, 415563, 415564, 415565, 415566);
Date: 2023-05-17 19:46:45 Duration: 13s127ms
-
UPDATE "stock_move" SET "date" = '2023-05-17 17:50:45', "state" = 'done', "write_uid" = 1006, "write_date" = (now() at time zone 'UTC') WHERE id IN (415569, 415570, 415571, 415572, 415574, 415575, 415576, 415577, 415579, 415580, 415581, 415582, 415583, 415584, 415585, 415586, 415587, 415588, 415589, 415590, 415591, 415592);
Date: 2023-05-17 17:50:58 Duration: 12s868ms
11 5m50s 597 548ms 848ms 587ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 17 00 132 1m16s 579ms 11 15 8s622ms 574ms 12 30 17s195ms 573ms 13 45 26s609ms 591ms 14 48 28s55ms 584ms 15 94 56s416ms 600ms 16 41 24s82ms 587ms 17 25 15s38ms 601ms 18 126 1m14s 590ms 19 31 18s300ms 590ms 20 10 5s765ms 576ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%4707q%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4707q%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%4707q%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 15:58:35 Duration: 848ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%33050R%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%33050R%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%33050R%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 13:20:07 Duration: 777ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%wks4707%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%wks4707%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%wks4707%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 13:27:35 Duration: 748ms
12 5m46s 1,920 169ms 327ms 180ms select res_partner.id from "res_partner" where ("res_partner"."active" = true) and (((("res_partner"."partner_share" is null or "res_partner"."partner_share" = false) or ("res_partner"."company_id" in (...))) or "res_partner"."company_id" is null) and (((("res_partner"."type" != ?) or "res_partner"."type" is null) or "res_partner"."type" is null) or ("res_partner"."type" = ?))) and (unaccent (res_partner.email) ilike unaccent (?) or unaccent (res_partner.display_name) ilike unaccent (?) or unaccent (res_partner.ref) ilike unaccent (?) or unaccent (res_partner.vat) ilike unaccent (?)) unaccent (res_partner.display_name);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 17 07 1 174ms 174ms 10 8 1s435ms 179ms 11 17 2s972ms 174ms 12 186 33s94ms 177ms 13 203 36s639ms 180ms 14 251 46s16ms 183ms 15 309 55s983ms 181ms 16 199 35s408ms 177ms 17 176 32s177ms 182ms 18 240 43s312ms 180ms 19 267 47s885ms 179ms 20 35 6s245ms 178ms 21 21 3s629ms 172ms 22 5 880ms 176ms 23 2 347ms 173ms -
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%v-00918%') OR unaccent (res_partner.display_name) ilike unaccent ('%v-00918%') OR unaccent (res_partner.ref) ilike unaccent ('%v-00918%') OR unaccent (res_partner.vat) ilike unaccent ('v-00918')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%v-00918%') desc, unaccent (res_partner.display_name);
Date: 2023-05-17 14:51:45 Duration: 327ms
-
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%V2556%') OR unaccent (res_partner.display_name) ilike unaccent ('%V2556%') OR unaccent (res_partner.ref) ilike unaccent ('%V2556%') OR unaccent (res_partner.vat) ilike unaccent ('V2556')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%V2556%') desc, unaccent (res_partner.display_name);
Date: 2023-05-17 14:51:45 Duration: 324ms
-
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%V2549%') OR unaccent (res_partner.display_name) ilike unaccent ('%V2549%') OR unaccent (res_partner.ref) ilike unaccent ('%V2549%') OR unaccent (res_partner.vat) ilike unaccent ('V2549')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%V2549%') desc, unaccent (res_partner.display_name);
Date: 2023-05-17 14:53:18 Duration: 285ms
13 5m38s 377 410ms 5s167ms 896ms update "stock_move" set "date" = ?, "is_done" = true, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 17 10 1 700ms 700ms 11 6 5s614ms 935ms 12 33 26s15ms 788ms 13 83 1m1s 746ms 14 31 35s55ms 1s130ms 15 27 27s167ms 1s6ms 16 17 22s344ms 1s314ms 17 79 1m5s 825ms 18 57 53s328ms 935ms 19 34 34s755ms 1s22ms 20 9 5s897ms 655ms -
UPDATE "stock_move" SET "date" = '2023-05-17 18:59:05', "is_done" = true, "state" = 'done', "write_uid" = 952, "write_date" = (now() at time zone 'UTC') WHERE id IN (422724, 422725, 422726, 422727, 422731, 422732, 422735);
Date: 2023-05-17 18:59:21 Duration: 5s167ms
-
UPDATE "stock_move" SET "date" = '2023-05-17 17:15:43', "is_done" = true, "state" = 'done', "write_uid" = 979, "write_date" = (now() at time zone 'UTC') WHERE id IN (422122, 422123, 422124, 422125, 422126, 422127);
Date: 2023-05-17 17:16:01 Duration: 4s419ms
-
UPDATE "stock_move" SET "date" = '2023-05-17 16:33:31', "is_done" = true, "state" = 'done', "write_uid" = 1237, "write_date" = (now() at time zone 'UTC') WHERE id IN (416626, 416627, 416628, 416630, 416632, 416633);
Date: 2023-05-17 16:33:37 Duration: 4s351ms
14 5m35s 278 143ms 11s485ms 1s205ms update "stock_move" set "branch_id" = ?, "picking_id" = ?, "related_core_purchase_line_id" = ?, "related_core_repair_line_id" = ?, "related_core_sale_line_id" = ?, "scrapped" = false, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 17 09 1 9s258ms 9s258ms 11 13 20s573ms 1s582ms 12 41 46s981ms 1s145ms 13 33 32s296ms 978ms 14 31 1m 1s959ms 15 38 44s29ms 1s158ms 16 26 21s910ms 842ms 17 31 31s471ms 1s15ms 18 24 19s51ms 793ms 19 22 22s362ms 1s16ms 20 12 13s274ms 1s106ms 21 6 13s174ms 2s195ms -
UPDATE "stock_move" SET "branch_id" = 48, "picking_id" = 146907, "related_core_purchase_line_id" = NULL, "related_core_repair_line_id" = NULL, "related_core_sale_line_id" = NULL, "scrapped" = false, "state" = 'confirmed', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (421683, 421684, 421685, 421686, 421687, 421688, 421689, 421690, 421691, 421692, 421693, 421694, 421695, 421696, 421697, 421698, 421699, 421700, 421701, 421702, 421703, 421704, 421705);
Date: 2023-05-17 14:56:58 Duration: 11s485ms
-
UPDATE "stock_move" SET "branch_id" = 38, "picking_id" = 146428, "related_core_purchase_line_id" = NULL, "related_core_repair_line_id" = NULL, "related_core_sale_line_id" = NULL, "scrapped" = false, "state" = 'confirmed', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (420929, 420930, 420931, 420933, 420914, 420915, 420916, 420917, 420918, 420919, 420920, 420921, 420922, 420923, 420924, 420925, 420926, 420927);
Date: 2023-05-17 09:36:19 Duration: 9s258ms
-
UPDATE "stock_move" SET "branch_id" = 37, "picking_id" = 146868, "related_core_purchase_line_id" = NULL, "related_core_repair_line_id" = NULL, "related_core_sale_line_id" = NULL, "scrapped" = false, "state" = 'confirmed', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (421610, 421611, 421612, 421613, 421614, 421615, 421616, 421617, 421618, 421619, 421620, 421621, 421622, 421623, 421624, 421625);
Date: 2023-05-17 14:44:08 Duration: 6s734ms
15 5m10s 1,460 120ms 554ms 212ms with currency_rate as ( select r.currency_id, coalesce(r.company_id, c.id) as company_id, r.rate, r.name as date_start, ( select name from res_currency_rate r2 where r2.name > r.name and r2.currency_id = r.currency_id and (r2.company_id is null or r2.company_id = c.id) order by r2.name asc limit ?) as date_end from res_currency_rate r join res_company c on (r.company_id is null or r.company_id = c.id)) select l.product_id as product_id, sum(l.price_unit / ( case coalesce(cr.rate, ?) when ? then ?.? else cr.rate end) * l.quantity * ( case when i.move_type in (...) then ? else ? end) * ((? - l.discount) * ?.?)) / nullif (sum(l.quantity * ( case when i.move_type in (...) then ? else ? end)), ?) as avg_unit_price, sum(l.quantity * ( case when i.move_type in (...) then ? else ? end)) as num_qty, sum(abs(l.balance) * ( case when i.move_type in (...) then ? else ? end)) as total, sum(l.quantity * pt.list_price * ( case when i.move_type in (...) then ? else ? end)) as sale_expected from account_move_line l left join account_move i on (l.move_id = i.id) left join product_product product on (product.id = l.product_id) left join product_template pt on (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= coalesce(i.invoice_date, now()) and (cr.date_end is null or cr.date_end > coalesce(i.invoice_date, now()))) where l.product_id in (...) and i.state in (...) and i.payment_state in (...) and i.move_type in (...) and i.invoice_date between ? and ? and i.company_id = ? and l.display_type is null and l.exclude_from_invoice_tab = false group by l.product_id;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 17 08 2 415ms 207ms 09 2 461ms 230ms 10 10 2s166ms 216ms 11 20 4s329ms 216ms 12 157 32s898ms 209ms 13 193 40s581ms 210ms 14 180 38s91ms 211ms 15 246 52s975ms 215ms 16 97 20s706ms 213ms 17 241 51s612ms 214ms 18 121 26s61ms 215ms 19 151 31s887ms 211ms 20 36 7s904ms 219ms 21 2 433ms 216ms 23 2 419ms 209ms -
WITH currency_rate AS ( SELECT r.currency_id, COALESCE(r.company_id, c.id) as company_id, r.rate, r.name AS date_start, ( SELECT name FROM res_currency_rate r2 WHERE r2.name > r.name AND r2.currency_id = r.currency_id AND (r2.company_id is null or r2.company_id = c.id) ORDER BY r2.name ASC LIMIT 1) AS date_end FROM res_currency_rate r JOIN res_company c ON (r.company_id is null or r.company_id = c.id)) SELECT l.product_id as product_id, SUM(l.price_unit / ( CASE COALESCE(cr.rate, 0) WHEN 0 THEN 1.0 ELSE cr.rate END) * l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END) * ((100 - l.discount) * 0.01)) / NULLIF (SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)), 0) AS avg_unit_price, SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS num_qty, SUM(ABS(l.balance) * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS total, SUM(l.quantity * pt.list_price * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS sale_expected FROM account_move_line l LEFT JOIN account_move i ON (l.move_id = i.id) LEFT JOIN product_product product ON (product.id = l.product_id) LEFT JOIN product_template pt ON (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= COALESCE(i.invoice_date, NOW()) and (cr.date_end IS NULL OR cr.date_end > COALESCE(i.invoice_date, NOW()))) WHERE l.product_id IN (189663, 249278, 189020) AND i.state IN ('posted') AND i.payment_state IN ('not_paid', 'in_payment', 'paid') AND i.move_type IN ('out_invoice', 'out_refund') AND i.invoice_date BETWEEN '2023-01-01' AND '2023-12-31' AND i.company_id = 1 AND l.display_type IS NULL AND l.exclude_from_invoice_tab = false GROUP BY l.product_id;
Date: 2023-05-17 18:06:10 Duration: 554ms
-
WITH currency_rate AS ( SELECT r.currency_id, COALESCE(r.company_id, c.id) as company_id, r.rate, r.name AS date_start, ( SELECT name FROM res_currency_rate r2 WHERE r2.name > r.name AND r2.currency_id = r.currency_id AND (r2.company_id is null or r2.company_id = c.id) ORDER BY r2.name ASC LIMIT 1) AS date_end FROM res_currency_rate r JOIN res_company c ON (r.company_id is null or r.company_id = c.id)) SELECT l.product_id as product_id, SUM(l.price_unit / ( CASE COALESCE(cr.rate, 0) WHEN 0 THEN 1.0 ELSE cr.rate END) * l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END) * ((100 - l.discount) * 0.01)) / NULLIF (SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)), 0) AS avg_unit_price, SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS num_qty, SUM(ABS(l.balance) * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS total, SUM(l.quantity * pt.list_price * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS sale_expected FROM account_move_line l LEFT JOIN account_move i ON (l.move_id = i.id) LEFT JOIN product_product product ON (product.id = l.product_id) LEFT JOIN product_template pt ON (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= COALESCE(i.invoice_date, NOW()) and (cr.date_end IS NULL OR cr.date_end > COALESCE(i.invoice_date, NOW()))) WHERE l.product_id IN (220319) AND i.state IN ('posted') AND i.payment_state IN ('not_paid', 'in_payment', 'paid') AND i.move_type IN ('out_invoice', 'out_refund') AND i.invoice_date BETWEEN '2023-01-01' AND '2023-12-31' AND i.company_id = 1 AND l.display_type IS NULL AND l.exclude_from_invoice_tab = false GROUP BY l.product_id;
Date: 2023-05-17 15:07:34 Duration: 397ms
-
WITH currency_rate AS ( SELECT r.currency_id, COALESCE(r.company_id, c.id) as company_id, r.rate, r.name AS date_start, ( SELECT name FROM res_currency_rate r2 WHERE r2.name > r.name AND r2.currency_id = r.currency_id AND (r2.company_id is null or r2.company_id = c.id) ORDER BY r2.name ASC LIMIT 1) AS date_end FROM res_currency_rate r JOIN res_company c ON (r.company_id is null or r.company_id = c.id)) SELECT l.product_id as product_id, SUM(l.price_unit / ( CASE COALESCE(cr.rate, 0) WHEN 0 THEN 1.0 ELSE cr.rate END) * l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END) * ((100 - l.discount) * 0.01)) / NULLIF (SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)), 0) AS avg_unit_price, SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS num_qty, SUM(ABS(l.balance) * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS total, SUM(l.quantity * pt.list_price * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS sale_expected FROM account_move_line l LEFT JOIN account_move i ON (l.move_id = i.id) LEFT JOIN product_product product ON (product.id = l.product_id) LEFT JOIN product_template pt ON (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= COALESCE(i.invoice_date, NOW()) and (cr.date_end IS NULL OR cr.date_end > COALESCE(i.invoice_date, NOW()))) WHERE l.product_id IN (237355, 237367, 237298, 173187, 173349, 174133, 173377, 173303, 173337, 239470, 239482, 173975, 174081, 174247, 173755, 239248, 173883, 174088) AND i.state IN ('posted') AND i.payment_state IN ('not_paid', 'in_payment', 'paid') AND i.move_type IN ('out_invoice', 'out_refund') AND i.invoice_date BETWEEN '2023-01-01' AND '2023-12-31' AND i.company_id = 1 AND l.display_type IS NULL AND l.exclude_from_invoice_tab = false GROUP BY l.product_id;
Date: 2023-05-17 17:32:05 Duration: 355ms
16 4m58s 1,086 245ms 401ms 274ms select "sale_history_line".id from "sale_history_line" where ("sale_history_line"."so_line_id" in (...)) order by "sale_history_line"."id";Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 17 09 22 5s658ms 257ms 11 76 20s909ms 275ms 12 146 41s60ms 281ms 13 97 26s908ms 277ms 14 182 50s803ms 279ms 15 156 43s293ms 277ms 16 66 18s66ms 273ms 17 96 26s257ms 273ms 18 81 21s824ms 269ms 19 83 21s905ms 263ms 20 35 9s717ms 277ms 21 46 11s875ms 258ms -
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (156625)) ORDER BY "sale_history_line"."id";
Date: 2023-05-17 14:12:31 Duration: 401ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (156607)) ORDER BY "sale_history_line"."id";
Date: 2023-05-17 14:37:35 Duration: 396ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (61292)) ORDER BY "sale_history_line"."id";
Date: 2023-05-17 12:28:51 Duration: 395ms
17 4m55s 594 139ms 5s437ms 496ms update "stock_quant" set "quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 17 09 2 803ms 401ms 11 16 8s286ms 517ms 12 52 22s190ms 426ms 13 71 31s370ms 441ms 14 92 37s853ms 411ms 15 71 35s452ms 499ms 16 34 18s766ms 551ms 17 120 57s874ms 482ms 18 43 31s716ms 737ms 19 79 41s917ms 530ms 20 14 8s880ms 634ms -
UPDATE "stock_quant" SET "quantity" = 0.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (294720, 294722, 1124, 294725, 1700, 294727, 294729, 294731, 294733, 294712, 294713, 294715, 294717);
Date: 2023-05-17 18:25:58 Duration: 5s437ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (246509, 55534, 55536, 55025, 55122, 55541);
Date: 2023-05-17 18:16:40 Duration: 4s741ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "write_uid" = 1001, "write_date" = (now() at time zone 'UTC') WHERE id IN (29253, 29254, 31495, 31494, 27788, 27789, 27822, 27823, 28016, 28017, 169845, 172277, 28122, 28123, 32222, 32223);
Date: 2023-05-17 12:28:38 Duration: 3s743ms
18 4m50s 247 1s89ms 1s415ms 1s175ms select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 17 12 48 57s936ms 1s207ms 13 31 35s336ms 1s139ms 14 7 7s941ms 1s134ms 15 15 18s227ms 1s215ms 16 15 17s955ms 1s197ms 17 42 49s224ms 1s172ms 18 70 1m20s 1s155ms 19 3 3s335ms 1s111ms 20 4 4s794ms 1s198ms 21 12 14s627ms 1s218ms -
select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;
Date: 2023-05-17 12:46:05 Duration: 1s415ms
-
select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;
Date: 2023-05-17 12:46:05 Duration: 1s376ms
-
select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;
Date: 2023-05-17 12:46:04 Duration: 1s372ms
19 4m31s 463 553ms 1s163ms 587ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where (((("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and ("product_product__product_tmpl_id"."purchase_ok" is not null and "product_product__product_tmpl_id"."purchase_ok" != false)) and (("product_product__product_tmpl_id"."type" != ?) or "product_product__product_tmpl_id"."type" is null)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 17 11 120 1m9s 576ms 12 68 40s409ms 594ms 13 24 14s99ms 587ms 14 17 10s189ms 599ms 15 25 16s774ms 670ms 16 85 48s812ms 574ms 17 46 26s471ms 575ms 18 49 29s76ms 593ms 19 15 8s733ms 582ms 20 14 8s117ms 579ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%A1805E44%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%A1805E44%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%A1805E44%'))) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 15:00:13 Duration: 1s163ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%A1805E447%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%A1805E447%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%A1805E447%'))) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 15:00:13 Duration: 1s103ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%A1805E%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%A1805E%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%A1805E%'))) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 15:00:12 Duration: 1s39ms
20 4m22s 82 2s263ms 32s294ms 3s201ms delete from sale_order_line where id in (...);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 17 11 3 9s398ms 3s132ms 12 9 23s962ms 2s662ms 13 4 9s234ms 2s308ms 14 7 16s452ms 2s350ms 15 6 16s917ms 2s819ms 16 2 9s452ms 4s726ms 17 5 11s689ms 2s337ms 18 26 1m8s 2s619ms 19 17 55s669ms 3s274ms 20 1 2s448ms 2s448ms 21 2 39s188ms 19s594ms -
DELETE FROM sale_order_line WHERE id IN (153984, 153987, 153997, 154024, 154029, 154030, 154031, 154033, 154034, 154039, 154047, 154048, 154052, 154054);
Date: 2023-05-17 21:27:28 Duration: 32s294ms
-
DELETE FROM sale_order_line WHERE id IN (42986, 43016, 43019, 43020, 43036, 43079);
Date: 2023-05-17 19:07:25 Duration: 13s800ms
-
DELETE FROM sale_order_line WHERE id IN (156921, 156922, 156923);
Date: 2023-05-17 16:41:00 Duration: 7s99ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 7,199 26m40s 120ms 582ms 222ms select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 17 00 104 17s892ms 172ms 01 30 5s427ms 180ms 02 19 3s243ms 170ms 03 28 4s871ms 173ms 04 33 5s610ms 170ms 05 160 28s926ms 180ms 06 168 28s644ms 170ms 07 107 19s314ms 180ms 08 139 24s702ms 177ms 09 86 15s911ms 185ms 10 83 16s575ms 199ms 11 201 37s570ms 186ms 12 395 1m18s 197ms 13 741 2m33s 207ms 14 603 2m17s 227ms 15 771 2m49s 220ms 16 767 3m13s 252ms 17 662 2m30s 227ms 18 588 2m36s 266ms 19 579 2m38s 274ms 20 398 1m34s 237ms 21 128 23s725ms 185ms 22 149 27s206ms 182ms 23 260 48s353ms 185ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-17 15:51:37') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_990"', '["pointspring_master","calendar.alarm",19528]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",74]', '["pointspring_master","mail.channel",75]', '["pointspring_master","mail.channel",76]', '["pointspring_master","mail.channel",77]', '["pointspring_master","mail.channel",339]', '["pointspring_master","mail.channel",473]', '["pointspring_master","res.partner",19528]', '["pointspring_master","ir.needaction",19528]'))) ORDER BY "bus_bus"."id";
Date: 2023-05-17 15:52:27 Duration: 582ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-17 15:51:37') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1017"', '["pointspring_master","calendar.alarm",19555]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",36]', '["pointspring_master","mail.channel",41]', '["pointspring_master","mail.channel",42]', '["pointspring_master","mail.channel",503]', '["pointspring_master","res.partner",19555]', '["pointspring_master","ir.needaction",19555]'))) ORDER BY "bus_bus"."id";
Date: 2023-05-17 15:52:27 Duration: 575ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-17 15:51:37') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1015"', '["pointspring_master","calendar.alarm",19553]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",51]', '["pointspring_master","mail.channel",52]', '["pointspring_master","mail.channel",53]', '["pointspring_master","mail.channel",346]', '["pointspring_master","mail.channel",347]', '["pointspring_master","mail.channel",457]', '["pointspring_master","res.partner",19553]', '["pointspring_master","ir.needaction",19553]'))) ORDER BY "bus_bus"."id";
Date: 2023-05-17 15:52:27 Duration: 575ms
2 6,579 18m51s 160ms 656ms 171ms select "ir_attachment".id from "ir_attachment" where (("ir_attachment"."res_field" is null and (unaccent ("ir_attachment"."url"::text) like unaccent (?))) and (not ((unaccent ("ir_attachment"."url"::text) like unaccent (?))))) order by "ir_attachment"."id" desc;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 17 00 49 8s216ms 167ms 01 12 1s963ms 163ms 02 12 1s967ms 163ms 03 133 21s801ms 163ms 04 8 1s308ms 163ms 05 36 6s590ms 183ms 06 43 7s310ms 170ms 07 23 3s802ms 165ms 08 39 6s584ms 168ms 09 58 9s564ms 164ms 10 55 9s43ms 164ms 11 395 1m6s 169ms 12 977 2m49s 173ms 13 858 2m29s 174ms 14 662 1m53s 171ms 15 651 1m53s 174ms 16 432 1m13s 169ms 17 472 1m21s 173ms 18 542 1m34s 174ms 19 481 1m22s 171ms 20 361 1m 168ms 21 89 14s607ms 164ms 22 70 11s470ms 163ms 23 121 19s951ms 164ms -
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-9ded8a0/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-05-17 19:19:38 Duration: 656ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.report_assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-5826980/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-05-17 18:06:10 Duration: 604ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-fb6cd24/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-05-17 15:35:18 Duration: 539ms
3 4,390 42m59s 537ms 1s8ms 587ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where ((("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and ("product_product__product_tmpl_id"."sale_ok" is not null and "product_product__product_tmpl_id"."sale_ok" != false)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 17 09 96 55s156ms 574ms 11 275 2m38s 576ms 12 568 5m34s 588ms 13 661 6m32s 593ms 14 551 5m25s 591ms 15 445 4m20s 586ms 16 369 3m34s 581ms 17 413 4m4s 591ms 18 353 3m28s 589ms 19 421 4m8s 590ms 20 124 1m12s 582ms 21 91 51s560ms 566ms 22 23 13s466ms 585ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%361168%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%361-168%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%361-168%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 17:43:06 Duration: 1s8ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%qplae%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%qpl-a-e%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%qpl-a-e%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 19:36:49 Duration: 947ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%tv13%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%tv13%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%tv13%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 16:54:22 Duration: 941ms
4 2,585 6m40s 120ms 386ms 154ms select count(distinct (so.id)) as total_orders from sale_order as so left join sale_order_line as sol on sol.order_id = so.id left join product_warehouse_inventory as pwi on pwi.product_id = sol.product_id left join stock_warehouse as sw on sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= ?::timestamp and so.date_order <= ?::timestamp and sol.product_id = ? and so.state in (...) and so.warehouse_id = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 17 00 257 40s228ms 156ms 01 240 37s851ms 157ms 02 339 53s985ms 159ms 03 220 34s51ms 154ms 04 171 26s552ms 155ms 05 195 29s346ms 150ms 06 208 31s877ms 153ms 07 167 25s602ms 153ms 08 179 27s75ms 151ms 09 157 23s988ms 152ms 22 234 35s902ms 153ms 23 218 33s908ms 155ms -
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-11-17T22:30:01.838094'::timestamp and so.date_order <= '2023-05-17T22:30:01.838094'::timestamp and sol.product_id = 203207 and so.state in ('done', 'sale') and so.warehouse_id = 44;
Date: 2023-05-17 22:33:14 Duration: 386ms
-
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-11-17T00:30:09.593526'::timestamp and so.date_order <= '2023-05-17T00:30:09.593526'::timestamp and sol.product_id = 186487 and so.state in ('done', 'sale') and so.warehouse_id = 41;
Date: 2023-05-17 00:31:35 Duration: 368ms
-
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-11-17T02:30:06.402873'::timestamp and so.date_order <= '2023-05-17T02:30:06.402873'::timestamp and sol.product_id = 221179 and so.state in ('done', 'sale') and so.warehouse_id = 36;
Date: 2023-05-17 02:30:49 Duration: 345ms
5 1,920 5m46s 169ms 327ms 180ms select res_partner.id from "res_partner" where ("res_partner"."active" = true) and (((("res_partner"."partner_share" is null or "res_partner"."partner_share" = false) or ("res_partner"."company_id" in (...))) or "res_partner"."company_id" is null) and (((("res_partner"."type" != ?) or "res_partner"."type" is null) or "res_partner"."type" is null) or ("res_partner"."type" = ?))) and (unaccent (res_partner.email) ilike unaccent (?) or unaccent (res_partner.display_name) ilike unaccent (?) or unaccent (res_partner.ref) ilike unaccent (?) or unaccent (res_partner.vat) ilike unaccent (?)) unaccent (res_partner.display_name);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 17 07 1 174ms 174ms 10 8 1s435ms 179ms 11 17 2s972ms 174ms 12 186 33s94ms 177ms 13 203 36s639ms 180ms 14 251 46s16ms 183ms 15 309 55s983ms 181ms 16 199 35s408ms 177ms 17 176 32s177ms 182ms 18 240 43s312ms 180ms 19 267 47s885ms 179ms 20 35 6s245ms 178ms 21 21 3s629ms 172ms 22 5 880ms 176ms 23 2 347ms 173ms -
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%v-00918%') OR unaccent (res_partner.display_name) ilike unaccent ('%v-00918%') OR unaccent (res_partner.ref) ilike unaccent ('%v-00918%') OR unaccent (res_partner.vat) ilike unaccent ('v-00918')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%v-00918%') desc, unaccent (res_partner.display_name);
Date: 2023-05-17 14:51:45 Duration: 327ms
-
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%V2556%') OR unaccent (res_partner.display_name) ilike unaccent ('%V2556%') OR unaccent (res_partner.ref) ilike unaccent ('%V2556%') OR unaccent (res_partner.vat) ilike unaccent ('V2556')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%V2556%') desc, unaccent (res_partner.display_name);
Date: 2023-05-17 14:51:45 Duration: 324ms
-
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%V2549%') OR unaccent (res_partner.display_name) ilike unaccent ('%V2549%') OR unaccent (res_partner.ref) ilike unaccent ('%V2549%') OR unaccent (res_partner.vat) ilike unaccent ('V2549')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%V2549%') desc, unaccent (res_partner.display_name);
Date: 2023-05-17 14:53:18 Duration: 285ms
6 1,715 12m3s 288ms 817ms 421ms select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 17 10 1 349ms 349ms 11 113 36s973ms 327ms 12 246 1m30s 367ms 13 1 289ms 289ms 14 257 1m50s 429ms 15 1,047 7m50s 448ms 16 50 15s37ms 300ms -
select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;
Date: 2023-05-17 14:54:13 Duration: 817ms
-
select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;
Date: 2023-05-17 15:35:18 Duration: 737ms
-
select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;
Date: 2023-05-17 15:35:19 Duration: 735ms
7 1,460 5m10s 120ms 554ms 212ms with currency_rate as ( select r.currency_id, coalesce(r.company_id, c.id) as company_id, r.rate, r.name as date_start, ( select name from res_currency_rate r2 where r2.name > r.name and r2.currency_id = r.currency_id and (r2.company_id is null or r2.company_id = c.id) order by r2.name asc limit ?) as date_end from res_currency_rate r join res_company c on (r.company_id is null or r.company_id = c.id)) select l.product_id as product_id, sum(l.price_unit / ( case coalesce(cr.rate, ?) when ? then ?.? else cr.rate end) * l.quantity * ( case when i.move_type in (...) then ? else ? end) * ((? - l.discount) * ?.?)) / nullif (sum(l.quantity * ( case when i.move_type in (...) then ? else ? end)), ?) as avg_unit_price, sum(l.quantity * ( case when i.move_type in (...) then ? else ? end)) as num_qty, sum(abs(l.balance) * ( case when i.move_type in (...) then ? else ? end)) as total, sum(l.quantity * pt.list_price * ( case when i.move_type in (...) then ? else ? end)) as sale_expected from account_move_line l left join account_move i on (l.move_id = i.id) left join product_product product on (product.id = l.product_id) left join product_template pt on (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= coalesce(i.invoice_date, now()) and (cr.date_end is null or cr.date_end > coalesce(i.invoice_date, now()))) where l.product_id in (...) and i.state in (...) and i.payment_state in (...) and i.move_type in (...) and i.invoice_date between ? and ? and i.company_id = ? and l.display_type is null and l.exclude_from_invoice_tab = false group by l.product_id;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 17 08 2 415ms 207ms 09 2 461ms 230ms 10 10 2s166ms 216ms 11 20 4s329ms 216ms 12 157 32s898ms 209ms 13 193 40s581ms 210ms 14 180 38s91ms 211ms 15 246 52s975ms 215ms 16 97 20s706ms 213ms 17 241 51s612ms 214ms 18 121 26s61ms 215ms 19 151 31s887ms 211ms 20 36 7s904ms 219ms 21 2 433ms 216ms 23 2 419ms 209ms -
WITH currency_rate AS ( SELECT r.currency_id, COALESCE(r.company_id, c.id) as company_id, r.rate, r.name AS date_start, ( SELECT name FROM res_currency_rate r2 WHERE r2.name > r.name AND r2.currency_id = r.currency_id AND (r2.company_id is null or r2.company_id = c.id) ORDER BY r2.name ASC LIMIT 1) AS date_end FROM res_currency_rate r JOIN res_company c ON (r.company_id is null or r.company_id = c.id)) SELECT l.product_id as product_id, SUM(l.price_unit / ( CASE COALESCE(cr.rate, 0) WHEN 0 THEN 1.0 ELSE cr.rate END) * l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END) * ((100 - l.discount) * 0.01)) / NULLIF (SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)), 0) AS avg_unit_price, SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS num_qty, SUM(ABS(l.balance) * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS total, SUM(l.quantity * pt.list_price * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS sale_expected FROM account_move_line l LEFT JOIN account_move i ON (l.move_id = i.id) LEFT JOIN product_product product ON (product.id = l.product_id) LEFT JOIN product_template pt ON (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= COALESCE(i.invoice_date, NOW()) and (cr.date_end IS NULL OR cr.date_end > COALESCE(i.invoice_date, NOW()))) WHERE l.product_id IN (189663, 249278, 189020) AND i.state IN ('posted') AND i.payment_state IN ('not_paid', 'in_payment', 'paid') AND i.move_type IN ('out_invoice', 'out_refund') AND i.invoice_date BETWEEN '2023-01-01' AND '2023-12-31' AND i.company_id = 1 AND l.display_type IS NULL AND l.exclude_from_invoice_tab = false GROUP BY l.product_id;
Date: 2023-05-17 18:06:10 Duration: 554ms
-
WITH currency_rate AS ( SELECT r.currency_id, COALESCE(r.company_id, c.id) as company_id, r.rate, r.name AS date_start, ( SELECT name FROM res_currency_rate r2 WHERE r2.name > r.name AND r2.currency_id = r.currency_id AND (r2.company_id is null or r2.company_id = c.id) ORDER BY r2.name ASC LIMIT 1) AS date_end FROM res_currency_rate r JOIN res_company c ON (r.company_id is null or r.company_id = c.id)) SELECT l.product_id as product_id, SUM(l.price_unit / ( CASE COALESCE(cr.rate, 0) WHEN 0 THEN 1.0 ELSE cr.rate END) * l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END) * ((100 - l.discount) * 0.01)) / NULLIF (SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)), 0) AS avg_unit_price, SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS num_qty, SUM(ABS(l.balance) * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS total, SUM(l.quantity * pt.list_price * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS sale_expected FROM account_move_line l LEFT JOIN account_move i ON (l.move_id = i.id) LEFT JOIN product_product product ON (product.id = l.product_id) LEFT JOIN product_template pt ON (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= COALESCE(i.invoice_date, NOW()) and (cr.date_end IS NULL OR cr.date_end > COALESCE(i.invoice_date, NOW()))) WHERE l.product_id IN (220319) AND i.state IN ('posted') AND i.payment_state IN ('not_paid', 'in_payment', 'paid') AND i.move_type IN ('out_invoice', 'out_refund') AND i.invoice_date BETWEEN '2023-01-01' AND '2023-12-31' AND i.company_id = 1 AND l.display_type IS NULL AND l.exclude_from_invoice_tab = false GROUP BY l.product_id;
Date: 2023-05-17 15:07:34 Duration: 397ms
-
WITH currency_rate AS ( SELECT r.currency_id, COALESCE(r.company_id, c.id) as company_id, r.rate, r.name AS date_start, ( SELECT name FROM res_currency_rate r2 WHERE r2.name > r.name AND r2.currency_id = r.currency_id AND (r2.company_id is null or r2.company_id = c.id) ORDER BY r2.name ASC LIMIT 1) AS date_end FROM res_currency_rate r JOIN res_company c ON (r.company_id is null or r.company_id = c.id)) SELECT l.product_id as product_id, SUM(l.price_unit / ( CASE COALESCE(cr.rate, 0) WHEN 0 THEN 1.0 ELSE cr.rate END) * l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END) * ((100 - l.discount) * 0.01)) / NULLIF (SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)), 0) AS avg_unit_price, SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS num_qty, SUM(ABS(l.balance) * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS total, SUM(l.quantity * pt.list_price * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS sale_expected FROM account_move_line l LEFT JOIN account_move i ON (l.move_id = i.id) LEFT JOIN product_product product ON (product.id = l.product_id) LEFT JOIN product_template pt ON (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= COALESCE(i.invoice_date, NOW()) and (cr.date_end IS NULL OR cr.date_end > COALESCE(i.invoice_date, NOW()))) WHERE l.product_id IN (237355, 237367, 237298, 173187, 173349, 174133, 173377, 173303, 173337, 239470, 239482, 173975, 174081, 174247, 173755, 239248, 173883, 174088) AND i.state IN ('posted') AND i.payment_state IN ('not_paid', 'in_payment', 'paid') AND i.move_type IN ('out_invoice', 'out_refund') AND i.invoice_date BETWEEN '2023-01-01' AND '2023-12-31' AND i.company_id = 1 AND l.display_type IS NULL AND l.exclude_from_invoice_tab = false GROUP BY l.product_id;
Date: 2023-05-17 17:32:05 Duration: 355ms
8 1,264 12m24s 543ms 966ms 589ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where (("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 17 12 51 29s697ms 582ms 13 91 54s10ms 593ms 14 173 1m43s 595ms 15 114 1m7s 590ms 16 24 14s519ms 604ms 17 285 2m48s 589ms 18 305 2m59s 589ms 19 190 1m50s 581ms 20 26 14s887ms 572ms 23 5 2s808ms 561ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%43029%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%43029%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%43029%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 14:42:06 Duration: 966ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%119%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%119%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%119%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 15:20:50 Duration: 952ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%2531%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%2-53-1%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%2-53-1%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 14:59:01 Duration: 863ms
9 1,222 3m1s 138ms 1s591ms 148ms update "stock_quant" set "reserved_quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 17 09 14 1s992ms 142ms 11 61 8s740ms 143ms 12 124 18s290ms 147ms 13 118 17s497ms 148ms 14 168 24s889ms 148ms 15 173 25s551ms 147ms 16 66 9s539ms 144ms 17 163 23s917ms 146ms 18 126 20s2ms 158ms 19 153 23s117ms 151ms 20 27 3s891ms 144ms 21 21 3s32ms 144ms 22 7 1s11ms 144ms 23 1 146ms 146ms -
UPDATE "stock_quant" SET "reserved_quantity" = 1.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (668, 295686, 295688, 295536, 295953, 295955, 295957, 295670, 295960, 295962, 295964);
Date: 2023-05-17 18:23:33 Duration: 1s591ms
-
UPDATE "stock_quant" SET "reserved_quantity" = 4.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (968, 255393, 213147, 1070);
Date: 2023-05-17 19:04:47 Duration: 588ms
-
UPDATE "stock_quant" SET "reserved_quantity" = 2.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (890, 1948);
Date: 2023-05-17 19:04:47 Duration: 292ms
10 1,086 4m58s 245ms 401ms 274ms select "sale_history_line".id from "sale_history_line" where ("sale_history_line"."so_line_id" in (...)) order by "sale_history_line"."id";Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 17 09 22 5s658ms 257ms 11 76 20s909ms 275ms 12 146 41s60ms 281ms 13 97 26s908ms 277ms 14 182 50s803ms 279ms 15 156 43s293ms 277ms 16 66 18s66ms 273ms 17 96 26s257ms 273ms 18 81 21s824ms 269ms 19 83 21s905ms 263ms 20 35 9s717ms 277ms 21 46 11s875ms 258ms -
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (156625)) ORDER BY "sale_history_line"."id";
Date: 2023-05-17 14:12:31 Duration: 401ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (156607)) ORDER BY "sale_history_line"."id";
Date: 2023-05-17 14:37:35 Duration: 396ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (61292)) ORDER BY "sale_history_line"."id";
Date: 2023-05-17 12:28:51 Duration: 395ms
11 1,037 3m48s 201ms 883ms 219ms update "sale_order_line" set "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 17 09 20 4s214ms 210ms 11 88 18s733ms 212ms 12 149 34s593ms 232ms 13 100 21s927ms 219ms 14 163 35s723ms 219ms 15 145 31s684ms 218ms 16 56 12s316ms 219ms 17 98 21s510ms 219ms 18 63 13s598ms 215ms 19 65 14s118ms 217ms 20 35 7s693ms 219ms 21 55 11s906ms 216ms -
UPDATE "sale_order_line" SET "write_uid" = 1164, "write_date" = (now() at time zone 'UTC') WHERE id IN (156320, 156329, 156323, 156308);
Date: 2023-05-17 12:23:44 Duration: 883ms
-
UPDATE "sale_order_line" SET "write_uid" = 1140, "write_date" = (now() at time zone 'UTC') WHERE id IN (156260, 156270, 156271);
Date: 2023-05-17 12:00:31 Duration: 832ms
-
UPDATE "sale_order_line" SET "write_uid" = 1147, "write_date" = (now() at time zone 'UTC') WHERE id IN (156290, 156293);
Date: 2023-05-17 12:05:16 Duration: 434ms
12 957 11m45s 688ms 1s292ms 737ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (("product_template"."is_core" is null or "product_template"."is_core" = false) and (("product_template"."type" in (...)) and (((((unaccent ("product_template"."default_code"::text) ilike unaccent (?)) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null)))) or unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?)) or false) or (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent (?)))))) and (("product_template"."company_id" in (...)) or "product_template"."company_id" is null) order by coalesce("product_template__name"."value", "product_template"."name") limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 17 10 4 2s862ms 715ms 11 59 43s121ms 730ms 12 128 1m34s 734ms 13 122 1m30s 738ms 14 120 1m28s 738ms 15 118 1m28s 748ms 16 100 1m12s 729ms 17 61 45s19ms 738ms 18 111 1m22s 746ms 19 82 59s979ms 731ms 20 43 31s566ms 734ms 21 1 728ms 728ms 22 8 5s688ms 711ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%e-9524-r%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%e-9524-r%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%e-9524-r%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%e-9524-r%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-05-17 15:18:08 Duration: 1s292ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%565f%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%565f%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%565f%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%565f%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-05-17 15:18:10 Duration: 1s120ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%169107%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%169107%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%169107%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%169107%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-05-17 12:54:29 Duration: 1s78ms
13 920 8m13s 144ms 4s704ms 536ms update "stock_quant" set "quantity" = ?.?, "reserved_quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 17 09 9 6s508ms 723ms 10 5 2s14ms 402ms 11 12 7s47ms 587ms 12 105 56s362ms 536ms 13 170 1m33s 549ms 14 149 1m27s 584ms 15 76 40s137ms 528ms 16 48 28s990ms 603ms 17 148 1m8s 465ms 18 94 51s712ms 550ms 19 80 38s86ms 476ms 20 23 12s758ms 554ms 21 1 412ms 412ms -
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (295686, 295688, 296108, 295536, 295953, 295955, 295957, 295670, 295960, 295962, 295964);
Date: 2023-05-17 18:25:50 Duration: 4s704ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (140899, 234820, 269095, 141064, 145900, 275468, 276594, 141299);
Date: 2023-05-17 14:58:00 Duration: 4s82ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (298385, 298387, 295039);
Date: 2023-05-17 14:05:29 Duration: 2s525ms
14 890 3m24s 201ms 1s333ms 230ms update "sale_order_line" set "invoice_status" = ?, "open_qty_fil" = ?.?, "qty_delivered" = ?, "qty_to_invoice" = ?, "untaxed_amount_to_invoice" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 17 09 15 3s212ms 214ms 10 5 1s113ms 222ms 11 15 3s255ms 217ms 12 123 28s99ms 228ms 13 160 35s708ms 223ms 14 179 40s676ms 227ms 15 101 25s471ms 252ms 16 62 15s74ms 243ms 17 88 21s11ms 238ms 18 55 12s148ms 220ms 19 72 15s774ms 219ms 20 14 3s6ms 214ms 21 1 230ms 230ms -
UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 1.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1237, "write_date" = (now() at time zone 'UTC') WHERE id IN (154184, 154185, 154187, 154188, 154189, 154198);
Date: 2023-05-17 16:32:21 Duration: 1s333ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 5.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1007, "write_date" = (now() at time zone 'UTC') WHERE id IN (154857, 149355, 149356, 149357, 154865, 154867);
Date: 2023-05-17 15:54:11 Duration: 1s331ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 10.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1007, "write_date" = (now() at time zone 'UTC') WHERE id IN (154912, 149346, 154917, 154922, 154911);
Date: 2023-05-17 15:54:09 Duration: 1s77ms
15 752 2m46s 200ms 652ms 220ms update "sale_order_line" set "invoice_status" = ?, "qty_invoiced" = ?, "qty_to_invoice" = ?, "untaxed_amount_invoiced" = ?, "untaxed_amount_to_invoice" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 17 09 15 3s169ms 211ms 10 5 1s92ms 218ms 11 12 2s500ms 208ms 12 108 24s40ms 222ms 13 148 32s413ms 219ms 14 141 31s905ms 226ms 15 99 21s310ms 215ms 16 59 13s112ms 222ms 17 71 15s524ms 218ms 18 32 6s975ms 217ms 19 48 11s17ms 229ms 20 13 2s821ms 217ms 21 1 214ms 214ms -
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '1.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '119.89', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (156584, 156585, 156586);
Date: 2023-05-17 14:58:26 Duration: 652ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '2.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '358.18', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1237, "write_date" = (now() at time zone 'UTC') WHERE id IN (127668);
Date: 2023-05-17 19:11:54 Duration: 476ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '100.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '177.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1237, "write_date" = (now() at time zone 'UTC') WHERE id IN (147515, 147516);
Date: 2023-05-17 19:59:16 Duration: 454ms
16 692 2m34s 203ms 524ms 223ms update "sale_order_line" set "branch_id" = ?, "currency_id" = ?, "cus_date_order" = ?, "cus_part_route" = ?, "cus_user_id" = ?, "inventory_vendor_id" = ?, "is_service" = false, "margin" = ?, "margin_percent" = ?.?, "order_partner_id" = ?, "price_reduce" = ?, "price_reduce_taxexcl" = ?, "price_reduce_taxinc" = ?, "price_subtotal" = ?, "price_tax" = ?.?, "price_total" = ?, "purchase_price" = ?, "qty_delivered_method" = ?, "qty_invoiced" = ?, "qty_to_invoice" = ?, "salesman_id" = ?, "untaxed_amount_invoiced" = ?, "untaxed_amount_to_invoice" = ?, "warehouse_id" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 17 11 52 11s558ms 222ms 12 103 22s938ms 222ms 13 107 23s988ms 224ms 14 85 18s990ms 223ms 15 70 15s941ms 227ms 16 54 11s917ms 220ms 17 62 13s763ms 221ms 18 52 11s846ms 227ms 19 66 14s848ms 224ms 20 18 4s78ms 226ms 21 21 4s578ms 218ms 22 2 444ms 222ms -
UPDATE "sale_order_line" SET "branch_id" = 37, "currency_id" = 2, "cus_date_order" = '2023-05-17 18:02:28', "cus_part_route" = NULL, "cus_user_id" = 993, "inventory_vendor_id" = 3026, "is_service" = false, "margin" = '61.67', "margin_percent" = 0.45001459427904267, "order_partner_id" = 39632, "price_reduce" = '137.04', "price_reduce_taxexcl" = '137.04', "price_reduce_taxinc" = '137.04', "price_subtotal" = '137.04', "price_tax" = 0.0, "price_total" = '137.04', "purchase_price" = '75.37', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 993, "untaxed_amount_invoiced" = '0.00', "untaxed_amount_to_invoice" = '0.00', "warehouse_id" = 35, "write_uid" = 1010, "write_date" = (now() at time zone 'UTC') WHERE id IN (157056);
Date: 2023-05-17 18:03:24 Duration: 524ms
-
UPDATE "sale_order_line" SET "branch_id" = 46, "currency_id" = 2, "cus_date_order" = '2023-05-17 14:59:53', "cus_part_route" = NULL, "cus_user_id" = 1009, "inventory_vendor_id" = 3089, "is_service" = false, "margin" = '4.15', "margin_percent" = 0.3900375939849624, "order_partner_id" = 33310, "price_reduce" = '10.64', "price_reduce_taxexcl" = '10.64', "price_reduce_taxinc" = '10.64', "price_subtotal" = '10.64', "price_tax" = 0.0, "price_total" = '10.64', "purchase_price" = '6.49', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 1009, "untaxed_amount_invoiced" = '0.00', "untaxed_amount_to_invoice" = '0.00', "warehouse_id" = 43, "write_uid" = 964, "write_date" = (now() at time zone 'UTC') WHERE id IN (156752);
Date: 2023-05-17 15:00:12 Duration: 407ms
-
UPDATE "sale_order_line" SET "branch_id" = 48, "currency_id" = 2, "cus_date_order" = '2023-05-17 16:54:42', "cus_part_route" = NULL, "cus_user_id" = 965, "inventory_vendor_id" = 3076, "is_service" = false, "margin" = '40.92', "margin_percent" = 0.31002348662777485, "order_partner_id" = 46209, "price_reduce" = '131.99', "price_reduce_taxexcl" = '131.99', "price_reduce_taxinc" = '131.99', "price_subtotal" = '131.99', "price_tax" = 0.0, "price_total" = '131.99', "purchase_price" = '91.07', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 965, "untaxed_amount_invoiced" = '0.00', "untaxed_amount_to_invoice" = '0.00', "warehouse_id" = 45, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (157019);
Date: 2023-05-17 17:43:49 Duration: 374ms
17 597 5m50s 548ms 848ms 587ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 17 00 132 1m16s 579ms 11 15 8s622ms 574ms 12 30 17s195ms 573ms 13 45 26s609ms 591ms 14 48 28s55ms 584ms 15 94 56s416ms 600ms 16 41 24s82ms 587ms 17 25 15s38ms 601ms 18 126 1m14s 590ms 19 31 18s300ms 590ms 20 10 5s765ms 576ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%4707q%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4707q%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%4707q%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 15:58:35 Duration: 848ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%33050R%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%33050R%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%33050R%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 13:20:07 Duration: 777ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%wks4707%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%wks4707%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%wks4707%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 13:27:35 Duration: 748ms
18 594 4m55s 139ms 5s437ms 496ms update "stock_quant" set "quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 17 09 2 803ms 401ms 11 16 8s286ms 517ms 12 52 22s190ms 426ms 13 71 31s370ms 441ms 14 92 37s853ms 411ms 15 71 35s452ms 499ms 16 34 18s766ms 551ms 17 120 57s874ms 482ms 18 43 31s716ms 737ms 19 79 41s917ms 530ms 20 14 8s880ms 634ms -
UPDATE "stock_quant" SET "quantity" = 0.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (294720, 294722, 1124, 294725, 1700, 294727, 294729, 294731, 294733, 294712, 294713, 294715, 294717);
Date: 2023-05-17 18:25:58 Duration: 5s437ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (246509, 55534, 55536, 55025, 55122, 55541);
Date: 2023-05-17 18:16:40 Duration: 4s741ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "write_uid" = 1001, "write_date" = (now() at time zone 'UTC') WHERE id IN (29253, 29254, 31495, 31494, 27788, 27789, 27822, 27823, 28016, 28017, 169845, 172277, 28122, 28123, 32222, 32223);
Date: 2023-05-17 12:28:38 Duration: 3s743ms
19 572 2m13s 221ms 361ms 232ms select "sale_line_report".id from "sale_line_report" where ("sale_line_report"."real_line_id" in (...)) order by "sale_line_report"."id";Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 17 11 52 11s986ms 230ms 12 124 28s814ms 232ms 13 52 12s316ms 236ms 14 39 9s96ms 233ms 15 56 13s129ms 234ms 16 29 6s622ms 228ms 17 74 17s356ms 234ms 18 69 16s77ms 233ms 19 39 9s115ms 233ms 20 12 2s766ms 230ms 21 25 5s764ms 230ms 22 1 225ms 225ms -
SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (157194)) ORDER BY "sale_line_report"."id";
Date: 2023-05-17 19:36:38 Duration: 361ms
-
SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (156812)) ORDER BY "sale_line_report"."id";
Date: 2023-05-17 15:41:13 Duration: 351ms
-
SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (156768)) ORDER BY "sale_line_report"."id";
Date: 2023-05-17 15:11:43 Duration: 329ms
20 534 7m27s 531ms 2s628ms 837ms update "stock_move" set "current_warehouse_qty" = ?.?, "date" = ?, "is_done" = true, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 17 10 1 706ms 706ms 11 5 4s31ms 806ms 12 71 57s996ms 816ms 13 93 1m25s 919ms 14 91 1m18s 858ms 15 65 54s527ms 838ms 16 26 23s75ms 887ms 17 68 53s178ms 782ms 18 33 25s555ms 774ms 19 42 31s440ms 748ms 20 38 32s495ms 855ms 21 1 707ms 707ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 1.0, "date" = '2023-05-17 13:01:55', "is_done" = true, "state" = 'done', "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (420968, 420966, 420975);
Date: 2023-05-17 13:02:01 Duration: 2s628ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 10.0, "date" = '2023-05-17 13:19:59', "is_done" = true, "state" = 'done', "write_uid" = 1028, "write_date" = (now() at time zone 'UTC') WHERE id IN (421329, 421331);
Date: 2023-05-17 13:20:09 Duration: 2s349ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "date" = '2023-05-17 14:12:56', "is_done" = true, "state" = 'done', "write_uid" = 1000, "write_date" = (now() at time zone 'UTC') WHERE id IN (421484, 421486);
Date: 2023-05-17 14:13:02 Duration: 2s292ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2s263ms 32s294ms 3s201ms 82 4m22s delete from sale_order_line where id in (...);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 17 11 3 9s398ms 3s132ms 12 9 23s962ms 2s662ms 13 4 9s234ms 2s308ms 14 7 16s452ms 2s350ms 15 6 16s917ms 2s819ms 16 2 9s452ms 4s726ms 17 5 11s689ms 2s337ms 18 26 1m8s 2s619ms 19 17 55s669ms 3s274ms 20 1 2s448ms 2s448ms 21 2 39s188ms 19s594ms -
DELETE FROM sale_order_line WHERE id IN (153984, 153987, 153997, 154024, 154029, 154030, 154031, 154033, 154034, 154039, 154047, 154048, 154052, 154054);
Date: 2023-05-17 21:27:28 Duration: 32s294ms
-
DELETE FROM sale_order_line WHERE id IN (42986, 43016, 43019, 43020, 43036, 43079);
Date: 2023-05-17 19:07:25 Duration: 13s800ms
-
DELETE FROM sale_order_line WHERE id IN (156921, 156922, 156923);
Date: 2023-05-17 16:41:00 Duration: 7s99ms
2 284ms 18s499ms 2s352ms 162 6m21s update "stock_move" set "date" = ?, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 17 09 1 11s122ms 11s122ms 10 3 2s197ms 732ms 11 3 2s859ms 953ms 12 16 28s621ms 1s788ms 13 23 44s209ms 1s922ms 14 22 55s514ms 2s523ms 15 17 49s781ms 2s928ms 16 3 6s128ms 2s42ms 17 42 1m14s 1s781ms 18 14 48s520ms 3s465ms 19 15 53s713ms 3s580ms 20 3 3s619ms 1s206ms -
UPDATE "stock_move" SET "date" = '2023-05-17 18:25:16', "state" = 'done', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (411027, 411028, 411029, 411030, 411031, 411035, 411052, 411053, 411055, 411065, 411067, 422589, 411069, 411071, 411072, 411073, 411074, 411077, 411078, 411086, 411087, 411093, 411096, 411102, 411103, 411105);
Date: 2023-05-17 18:25:39 Duration: 18s499ms
-
UPDATE "stock_move" SET "date" = '2023-05-17 19:46:31', "state" = 'done', "write_uid" = 1237, "write_date" = (now() at time zone 'UTC') WHERE id IN (415541, 415542, 415544, 415545, 415546, 415547, 415548, 415549, 415550, 415551, 415554, 415555, 415556, 415557, 415558, 415559, 415560, 415561, 415562, 415563, 415564, 415565, 415566);
Date: 2023-05-17 19:46:45 Duration: 13s127ms
-
UPDATE "stock_move" SET "date" = '2023-05-17 17:50:45', "state" = 'done', "write_uid" = 1006, "write_date" = (now() at time zone 'UTC') WHERE id IN (415569, 415570, 415571, 415572, 415574, 415575, 415576, 415577, 415579, 415580, 415581, 415582, 415583, 415584, 415585, 415586, 415587, 415588, 415589, 415590, 415591, 415592);
Date: 2023-05-17 17:50:58 Duration: 12s868ms
3 143ms 11s485ms 1s205ms 278 5m35s update "stock_move" set "branch_id" = ?, "picking_id" = ?, "related_core_purchase_line_id" = ?, "related_core_repair_line_id" = ?, "related_core_sale_line_id" = ?, "scrapped" = false, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 17 09 1 9s258ms 9s258ms 11 13 20s573ms 1s582ms 12 41 46s981ms 1s145ms 13 33 32s296ms 978ms 14 31 1m 1s959ms 15 38 44s29ms 1s158ms 16 26 21s910ms 842ms 17 31 31s471ms 1s15ms 18 24 19s51ms 793ms 19 22 22s362ms 1s16ms 20 12 13s274ms 1s106ms 21 6 13s174ms 2s195ms -
UPDATE "stock_move" SET "branch_id" = 48, "picking_id" = 146907, "related_core_purchase_line_id" = NULL, "related_core_repair_line_id" = NULL, "related_core_sale_line_id" = NULL, "scrapped" = false, "state" = 'confirmed', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (421683, 421684, 421685, 421686, 421687, 421688, 421689, 421690, 421691, 421692, 421693, 421694, 421695, 421696, 421697, 421698, 421699, 421700, 421701, 421702, 421703, 421704, 421705);
Date: 2023-05-17 14:56:58 Duration: 11s485ms
-
UPDATE "stock_move" SET "branch_id" = 38, "picking_id" = 146428, "related_core_purchase_line_id" = NULL, "related_core_repair_line_id" = NULL, "related_core_sale_line_id" = NULL, "scrapped" = false, "state" = 'confirmed', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (420929, 420930, 420931, 420933, 420914, 420915, 420916, 420917, 420918, 420919, 420920, 420921, 420922, 420923, 420924, 420925, 420926, 420927);
Date: 2023-05-17 09:36:19 Duration: 9s258ms
-
UPDATE "stock_move" SET "branch_id" = 37, "picking_id" = 146868, "related_core_purchase_line_id" = NULL, "related_core_repair_line_id" = NULL, "related_core_sale_line_id" = NULL, "scrapped" = false, "state" = 'confirmed', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (421610, 421611, 421612, 421613, 421614, 421615, 421616, 421617, 421618, 421619, 421620, 421621, 421622, 421623, 421624, 421625);
Date: 2023-05-17 14:44:08 Duration: 6s734ms
4 1s89ms 1s415ms 1s175ms 247 4m50s select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 17 12 48 57s936ms 1s207ms 13 31 35s336ms 1s139ms 14 7 7s941ms 1s134ms 15 15 18s227ms 1s215ms 16 15 17s955ms 1s197ms 17 42 49s224ms 1s172ms 18 70 1m20s 1s155ms 19 3 3s335ms 1s111ms 20 4 4s794ms 1s198ms 21 12 14s627ms 1s218ms -
select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;
Date: 2023-05-17 12:46:05 Duration: 1s415ms
-
select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;
Date: 2023-05-17 12:46:05 Duration: 1s376ms
-
select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;
Date: 2023-05-17 12:46:04 Duration: 1s372ms
5 410ms 5s167ms 896ms 377 5m38s update "stock_move" set "date" = ?, "is_done" = true, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 17 10 1 700ms 700ms 11 6 5s614ms 935ms 12 33 26s15ms 788ms 13 83 1m1s 746ms 14 31 35s55ms 1s130ms 15 27 27s167ms 1s6ms 16 17 22s344ms 1s314ms 17 79 1m5s 825ms 18 57 53s328ms 935ms 19 34 34s755ms 1s22ms 20 9 5s897ms 655ms -
UPDATE "stock_move" SET "date" = '2023-05-17 18:59:05', "is_done" = true, "state" = 'done', "write_uid" = 952, "write_date" = (now() at time zone 'UTC') WHERE id IN (422724, 422725, 422726, 422727, 422731, 422732, 422735);
Date: 2023-05-17 18:59:21 Duration: 5s167ms
-
UPDATE "stock_move" SET "date" = '2023-05-17 17:15:43', "is_done" = true, "state" = 'done', "write_uid" = 979, "write_date" = (now() at time zone 'UTC') WHERE id IN (422122, 422123, 422124, 422125, 422126, 422127);
Date: 2023-05-17 17:16:01 Duration: 4s419ms
-
UPDATE "stock_move" SET "date" = '2023-05-17 16:33:31', "is_done" = true, "state" = 'done', "write_uid" = 1237, "write_date" = (now() at time zone 'UTC') WHERE id IN (416626, 416627, 416628, 416630, 416632, 416633);
Date: 2023-05-17 16:33:37 Duration: 4s351ms
6 531ms 2s628ms 837ms 534 7m27s update "stock_move" set "current_warehouse_qty" = ?.?, "date" = ?, "is_done" = true, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 17 10 1 706ms 706ms 11 5 4s31ms 806ms 12 71 57s996ms 816ms 13 93 1m25s 919ms 14 91 1m18s 858ms 15 65 54s527ms 838ms 16 26 23s75ms 887ms 17 68 53s178ms 782ms 18 33 25s555ms 774ms 19 42 31s440ms 748ms 20 38 32s495ms 855ms 21 1 707ms 707ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 1.0, "date" = '2023-05-17 13:01:55', "is_done" = true, "state" = 'done', "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (420968, 420966, 420975);
Date: 2023-05-17 13:02:01 Duration: 2s628ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 10.0, "date" = '2023-05-17 13:19:59', "is_done" = true, "state" = 'done', "write_uid" = 1028, "write_date" = (now() at time zone 'UTC') WHERE id IN (421329, 421331);
Date: 2023-05-17 13:20:09 Duration: 2s349ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "date" = '2023-05-17 14:12:56', "is_done" = true, "state" = 'done', "write_uid" = 1000, "write_date" = (now() at time zone 'UTC') WHERE id IN (421484, 421486);
Date: 2023-05-17 14:13:02 Duration: 2s292ms
7 688ms 1s292ms 737ms 957 11m45s select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (("product_template"."is_core" is null or "product_template"."is_core" = false) and (("product_template"."type" in (...)) and (((((unaccent ("product_template"."default_code"::text) ilike unaccent (?)) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null)))) or unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?)) or false) or (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent (?)))))) and (("product_template"."company_id" in (...)) or "product_template"."company_id" is null) order by coalesce("product_template__name"."value", "product_template"."name") limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 17 10 4 2s862ms 715ms 11 59 43s121ms 730ms 12 128 1m34s 734ms 13 122 1m30s 738ms 14 120 1m28s 738ms 15 118 1m28s 748ms 16 100 1m12s 729ms 17 61 45s19ms 738ms 18 111 1m22s 746ms 19 82 59s979ms 731ms 20 43 31s566ms 734ms 21 1 728ms 728ms 22 8 5s688ms 711ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%e-9524-r%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%e-9524-r%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%e-9524-r%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%e-9524-r%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-05-17 15:18:08 Duration: 1s292ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%565f%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%565f%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%565f%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%565f%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-05-17 15:18:10 Duration: 1s120ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%169107%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%169107%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%169107%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%169107%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-05-17 12:54:29 Duration: 1s78ms
8 543ms 966ms 589ms 1,264 12m24s select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where (("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 17 12 51 29s697ms 582ms 13 91 54s10ms 593ms 14 173 1m43s 595ms 15 114 1m7s 590ms 16 24 14s519ms 604ms 17 285 2m48s 589ms 18 305 2m59s 589ms 19 190 1m50s 581ms 20 26 14s887ms 572ms 23 5 2s808ms 561ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%43029%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%43029%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%43029%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 14:42:06 Duration: 966ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%119%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%119%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%119%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 15:20:50 Duration: 952ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%2531%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%2-53-1%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%2-53-1%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 14:59:01 Duration: 863ms
9 548ms 848ms 587ms 597 5m50s select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 17 00 132 1m16s 579ms 11 15 8s622ms 574ms 12 30 17s195ms 573ms 13 45 26s609ms 591ms 14 48 28s55ms 584ms 15 94 56s416ms 600ms 16 41 24s82ms 587ms 17 25 15s38ms 601ms 18 126 1m14s 590ms 19 31 18s300ms 590ms 20 10 5s765ms 576ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%4707q%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4707q%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%4707q%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 15:58:35 Duration: 848ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%33050R%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%33050R%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%33050R%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 13:20:07 Duration: 777ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%wks4707%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%wks4707%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%wks4707%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 13:27:35 Duration: 748ms
10 537ms 1s8ms 587ms 4,390 42m59s select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where ((("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and ("product_product__product_tmpl_id"."sale_ok" is not null and "product_product__product_tmpl_id"."sale_ok" != false)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 17 09 96 55s156ms 574ms 11 275 2m38s 576ms 12 568 5m34s 588ms 13 661 6m32s 593ms 14 551 5m25s 591ms 15 445 4m20s 586ms 16 369 3m34s 581ms 17 413 4m4s 591ms 18 353 3m28s 589ms 19 421 4m8s 590ms 20 124 1m12s 582ms 21 91 51s560ms 566ms 22 23 13s466ms 585ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%361168%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%361-168%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%361-168%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 17:43:06 Duration: 1s8ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%qplae%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%qpl-a-e%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%qpl-a-e%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 19:36:49 Duration: 947ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%tv13%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%tv13%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%tv13%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 16:54:22 Duration: 941ms
11 553ms 1s163ms 587ms 463 4m31s select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where (((("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and ("product_product__product_tmpl_id"."purchase_ok" is not null and "product_product__product_tmpl_id"."purchase_ok" != false)) and (("product_product__product_tmpl_id"."type" != ?) or "product_product__product_tmpl_id"."type" is null)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 17 11 120 1m9s 576ms 12 68 40s409ms 594ms 13 24 14s99ms 587ms 14 17 10s189ms 599ms 15 25 16s774ms 670ms 16 85 48s812ms 574ms 17 46 26s471ms 575ms 18 49 29s76ms 593ms 19 15 8s733ms 582ms 20 14 8s117ms 579ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%A1805E44%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%A1805E44%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%A1805E44%'))) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 15:00:13 Duration: 1s163ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%A1805E447%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%A1805E447%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%A1805E447%'))) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 15:00:13 Duration: 1s103ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%A1805E%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%A1805E%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%A1805E%'))) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-17 15:00:12 Duration: 1s39ms
12 144ms 4s704ms 536ms 920 8m13s update "stock_quant" set "quantity" = ?.?, "reserved_quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 17 09 9 6s508ms 723ms 10 5 2s14ms 402ms 11 12 7s47ms 587ms 12 105 56s362ms 536ms 13 170 1m33s 549ms 14 149 1m27s 584ms 15 76 40s137ms 528ms 16 48 28s990ms 603ms 17 148 1m8s 465ms 18 94 51s712ms 550ms 19 80 38s86ms 476ms 20 23 12s758ms 554ms 21 1 412ms 412ms -
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (295686, 295688, 296108, 295536, 295953, 295955, 295957, 295670, 295960, 295962, 295964);
Date: 2023-05-17 18:25:50 Duration: 4s704ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (140899, 234820, 269095, 141064, 145900, 275468, 276594, 141299);
Date: 2023-05-17 14:58:00 Duration: 4s82ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (298385, 298387, 295039);
Date: 2023-05-17 14:05:29 Duration: 2s525ms
13 139ms 5s437ms 496ms 594 4m55s update "stock_quant" set "quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 17 09 2 803ms 401ms 11 16 8s286ms 517ms 12 52 22s190ms 426ms 13 71 31s370ms 441ms 14 92 37s853ms 411ms 15 71 35s452ms 499ms 16 34 18s766ms 551ms 17 120 57s874ms 482ms 18 43 31s716ms 737ms 19 79 41s917ms 530ms 20 14 8s880ms 634ms -
UPDATE "stock_quant" SET "quantity" = 0.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (294720, 294722, 1124, 294725, 1700, 294727, 294729, 294731, 294733, 294712, 294713, 294715, 294717);
Date: 2023-05-17 18:25:58 Duration: 5s437ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (246509, 55534, 55536, 55025, 55122, 55541);
Date: 2023-05-17 18:16:40 Duration: 4s741ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "write_uid" = 1001, "write_date" = (now() at time zone 'UTC') WHERE id IN (29253, 29254, 31495, 31494, 27788, 27789, 27822, 27823, 28016, 28017, 169845, 172277, 28122, 28123, 32222, 32223);
Date: 2023-05-17 12:28:38 Duration: 3s743ms
14 288ms 817ms 421ms 1,715 12m3s select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 17 10 1 349ms 349ms 11 113 36s973ms 327ms 12 246 1m30s 367ms 13 1 289ms 289ms 14 257 1m50s 429ms 15 1,047 7m50s 448ms 16 50 15s37ms 300ms -
select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;
Date: 2023-05-17 14:54:13 Duration: 817ms
-
select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;
Date: 2023-05-17 15:35:18 Duration: 737ms
-
select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;
Date: 2023-05-17 15:35:19 Duration: 735ms
15 245ms 401ms 274ms 1,086 4m58s select "sale_history_line".id from "sale_history_line" where ("sale_history_line"."so_line_id" in (...)) order by "sale_history_line"."id";Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 17 09 22 5s658ms 257ms 11 76 20s909ms 275ms 12 146 41s60ms 281ms 13 97 26s908ms 277ms 14 182 50s803ms 279ms 15 156 43s293ms 277ms 16 66 18s66ms 273ms 17 96 26s257ms 273ms 18 81 21s824ms 269ms 19 83 21s905ms 263ms 20 35 9s717ms 277ms 21 46 11s875ms 258ms -
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (156625)) ORDER BY "sale_history_line"."id";
Date: 2023-05-17 14:12:31 Duration: 401ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (156607)) ORDER BY "sale_history_line"."id";
Date: 2023-05-17 14:37:35 Duration: 396ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (61292)) ORDER BY "sale_history_line"."id";
Date: 2023-05-17 12:28:51 Duration: 395ms
16 221ms 361ms 232ms 572 2m13s select "sale_line_report".id from "sale_line_report" where ("sale_line_report"."real_line_id" in (...)) order by "sale_line_report"."id";Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 17 11 52 11s986ms 230ms 12 124 28s814ms 232ms 13 52 12s316ms 236ms 14 39 9s96ms 233ms 15 56 13s129ms 234ms 16 29 6s622ms 228ms 17 74 17s356ms 234ms 18 69 16s77ms 233ms 19 39 9s115ms 233ms 20 12 2s766ms 230ms 21 25 5s764ms 230ms 22 1 225ms 225ms -
SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (157194)) ORDER BY "sale_line_report"."id";
Date: 2023-05-17 19:36:38 Duration: 361ms
-
SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (156812)) ORDER BY "sale_line_report"."id";
Date: 2023-05-17 15:41:13 Duration: 351ms
-
SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (156768)) ORDER BY "sale_line_report"."id";
Date: 2023-05-17 15:11:43 Duration: 329ms
17 201ms 1s333ms 230ms 890 3m24s update "sale_order_line" set "invoice_status" = ?, "open_qty_fil" = ?.?, "qty_delivered" = ?, "qty_to_invoice" = ?, "untaxed_amount_to_invoice" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 17 09 15 3s212ms 214ms 10 5 1s113ms 222ms 11 15 3s255ms 217ms 12 123 28s99ms 228ms 13 160 35s708ms 223ms 14 179 40s676ms 227ms 15 101 25s471ms 252ms 16 62 15s74ms 243ms 17 88 21s11ms 238ms 18 55 12s148ms 220ms 19 72 15s774ms 219ms 20 14 3s6ms 214ms 21 1 230ms 230ms -
UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 1.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1237, "write_date" = (now() at time zone 'UTC') WHERE id IN (154184, 154185, 154187, 154188, 154189, 154198);
Date: 2023-05-17 16:32:21 Duration: 1s333ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 5.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1007, "write_date" = (now() at time zone 'UTC') WHERE id IN (154857, 149355, 149356, 149357, 154865, 154867);
Date: 2023-05-17 15:54:11 Duration: 1s331ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 10.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1007, "write_date" = (now() at time zone 'UTC') WHERE id IN (154912, 149346, 154917, 154922, 154911);
Date: 2023-05-17 15:54:09 Duration: 1s77ms
18 203ms 524ms 223ms 692 2m34s update "sale_order_line" set "branch_id" = ?, "currency_id" = ?, "cus_date_order" = ?, "cus_part_route" = ?, "cus_user_id" = ?, "inventory_vendor_id" = ?, "is_service" = false, "margin" = ?, "margin_percent" = ?.?, "order_partner_id" = ?, "price_reduce" = ?, "price_reduce_taxexcl" = ?, "price_reduce_taxinc" = ?, "price_subtotal" = ?, "price_tax" = ?.?, "price_total" = ?, "purchase_price" = ?, "qty_delivered_method" = ?, "qty_invoiced" = ?, "qty_to_invoice" = ?, "salesman_id" = ?, "untaxed_amount_invoiced" = ?, "untaxed_amount_to_invoice" = ?, "warehouse_id" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 17 11 52 11s558ms 222ms 12 103 22s938ms 222ms 13 107 23s988ms 224ms 14 85 18s990ms 223ms 15 70 15s941ms 227ms 16 54 11s917ms 220ms 17 62 13s763ms 221ms 18 52 11s846ms 227ms 19 66 14s848ms 224ms 20 18 4s78ms 226ms 21 21 4s578ms 218ms 22 2 444ms 222ms -
UPDATE "sale_order_line" SET "branch_id" = 37, "currency_id" = 2, "cus_date_order" = '2023-05-17 18:02:28', "cus_part_route" = NULL, "cus_user_id" = 993, "inventory_vendor_id" = 3026, "is_service" = false, "margin" = '61.67', "margin_percent" = 0.45001459427904267, "order_partner_id" = 39632, "price_reduce" = '137.04', "price_reduce_taxexcl" = '137.04', "price_reduce_taxinc" = '137.04', "price_subtotal" = '137.04', "price_tax" = 0.0, "price_total" = '137.04', "purchase_price" = '75.37', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 993, "untaxed_amount_invoiced" = '0.00', "untaxed_amount_to_invoice" = '0.00', "warehouse_id" = 35, "write_uid" = 1010, "write_date" = (now() at time zone 'UTC') WHERE id IN (157056);
Date: 2023-05-17 18:03:24 Duration: 524ms
-
UPDATE "sale_order_line" SET "branch_id" = 46, "currency_id" = 2, "cus_date_order" = '2023-05-17 14:59:53', "cus_part_route" = NULL, "cus_user_id" = 1009, "inventory_vendor_id" = 3089, "is_service" = false, "margin" = '4.15', "margin_percent" = 0.3900375939849624, "order_partner_id" = 33310, "price_reduce" = '10.64', "price_reduce_taxexcl" = '10.64', "price_reduce_taxinc" = '10.64', "price_subtotal" = '10.64', "price_tax" = 0.0, "price_total" = '10.64', "purchase_price" = '6.49', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 1009, "untaxed_amount_invoiced" = '0.00', "untaxed_amount_to_invoice" = '0.00', "warehouse_id" = 43, "write_uid" = 964, "write_date" = (now() at time zone 'UTC') WHERE id IN (156752);
Date: 2023-05-17 15:00:12 Duration: 407ms
-
UPDATE "sale_order_line" SET "branch_id" = 48, "currency_id" = 2, "cus_date_order" = '2023-05-17 16:54:42', "cus_part_route" = NULL, "cus_user_id" = 965, "inventory_vendor_id" = 3076, "is_service" = false, "margin" = '40.92', "margin_percent" = 0.31002348662777485, "order_partner_id" = 46209, "price_reduce" = '131.99', "price_reduce_taxexcl" = '131.99', "price_reduce_taxinc" = '131.99', "price_subtotal" = '131.99', "price_tax" = 0.0, "price_total" = '131.99', "purchase_price" = '91.07', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 965, "untaxed_amount_invoiced" = '0.00', "untaxed_amount_to_invoice" = '0.00', "warehouse_id" = 45, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (157019);
Date: 2023-05-17 17:43:49 Duration: 374ms
19 120ms 582ms 222ms 7,199 26m40s select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 17 00 104 17s892ms 172ms 01 30 5s427ms 180ms 02 19 3s243ms 170ms 03 28 4s871ms 173ms 04 33 5s610ms 170ms 05 160 28s926ms 180ms 06 168 28s644ms 170ms 07 107 19s314ms 180ms 08 139 24s702ms 177ms 09 86 15s911ms 185ms 10 83 16s575ms 199ms 11 201 37s570ms 186ms 12 395 1m18s 197ms 13 741 2m33s 207ms 14 603 2m17s 227ms 15 771 2m49s 220ms 16 767 3m13s 252ms 17 662 2m30s 227ms 18 588 2m36s 266ms 19 579 2m38s 274ms 20 398 1m34s 237ms 21 128 23s725ms 185ms 22 149 27s206ms 182ms 23 260 48s353ms 185ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-17 15:51:37') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_990"', '["pointspring_master","calendar.alarm",19528]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",74]', '["pointspring_master","mail.channel",75]', '["pointspring_master","mail.channel",76]', '["pointspring_master","mail.channel",77]', '["pointspring_master","mail.channel",339]', '["pointspring_master","mail.channel",473]', '["pointspring_master","res.partner",19528]', '["pointspring_master","ir.needaction",19528]'))) ORDER BY "bus_bus"."id";
Date: 2023-05-17 15:52:27 Duration: 582ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-17 15:51:37') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1017"', '["pointspring_master","calendar.alarm",19555]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",36]', '["pointspring_master","mail.channel",41]', '["pointspring_master","mail.channel",42]', '["pointspring_master","mail.channel",503]', '["pointspring_master","res.partner",19555]', '["pointspring_master","ir.needaction",19555]'))) ORDER BY "bus_bus"."id";
Date: 2023-05-17 15:52:27 Duration: 575ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-17 15:51:37') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1015"', '["pointspring_master","calendar.alarm",19553]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",51]', '["pointspring_master","mail.channel",52]', '["pointspring_master","mail.channel",53]', '["pointspring_master","mail.channel",346]', '["pointspring_master","mail.channel",347]', '["pointspring_master","mail.channel",457]', '["pointspring_master","res.partner",19553]', '["pointspring_master","ir.needaction",19553]'))) ORDER BY "bus_bus"."id";
Date: 2023-05-17 15:52:27 Duration: 575ms
20 200ms 652ms 220ms 752 2m46s update "sale_order_line" set "invoice_status" = ?, "qty_invoiced" = ?, "qty_to_invoice" = ?, "untaxed_amount_invoiced" = ?, "untaxed_amount_to_invoice" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 17 09 15 3s169ms 211ms 10 5 1s92ms 218ms 11 12 2s500ms 208ms 12 108 24s40ms 222ms 13 148 32s413ms 219ms 14 141 31s905ms 226ms 15 99 21s310ms 215ms 16 59 13s112ms 222ms 17 71 15s524ms 218ms 18 32 6s975ms 217ms 19 48 11s17ms 229ms 20 13 2s821ms 217ms 21 1 214ms 214ms -
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '1.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '119.89', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (156584, 156585, 156586);
Date: 2023-05-17 14:58:26 Duration: 652ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '2.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '358.18', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1237, "write_date" = (now() at time zone 'UTC') WHERE id IN (127668);
Date: 2023-05-17 19:11:54 Duration: 476ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '100.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '177.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1237, "write_date" = (now() at time zone 'UTC') WHERE id IN (147515, 147516);
Date: 2023-05-17 19:59:16 Duration: 454ms
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 59,170 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 1566 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 811 Max number of times the same event was reported
- 1,566 Total events found
Rank Times reported Error 1 811 ERROR: could not obtain lock on row in relation "..."
Times Reported Most Frequent Error / Event #1
Day Hour Count May 17 00 64 01 68 02 56 03 45 04 47 05 48 06 50 07 77 08 47 09 46 10 28 11 15 12 10 13 12 14 9 15 17 16 19 17 17 18 10 19 8 20 9 21 12 22 44 23 53 - ERROR: could not obtain lock on row in relation "ir_cron"
- ERROR: could not obtain lock on row in relation "website_visitor"
- ERROR: could not obtain lock on row in relation "stock_quant"
Statement: SELECT * FROM ir_cron WHERE numbercall != 0 AND active AND nextcall <= (now() at time zone 'UTC') AND id=65 FOR UPDATE NOWAIT
Date: 2023-05-17 00:10:09
Statement: SELECT * FROM website_visitor where id = 15370 FOR NO KEY UPDATE NOWAIT
Date: 2023-05-17 11:58:58
Statement: SELECT 1 FROM stock_quant WHERE id = 278126 FOR UPDATE NOWAIT
Date: 2023-05-17 13:02:27
2 694 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #2
Day Hour Count May 17 00 2 02 2 03 5 06 3 07 2 08 6 09 1 10 7 11 45 12 121 13 97 14 69 15 82 16 37 17 35 18 73 19 59 20 31 21 4 22 7 23 6 - ERROR: could not serialize access due to concurrent update
Statement: UPDATE "bus_presence" SET "last_poll"='2023-05-17 00:39:43',"last_presence"='2023-05-17 00:39:43.455538' WHERE id IN (152)
Date: 2023-05-17 00:39:43
3 39 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #3
Day Hour Count May 17 12 10 13 6 14 5 15 10 16 2 17 4 19 2 - ERROR: process 1841018 still waiting for ShareLock on transaction 186227372 after 1000.058 ms
- ERROR: process 1876979 still waiting for ShareLock on transaction 186228780 after 1000.058 ms
- ERROR: process 1844252 still waiting for ShareLock on transaction 186229304 after 1000.044 ms
Detail: Process holding the lock: 1876952. Wait queue: 1841018.
Context: while updating tuple (22109,12) in relation "account_move"
Statement: UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 641433 AND sequence_prefix = (SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 641433 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1 ) RETURNING name;Date: 2023-05-17 12:33:18
Detail: Process holding the lock: 1877834. Wait queue: 1876979.
Context: while updating tuple (22100,22) in relation "account_move"
Statement: UPDATE "account_move" SET "access_token"='ac7c6869-82ee-48fc-9a68-f1822f466092',"is_move_sent"=true,"write_uid"=971,"write_date"=(now() at time zone 'UTC') WHERE id IN (641462)Date: 2023-05-17 12:41:59
Detail: Process holding the lock: 1867300. Wait queue: 1844252.
Context: while updating tuple (22134,4) in relation "account_move"
Statement: UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 641477 AND sequence_prefix = (SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 641477 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1 ) RETURNING name;Date: 2023-05-17 12:44:51
4 6 ERROR: current transaction is aborted, commands ignored until end of transaction block
Times Reported Most Frequent Error / Event #4
Day Hour Count May 17 11 1 12 1 13 1 14 2 18 1 - ERROR: current transaction is aborted, commands ignored until end of transaction block
Statement: SELECT "ir_ui_view".id FROM "ir_ui_view" LEFT JOIN "website" AS "ir_ui_view__website_id" ON ("ir_ui_view"."website_id" = "ir_ui_view__website_id"."id") WHERE (("ir_ui_view"."active" = true) AND (("ir_ui_view"."key" = 'http_routing.http_error') AND (("ir_ui_view"."website_id" in (1)) OR "ir_ui_view"."website_id" IS NULL))) ORDER BY "ir_ui_view__website_id"."id" LIMIT 1
Date: 2023-05-17 11:20:21
5 5 ERROR: duplicate key value violates unique constraint "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count May 17 12 2 19 3 - ERROR: duplicate key value violates unique constraint "mail_followers_mail_followers_res_partner_res_model_id_uniq"
- ERROR: duplicate key value violates unique constraint "fleet_vehicle_vehicle_unit_no_driver_id_unique"
- ERROR: duplicate key value violates unique constraint "fleet_vehicle_vin_sn_unique"
Detail: Key (res_model, res_id, partner_id)=(sale.order, 53525, 19548) already exists.
Statement: INSERT INTO "mail_followers" ("id", "channel_id", "partner_id", "res_id", "res_model") VALUES (nextval('mail_followers_id_seq'), NULL, 19548, 53525, 'sale.order') RETURNING idDate: 2023-05-17 12:06:27
Detail: Key (vehicle_unit_no, driver_id)=(987, 34094) already exists.
Statement: INSERT INTO "fleet_vehicle" ("id", "create_uid", "create_date", "write_uid", "write_date", "acquisition_date", "active", "brand_id", "car_value", "co2", "color", "company_id", "description", "doors", "driver_id", "first_contract_date", "fuel_type", "future_driver_id", "horsepower", "horsepower_tax", "license_plate", "location", "manager_id", "model_id", "model_vehicle_type", "model_year", "name", "net_car_value", "next_assignation_date", "odometer_unit", "power", "residual_value", "seats", "state_id", "transmission", "vehicle_unit_no", "vin_sn") VALUES (nextval('fleet_vehicle_id_seq'), 978, (now() at time zone 'UTC'), 978, (now() at time zone 'UTC'), '2023-05-17', true, 105, 0.0, 0.0, NULL, 1, NULL, 5, 34094, '2023-05-17', NULL, NULL, 0, 0.0, NULL, NULL, 2, 237, 21, NULL, 'F', 0.0, NULL, 'miles', 0, 0.0, 0, 3, NULL, '987', 'XXXXXXXX') RETURNING idDate: 2023-05-17 12:30:02
Detail: Key (vin_sn)=(5PU60521) already exists.
Statement: INSERT INTO "fleet_vehicle" ("id", "create_uid", "create_date", "write_uid", "write_date", "acquisition_date", "active", "brand_id", "car_value", "co2", "color", "company_id", "description", "doors", "driver_id", "first_contract_date", "fuel_type", "future_driver_id", "horsepower", "horsepower_tax", "license_plate", "location", "manager_id", "model_id", "model_vehicle_type", "model_year", "name", "net_car_value", "next_assignation_date", "odometer_unit", "power", "residual_value", "seats", "state_id", "transmission", "vehicle_unit_no", "vin_sn") VALUES (nextval('fleet_vehicle_id_seq'), 1235, (now() at time zone 'UTC'), 1235, (now() at time zone 'UTC'), '2023-05-17', true, 132, 0.0, 0.0, NULL, 1, NULL, 5, 34096, '2023-05-17', NULL, NULL, 0, 0.0, NULL, NULL, 2, 226, 28, NULL, 'wes', 0.0, NULL, 'miles', 0, 0.0, 0, 3, NULL, '5PU60521', '5PU60521') RETURNING idDate: 2023-05-17 19:05:43
6 3 LOG: process ... still waiting for ExclusiveLock on tuple (...) of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #6
Day Hour Count May 17 12 2 15 1 - ERROR: process 1841018 still waiting for ExclusiveLock on tuple (22134,4) of relation 42418 of database 65946 after 1000.045 ms
- ERROR: process 1840550 still waiting for ExclusiveLock on tuple (8283,26) of relation 42418 of database 65946 after 1000.068 ms
- ERROR: process 2210580 still waiting for ExclusiveLock on tuple (22293,10) of relation 42418 of database 65946 after 1000.058 ms
Detail: Process holding the lock: 1844252. Wait queue: 1841018.
Statement: UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 639532 AND sequence_prefix = (SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 639532 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1 ) RETURNING name;Date: 2023-05-17 12:44:51
Detail: Process holding the lock: 1840748. Wait queue: 1840550.
Statement: UPDATE "account_move" SET "message_main_attachment_id"=2530305,"write_uid"=1026,"write_date"=(now() at time zone 'UTC') WHERE id IN (641608)Date: 2023-05-17 12:58:22
Detail: Process holding the lock: 2211861. Wait queue: 2210580.
Statement: UPDATE "account_move" SET "message_main_attachment_id"=2532749,"write_uid"=972,"write_date"=(now() at time zone 'UTC') WHERE id IN (642854)Date: 2023-05-17 15:56:00
7 2 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count May 17 17 2 - ERROR: syntax error at or near ")" at character 149
Statement: select product.id from product_product product LEFT JOIN product_template pt ON (pt.id = product.product_tmpl_id) where product.id in () and pt.is_core = True
Date: 2023-05-17 17:24:37
8 2 ERROR: could not create unique index "..."
Times Reported Most Frequent Error / Event #8
Day Hour Count May 17 08 2 - ERROR: could not create unique index "vendor_account_master_unique_acc_no"
Detail: Key (account_number)=(P10394) is duplicated.
Statement: ALTER TABLE "vendor_account_master" ADD CONSTRAINT "vendor_account_master_unique_acc_no" unique (account_number)Date: 2023-05-17 08:12:05
9 2 ERROR: null value in column "..." of relation "..." violates not-null constraint
Times Reported Most Frequent Error / Event #9
Day Hour Count May 17 16 2 - ERROR: null value in column "branch_id" of relation "account_move_line" violates not-null constraint
Detail: Failing row contains (2337317, 642917, null, null, null, null, null, 1, 2, null, null, 10, null, 1.00, null, 0.00, 22746.16, 22746.16, null, 0.00, null, null, null, f, null, 2, null, null, null, null, null, null, null, null, null, null, t, null, null, null, null, null, null, null, null, null, null, 956, 2023-05-17 16:07:44.44323, 956, 2023-05-17 16:07:44.44323, null, null, null, null, null, null, null, null, null, null, new_product, 1, null, null, null, null, null, null, null, null, null, null, t, null, null, null, null, null, null, null).
Statement: INSERT INTO "account_move_line" ("id", "create_uid", "create_date", "write_uid", "write_date", "account_id", "amount_currency", "blocked", "branch_id", "company_currency_id", "company_id", "credit", "currency_id", "debit", "discount", "display_type", "is_visible_in_report", "move_id", "move_options", "name", "quantity", "sequence", "sign_product_qty", "tax_exigible") VALUES (nextval('account_move_line_id_seq'), 956, (now() at time zone 'UTC'), 956, (now() at time zone 'UTC'), NULL, '0.00', false, NULL, 2, 1, '22746.16', 2, '22746.16', '0.00', NULL, true, 642917, 'new_product', NULL, '1.00', 10, 1.0, true) RETURNING idDate: 2023-05-17 16:07:44
10 1 LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #10
Day Hour Count May 17 08 1 - ERROR: process 1840751 still waiting for AccessShareLock on relation 43699 of database 65946 after 1000.049 ms at character 34
Detail: Process holding the lock: 1840729. Wait queue: 1840751.
Statement: SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.template') ORDER BY "ir_model_fields"."name"Date: 2023-05-17 08:12:25
11 1 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count May 17 09 1 - ERROR: column res_partner.blanket_po does not exist at character 5413
Statement: SELECT "res_partner"."id" as "id", "res_partner"."display_name" as "display_name", "res_partner"."date" as "date", "res_partner"."title" as "title", "res_partner"."parent_id" as "parent_id", "res_partner"."lang" as "lang", "res_partner"."tz" as "tz", "res_partner"."vat" as "vat", "res_partner"."website" as "website", "res_partner"."comment" as "comment", "res_partner"."active" as "active", "res_partner"."employee" as "employee", "res_partner"."function" as "function", "res_partner"."partner_latitude" as "partner_latitude", "res_partner"."partner_longitude" as "partner_longitude", "res_partner"."mobile" as "mobile", "res_partner"."is_company" as "is_company", "res_partner"."industry_id" as "industry_id", "res_partner"."company_id" as "company_id", "res_partner"."color" as "color", "res_partner"."partner_share" as "partner_share", "res_partner"."commercial_partner_id" as "commercial_partner_id", "res_partner"."commercial_company_name" as "commercial_company_name", "res_partner"."company_name" as "company_name", "res_partner"."date_localization" as "date_localization", "res_partner"."message_main_attachment_id" as "message_main_attachment_id", "res_partner"."email_normalized" as "email_normalized", "res_partner"."message_bounce" as "message_bounce", "res_partner"."email" as "email", "res_partner"."phone" as "phone", "res_partner"."user_id" as "user_id", "res_partner"."contact_address_complete" as "contact_address_complete", "res_partner"."calendar_last_notif_ack" as "calendar_last_notif_ack", "res_partner"."plan_to_change_car" as "plan_to_change_car", "res_partner"."phone_sanitized" as "phone_sanitized", "res_partner"."ocn_token" as "ocn_token", "res_partner"."partner_gid" as "partner_gid", "res_partner"."additional_info" as "additional_info", "res_partner"."debit_limit" as "debit_limit", "res_partner"."last_time_entries_checked" as "last_time_entries_checked", "res_partner"."invoice_warn" as "invoice_warn", "res_partner"."invoice_warn_msg" as "invoice_warn_msg", "res_partner"."supplier_rank" as "supplier_rank", "res_partner"."customer_rank" as "customer_rank", "res_partner"."team_id" as "team_id", "res_partner"."picking_warn" as "picking_warn", "res_partner"."picking_warn_msg" as "picking_warn_msg", COALESCE("res_partner__website_meta_title"."value", "res_partner"."website_meta_title") as "website_meta_title", COALESCE("res_partner__website_meta_description"."value", "res_partner"."website_meta_description") as "website_meta_description", COALESCE("res_partner__website_meta_keywords"."value", "res_partner"."website_meta_keywords") as "website_meta_keywords", "res_partner"."website_meta_og_img" as "website_meta_og_img", COALESCE("res_partner__seo_name"."value", "res_partner"."seo_name") as "seo_name", "res_partner"."website_id" as "website_id", "res_partner"."is_published" as "is_published", "res_partner"."online_partner_vendor_name" as "online_partner_vendor_name", "res_partner"."online_partner_bank_account" as "online_partner_bank_account", "res_partner"."is_1099" as "is_1099", "res_partner"."type_1099_id" as "type_1099_id", "res_partner"."box_1099_misc_id" as "box_1099_misc_id", "res_partner"."purchase_warn" as "purchase_warn", "res_partner"."purchase_warn_msg" as "purchase_warn_msg", COALESCE("res_partner__website_short_description"."value", "res_partner"."website_short_description") as "website_short_description", "res_partner"."sale_warn" as "sale_warn", "res_partner"."sale_warn_msg" as "sale_warn_msg", "res_partner"."credit_limit" as "credit_limit", "res_partner"."check_credit_limit" as "check_credit_limit", "res_partner"."partner_weight" as "partner_weight", "res_partner"."grade_id" as "grade_id", "res_partner"."grade_sequence" as "grade_sequence", "res_partner"."activation" as "activation", "res_partner"."date_partnership" as "date_partnership", "res_partner"."date_review" as "date_review", "res_partner"."date_review_next" as "date_review_next", "res_partner"."assigned_partner_id" as "assigned_partner_id", "res_partner"."implemented_count" as "implemented_count", "res_partner"."branch_id" as "branch_id", "res_partner"."hdatp" as "hdatp", "res_partner"."product" as "product", "res_partner"."delete_flag" as "delete_flag", "res_partner"."ssn" as "ssn", "res_partner"."is_tax_exempt" as "is_tax_exempt", "res_partner"."f_name" as "f_name", "res_partner"."is_self_used" as "is_self_used", "res_partner"."sales_tax" as "sales_tax", "res_partner"."exempt" as "exempt", "res_partner"."name" as "name", "res_partner"."street" as "street", "res_partner"."street2" as "street2", "res_partner"."zip" as "zip", "res_partner"."city" as "city", "res_partner"."state_id" as "state_id", "res_partner"."country_id" as "country_id", "res_partner"."part_business" as "part_business", "res_partner"."part_vocation" as "part_vocation", "res_partner"."part_route" as "part_route", "res_partner"."mon_deli_day" as "mon_deli_day", "res_partner"."tue_deli_day" as "tue_deli_day", "res_partner"."wed_deli_day" as "wed_deli_day", "res_partner"."thu_deli_day" as "thu_deli_day", "res_partner"."fri_deli_day" as "fri_deli_day", "res_partner"."identification_type_id" as "identification_type_id", "res_partner"."core_bank_partner" as "core_bank_partner", "res_partner"."core_bank_day" as "core_bank_day", "res_partner"."core_invoice_type" as "core_invoice_type", "res_partner"."ref" as "ref", "res_partner"."order_number_required" as "order_number_required", "res_partner"."blanket_po" as "blanket_po", "res_partner"."print_backorder_inv" as "print_backorder_inv", "res_partner"."receive_email_invoices" as "receive_email_invoices", "res_partner"."receive_email_statements_bool" as "receive_email_statements_bool", "res_partner"."action_email" as "action_email", "res_partner"."cod_flag" as "cod_flag", "res_partner"."cod_date" as "cod_date", "res_partner"."cod_not" as "cod_not", "res_partner"."cod_comment" as "cod_comment", "res_partner"."created_date_editable" as "created_date_editable", "res_partner"."customer_cus" as "customer_cus", "res_partner"."vendor_cus" as "vendor_cus", "res_partner"."fax" as "fax", "res_partner"."delivery_type" as "delivery_type", "res_partner"."type" as "type", "res_partner"."allowed_branch" as "allowed_branch", "res_partner"."first_active_date" as "first_active_date", "res_partner"."email_inv_subacc" as "email_inv_subacc", "res_partner"."contact_address_ref" as "contact_address_ref", "res_partner"."vendor_type" as "vendor_type", "res_partner"."paid_by_vc" as "paid_by_vc", "res_partner"."current_date" as "current_date", "res_partner"."receive_email_statements" as "receive_email_statements", "res_partner"."customer_statement_sent" as "customer_statement_sent", "res_partner"."send_assigned_by_seller_account" as "send_assigned_by_seller_account", "res_partner"."has_edi_arrangement" as "has_edi_arrangement", "res_partner"."create_uid" as "create_uid", "res_partner"."create_date" as "create_date", "res_partner"."write_uid" as "write_uid", "res_partner"."write_date" as "write_date" FROM "res_partner" LEFT JOIN "ir_translation" AS "res_partner__website_meta_title" ON ("res_partner"."id" = "res_partner__website_meta_title"."res_id" AND "res_partner__website_meta_title"."type" = 'model' AND "res_partner__website_meta_title"."name" = 'res.partner,website_meta_title' AND "res_partner__website_meta_title"."lang" = 'en_US' AND "res_partner__website_meta_title"."value" != '') LEFT JOIN "ir_translation" AS "res_partner__website_meta_description" ON ("res_partner"."id" = "res_partner__website_meta_description"."res_id" AND "res_partner__website_meta_description"."type" = 'model' AND "res_partner__website_meta_description"."name" = 'res.partner,website_meta_description' AND "res_partner__website_meta_description"."lang" = 'en_US' AND "res_partner__website_meta_description"."value" != '') LEFT JOIN "ir_translation" AS "res_partner__website_meta_keywords" ON ("res_partner"."id" = "res_partner__website_meta_keywords"."res_id" AND "res_partner__website_meta_keywords"."type" = 'model' AND "res_partner__website_meta_keywords"."name" = 'res.partner,website_meta_keywords' AND "res_partner__website_meta_keywords"."lang" = 'en_US' AND "res_partner__website_meta_keywords"."value" != '') LEFT JOIN "ir_translation" AS "res_partner__seo_name" ON ("res_partner"."id" = "res_partner__seo_name"."res_id" AND "res_partner__seo_name"."type" = 'model' AND "res_partner__seo_name"."name" = 'res.partner,seo_name' AND "res_partner__seo_name"."lang" = 'en_US' AND "res_partner__seo_name"."value" != '') LEFT JOIN "ir_translation" AS "res_partner__website_short_description" ON ("res_partner"."id" = "res_partner__website_short_description"."res_id" AND "res_partner__website_short_description"."type" = 'model' AND "res_partner__website_short_description"."name" = 'res.partner,website_short_description' AND "res_partner__website_short_description"."lang" = 'en_US' AND "res_partner__website_short_description"."value" != '') WHERE "res_partner".id IN (1)
Date: 2023-05-17 09:10:35