pgBadger-
Global information
- Generated on Tue Feb 20 00:50:05 2024
- Log file: /var/log/postgresql/postgresql-14-main.log
- Parsed 192,871 log entries in 4s
- Log start from 2024-02-19 00:00:42 to 2024-02-19 23:59:05
-
Overview
Global Stats
- 1,307 Number of unique normalized queries
- 68,241 Number of queries
- 8h15m Total query duration
- 2024-02-19 00:00:42 First query
- 2024-02-19 23:56:29 Last query
- 71 queries/s at 2024-02-19 19:10:53 Query peak
- 8h15m Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h15m Execute total duration
- 1,374 Number of events
- 9 Number of unique normalized events
- 733 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
- 68,241 Average queries per session
- 8h15m 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
- 71 queries/s Query Peak
- 2024-02-19 19:10:53 Date
SELECT Traffic
Key values
- 71 queries/s Query Peak
- 2024-02-19 19:10:53 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 11 queries/s Query Peak
- 2024-02-19 18:21:22 Date
Queries duration
Key values
- 8h15m 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) Feb 19 00 304 0ms 715ms 296ms 6s562ms 12s321ms 12s933ms 01 667 0ms 4s61ms 321ms 17s358ms 18s513ms 25s67ms 02 608 0ms 7s36ms 335ms 16s643ms 22s40ms 28s683ms 03 107 0ms 526ms 259ms 1s648ms 3s496ms 8s820ms 04 71 0ms 1s14ms 349ms 4s957ms 9s869ms 9s869ms 05 68 0ms 733ms 388ms 834ms 1s658ms 19s627ms 06 137 0ms 989ms 348ms 4s502ms 11s661ms 13s60ms 07 152 0ms 702ms 306ms 1s719ms 12s264ms 15s37ms 08 203 0ms 763ms 393ms 12s805ms 12s861ms 23s35ms 09 648 0ms 3m50s 1s424ms 1m7s 1m34s 3m50s 10 402 0ms 714ms 236ms 4s283ms 5s750ms 18s433ms 11 124 0ms 1s687ms 372ms 2s844ms 3s889ms 14s443ms 12 3,499 120ms 2m27s 438ms 58s864ms 1m26s 3m51s 13 5,934 120ms 18s456ms 442ms 1m26s 1m56s 2m18s 14 7,344 120ms 40s174ms 452ms 1m36s 2m10s 2m54s 15 10,225 120ms 43s910ms 406ms 2m27s 2m35s 2m42s 16 6,636 120ms 30s204ms 418ms 1m28s 1m46s 2m42s 17 5,538 120ms 18s874ms 446ms 1m32s 1m48s 2m35s 18 9,014 120ms 15s532ms 344ms 1m50s 2m45s 3m44s 19 6,449 120ms 13s455ms 440ms 1m31s 2m18s 3m38s 20 5,426 120ms 33s446ms 522ms 1m24s 1m45s 1m53s 21 2,962 120ms 10s620ms 441ms 46s656ms 54s316ms 1m13s 22 915 0ms 4s791ms 402ms 17s444ms 27s292ms 42s303ms 23 808 0ms 1m19s 662ms 37s580ms 44s292ms 1m25s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Feb 19 00 304 0 296ms 2s695ms 6s562ms 12s933ms 01 333 0 311ms 5s304ms 11s205ms 17s358ms 02 272 0 325ms 2s807ms 7s174ms 19s977ms 03 107 0 259ms 956ms 1s648ms 8s820ms 04 67 0 351ms 1s368ms 4s957ms 9s869ms 05 68 0 388ms 831ms 834ms 19s627ms 06 137 0 348ms 979ms 4s502ms 13s60ms 07 152 0 306ms 1s157ms 1s719ms 15s37ms 08 202 0 391ms 3s846ms 12s805ms 23s35ms 09 524 98 1s465ms 41s301ms 1m7s 3m50s 10 402 0 236ms 3s715ms 4s283ms 18s433ms 11 124 0 372ms 2s472ms 2s844ms 14s443ms 12 2,499 0 430ms 37s441ms 46s744ms 1m 13 4,448 0 450ms 47s746ms 1m7s 1m45s 14 5,058 0 462ms 53s805ms 1m20s 2m17s 15 7,782 0 402ms 1m23s 1m52s 2m15s 16 4,492 0 440ms 55s184ms 1m13s 1m47s 17 4,379 0 460ms 49s969ms 1m27s 1m42s 18 6,646 0 324ms 54s24ms 1m22s 2m45s 19 4,494 0 439ms 51s141ms 1m15s 2m2s 20 4,012 0 539ms 46s403ms 1m9s 1m48s 21 2,291 0 466ms 27s995ms 36s348ms 51s632ms 22 627 0 479ms 9s977ms 15s451ms 42s303ms 23 526 0 302ms 4s338ms 8s79ms 40s353ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Feb 19 00 0 0 0 0 0ms 0ms 0ms 0ms 01 148 182 3 0 332ms 2s677ms 7s650ms 11s134ms 02 157 178 1 0 342ms 2s94ms 6s572ms 13s625ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 4 0 0 314ms 0ms 0ms 629ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 1 0 0 680ms 0ms 0ms 0ms 09 0 26 0 0 447ms 0ms 0ms 2s384ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 24 971 4 0 456ms 3s516ms 8s688ms 31s358ms 13 55 1,395 32 0 419ms 9s795ms 15s982ms 27s907ms 14 91 2,130 57 0 429ms 14s639ms 22s650ms 39s496ms 15 63 2,324 48 0 422ms 15s362ms 26s849ms 46s882ms 16 116 1,966 60 0 372ms 11s459ms 19s238ms 31s946ms 17 33 1,098 24 0 393ms 8s38ms 11s286ms 17s871ms 18 48 2,285 28 0 399ms 14s864ms 22s605ms 49s282ms 19 136 1,765 46 0 442ms 12s347ms 22s686ms 47s591ms 20 57 1,316 36 0 473ms 7s901ms 15s936ms 43s690ms 21 52 608 10 0 358ms 3s103ms 6s389ms 13s793ms 22 28 259 1 0 234ms 800ms 2s141ms 5s646ms 23 7 243 32 0 1s334ms 3s343ms 7s512ms 46s274ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Feb 19 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 Feb 19 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 Feb 19 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 Feb 19 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 Feb 19 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) Feb 19 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 Feb 19 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 Feb 19 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 Feb 19 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
- 20 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 11 43s690ms 10s224ms 10s224ms 3s971ms 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 != 1214681 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 != 1214681 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;
Date: 2024-02-19 17:18:09
2 3 9s66ms 3s190ms 4s267ms 3s22ms 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" = 5083642, "write_uid" = 1028, "write_date" = (now() at time zone 'UTC') WHERE id IN (1215431);
Date: 2024-02-19 19:13:15
3 1 7s656ms 7s656ms 7s656ms 7s656ms insert into "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "note", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "warehouse_id") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), false, null, ?, ?, ?, ?, ?, true, ?, ?, ?, ?, null, ?, ?, ?, ?, ?, ?, ?, ?, true, ?, ?, ?, ?) returning id;-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "note", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1015, (now() at time zone 'UTC'), 1015, (now() at time zone 'UTC'), false, NULL, 42, 1, '2024-02-22 19:37:43.725529', 40, 225106, true, 421, 468, 'core_return_1', '07-L/INT/04457', NULL, 'Warehouse Inventory Transfer to BLS', 347202, 317, '0', 'make_to_stock', 237185, 1, '4.00', true, 10, 38, 'draft', 40) RETURNING id;
Date: 2024-02-19 19:37:51
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "note", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1015, (now() at time zone 'UTC'), 1015, (now() at time zone 'UTC'), false, NULL, 42, 1, '2024-02-22 19:37:43.725529', 40, 225106, true, 421, 468, 'core_return_1', '07-L/INT/04457', NULL, 'Warehouse Inventory Transfer to BLS', 347202, 317, '0', 'make_to_stock', 237202, 1, '148.00', true, 10, 38, 'draft', 40) RETURNING id;
Date: 2024-02-19 19:37:49
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "note", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1028, (now() at time zone 'UTC'), 1028, (now() at time zone 'UTC'), false, NULL, 42, 1, '2024-02-22 19:57:01.376870', 40, 225128, true, 421, 468, 'core_return_1', '07-L/INT/04459', NULL, 'Warehouse Inventory Transfer to BLS', 347227, 317, '0', 'make_to_stock', 237202, 1, '34.00', true, 10, 44, 'draft', 40) RETURNING id;
Date: 2024-02-19 19:57:01
4 1 6s90ms 6s90ms 6s90ms 6s90ms update "ir_property" set "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);-
UPDATE "ir_property" SET "write_uid" = 981, "write_date" = (now() at time zone 'UTC') WHERE id IN (601219);
Date: 2024-02-19 20:26:50
5 1 5s699ms 5s699ms 5s699ms 5s699ms delete from ir_attachment where id in (...);-
DELETE FROM ir_attachment WHERE id IN (5080578, 5080577, 5080576, 5080575);
Date: 2024-02-19 08:59:06
6 1 2s389ms 2s389ms 2s389ms 2s389ms update "sale_order_line" set "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);-
UPDATE "sale_order_line" SET "write_uid" = 1149, "write_date" = (now() at time zone 'UTC') WHERE id IN (342112, 342049, 342113, 342051, 342114, 342117, 342179, 342121, 342122, 342123, 342124, 342061, 342065, 342135, 342042);
Date: 2024-02-19 15:29:50
-
UPDATE "sale_order_line" SET "write_uid" = 1140, "write_date" = (now() at time zone 'UTC') WHERE id IN (341796, 341797, 341798, 341801, 341802, 341806, 341789, 341790, 341791);
Date: 2024-02-19 13:15:49
-
UPDATE "sale_order_line" SET "write_uid" = 1149, "write_date" = (now() at time zone 'UTC') WHERE id IN (342213, 342187, 342191, 342195, 342232, 342206);
Date: 2024-02-19 15:55:17
7 1 1s871ms 1s871ms 1s871ms 1s871ms update account_payment set write_uid = ? where id = ?;-
update account_payment set write_uid = '1213' where id = '53279';
Date: 2024-02-19 18:07:13
-
update account_payment set write_uid = '1213' where id = '53279';
Date: 2024-02-19 18:07:13
8 1 1s108ms 1s108ms 1s108ms 1s108ms update "sale_order" set "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);-
UPDATE "sale_order" SET "write_uid" = 1181, "write_date" = (now() at time zone 'UTC') WHERE id IN (65827);
Date: 2024-02-19 20:20:09
Queries that waited the most
Rank Wait time Query 1 10s224ms 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 != 1214681 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 != 1214681 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-02-19 17:18:09 ]
2 7s656ms INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "note", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1028, (now() at time zone 'UTC'), 1028, (now() at time zone 'UTC'), false, NULL, 50, 1, '2024-02-19 19:56:52', 40, 225125, true, 468, 453, 'core_return_1', '12-S/INT/08136', NULL, '12-S/INT/08136', 347224, 349, '0', 'make_to_stock', 237202, 1, '34.00', true, 10, 44, 'draft', 44) RETURNING id;[ Date: 2024-02-19 19:57:00 ]
3 6s90ms UPDATE "ir_property" SET "write_uid" = 981, "write_date" = (now() at time zone 'UTC') WHERE id IN (601219);[ Date: 2024-02-19 20:26:50 ]
4 5s699ms DELETE FROM ir_attachment WHERE id IN (5080578, 5080577, 5080576, 5080575);[ Date: 2024-02-19 08:59:06 ]
5 4s882ms UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1215170 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1215170 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-02-19 18:39:06 ]
6 4s877ms 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 != 1213288 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 != 1213288 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-02-19 12:57:03 ]
7 4s389ms UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1215315 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1215315 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-02-19 19:03:58 ]
8 4s267ms UPDATE "account_move" SET "message_main_attachment_id" = 5081124, "write_uid" = 1041, "write_date" = (now() at time zone 'UTC') WHERE id IN (1213392);[ Date: 2024-02-19 13:23:30 ]
9 3s973ms 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 != 1213392 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 != 1213392 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-02-19 14:00:54 ]
10 3s793ms 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 != 1214031 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 != 1214031 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-02-19 15:12:26 ]
11 3s389ms UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1215301 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1215301 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-02-19 19:02:40 ]
12 3s190ms UPDATE "account_move" SET "message_main_attachment_id" = 5083642, "write_uid" = 1028, "write_date" = (now() at time zone 'UTC') WHERE id IN (1215431);[ Date: 2024-02-19 19:13:15 ]
13 3s39ms 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 != 1213626 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 != 1213626 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-02-19 14:12:00 ]
14 2s389ms UPDATE "sale_order_line" SET "write_uid" = 1149, "write_date" = (now() at time zone 'UTC') WHERE id IN (342042);[ Date: 2024-02-19 15:28:12 ]
15 2s14ms UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1215635 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1215635 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-02-19 19:35:01 ]
16 1s871ms update account_payment set write_uid = '1213' where id = '53279';[ Date: 2024-02-19 18:07:13 ]
17 1s833ms 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 != 1213780 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 != 1213780 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-02-19 14:35:11 ]
18 1s608ms UPDATE "account_move" SET "message_main_attachment_id" = 5080820, "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (1213304);[ Date: 2024-02-19 12:53:10 ]
19 1s272ms 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 != 1213833 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 != 1213833 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-02-19 14:42:08 ]
20 1s108ms UPDATE "sale_order" SET "write_uid" = 1181, "write_date" = (now() at time zone 'UTC') WHERE id IN (65827);[ Date: 2024-02-19 20:20:09 ]
-
Queries
Queries by type
Key values
- 49,946 Total read queries
- 18,295 Total write queries
Queries by database
Key values
- unknown Main database
- 68,241 Requests
- 8h15m (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 68,286 Requests
User Request type Count Duration unknown Total 68,286 8h15m9s copy to 98 12m46s cte 49 11s304ms delete 382 13m26s insert 1,015 4m28s select 49,991 5h53m17s update 16,751 1h50m59s Duration by user
Key values
- 8h15m9s (unknown) Main time consuming user
User Request type Count Duration unknown Total 68,286 8h15m9s copy to 98 12m46s cte 49 11s304ms delete 382 13m26s insert 1,015 4m28s select 49,991 5h53m17s update 16,751 1h50m59s Queries by host
Key values
- unknown Main host
- 68,286 Requests
- 8h15m9s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 68,241 Requests
- 8h15m (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2024-02-19 17:41:29 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 50,598 100-500ms duration
Slowest individual queries
Rank Duration Query 1 3m50s 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: 2024-02-19 09:08:50 ]
2 2m27s DELETE FROM account_move_line WHERE id IN (4225720, 4225721, 4225722, 4225723, 4225724, 4225725, 4225726, 4225727, 4225728, 4225729, 4225730, 4225731, 4225732, 4225733, 4225734, 4225735, 4225736, 4225737, 4225738, 4225739, 4225740, 4225741, 4225742, 4225743, 4225744, 4225745, 4225746, 4225747, 4225748, 4225749, 4225750, 4225751, 4225752, 4225753, 4225754, 4225755, 4225756, 4225757, 4225758, 4225759, 4225760, 4225761, 4225762, 4225763, 4225764, 4225765, 4225766, 4225767, 4225768, 4225769, 4225770, 4225771, 4225772, 4225773, 4225774, 4225775, 4225776, 4225777, 4225778, 4225779, 4225780, 4225781, 4225782, 4225783, 4225784, 4225785, 4225786, 4225787, 4225788, 4225789, 4225790, 4225791, 4225792, 4225793, 4225794, 4225795, 4225796, 4225797, 4225798, 4225799, 4225800, 4225801, 4225802, 4225803, 4225804, 4225805, 4225806, 4225807, 4225808, 4225809, 4225810, 4225811, 4225812, 4225813, 4225814, 4225815, 4225816);[ Date: 2024-02-19 12:51:18 ]
3 1m41s 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: 2024-02-19 09:03:16 ]
4 1m34s 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: 2024-02-19 09:04:59 ]
5 1m19s DELETE FROM account_move_line WHERE id IN (4187140, 4187141, 4187142, 4187143, 4187144, 4187145, 4187146, 4187147, 4187148, 4187149, 4187150, 4187151, 4187152, 4187153, 4187154, 4187155, 4187156, 4187157, 4187158, 4187159, 4187160, 4187161, 4187162, 4187163, 4187164, 4187165, 4187166, 4187167, 4187168, 4187169, 4187170, 4187171, 4187172, 4187173, 4187174, 4187175, 4187176, 4187177, 4187178, 4187179, 4187180, 4187181, 4187182, 4187183, 4187184, 4187185, 4187186, 4187187, 4187188, 4187189, 4187190, 4187191, 4231777, 4231778);[ Date: 2024-02-19 23:43:33 ]
6 1m12s 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: 2024-02-19 09:12:55 ]
7 46s656ms COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;[ Date: 2024-02-19 09:11:42 ]
8 43s910ms SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "invoice_date_count", sum("sale_history_line"."product_uom_qty") AS "product_uom_qty", sum("sale_history_line"."cost_price_unit") AS "cost_price_unit", sum("sale_history_line"."cost_subtotal") AS "cost_subtotal", sum("sale_history_line"."price_unit") AS "price_unit", sum("sale_history_line"."price_subtotal") AS "price_subtotal", sum("sale_history_line"."gross_profit") AS "gross_profit", date_trunc('month', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:month" FROM "sale_history_line" WHERE ((("sale_history_line"."invoice_date" >= '2024-01-01') AND ("sale_history_line"."invoice_date" < '2025-01-01')) AND ("sale_history_line"."user_id" in ( SELECT "res_users".id FROM "res_users" LEFT JOIN "res_partner" AS "res_users__partner_id" ON ("res_users"."partner_id" = "res_users__partner_id"."id") WHERE (unaccent ("res_users__partner_id"."name"::text) ilike unaccent ('%ken k%')) AND (("res_users"."share" IS NULL or "res_users"."share" = false) OR EXISTS ( SELECT 1 FROM "res_company_users_rel" AS "res_users__company_ids" WHERE "res_users__company_ids"."user_id" = "res_users".id AND "res_users__company_ids"."cid" IN (1))) AND (((("res_users__partner_id"."partner_share" IS NULL or "res_users__partner_id"."partner_share" = false) OR ("res_users__partner_id"."company_id" in (1))) OR "res_users__partner_id"."company_id" IS NULL) AND (((("res_users__partner_id"."type" != 'private') OR "res_users__partner_id"."type" IS NULL) OR "res_users__partner_id"."type" IS NULL) OR ("res_users__partner_id"."type" = 'private')))))) GROUP BY date_trunc('month', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:month";[ Date: 2024-02-19 15:09:57 ]
9 43s706ms SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "invoice_date_count", sum("sale_history_line"."product_uom_qty") AS "product_uom_qty", sum("sale_history_line"."cost_price_unit") AS "cost_price_unit", sum("sale_history_line"."cost_subtotal") AS "cost_subtotal", sum("sale_history_line"."price_unit") AS "price_unit", sum("sale_history_line"."price_subtotal") AS "price_subtotal", sum("sale_history_line"."gross_profit") AS "gross_profit", date_trunc('month', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:month" FROM "sale_history_line" WHERE ((("sale_history_line"."invoice_date" >= '2024-01-01') AND ("sale_history_line"."invoice_date" < '2025-01-01')) AND ("sale_history_line"."user_id" in ( SELECT "res_users".id FROM "res_users" LEFT JOIN "res_partner" AS "res_users__partner_id" ON ("res_users"."partner_id" = "res_users__partner_id"."id") WHERE (unaccent ("res_users__partner_id"."name"::text) ilike unaccent ('%ken k%')) AND (("res_users"."share" IS NULL or "res_users"."share" = false) OR EXISTS ( SELECT 1 FROM "res_company_users_rel" AS "res_users__company_ids" WHERE "res_users__company_ids"."user_id" = "res_users".id AND "res_users__company_ids"."cid" IN (1))) AND (((("res_users__partner_id"."partner_share" IS NULL or "res_users__partner_id"."partner_share" = false) OR ("res_users__partner_id"."company_id" in (1))) OR "res_users__partner_id"."company_id" IS NULL) AND (((("res_users__partner_id"."type" != 'private') OR "res_users__partner_id"."type" IS NULL) OR "res_users__partner_id"."type" IS NULL) OR ("res_users__partner_id"."type" = 'private')))))) GROUP BY date_trunc('month', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:month";[ Date: 2024-02-19 15:10:39 ]
10 40s174ms SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "invoice_date_count", sum("sale_history_line"."product_uom_qty") AS "product_uom_qty", sum("sale_history_line"."cost_price_unit") AS "cost_price_unit", sum("sale_history_line"."cost_subtotal") AS "cost_subtotal", sum("sale_history_line"."price_unit") AS "price_unit", sum("sale_history_line"."price_subtotal") AS "price_subtotal", sum("sale_history_line"."gross_profit") AS "gross_profit", date_trunc('month', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:month" FROM "sale_history_line" WHERE (((("sale_history_line"."manufacturing_usage" IS NULL or "sale_history_line"."manufacturing_usage" = false) AND ("sale_history_line"."is_shipping" IS NULL or "sale_history_line"."is_shipping" = false)) AND ("sale_history_line"."user_id" in ( SELECT "res_users".id FROM "res_users" LEFT JOIN "res_partner" AS "res_users__partner_id" ON ("res_users"."partner_id" = "res_users__partner_id"."id") WHERE (unaccent ("res_users__partner_id"."name"::text) ilike unaccent ('%Ed Robinson%')) AND (("res_users"."share" IS NULL or "res_users"."share" = false) OR EXISTS ( SELECT 1 FROM "res_company_users_rel" AS "res_users__company_ids" WHERE "res_users__company_ids"."user_id" = "res_users".id AND "res_users__company_ids"."cid" IN (1))) AND (((("res_users__partner_id"."partner_share" IS NULL or "res_users__partner_id"."partner_share" = false) OR ("res_users__partner_id"."company_id" in (1))) OR "res_users__partner_id"."company_id" IS NULL) AND (((("res_users__partner_id"."type" != 'private') OR "res_users__partner_id"."type" IS NULL) OR "res_users__partner_id"."type" IS NULL) OR ("res_users__partner_id"."type" = 'private')))))) AND (("sale_history_line"."invoice_date" >= '2024-01-01') AND ("sale_history_line"."invoice_date" <= '2024-12-31'))) GROUP BY date_trunc('month', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:month" LIMIT 80;[ Date: 2024-02-19 14:09:35 ]
11 38s272ms SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "invoice_date_count", sum("sale_history_line"."product_uom_qty") AS "product_uom_qty", sum("sale_history_line"."cost_price_unit") AS "cost_price_unit", sum("sale_history_line"."cost_subtotal") AS "cost_subtotal", sum("sale_history_line"."price_unit") AS "price_unit", sum("sale_history_line"."price_subtotal") AS "price_subtotal", sum("sale_history_line"."gross_profit") AS "gross_profit", date_trunc('month', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:month" FROM "sale_history_line" WHERE (((("sale_history_line"."manufacturing_usage" IS NULL or "sale_history_line"."manufacturing_usage" = false) AND ("sale_history_line"."is_shipping" IS NULL or "sale_history_line"."is_shipping" = false)) AND ("sale_history_line"."user_id" in ( SELECT "res_users".id FROM "res_users" LEFT JOIN "res_partner" AS "res_users__partner_id" ON ("res_users"."partner_id" = "res_users__partner_id"."id") WHERE (unaccent ("res_users__partner_id"."name"::text) ilike unaccent ('%Ed Robinson%')) AND (("res_users"."share" IS NULL or "res_users"."share" = false) OR EXISTS ( SELECT 1 FROM "res_company_users_rel" AS "res_users__company_ids" WHERE "res_users__company_ids"."user_id" = "res_users".id AND "res_users__company_ids"."cid" IN (1))) AND (((("res_users__partner_id"."partner_share" IS NULL or "res_users__partner_id"."partner_share" = false) OR ("res_users__partner_id"."company_id" in (1))) OR "res_users__partner_id"."company_id" IS NULL) AND (((("res_users__partner_id"."type" != 'private') OR "res_users__partner_id"."type" IS NULL) OR "res_users__partner_id"."type" IS NULL) OR ("res_users__partner_id"."type" = 'private')))))) AND (("sale_history_line"."invoice_date" >= '2024-01-01') AND ("sale_history_line"."invoice_date" <= '2024-12-31'))) GROUP BY date_trunc('month', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:month" LIMIT 80;[ Date: 2024-02-19 23:32:38 ]
12 33s446ms SELECT partner.id as partner_id, ful.id as followup_level, CASE WHEN partner.balance <= 0 THEN 'no_action_needed' WHEN in_need_of_action_aml.id IS NOT NULL AND (prop_date.value_datetime IS NULL OR prop_date.value_datetime::date <= '2024-02-19'::date) THEN 'in_need_of_action' WHEN exceeded_unreconciled_aml.id IS NOT NULL THEN 'with_overdue_invoices' ELSE 'no_action_needed' END as followup_status FROM ( SELECT partner.id, max(current_followup_level.delay) as followup_delay, SUM(aml.balance) as balance FROM res_partner partner JOIN account_move_line aml ON aml.partner_id = partner.id JOIN account_account account ON account.id = aml.account_id JOIN account_move move ON move.id = aml.move_id -- Get the followup level LEFT JOIN LATERAL ( SELECT COALESCE(next_ful.id, ful.id) as id, COALESCE(next_ful.delay, ful.delay) as delay FROM account_move_line line LEFT OUTER JOIN account_followup_followup_line ful ON ful.id = aml.followup_line_id LEFT OUTER JOIN account_followup_followup_line next_ful ON next_ful.id = ( SELECT next_ful.id FROM account_followup_followup_line next_ful WHERE next_ful.delay > COALESCE(ful.delay, - 999) AND COALESCE(aml.date_maturity, aml.date) + next_ful.delay <= '2024-02-19'::date AND next_ful.company_id = 1 ORDER BY next_ful.delay ASC LIMIT 1) WHERE line.id = aml.id AND aml.partner_id = partner.id AND aml.balance > 0) current_followup_level ON true WHERE account.deprecated IS NOT TRUE AND account.internal_type = 'receivable' AND move.state = 'posted' AND aml.reconciled IS NOT TRUE AND aml.blocked IS FALSE AND aml.company_id = 1 GROUP BY partner.id) partner LEFT JOIN account_followup_followup_line ful ON ful.delay = partner.followup_delay AND ful.company_id = 1 -- Get the followup status data LEFT OUTER JOIN LATERAL ( SELECT line.id FROM account_move_line line JOIN account_account account ON line.account_id = account.id JOIN account_move move ON line.move_id = move.id LEFT JOIN account_followup_followup_line ful ON ful.id = line.followup_line_id WHERE line.partner_id = partner.id AND account.internal_type = 'receivable' AND account.deprecated IS NOT TRUE AND move.state = 'posted' AND line.reconciled IS NOT TRUE AND line.balance > 0 AND line.blocked IS FALSE AND line.company_id = 1 AND COALESCE(ful.delay, - 999) < partner.followup_delay AND COALESCE(line.date_maturity, line.date) + COALESCE(ful.delay, - 999) <= '2024-02-19'::date LIMIT 1) in_need_of_action_aml ON true LEFT OUTER JOIN LATERAL ( SELECT line.id FROM account_move_line line JOIN account_account account ON line.account_id = account.id JOIN account_move move ON line.move_id = move.id WHERE line.partner_id = partner.id AND account.internal_type = 'receivable' AND account.deprecated IS NOT TRUE AND move.state = 'posted' AND line.reconciled IS NOT TRUE AND line.balance > 0 AND line.blocked IS FALSE AND line.company_id = 1 AND COALESCE(line.date_maturity, line.date) <= '2024-02-19'::date LIMIT 1) exceeded_unreconciled_aml ON true LEFT OUTER JOIN ir_property prop_date ON prop_date.res_id = CONCAT('res.partner,', partner.id) AND prop_date.name = 'payment_next_action_date' AND prop_date.company_id = 1;[ Date: 2024-02-19 20:33:12 ]
13 32s386ms SELECT partner.id as partner_id, ful.id as followup_level, CASE WHEN partner.balance <= 0 THEN 'no_action_needed' WHEN in_need_of_action_aml.id IS NOT NULL AND (prop_date.value_datetime IS NULL OR prop_date.value_datetime::date <= '2024-02-19'::date) THEN 'in_need_of_action' WHEN exceeded_unreconciled_aml.id IS NOT NULL THEN 'with_overdue_invoices' ELSE 'no_action_needed' END as followup_status FROM ( SELECT partner.id, max(current_followup_level.delay) as followup_delay, SUM(aml.balance) as balance FROM res_partner partner JOIN account_move_line aml ON aml.partner_id = partner.id JOIN account_account account ON account.id = aml.account_id JOIN account_move move ON move.id = aml.move_id -- Get the followup level LEFT JOIN LATERAL ( SELECT COALESCE(next_ful.id, ful.id) as id, COALESCE(next_ful.delay, ful.delay) as delay FROM account_move_line line LEFT OUTER JOIN account_followup_followup_line ful ON ful.id = aml.followup_line_id LEFT OUTER JOIN account_followup_followup_line next_ful ON next_ful.id = ( SELECT next_ful.id FROM account_followup_followup_line next_ful WHERE next_ful.delay > COALESCE(ful.delay, - 999) AND COALESCE(aml.date_maturity, aml.date) + next_ful.delay <= '2024-02-19'::date AND next_ful.company_id = 1 ORDER BY next_ful.delay ASC LIMIT 1) WHERE line.id = aml.id AND aml.partner_id = partner.id AND aml.balance > 0) current_followup_level ON true WHERE account.deprecated IS NOT TRUE AND account.internal_type = 'receivable' AND move.state = 'posted' AND aml.reconciled IS NOT TRUE AND aml.blocked IS FALSE AND aml.company_id = 1 GROUP BY partner.id) partner LEFT JOIN account_followup_followup_line ful ON ful.delay = partner.followup_delay AND ful.company_id = 1 -- Get the followup status data LEFT OUTER JOIN LATERAL ( SELECT line.id FROM account_move_line line JOIN account_account account ON line.account_id = account.id JOIN account_move move ON line.move_id = move.id LEFT JOIN account_followup_followup_line ful ON ful.id = line.followup_line_id WHERE line.partner_id = partner.id AND account.internal_type = 'receivable' AND account.deprecated IS NOT TRUE AND move.state = 'posted' AND line.reconciled IS NOT TRUE AND line.balance > 0 AND line.blocked IS FALSE AND line.company_id = 1 AND COALESCE(ful.delay, - 999) < partner.followup_delay AND COALESCE(line.date_maturity, line.date) + COALESCE(ful.delay, - 999) <= '2024-02-19'::date LIMIT 1) in_need_of_action_aml ON true LEFT OUTER JOIN LATERAL ( SELECT line.id FROM account_move_line line JOIN account_account account ON line.account_id = account.id JOIN account_move move ON line.move_id = move.id WHERE line.partner_id = partner.id AND account.internal_type = 'receivable' AND account.deprecated IS NOT TRUE AND move.state = 'posted' AND line.reconciled IS NOT TRUE AND line.balance > 0 AND line.blocked IS FALSE AND line.company_id = 1 AND COALESCE(line.date_maturity, line.date) <= '2024-02-19'::date LIMIT 1) exceeded_unreconciled_aml ON true LEFT OUTER JOIN ir_property prop_date ON prop_date.res_id = CONCAT('res.partner,', partner.id) AND prop_date.name = 'payment_next_action_date' AND prop_date.company_id = 1;[ Date: 2024-02-19 20:33:48 ]
14 30s204ms SELECT "mail_message".id FROM "mail_message" WHERE (unaccent ("mail_message"."subject"::text) ilike unaccent ('%G-15033%')) ORDER BY "mail_message"."id" DESC LIMIT 80;[ Date: 2024-02-19 16:51:13 ]
15 27s370ms 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, is_discount, is_sale_tax, auto_reconcile, is_writeoff, is_extra_line, is_carry_forward) TO stdout;[ Date: 2024-02-19 09:00:45 ]
16 24s103ms UPDATE "stock_move" SET "date" = '2024-02-19 15:18:12', "state" = 'done', "write_uid" = 1270, "write_date" = (now() at time zone 'UTC') WHERE id IN (819219, 819220, 819221, 819222, 819223, 819224, 819226, 819227, 819229, 819230, 819231, 819232, 819233, 819234, 819235, 819236, 819237, 819238, 819239, 819241, 819242, 819243, 819244, 819245, 819246, 819247, 819248, 819249, 819250, 819251, 819252, 819253, 819254, 819255, 819256);[ Date: 2024-02-19 15:18:38 ]
17 23s648ms DELETE FROM account_move_line WHERE id IN (4213364, 4213365, 4213366, 4213367, 4215588, 4215589, 4215590, 4215591, 4215592, 4215593, 4215594, 4215595, 4215596, 4215597, 4215598, 4215599);[ Date: 2024-02-19 23:56:18 ]
18 22s611ms DELETE FROM account_move_line WHERE id IN (4227499, 4227500, 4228159, 4228160, 4228161, 4228162, 4228163, 4228164, 4228165, 4228166, 4228167, 4228168, 4228169, 4228170, 4228171);[ Date: 2024-02-19 23:54:59 ]
19 20s975ms 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, technician_id, inventory_vendor_id, product_type) TO stdout;[ Date: 2024-02-19 09:10:20 ]
20 18s874ms SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "invoice_date_count", sum("sale_history_line"."product_uom_qty") AS "product_uom_qty", sum("sale_history_line"."cost_price_unit") AS "cost_price_unit", sum("sale_history_line"."cost_subtotal") AS "cost_subtotal", sum("sale_history_line"."price_unit") AS "price_unit", sum("sale_history_line"."price_subtotal") AS "price_subtotal", sum("sale_history_line"."gross_profit") AS "gross_profit", date_trunc('month', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:month" FROM "sale_history_line" WHERE ((("sale_history_line"."invoice_date" >= '2024-01-01') AND ("sale_history_line"."invoice_date" <= '2024-12-31')) AND ("sale_history_line"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%labor%'))))) GROUP BY date_trunc('month', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:month" LIMIT 80;[ Date: 2024-02-19 17:03:42 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h19m45s 10,524 120ms 2s375ms 454ms 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 Feb 19 00 118 49s58ms 415ms 01 154 1m6s 432ms 02 155 1m2s 405ms 03 33 12s316ms 373ms 04 34 13s160ms 387ms 05 44 19s797ms 449ms 06 100 37s306ms 373ms 07 83 32s768ms 394ms 08 146 1m3s 433ms 09 165 1m10s 424ms 10 45 18s756ms 416ms 11 45 18s793ms 417ms 12 337 1m49s 324ms 13 930 6m48s 439ms 14 1,234 9m27s 459ms 15 1,336 8m59s 403ms 16 785 5m56s 454ms 17 976 8m16s 508ms 18 1,010 6m57s 413ms 19 939 9m31s 608ms 20 931 8m 515ms 21 602 4m10s 415ms 22 214 1m23s 388ms 23 108 40s178ms 372ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-02-19 19:10:01') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1254"', '["pointspring_master","calendar.alarm",51895]', '["pointspring_master","mail.channel",533]', '["pointspring_master","mail.channel",534]', '["pointspring_master","res.partner",51895]', '["pointspring_master","ir.needaction",51895]'))) ORDER BY "bus_bus"."id";
Date: 2024-02-19 19:10:53 Duration: 2s375ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-02-19 19:10:01') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19529]', '["pointspring_master","mail.channel",157]', '["pointspring_master","mail.channel",158]', '["pointspring_master","mail.channel",159]', '["pointspring_master","mail.channel",160]', '["pointspring_master","mail.channel",485]', '["pointspring_master","mail.channel",553]', '["pointspring_master","res.partner",19529]', '["pointspring_master","ir.needaction",19529]'))) ORDER BY "bus_bus"."id";
Date: 2024-02-19 19:10:53 Duration: 2s365ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-02-19 19:10:01') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_972"', '["pointspring_master","calendar.alarm",19510]', '["pointspring_master","mail.channel",84]', '["pointspring_master","mail.channel",85]', '["pointspring_master","mail.channel",86]', '["pointspring_master","mail.channel",87]', '["pointspring_master","mail.channel",531]', '["pointspring_master","res.partner",19510]', '["pointspring_master","ir.needaction",19510]'))) ORDER BY "bus_bus"."id";
Date: 2024-02-19 19:10:53 Duration: 2s299ms
2 40m6s 3,489 606ms 2s432ms 689ms 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 #2
Day Hour Count Duration Avg duration Feb 19 12 283 3m9s 668ms 13 535 6m16s 702ms 14 535 6m17s 705ms 15 412 4m50s 704ms 16 427 4m50s 680ms 17 310 3m26s 666ms 18 313 3m36s 692ms 19 272 3m11s 702ms 20 316 3m32s 671ms 21 77 50s504ms 655ms 23 9 5s736ms 637ms -
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 ('%%78%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%7/8%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%7/8%'))) 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: 2024-02-19 14:08:31 Duration: 2s432ms
-
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 ('%%6531%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%6.5-3-1%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%6.5-3-1%'))) 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: 2024-02-19 14:08:31 Duration: 2s285ms
-
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 ('%%9499%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%9499%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%9499%'))) 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: 2024-02-19 14:49:16 Duration: 2s211ms
3 23m22s 4,095 120ms 758ms 342ms select "forecasted_data".id from "forecasted_data" where ("forecasted_data"."item_supply_plan_id" in (...)) order by "forecasted_data"."id";Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Feb 19 01 59 13s822ms 234ms 02 42 10s155ms 241ms 12 3 395ms 131ms 13 87 19s609ms 225ms 14 48 9s890ms 206ms 15 1,489 8m6s 326ms 16 484 3m4s 381ms 17 579 3m37s 376ms 18 762 4m57s 390ms 19 311 1m50s 353ms 20 95 19s700ms 207ms 21 104 25s389ms 244ms 22 18 3s448ms 191ms 23 14 3s72ms 219ms -
SELECT "forecasted_data".id FROM "forecasted_data" WHERE ("forecasted_data"."item_supply_plan_id" in (35595)) ORDER BY "forecasted_data"."id";
Date: 2024-02-19 15:45:30 Duration: 758ms
-
SELECT "forecasted_data".id FROM "forecasted_data" WHERE ("forecasted_data"."item_supply_plan_id" in (35792, 35071)) ORDER BY "forecasted_data"."id";
Date: 2024-02-19 15:06:15 Duration: 744ms
-
SELECT "forecasted_data".id FROM "forecasted_data" WHERE ("forecasted_data"."item_supply_plan_id" in (35800)) ORDER BY "forecasted_data"."id";
Date: 2024-02-19 16:26:20 Duration: 728ms
4 19m53s 3,286 336ms 1s424ms 363ms 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 #4
Day Hour Count Duration Avg duration Feb 19 00 3 1s47ms 349ms 01 3 1s14ms 338ms 06 1 336ms 336ms 08 3 1s14ms 338ms 09 7 2s361ms 337ms 10 5 1s721ms 344ms 11 24 8s165ms 340ms 12 247 1m27s 355ms 13 490 2m56s 360ms 14 550 3m25s 373ms 15 394 2m26s 371ms 16 393 2m22s 361ms 17 255 1m30s 356ms 18 265 1m36s 364ms 19 210 1m17s 368ms 20 248 1m28s 357ms 21 126 44s323ms 351ms 22 29 9s830ms 338ms 23 33 11s333ms 343ms -
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_backend.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-472a842/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-02-19 14:04:04 Duration: 1s424ms
-
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.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-a54df00/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-02-19 15:29:47 Duration: 992ms
-
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_backend.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-bba3a16/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-02-19 19:19:14 Duration: 959ms
5 12m40s 898 786ms 1s858ms 846ms 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 #5
Day Hour Count Duration Avg duration Feb 19 12 38 31s613ms 831ms 13 105 1m29s 849ms 14 99 1m25s 859ms 15 127 1m51s 876ms 16 113 1m34s 835ms 17 68 56s54ms 824ms 18 80 1m8s 851ms 19 94 1m18s 835ms 20 102 1m26s 845ms 21 54 44s472ms 823ms 22 16 13s222ms 826ms 23 2 1s678ms 839ms -
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 ('%329071-62x%')) 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 ('%329071-62x%'))) 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 ('%329071-62x%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%329071-62x%')))))) 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: 2024-02-19 15:10:13 Duration: 1s858ms
-
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 ('%lfp3191%')) 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 ('%lfp3191%'))) 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 ('%lfp3191%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%lfp3191%')))))) 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: 2024-02-19 13:53:45 Duration: 1s735ms
-
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 ('%321-368%')) 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 ('%321-368%'))) 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 ('%321-368%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%321-368%')))))) 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: 2024-02-19 20:22:54 Duration: 1s555ms
6 12m19s 2,914 120ms 653ms 253ms select "product_warehouse_inventory".id from "product_warehouse_inventory" where ("product_warehouse_inventory"."product_id" in (...)) order by "product_warehouse_inventory"."warehouse_name";Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Feb 19 00 2 260ms 130ms 01 72 10s749ms 149ms 02 35 5s374ms 153ms 12 1 237ms 237ms 13 89 14s762ms 165ms 14 49 7s788ms 158ms 15 1,132 4m27s 236ms 16 301 1m20s 268ms 17 392 1m54s 291ms 18 525 2m43s 312ms 19 212 58s407ms 275ms 20 29 4s205ms 145ms 21 44 7s165ms 162ms 22 23 3s293ms 143ms 23 8 1s155ms 144ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (180516, 180501, 180313, 180312, 180311, 180236, 180227, 179866, 179818, 179416, 179343, 179225, 178967, 178935, 178711, 178710, 178699, 178694, 178630, 178479, 180381, 179622, 179686, 178683)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-02-19 18:16:35 Duration: 653ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (181845, 182155, 182165, 182171, 182965, 182713)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-02-19 15:06:15 Duration: 614ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (220110, 219747, 219614, 218570, 216887, 216793, 216001, 215959, 215519, 215194, 215083, 215023, 214966, 214532, 214496, 214385, 214035, 213571, 213559, 213440, 213428, 213427, 213410, 213712, 213713, 219897, 213814, 243762, 216281, 216280, 216172, 215703, 215636, 215534, 214759, 214030, 213426, 215786, 213911, 214174, 216391)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-02-19 15:06:13 Duration: 602ms
7 9m43s 853 620ms 1s429ms 684ms 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 #7
Day Hour Count Duration Avg duration Feb 19 12 99 1m8s 689ms 13 61 41s676ms 683ms 14 5 3s253ms 650ms 15 82 55s960ms 682ms 16 103 1m10s 685ms 17 55 37s32ms 673ms 18 102 1m11s 696ms 19 243 2m45s 683ms 20 42 29s594ms 704ms 21 61 40s499ms 663ms -
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 ('%%3089%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%3089%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%3089%'))) 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: 2024-02-19 16:33:52 Duration: 1s429ms
-
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 ('%%A8030%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%A-8030%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%A-8030%'))) 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: 2024-02-19 19:58:47 Duration: 1s215ms
-
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 ('%%lab4%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%lab4%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%lab4%'))) 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: 2024-02-19 18:15:05 Duration: 1s185ms
8 8m55s 504 961ms 2s139ms 1s62ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) 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"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?)))) order by coalesce("product_template"."is_published", false) desc, "product_template"."website_sequence" asc, "product_template"."id" desc;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Feb 19 12 108 1m50s 1s19ms 13 27 28s999ms 1s74ms 14 90 1m42s 1s143ms 15 96 1m41s 1s57ms 16 75 1m18s 1s52ms 17 27 28s325ms 1s49ms 18 9 9s114ms 1s12ms 19 12 12s209ms 1s17ms 20 24 26s687ms 1s111ms 21 36 36s507ms 1s14ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') 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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%32-30-52-72%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%32-30-52-72%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%32-30-52-72%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%32-30-52-72%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%32-30-52-72%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%32-30-52-72%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2024-02-19 14:52:31 Duration: 2s139ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') 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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%2-1-1313-9%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%2-1-1313-9%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%2-1-1313-9%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%2-1-1313-9%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%2-1-1313-9%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%2-1-1313-9%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2024-02-19 15:29:48 Duration: 2s74ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') 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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%32-30-52-72%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%32-30-52-72%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%32-30-52-72%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%32-30-52-72%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%32-30-52-72%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%32-30-52-72%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2024-02-19 14:52:33 Duration: 1s895ms
9 8m18s 2,560 175ms 678ms 194ms 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 #9
Day Hour Count Duration Avg duration Feb 19 09 5 899ms 179ms 10 1 177ms 177ms 11 10 1s776ms 177ms 12 24 4s502ms 187ms 13 87 17s380ms 199ms 14 233 46s196ms 198ms 15 119 23s325ms 196ms 16 136 26s365ms 193ms 17 114 22s450ms 196ms 18 1,183 3m50s 194ms 19 305 59s772ms 195ms 20 171 33s298ms 194ms 21 152 28s798ms 189ms 22 5 896ms 179ms 23 15 2s700ms 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 (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 ('%T-05461%') OR unaccent (res_partner.display_name) ilike unaccent ('%T-05461%') OR unaccent (res_partner.ref) ilike unaccent ('%T-05461%') OR unaccent (res_partner.vat) ilike unaccent ('T-05461')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%T-05461%') desc, unaccent (res_partner.display_name);
Date: 2024-02-19 17:58:30 Duration: 678ms
-
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 ('%G-02933%') OR unaccent (res_partner.display_name) ilike unaccent ('%G-02933%') OR unaccent (res_partner.ref) ilike unaccent ('%G-02933%') OR unaccent (res_partner.vat) ilike unaccent ('G-02933')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%G-02933%') desc, unaccent (res_partner.display_name);
Date: 2024-02-19 18:43:30 Duration: 667ms
-
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 ('%15740%') OR unaccent (res_partner.display_name) ilike unaccent ('%15740%') OR unaccent (res_partner.ref) ilike unaccent ('%15740%') OR unaccent (res_partner.vat) ilike unaccent ('15740')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%15740%') desc, unaccent (res_partner.display_name);
Date: 2024-02-19 13:42:37 Duration: 619ms
10 8m5s 721 611ms 1s617ms 673ms 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"."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 Feb 19 12 8 6s328ms 791ms 13 21 13s656ms 650ms 14 45 30s637ms 680ms 15 102 1m12s 715ms 16 101 1m7s 666ms 17 159 1m45s 660ms 18 80 54s613ms 682ms 19 73 49s810ms 682ms 20 31 21s499ms 693ms 21 31 19s620ms 632ms 22 70 44s418ms 634ms -
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 ('%%4309124%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4309124%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%4309124%'))) 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"."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: 2024-02-19 19:19:14 Duration: 1s617ms
-
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 ('%%lf14%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%lf14%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%lf14%'))) 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"."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: 2024-02-19 18:17:25 Duration: 1s151ms
-
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 ('%%820b7532%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%820.b7532%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%820.b7532%'))) 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"."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: 2024-02-19 15:24:34 Duration: 1s66ms
11 7m47s 36 1s464ms 2m27s 12s996ms delete from account_move_line where id in (...);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Feb 19 12 2 2m31s 1m15s 13 2 11s758ms 5s879ms 14 1 3s124ms 3s124ms 15 1 6s6ms 6s6ms 17 1 4s415ms 4s415ms 18 3 9s560ms 3s186ms 19 7 23s636ms 3s376ms 20 1 7s349ms 7s349ms 21 1 3s104ms 3s104ms 23 17 4m7s 14s571ms -
DELETE FROM account_move_line WHERE id IN (4225720, 4225721, 4225722, 4225723, 4225724, 4225725, 4225726, 4225727, 4225728, 4225729, 4225730, 4225731, 4225732, 4225733, 4225734, 4225735, 4225736, 4225737, 4225738, 4225739, 4225740, 4225741, 4225742, 4225743, 4225744, 4225745, 4225746, 4225747, 4225748, 4225749, 4225750, 4225751, 4225752, 4225753, 4225754, 4225755, 4225756, 4225757, 4225758, 4225759, 4225760, 4225761, 4225762, 4225763, 4225764, 4225765, 4225766, 4225767, 4225768, 4225769, 4225770, 4225771, 4225772, 4225773, 4225774, 4225775, 4225776, 4225777, 4225778, 4225779, 4225780, 4225781, 4225782, 4225783, 4225784, 4225785, 4225786, 4225787, 4225788, 4225789, 4225790, 4225791, 4225792, 4225793, 4225794, 4225795, 4225796, 4225797, 4225798, 4225799, 4225800, 4225801, 4225802, 4225803, 4225804, 4225805, 4225806, 4225807, 4225808, 4225809, 4225810, 4225811, 4225812, 4225813, 4225814, 4225815, 4225816);
Date: 2024-02-19 12:51:18 Duration: 2m27s
-
DELETE FROM account_move_line WHERE id IN (4187140, 4187141, 4187142, 4187143, 4187144, 4187145, 4187146, 4187147, 4187148, 4187149, 4187150, 4187151, 4187152, 4187153, 4187154, 4187155, 4187156, 4187157, 4187158, 4187159, 4187160, 4187161, 4187162, 4187163, 4187164, 4187165, 4187166, 4187167, 4187168, 4187169, 4187170, 4187171, 4187172, 4187173, 4187174, 4187175, 4187176, 4187177, 4187178, 4187179, 4187180, 4187181, 4187182, 4187183, 4187184, 4187185, 4187186, 4187187, 4187188, 4187189, 4187190, 4187191, 4231777, 4231778);
Date: 2024-02-19 23:43:33 Duration: 1m19s
-
DELETE FROM account_move_line WHERE id IN (4213364, 4213365, 4213366, 4213367, 4215588, 4215589, 4215590, 4215591, 4215592, 4215593, 4215594, 4215595, 4215596, 4215597, 4215598, 4215599);
Date: 2024-02-19 23:56:18 Duration: 23s648ms
12 7m30s 561 133ms 6s981ms 803ms 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 #12
Day Hour Count Duration Avg duration Feb 19 09 2 1s959ms 979ms 12 14 9s606ms 686ms 13 80 1m1s 766ms 14 108 1m33s 863ms 15 74 57s811ms 781ms 16 64 50s712ms 792ms 17 50 42s661ms 853ms 18 72 58s750ms 815ms 19 38 30s551ms 803ms 20 42 30s977ms 737ms 21 12 8s954ms 746ms 23 5 3s891ms 778ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 1.0, "date" = '2024-02-19 14:20:20', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (813312, 813313, 813303, 813304, 813305, 813309, 813310);
Date: 2024-02-19 14:20:30 Duration: 6s981ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "date" = '2024-02-19 17:34:22', "is_done" = true, "state" = 'done', "write_uid" = 1017, "write_date" = (now() at time zone 'UTC') WHERE id IN (809708, 809710, 809711, 809714, 809715, 809716, 809717);
Date: 2024-02-19 17:34:30 Duration: 4s464ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 1.0, "date" = '2024-02-19 19:39:45', "is_done" = true, "state" = 'done', "write_uid" = 964, "write_date" = (now() at time zone 'UTC') WHERE id IN (803849, 803850, 803851, 803852);
Date: 2024-02-19 19:39:49 Duration: 2s792ms
13 7m10s 794 127ms 18s289ms 542ms update "stock_move" set "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Feb 19 01 20 28s302ms 1s415ms 02 16 29s508ms 1s844ms 12 41 16s898ms 412ms 13 81 39s231ms 484ms 14 95 46s369ms 488ms 15 93 38s843ms 417ms 16 104 50s813ms 488ms 17 44 19s913ms 452ms 18 84 33s962ms 404ms 19 62 42s386ms 683ms 20 66 46s704ms 707ms 21 52 22s957ms 441ms 22 30 12s905ms 430ms 23 6 2s163ms 360ms -
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (820140, 820143, 820144, 820145, 820146, 820147, 820148, 820149, 820150, 820151, 820152, 820154, 820155, 820156, 820157, 820158, 820159, 820160, 820161, 820162, 820163, 820167, 820169, 820171, 820172, 820173, 820175, 820176, 820178, 820181, 820182, 820183, 820185, 820188, 820189, 820192, 820198, 820201, 820204, 820208, 820211, 820212, 820216, 820217, 820218, 820220, 820222);
Date: 2024-02-19 20:01:29 Duration: 18s289ms
-
UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (820105, 820106, 820107, 820108, 820109, 820110, 820111, 820112, 820113, 820114, 820115, 820116, 820117, 820118, 820119, 820120, 820121, 820122, 820123);
Date: 2024-02-19 19:38:22 Duration: 9s932ms
-
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (818498, 818500, 818502, 818504, 818506, 818508, 818509, 818511, 818513, 818515, 818517, 818519, 818521, 818523);
Date: 2024-02-19 02:21:54 Duration: 7s36ms
14 6m38s 776 129ms 7s373ms 513ms update "stock_quant" set "quantity" = ?.?, "reserved_quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Feb 19 09 4 2s136ms 534ms 12 17 8s758ms 515ms 13 77 35s170ms 456ms 14 184 1m40s 544ms 15 135 1m4s 476ms 16 78 32s917ms 422ms 17 53 30s542ms 576ms 18 70 36s298ms 518ms 19 62 36s28ms 581ms 20 50 28s41ms 560ms 21 18 9s438ms 524ms 23 28 14s641ms 522ms -
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (436969, 436970, 436971, 436972, 436973, 436974, 436975, 436976, 436977, 436978);
Date: 2024-02-19 14:43:40 Duration: 7s373ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1267, "write_date" = (now() at time zone 'UTC') WHERE id IN (437126, 437127, 437128, 437129, 437130, 437131, 437132, 437133, 437134, 437135, 437136, 437137, 437138, 437139, 437140, 437141, 437142);
Date: 2024-02-19 17:01:01 Duration: 6s534ms
-
UPDATE "stock_quant" SET "quantity" = 2.0, "reserved_quantity" = 0.0, "write_uid" = 1038, "write_date" = (now() at time zone 'UTC') WHERE id IN (356544, 370308, 370310, 50825, 50987, 261964, 337069, 50766, 238607, 50834, 238582, 417879, 245019, 50941);
Date: 2024-02-19 20:48:12 Duration: 5s411ms
15 6m9s 136 264ms 24s103ms 2s717ms update "stock_move" set "date" = ?, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Feb 19 09 1 629ms 629ms 12 1 669ms 669ms 13 6 13s826ms 2s304ms 14 32 1m7s 2s101ms 15 17 1m4s 3s791ms 16 10 35s452ms 3s545ms 17 4 8s239ms 2s59ms 18 29 1m19s 2s756ms 19 7 8s957ms 1s279ms 20 17 1m2s 3s662ms 21 5 14s753ms 2s950ms 23 7 13s97ms 1s871ms -
UPDATE "stock_move" SET "date" = '2024-02-19 15:18:12', "state" = 'done', "write_uid" = 1270, "write_date" = (now() at time zone 'UTC') WHERE id IN (819219, 819220, 819221, 819222, 819223, 819224, 819226, 819227, 819229, 819230, 819231, 819232, 819233, 819234, 819235, 819236, 819237, 819238, 819239, 819241, 819242, 819243, 819244, 819245, 819246, 819247, 819248, 819249, 819250, 819251, 819252, 819253, 819254, 819255, 819256);
Date: 2024-02-19 15:18:38 Duration: 24s103ms
-
UPDATE "stock_move" SET "date" = '2024-02-19 20:28:07', "state" = 'done', "write_uid" = 965, "write_date" = (now() at time zone 'UTC') WHERE id IN (809669, 809670, 809671, 809672, 809673, 809674, 809675, 809676, 809677, 809680, 809681, 809682, 809683, 809684, 809685, 809686, 809687, 809688, 809689, 809690, 809691, 809692, 809693, 809694, 809695);
Date: 2024-02-19 20:28:25 Duration: 16s882ms
-
UPDATE "stock_move" SET "date" = '2024-02-19 18:11:27', "state" = 'done', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (812717, 812718, 812719, 812720, 812721, 812722, 812723, 812724, 812725, 812726, 812727, 812728, 812729, 812730, 812731, 812732, 812734, 812735, 812736, 812737);
Date: 2024-02-19 18:11:41 Duration: 13s502ms
16 6m2s 400 257ms 15s532ms 905ms update "stock_move" set "current_warehouse_qty" = ?.?, "date" = ?, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Feb 19 12 4 3s505ms 876ms 13 15 5s996ms 399ms 14 16 12s252ms 765ms 15 27 20s513ms 759ms 16 26 17s907ms 688ms 17 17 14s955ms 879ms 18 66 1m13s 1s113ms 19 151 2m31s 1s 20 64 56s818ms 887ms 21 13 5s361ms 412ms 23 1 292ms 292ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "date" = '2024-02-19 18:53:03', "state" = 'done', "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (809730, 809731, 809732, 809734, 809740, 809753, 809754, 809755, 809756, 809757, 809758, 809759, 809760, 809762, 809763, 809765, 809766, 809767, 809768, 809769, 809770, 809771, 809772);
Date: 2024-02-19 18:53:29 Duration: 15s532ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 3.0, "date" = '2024-02-19 18:53:03', "state" = 'done', "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (809764, 809733, 809735, 809736, 809737, 809738, 809739, 809743, 809744, 809745, 809746, 809747, 809748, 809750, 809752);
Date: 2024-02-19 18:53:39 Duration: 9s789ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 3.0, "date" = '2024-02-19 15:03:48', "state" = 'done', "write_uid" = 1017, "write_date" = (now() at time zone 'UTC') WHERE id IN (812362, 812363, 812364, 812368, 812370);
Date: 2024-02-19 15:03:55 Duration: 3s419ms
17 5m44s 737 120ms 6s453ms 467ms 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 Feb 19 09 2 511ms 255ms 12 3 645ms 215ms 13 50 22s831ms 456ms 14 81 27s829ms 343ms 15 67 28s837ms 430ms 16 71 33s335ms 469ms 17 32 16s632ms 519ms 18 118 1m3s 538ms 19 124 1m1s 499ms 20 125 59s885ms 479ms 21 60 27s497ms 458ms 23 4 749ms 187ms -
UPDATE "stock_quant" SET "quantity" = 2.0, "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (406112, 50914, 397667, 406114, 337061, 50874, 50765, 198990, 50833, 50994, 50898, 50805, 50807, 50840, 412153, 412154, 412159);
Date: 2024-02-19 18:53:48 Duration: 6s453ms
-
UPDATE "stock_quant" SET "quantity" = 2.0, "write_uid" = 965, "write_date" = (now() at time zone 'UTC') WHERE id IN (143170, 348772, 143048, 143019, 143053, 417998, 143023, 143247, 348783, 348786, 343220, 429111, 237595, 429116, 143037, 411742);
Date: 2024-02-19 20:28:41 Duration: 6s220ms
-
UPDATE "stock_quant" SET "quantity" = 3.0, "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (370308, 370310, 50825, 50987, 261964, 337069, 50766, 238607, 50834, 238582, 417879, 370297, 245019, 50941);
Date: 2024-02-19 18:53:54 Duration: 5s680ms
18 5m28s 2,404 122ms 805ms 136ms update product_warehouse_inventory set sft_stk_qty = ? where id = ( select id from product_warehouse_inventory where product_id = (?) and warehouse_id = (?));Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Feb 19 13 32 4s694ms 146ms 14 26 3s570ms 137ms 15 124 17s602ms 141ms 16 462 1m1s 134ms 17 223 29s776ms 133ms 18 691 1m37s 141ms 19 451 1m 133ms 20 190 26s522ms 139ms 21 30 3s915ms 130ms 22 127 16s458ms 129ms 23 48 6s218ms 129ms -
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (209323) and warehouse_id = (45));
Date: 2024-02-19 18:52:58 Duration: 805ms
-
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (209234) and warehouse_id = (45));
Date: 2024-02-19 18:52:57 Duration: 557ms
-
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (212163) and warehouse_id = (39));
Date: 2024-02-19 20:09:50 Duration: 554ms
19 5m8s 2,001 120ms 989ms 154ms select count(?) from mail_tracking_value v left join mail_message m on (v.mail_message_id = m.id) join purchase_order po on (po.id = m.res_id) where m.create_date >= ? and m.model = ? and m.message_type = ? and v.old_value_char = ? and v.new_value_char = ? and po.company_id = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Feb 19 06 1 989ms 989ms 10 3 861ms 287ms 11 1 169ms 169ms 12 11 1s807ms 164ms 13 20 3s310ms 165ms 14 100 14s419ms 144ms 15 83 13s282ms 160ms 16 85 12s555ms 147ms 17 90 12s644ms 140ms 18 1,110 2m57s 159ms 19 230 33s285ms 144ms 20 210 29s286ms 139ms 21 47 6s930ms 147ms 22 10 1s675ms 167ms -
SELECT COUNT(1) FROM mail_tracking_value v LEFT JOIN mail_message m ON (v.mail_message_id = m.id) JOIN purchase_order po ON (po.id = m.res_id) WHERE m.create_date >= '2024-02-12 06:59:17' AND m.model = 'purchase.order' AND m.message_type = 'notification' AND v.old_value_char = 'RFQ' AND v.new_value_char = 'RFQ Sent' AND po.company_id = 1;
Date: 2024-02-19 06:59:18 Duration: 989ms
-
SELECT COUNT(1) FROM mail_tracking_value v LEFT JOIN mail_message m ON (v.mail_message_id = m.id) JOIN purchase_order po ON (po.id = m.res_id) WHERE m.create_date >= '2024-02-12 18:42:37' AND m.model = 'purchase.order' AND m.message_type = 'notification' AND v.old_value_char = 'RFQ' AND v.new_value_char = 'RFQ Sent' AND po.company_id = 1;
Date: 2024-02-19 18:42:37 Duration: 522ms
-
SELECT COUNT(1) FROM mail_tracking_value v LEFT JOIN mail_message m ON (v.mail_message_id = m.id) JOIN purchase_order po ON (po.id = m.res_id) WHERE m.create_date >= '2024-02-12 10:58:43' AND m.model = 'purchase.order' AND m.message_type = 'notification' AND v.old_value_char = 'RFQ' AND v.new_value_char = 'RFQ Sent' AND po.company_id = 1;
Date: 2024-02-19 10:58:43 Duration: 473ms
20 5m5s 285 173ms 12s931ms 1s71ms 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 #20
Day Hour Count Duration Avg duration Feb 19 09 2 1s304ms 652ms 12 7 7s794ms 1s113ms 13 21 19s439ms 925ms 14 63 1m6s 1s55ms 15 32 30s482ms 952ms 16 52 49s42ms 943ms 17 19 25s937ms 1s365ms 18 30 29s63ms 968ms 19 27 41s270ms 1s528ms 20 19 24s368ms 1s282ms 21 7 5s330ms 761ms 23 6 4s836ms 806ms -
UPDATE "stock_move" SET "date" = '2024-02-19 19:56:21', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (820096, 820097, 820098, 820099, 820100, 820101, 820102, 820103, 820104, 820086, 820087, 820088, 820089, 820090, 820091, 820092, 820093, 820094, 820095);
Date: 2024-02-19 19:56:34 Duration: 12s931ms
-
UPDATE "stock_move" SET "date" = '2024-02-19 17:00:44', "is_done" = true, "state" = 'done', "write_uid" = 1267, "write_date" = (now() at time zone 'UTC') WHERE id IN (809831, 809832, 809833, 809834, 809835, 809836, 809837, 809838, 809839, 809841, 809842, 809843, 809844, 809845, 809846, 809847, 809848);
Date: 2024-02-19 17:00:55 Duration: 11s109ms
-
UPDATE "stock_move" SET "date" = '2024-02-19 14:43:20', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (817971, 817972, 817973, 817975, 817976, 817977, 817978, 817980, 817981, 817982);
Date: 2024-02-19 14:43:33 Duration: 10s261ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 10,524 1h19m45s 120ms 2s375ms 454ms 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 Feb 19 00 118 49s58ms 415ms 01 154 1m6s 432ms 02 155 1m2s 405ms 03 33 12s316ms 373ms 04 34 13s160ms 387ms 05 44 19s797ms 449ms 06 100 37s306ms 373ms 07 83 32s768ms 394ms 08 146 1m3s 433ms 09 165 1m10s 424ms 10 45 18s756ms 416ms 11 45 18s793ms 417ms 12 337 1m49s 324ms 13 930 6m48s 439ms 14 1,234 9m27s 459ms 15 1,336 8m59s 403ms 16 785 5m56s 454ms 17 976 8m16s 508ms 18 1,010 6m57s 413ms 19 939 9m31s 608ms 20 931 8m 515ms 21 602 4m10s 415ms 22 214 1m23s 388ms 23 108 40s178ms 372ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-02-19 19:10:01') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1254"', '["pointspring_master","calendar.alarm",51895]', '["pointspring_master","mail.channel",533]', '["pointspring_master","mail.channel",534]', '["pointspring_master","res.partner",51895]', '["pointspring_master","ir.needaction",51895]'))) ORDER BY "bus_bus"."id";
Date: 2024-02-19 19:10:53 Duration: 2s375ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-02-19 19:10:01') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19529]', '["pointspring_master","mail.channel",157]', '["pointspring_master","mail.channel",158]', '["pointspring_master","mail.channel",159]', '["pointspring_master","mail.channel",160]', '["pointspring_master","mail.channel",485]', '["pointspring_master","mail.channel",553]', '["pointspring_master","res.partner",19529]', '["pointspring_master","ir.needaction",19529]'))) ORDER BY "bus_bus"."id";
Date: 2024-02-19 19:10:53 Duration: 2s365ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-02-19 19:10:01') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_972"', '["pointspring_master","calendar.alarm",19510]', '["pointspring_master","mail.channel",84]', '["pointspring_master","mail.channel",85]', '["pointspring_master","mail.channel",86]', '["pointspring_master","mail.channel",87]', '["pointspring_master","mail.channel",531]', '["pointspring_master","res.partner",19510]', '["pointspring_master","ir.needaction",19510]'))) ORDER BY "bus_bus"."id";
Date: 2024-02-19 19:10:53 Duration: 2s299ms
2 4,095 23m22s 120ms 758ms 342ms select "forecasted_data".id from "forecasted_data" where ("forecasted_data"."item_supply_plan_id" in (...)) order by "forecasted_data"."id";Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Feb 19 01 59 13s822ms 234ms 02 42 10s155ms 241ms 12 3 395ms 131ms 13 87 19s609ms 225ms 14 48 9s890ms 206ms 15 1,489 8m6s 326ms 16 484 3m4s 381ms 17 579 3m37s 376ms 18 762 4m57s 390ms 19 311 1m50s 353ms 20 95 19s700ms 207ms 21 104 25s389ms 244ms 22 18 3s448ms 191ms 23 14 3s72ms 219ms -
SELECT "forecasted_data".id FROM "forecasted_data" WHERE ("forecasted_data"."item_supply_plan_id" in (35595)) ORDER BY "forecasted_data"."id";
Date: 2024-02-19 15:45:30 Duration: 758ms
-
SELECT "forecasted_data".id FROM "forecasted_data" WHERE ("forecasted_data"."item_supply_plan_id" in (35792, 35071)) ORDER BY "forecasted_data"."id";
Date: 2024-02-19 15:06:15 Duration: 744ms
-
SELECT "forecasted_data".id FROM "forecasted_data" WHERE ("forecasted_data"."item_supply_plan_id" in (35800)) ORDER BY "forecasted_data"."id";
Date: 2024-02-19 16:26:20 Duration: 728ms
3 3,489 40m6s 606ms 2s432ms 689ms 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 Feb 19 12 283 3m9s 668ms 13 535 6m16s 702ms 14 535 6m17s 705ms 15 412 4m50s 704ms 16 427 4m50s 680ms 17 310 3m26s 666ms 18 313 3m36s 692ms 19 272 3m11s 702ms 20 316 3m32s 671ms 21 77 50s504ms 655ms 23 9 5s736ms 637ms -
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 ('%%78%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%7/8%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%7/8%'))) 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: 2024-02-19 14:08:31 Duration: 2s432ms
-
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 ('%%6531%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%6.5-3-1%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%6.5-3-1%'))) 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: 2024-02-19 14:08:31 Duration: 2s285ms
-
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 ('%%9499%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%9499%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%9499%'))) 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: 2024-02-19 14:49:16 Duration: 2s211ms
4 3,286 19m53s 336ms 1s424ms 363ms 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 #4
Day Hour Count Duration Avg duration Feb 19 00 3 1s47ms 349ms 01 3 1s14ms 338ms 06 1 336ms 336ms 08 3 1s14ms 338ms 09 7 2s361ms 337ms 10 5 1s721ms 344ms 11 24 8s165ms 340ms 12 247 1m27s 355ms 13 490 2m56s 360ms 14 550 3m25s 373ms 15 394 2m26s 371ms 16 393 2m22s 361ms 17 255 1m30s 356ms 18 265 1m36s 364ms 19 210 1m17s 368ms 20 248 1m28s 357ms 21 126 44s323ms 351ms 22 29 9s830ms 338ms 23 33 11s333ms 343ms -
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_backend.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-472a842/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-02-19 14:04:04 Duration: 1s424ms
-
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.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-a54df00/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-02-19 15:29:47 Duration: 992ms
-
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_backend.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-bba3a16/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-02-19 19:19:14 Duration: 959ms
5 2,914 12m19s 120ms 653ms 253ms select "product_warehouse_inventory".id from "product_warehouse_inventory" where ("product_warehouse_inventory"."product_id" in (...)) order by "product_warehouse_inventory"."warehouse_name";Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Feb 19 00 2 260ms 130ms 01 72 10s749ms 149ms 02 35 5s374ms 153ms 12 1 237ms 237ms 13 89 14s762ms 165ms 14 49 7s788ms 158ms 15 1,132 4m27s 236ms 16 301 1m20s 268ms 17 392 1m54s 291ms 18 525 2m43s 312ms 19 212 58s407ms 275ms 20 29 4s205ms 145ms 21 44 7s165ms 162ms 22 23 3s293ms 143ms 23 8 1s155ms 144ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (180516, 180501, 180313, 180312, 180311, 180236, 180227, 179866, 179818, 179416, 179343, 179225, 178967, 178935, 178711, 178710, 178699, 178694, 178630, 178479, 180381, 179622, 179686, 178683)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-02-19 18:16:35 Duration: 653ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (181845, 182155, 182165, 182171, 182965, 182713)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-02-19 15:06:15 Duration: 614ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (220110, 219747, 219614, 218570, 216887, 216793, 216001, 215959, 215519, 215194, 215083, 215023, 214966, 214532, 214496, 214385, 214035, 213571, 213559, 213440, 213428, 213427, 213410, 213712, 213713, 219897, 213814, 243762, 216281, 216280, 216172, 215703, 215636, 215534, 214759, 214030, 213426, 215786, 213911, 214174, 216391)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-02-19 15:06:13 Duration: 602ms
6 2,560 8m18s 175ms 678ms 194ms 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 #6
Day Hour Count Duration Avg duration Feb 19 09 5 899ms 179ms 10 1 177ms 177ms 11 10 1s776ms 177ms 12 24 4s502ms 187ms 13 87 17s380ms 199ms 14 233 46s196ms 198ms 15 119 23s325ms 196ms 16 136 26s365ms 193ms 17 114 22s450ms 196ms 18 1,183 3m50s 194ms 19 305 59s772ms 195ms 20 171 33s298ms 194ms 21 152 28s798ms 189ms 22 5 896ms 179ms 23 15 2s700ms 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 (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 ('%T-05461%') OR unaccent (res_partner.display_name) ilike unaccent ('%T-05461%') OR unaccent (res_partner.ref) ilike unaccent ('%T-05461%') OR unaccent (res_partner.vat) ilike unaccent ('T-05461')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%T-05461%') desc, unaccent (res_partner.display_name);
Date: 2024-02-19 17:58:30 Duration: 678ms
-
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 ('%G-02933%') OR unaccent (res_partner.display_name) ilike unaccent ('%G-02933%') OR unaccent (res_partner.ref) ilike unaccent ('%G-02933%') OR unaccent (res_partner.vat) ilike unaccent ('G-02933')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%G-02933%') desc, unaccent (res_partner.display_name);
Date: 2024-02-19 18:43:30 Duration: 667ms
-
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 ('%15740%') OR unaccent (res_partner.display_name) ilike unaccent ('%15740%') OR unaccent (res_partner.ref) ilike unaccent ('%15740%') OR unaccent (res_partner.vat) ilike unaccent ('15740')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%15740%') desc, unaccent (res_partner.display_name);
Date: 2024-02-19 13:42:37 Duration: 619ms
7 2,404 5m28s 122ms 805ms 136ms update product_warehouse_inventory set sft_stk_qty = ? where id = ( select id from product_warehouse_inventory where product_id = (?) and warehouse_id = (?));Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Feb 19 13 32 4s694ms 146ms 14 26 3s570ms 137ms 15 124 17s602ms 141ms 16 462 1m1s 134ms 17 223 29s776ms 133ms 18 691 1m37s 141ms 19 451 1m 133ms 20 190 26s522ms 139ms 21 30 3s915ms 130ms 22 127 16s458ms 129ms 23 48 6s218ms 129ms -
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (209323) and warehouse_id = (45));
Date: 2024-02-19 18:52:58 Duration: 805ms
-
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (209234) and warehouse_id = (45));
Date: 2024-02-19 18:52:57 Duration: 557ms
-
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (212163) and warehouse_id = (39));
Date: 2024-02-19 20:09:50 Duration: 554ms
8 2,001 5m8s 120ms 989ms 154ms select count(?) from mail_tracking_value v left join mail_message m on (v.mail_message_id = m.id) join purchase_order po on (po.id = m.res_id) where m.create_date >= ? and m.model = ? and m.message_type = ? and v.old_value_char = ? and v.new_value_char = ? and po.company_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Feb 19 06 1 989ms 989ms 10 3 861ms 287ms 11 1 169ms 169ms 12 11 1s807ms 164ms 13 20 3s310ms 165ms 14 100 14s419ms 144ms 15 83 13s282ms 160ms 16 85 12s555ms 147ms 17 90 12s644ms 140ms 18 1,110 2m57s 159ms 19 230 33s285ms 144ms 20 210 29s286ms 139ms 21 47 6s930ms 147ms 22 10 1s675ms 167ms -
SELECT COUNT(1) FROM mail_tracking_value v LEFT JOIN mail_message m ON (v.mail_message_id = m.id) JOIN purchase_order po ON (po.id = m.res_id) WHERE m.create_date >= '2024-02-12 06:59:17' AND m.model = 'purchase.order' AND m.message_type = 'notification' AND v.old_value_char = 'RFQ' AND v.new_value_char = 'RFQ Sent' AND po.company_id = 1;
Date: 2024-02-19 06:59:18 Duration: 989ms
-
SELECT COUNT(1) FROM mail_tracking_value v LEFT JOIN mail_message m ON (v.mail_message_id = m.id) JOIN purchase_order po ON (po.id = m.res_id) WHERE m.create_date >= '2024-02-12 18:42:37' AND m.model = 'purchase.order' AND m.message_type = 'notification' AND v.old_value_char = 'RFQ' AND v.new_value_char = 'RFQ Sent' AND po.company_id = 1;
Date: 2024-02-19 18:42:37 Duration: 522ms
-
SELECT COUNT(1) FROM mail_tracking_value v LEFT JOIN mail_message m ON (v.mail_message_id = m.id) JOIN purchase_order po ON (po.id = m.res_id) WHERE m.create_date >= '2024-02-12 10:58:43' AND m.model = 'purchase.order' AND m.message_type = 'notification' AND v.old_value_char = 'RFQ' AND v.new_value_char = 'RFQ Sent' AND po.company_id = 1;
Date: 2024-02-19 10:58:43 Duration: 473ms
9 1,318 3m38s 133ms 1s837ms 165ms select min("account_move".id) as id, count("account_move".id) AS "debit_origin_id_count", "account_move"."debit_origin_id" AS "debit_origin_id" from "account_move" left join "account_move" AS "account_move__debit_origin_id" on ("account_move"."debit_origin_id" = "account_move__debit_origin_id"."id") where ("account_move"."debit_origin_id" in (...)) and ("account_move"."company_id" is null or ("account_move"."company_id" in (...))) group by "account_move"."debit_origin_id", "account_move__debit_origin_id"."invoice_date_due" order by "account_move__debit_origin_id"."invoice_date_due";Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Feb 19 09 10 1s515ms 151ms 10 1 169ms 169ms 12 61 9s770ms 160ms 13 117 19s555ms 167ms 14 231 39s599ms 171ms 15 107 18s480ms 172ms 16 74 12s166ms 164ms 17 111 17s953ms 161ms 18 129 21s399ms 165ms 19 250 41s590ms 166ms 20 157 25s949ms 165ms 21 37 5s643ms 152ms 22 1 150ms 150ms 23 32 4s798ms 149ms -
SELECT min("account_move".id) AS id, count("account_move".id) AS "debit_origin_id_count", "account_move"."debit_origin_id" as "debit_origin_id" FROM "account_move" LEFT JOIN "account_move" AS "account_move__debit_origin_id" ON ("account_move"."debit_origin_id" = "account_move__debit_origin_id"."id") WHERE ("account_move"."debit_origin_id" in (1213581)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) GROUP BY "account_move"."debit_origin_id", "account_move__debit_origin_id"."invoice_date_due" ORDER BY "account_move__debit_origin_id"."invoice_date_due";
Date: 2024-02-19 14:04:05 Duration: 1s837ms
-
SELECT min("account_move".id) AS id, count("account_move".id) AS "debit_origin_id_count", "account_move"."debit_origin_id" as "debit_origin_id" FROM "account_move" LEFT JOIN "account_move" AS "account_move__debit_origin_id" ON ("account_move"."debit_origin_id" = "account_move__debit_origin_id"."id") WHERE ("account_move"."debit_origin_id" in (1082384)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) GROUP BY "account_move"."debit_origin_id", "account_move__debit_origin_id"."invoice_date_due" ORDER BY "account_move__debit_origin_id"."invoice_date_due";
Date: 2024-02-19 19:06:48 Duration: 1s388ms
-
SELECT min("account_move".id) AS id, count("account_move".id) AS "debit_origin_id_count", "account_move"."debit_origin_id" as "debit_origin_id" FROM "account_move" LEFT JOIN "account_move" AS "account_move__debit_origin_id" ON ("account_move"."debit_origin_id" = "account_move__debit_origin_id"."id") WHERE ("account_move"."debit_origin_id" in (1145172)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) GROUP BY "account_move"."debit_origin_id", "account_move__debit_origin_id"."invoice_date_due" ORDER BY "account_move__debit_origin_id"."invoice_date_due";
Date: 2024-02-19 20:20:22 Duration: 815ms
10 1,292 4m53s 205ms 676ms 227ms 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 #10
Day Hour Count Duration Avg duration Feb 19 12 408 1m31s 224ms 13 120 27s360ms 228ms 14 121 27s364ms 226ms 15 422 1m37s 230ms 16 29 6s667ms 229ms 17 47 10s223ms 217ms 18 56 13s224ms 236ms 19 39 8s643ms 221ms 20 34 7s564ms 222ms 21 14 3s116ms 222ms 22 2 419ms 209ms -
SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (320635)) ORDER BY "sale_line_report"."id";
Date: 2024-02-19 18:15:30 Duration: 676ms
-
SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (320635)) ORDER BY "sale_line_report"."id";
Date: 2024-02-19 18:15:30 Duration: 483ms
-
SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (342124)) ORDER BY "sale_line_report"."id";
Date: 2024-02-19 15:28:02 Duration: 470ms
11 1,223 3m36s 151ms 929ms 177ms select min("sale_report".id) as id, count("sale_report".id) AS "product_id_count", sum("sale_report"."product_uom_qty") AS "product_uom_qty", "sale_report"."product_id" AS "product_id" from "sale_report" left join "product_product" AS "sale_report__product_id" on ("sale_report"."product_id" = "sale_report__product_id"."id") left join "product_template" AS "sale_report__product_id__product_tmpl_id" on ("sale_report__product_id"."product_tmpl_id" = "sale_report__product_id__product_tmpl_id"."id") left join "ir_translation" AS "sale_report__product_id__product_tmpl_id__name" on ("sale_report__product_id__product_tmpl_id"."id" = "sale_report__product_id__product_tmpl_id__name"."res_id" and "sale_report__product_id__product_tmpl_id__name"."type" = ? and "sale_report__product_id__product_tmpl_id__name"."name" = ? and "sale_report__product_id__product_tmpl_id__name"."lang" = ? and "sale_report__product_id__product_tmpl_id__name"."value" != ?) where ((("sale_report"."state" in (...)) and ("sale_report"."product_id" in (...))) and ("sale_report"."date" >= ?)) and ("sale_report"."company_id" is null or ("sale_report"."company_id" in (...))) group by "sale_report"."product_id", "sale_report__product_id"."default_code", coalesce("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id" order by "sale_report__product_id"."default_code", coalesce("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id";Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Feb 19 01 1 168ms 168ms 11 5 847ms 169ms 12 51 8s702ms 170ms 13 140 25s574ms 182ms 14 106 18s744ms 176ms 15 190 35s740ms 188ms 16 158 28s273ms 178ms 17 86 14s538ms 169ms 18 111 20s7ms 180ms 19 130 23s406ms 180ms 20 142 24s51ms 169ms 21 56 9s187ms 164ms 22 39 6s323ms 162ms 23 8 1s269ms 158ms -
SELECT min("sale_report".id) AS id, count("sale_report".id) AS "product_id_count", sum("sale_report"."product_uom_qty") AS "product_uom_qty", "sale_report"."product_id" as "product_id" FROM "sale_report" LEFT JOIN "product_product" AS "sale_report__product_id" ON ("sale_report"."product_id" = "sale_report__product_id"."id") LEFT JOIN "product_template" AS "sale_report__product_id__product_tmpl_id" ON ("sale_report__product_id"."product_tmpl_id" = "sale_report__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "sale_report__product_id__product_tmpl_id__name" ON ("sale_report__product_id__product_tmpl_id"."id" = "sale_report__product_id__product_tmpl_id__name"."res_id" AND "sale_report__product_id__product_tmpl_id__name"."type" = 'model' AND "sale_report__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "sale_report__product_id__product_tmpl_id__name"."lang" = 'en_US' AND "sale_report__product_id__product_tmpl_id__name"."value" != '') WHERE ((("sale_report"."state" in ('sale', 'done', 'paid')) AND ("sale_report"."product_id" in (203802))) AND ("sale_report"."date" >= '2023-02-19 00:00:00')) AND ("sale_report"."company_id" IS NULL OR ("sale_report"."company_id" in (1))) GROUP BY "sale_report"."product_id", "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id" ORDER BY "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id";
Date: 2024-02-19 13:43:30 Duration: 929ms
-
SELECT min("sale_report".id) AS id, count("sale_report".id) AS "product_id_count", sum("sale_report"."product_uom_qty") AS "product_uom_qty", "sale_report"."product_id" as "product_id" FROM "sale_report" LEFT JOIN "product_product" AS "sale_report__product_id" ON ("sale_report"."product_id" = "sale_report__product_id"."id") LEFT JOIN "product_template" AS "sale_report__product_id__product_tmpl_id" ON ("sale_report__product_id"."product_tmpl_id" = "sale_report__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "sale_report__product_id__product_tmpl_id__name" ON ("sale_report__product_id__product_tmpl_id"."id" = "sale_report__product_id__product_tmpl_id__name"."res_id" AND "sale_report__product_id__product_tmpl_id__name"."type" = 'model' AND "sale_report__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "sale_report__product_id__product_tmpl_id__name"."lang" = 'en_US' AND "sale_report__product_id__product_tmpl_id__name"."value" != '') WHERE ((("sale_report"."state" in ('sale', 'done', 'paid')) AND ("sale_report"."product_id" in (172259))) AND ("sale_report"."date" >= '2023-02-19 00:00:00')) AND ("sale_report"."company_id" IS NULL OR ("sale_report"."company_id" in (1))) GROUP BY "sale_report"."product_id", "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id" ORDER BY "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id";
Date: 2024-02-19 16:26:20 Duration: 687ms
-
SELECT min("sale_report".id) AS id, count("sale_report".id) AS "product_id_count", sum("sale_report"."product_uom_qty") AS "product_uom_qty", "sale_report"."product_id" as "product_id" FROM "sale_report" LEFT JOIN "product_product" AS "sale_report__product_id" ON ("sale_report"."product_id" = "sale_report__product_id"."id") LEFT JOIN "product_template" AS "sale_report__product_id__product_tmpl_id" ON ("sale_report__product_id"."product_tmpl_id" = "sale_report__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "sale_report__product_id__product_tmpl_id__name" ON ("sale_report__product_id__product_tmpl_id"."id" = "sale_report__product_id__product_tmpl_id__name"."res_id" AND "sale_report__product_id__product_tmpl_id__name"."type" = 'model' AND "sale_report__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "sale_report__product_id__product_tmpl_id__name"."lang" = 'en_US' AND "sale_report__product_id__product_tmpl_id__name"."value" != '') WHERE ((("sale_report"."state" in ('sale', 'done', 'paid')) AND ("sale_report"."product_id" in (183606))) AND ("sale_report"."date" >= '2023-02-19 00:00:00')) AND ("sale_report"."company_id" IS NULL OR ("sale_report"."company_id" in (1))) GROUP BY "sale_report"."product_id", "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id" ORDER BY "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id";
Date: 2024-02-19 19:09:16 Duration: 545ms
12 1,196 2m44s 122ms 795ms 137ms update "stock_quant" set "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 Feb 19 01 23 2s952ms 128ms 02 21 2s685ms 127ms 12 62 8s365ms 134ms 13 128 18s424ms 143ms 14 179 24s579ms 137ms 15 171 24s276ms 141ms 16 122 16s962ms 139ms 17 58 7s685ms 132ms 18 158 21s484ms 135ms 19 120 16s277ms 135ms 20 91 12s448ms 136ms 21 42 5s650ms 134ms 22 16 2s90ms 130ms 23 5 659ms 131ms -
UPDATE "stock_quant" SET "reserved_quantity" = 0.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (295873, 435558, 345990, 400559, 339612, 58013);
Date: 2024-02-19 15:15:27 Duration: 795ms
-
UPDATE "stock_quant" SET "reserved_quantity" = 3.0, "write_uid" = 952, "write_date" = (now() at time zone 'UTC') WHERE id IN (44592);
Date: 2024-02-19 18:37:08 Duration: 386ms
-
UPDATE "stock_quant" SET "reserved_quantity" = 1.0, "write_uid" = 965, "write_date" = (now() at time zone 'UTC') WHERE id IN (146112);
Date: 2024-02-19 13:42:39 Duration: 329ms
13 898 12m40s 786ms 1s858ms 846ms 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 #13
Day Hour Count Duration Avg duration Feb 19 12 38 31s613ms 831ms 13 105 1m29s 849ms 14 99 1m25s 859ms 15 127 1m51s 876ms 16 113 1m34s 835ms 17 68 56s54ms 824ms 18 80 1m8s 851ms 19 94 1m18s 835ms 20 102 1m26s 845ms 21 54 44s472ms 823ms 22 16 13s222ms 826ms 23 2 1s678ms 839ms -
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 ('%329071-62x%')) 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 ('%329071-62x%'))) 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 ('%329071-62x%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%329071-62x%')))))) 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: 2024-02-19 15:10:13 Duration: 1s858ms
-
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 ('%lfp3191%')) 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 ('%lfp3191%'))) 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 ('%lfp3191%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%lfp3191%')))))) 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: 2024-02-19 13:53:45 Duration: 1s735ms
-
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 ('%321-368%')) 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 ('%321-368%'))) 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 ('%321-368%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%321-368%')))))) 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: 2024-02-19 20:22:54 Duration: 1s555ms
14 853 9m43s 620ms 1s429ms 684ms 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 #14
Day Hour Count Duration Avg duration Feb 19 12 99 1m8s 689ms 13 61 41s676ms 683ms 14 5 3s253ms 650ms 15 82 55s960ms 682ms 16 103 1m10s 685ms 17 55 37s32ms 673ms 18 102 1m11s 696ms 19 243 2m45s 683ms 20 42 29s594ms 704ms 21 61 40s499ms 663ms -
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 ('%%3089%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%3089%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%3089%'))) 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: 2024-02-19 16:33:52 Duration: 1s429ms
-
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 ('%%A8030%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%A-8030%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%A-8030%'))) 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: 2024-02-19 19:58:47 Duration: 1s215ms
-
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 ('%%lab4%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%lab4%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%lab4%'))) 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: 2024-02-19 18:15:05 Duration: 1s185ms
15 806 3m26s 214ms 1s788ms 256ms 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 #15
Day Hour Count Duration Avg duration Feb 19 09 5 1s280ms 256ms 12 26 6s901ms 265ms 13 73 18s145ms 248ms 14 222 55s527ms 250ms 15 133 35s801ms 269ms 16 37 9s133ms 246ms 17 54 13s57ms 241ms 18 94 27s176ms 289ms 19 40 10s89ms 252ms 20 52 12s823ms 246ms 21 29 7s21ms 242ms 23 41 9s503ms 231ms -
UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 0.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (331552, 331170, 331554, 331182, 331543, 331544, 331549, 331550);
Date: 2024-02-19 15:15:30 Duration: 1s788ms
-
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" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (336900, 336904, 336844, 336908, 336891, 336892, 336894);
Date: 2024-02-19 18:12:37 Duration: 1s595ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'to invoice', "open_qty_fil" = 0.0, "qty_delivered" = '1.00', "qty_to_invoice" = '1.00', "untaxed_amount_to_invoice" = '23.40', "write_uid" = 1022, "write_date" = (now() at time zone 'UTC') WHERE id IN (342451);
Date: 2024-02-19 18:17:25 Duration: 1s17ms
16 794 7m10s 127ms 18s289ms 542ms update "stock_move" set "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Feb 19 01 20 28s302ms 1s415ms 02 16 29s508ms 1s844ms 12 41 16s898ms 412ms 13 81 39s231ms 484ms 14 95 46s369ms 488ms 15 93 38s843ms 417ms 16 104 50s813ms 488ms 17 44 19s913ms 452ms 18 84 33s962ms 404ms 19 62 42s386ms 683ms 20 66 46s704ms 707ms 21 52 22s957ms 441ms 22 30 12s905ms 430ms 23 6 2s163ms 360ms -
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (820140, 820143, 820144, 820145, 820146, 820147, 820148, 820149, 820150, 820151, 820152, 820154, 820155, 820156, 820157, 820158, 820159, 820160, 820161, 820162, 820163, 820167, 820169, 820171, 820172, 820173, 820175, 820176, 820178, 820181, 820182, 820183, 820185, 820188, 820189, 820192, 820198, 820201, 820204, 820208, 820211, 820212, 820216, 820217, 820218, 820220, 820222);
Date: 2024-02-19 20:01:29 Duration: 18s289ms
-
UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (820105, 820106, 820107, 820108, 820109, 820110, 820111, 820112, 820113, 820114, 820115, 820116, 820117, 820118, 820119, 820120, 820121, 820122, 820123);
Date: 2024-02-19 19:38:22 Duration: 9s932ms
-
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (818498, 818500, 818502, 818504, 818506, 818508, 818509, 818511, 818513, 818515, 818517, 818519, 818521, 818523);
Date: 2024-02-19 02:21:54 Duration: 7s36ms
17 776 6m38s 129ms 7s373ms 513ms update "stock_quant" set "quantity" = ?.?, "reserved_quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Feb 19 09 4 2s136ms 534ms 12 17 8s758ms 515ms 13 77 35s170ms 456ms 14 184 1m40s 544ms 15 135 1m4s 476ms 16 78 32s917ms 422ms 17 53 30s542ms 576ms 18 70 36s298ms 518ms 19 62 36s28ms 581ms 20 50 28s41ms 560ms 21 18 9s438ms 524ms 23 28 14s641ms 522ms -
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (436969, 436970, 436971, 436972, 436973, 436974, 436975, 436976, 436977, 436978);
Date: 2024-02-19 14:43:40 Duration: 7s373ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1267, "write_date" = (now() at time zone 'UTC') WHERE id IN (437126, 437127, 437128, 437129, 437130, 437131, 437132, 437133, 437134, 437135, 437136, 437137, 437138, 437139, 437140, 437141, 437142);
Date: 2024-02-19 17:01:01 Duration: 6s534ms
-
UPDATE "stock_quant" SET "quantity" = 2.0, "reserved_quantity" = 0.0, "write_uid" = 1038, "write_date" = (now() at time zone 'UTC') WHERE id IN (356544, 370308, 370310, 50825, 50987, 261964, 337069, 50766, 238607, 50834, 238582, 417879, 245019, 50941);
Date: 2024-02-19 20:48:12 Duration: 5s411ms
18 738 2m35s 200ms 541ms 210ms select "product_template".id from "product_template" where (("product_template"."active" = true) and (("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, "product_template"."list_price" asc, "product_template"."id" desc;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Feb 19 08 6 1s241ms 206ms 09 306 1m2s 205ms 10 321 1m6s 205ms 12 3 925ms 308ms 13 6 1s255ms 209ms 14 3 611ms 203ms 15 87 20s908ms 240ms 17 3 635ms 211ms 18 3 616ms 205ms -
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" ASC, "product_template"."id" DESC;
Date: 2024-02-19 15:19:15 Duration: 541ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" ASC, "product_template"."id" DESC;
Date: 2024-02-19 15:19:15 Duration: 502ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" ASC, "product_template"."id" DESC;
Date: 2024-02-19 15:09:32 Duration: 417ms
19 737 5m44s 120ms 6s453ms 467ms update "stock_quant" set "quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Feb 19 09 2 511ms 255ms 12 3 645ms 215ms 13 50 22s831ms 456ms 14 81 27s829ms 343ms 15 67 28s837ms 430ms 16 71 33s335ms 469ms 17 32 16s632ms 519ms 18 118 1m3s 538ms 19 124 1m1s 499ms 20 125 59s885ms 479ms 21 60 27s497ms 458ms 23 4 749ms 187ms -
UPDATE "stock_quant" SET "quantity" = 2.0, "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (406112, 50914, 397667, 406114, 337061, 50874, 50765, 198990, 50833, 50994, 50898, 50805, 50807, 50840, 412153, 412154, 412159);
Date: 2024-02-19 18:53:48 Duration: 6s453ms
-
UPDATE "stock_quant" SET "quantity" = 2.0, "write_uid" = 965, "write_date" = (now() at time zone 'UTC') WHERE id IN (143170, 348772, 143048, 143019, 143053, 417998, 143023, 143247, 348783, 348786, 343220, 429111, 237595, 429116, 143037, 411742);
Date: 2024-02-19 20:28:41 Duration: 6s220ms
-
UPDATE "stock_quant" SET "quantity" = 3.0, "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (370308, 370310, 50825, 50987, 261964, 337069, 50766, 238607, 50834, 238582, 417879, 370297, 245019, 50941);
Date: 2024-02-19 18:53:54 Duration: 5s680ms
20 727 3m 219ms 666ms 248ms 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 Feb 19 09 5 1s236ms 247ms 12 24 5s721ms 238ms 13 70 18s571ms 265ms 14 190 46s868ms 246ms 15 89 22s335ms 250ms 16 33 7s772ms 235ms 17 86 21s653ms 251ms 18 83 21s423ms 258ms 19 39 9s382ms 240ms 20 46 10s980ms 238ms 21 24 5s868ms 244ms 23 38 8s812ms 231ms -
UPDATE "sale_order_line" SET "invoice_status" = 'no', "qty_invoiced" = '57.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '6530.49', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1035, "write_date" = (now() at time zone 'UTC') WHERE id IN (320635);
Date: 2024-02-19 18:17:00 Duration: 666ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '1.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '86.70', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (342116);
Date: 2024-02-19 14:52:30 Duration: 581ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '2.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '88.44', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 965, "write_date" = (now() at time zone 'UTC') WHERE id IN (342325, 342326);
Date: 2024-02-19 17:03:41 Duration: 544ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1s464ms 2m27s 12s996ms 36 7m47s delete from account_move_line where id in (...);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Feb 19 12 2 2m31s 1m15s 13 2 11s758ms 5s879ms 14 1 3s124ms 3s124ms 15 1 6s6ms 6s6ms 17 1 4s415ms 4s415ms 18 3 9s560ms 3s186ms 19 7 23s636ms 3s376ms 20 1 7s349ms 7s349ms 21 1 3s104ms 3s104ms 23 17 4m7s 14s571ms -
DELETE FROM account_move_line WHERE id IN (4225720, 4225721, 4225722, 4225723, 4225724, 4225725, 4225726, 4225727, 4225728, 4225729, 4225730, 4225731, 4225732, 4225733, 4225734, 4225735, 4225736, 4225737, 4225738, 4225739, 4225740, 4225741, 4225742, 4225743, 4225744, 4225745, 4225746, 4225747, 4225748, 4225749, 4225750, 4225751, 4225752, 4225753, 4225754, 4225755, 4225756, 4225757, 4225758, 4225759, 4225760, 4225761, 4225762, 4225763, 4225764, 4225765, 4225766, 4225767, 4225768, 4225769, 4225770, 4225771, 4225772, 4225773, 4225774, 4225775, 4225776, 4225777, 4225778, 4225779, 4225780, 4225781, 4225782, 4225783, 4225784, 4225785, 4225786, 4225787, 4225788, 4225789, 4225790, 4225791, 4225792, 4225793, 4225794, 4225795, 4225796, 4225797, 4225798, 4225799, 4225800, 4225801, 4225802, 4225803, 4225804, 4225805, 4225806, 4225807, 4225808, 4225809, 4225810, 4225811, 4225812, 4225813, 4225814, 4225815, 4225816);
Date: 2024-02-19 12:51:18 Duration: 2m27s
-
DELETE FROM account_move_line WHERE id IN (4187140, 4187141, 4187142, 4187143, 4187144, 4187145, 4187146, 4187147, 4187148, 4187149, 4187150, 4187151, 4187152, 4187153, 4187154, 4187155, 4187156, 4187157, 4187158, 4187159, 4187160, 4187161, 4187162, 4187163, 4187164, 4187165, 4187166, 4187167, 4187168, 4187169, 4187170, 4187171, 4187172, 4187173, 4187174, 4187175, 4187176, 4187177, 4187178, 4187179, 4187180, 4187181, 4187182, 4187183, 4187184, 4187185, 4187186, 4187187, 4187188, 4187189, 4187190, 4187191, 4231777, 4231778);
Date: 2024-02-19 23:43:33 Duration: 1m19s
-
DELETE FROM account_move_line WHERE id IN (4213364, 4213365, 4213366, 4213367, 4215588, 4215589, 4215590, 4215591, 4215592, 4215593, 4215594, 4215595, 4215596, 4215597, 4215598, 4215599);
Date: 2024-02-19 23:56:18 Duration: 23s648ms
2 264ms 24s103ms 2s717ms 136 6m9s 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 Feb 19 09 1 629ms 629ms 12 1 669ms 669ms 13 6 13s826ms 2s304ms 14 32 1m7s 2s101ms 15 17 1m4s 3s791ms 16 10 35s452ms 3s545ms 17 4 8s239ms 2s59ms 18 29 1m19s 2s756ms 19 7 8s957ms 1s279ms 20 17 1m2s 3s662ms 21 5 14s753ms 2s950ms 23 7 13s97ms 1s871ms -
UPDATE "stock_move" SET "date" = '2024-02-19 15:18:12', "state" = 'done', "write_uid" = 1270, "write_date" = (now() at time zone 'UTC') WHERE id IN (819219, 819220, 819221, 819222, 819223, 819224, 819226, 819227, 819229, 819230, 819231, 819232, 819233, 819234, 819235, 819236, 819237, 819238, 819239, 819241, 819242, 819243, 819244, 819245, 819246, 819247, 819248, 819249, 819250, 819251, 819252, 819253, 819254, 819255, 819256);
Date: 2024-02-19 15:18:38 Duration: 24s103ms
-
UPDATE "stock_move" SET "date" = '2024-02-19 20:28:07', "state" = 'done', "write_uid" = 965, "write_date" = (now() at time zone 'UTC') WHERE id IN (809669, 809670, 809671, 809672, 809673, 809674, 809675, 809676, 809677, 809680, 809681, 809682, 809683, 809684, 809685, 809686, 809687, 809688, 809689, 809690, 809691, 809692, 809693, 809694, 809695);
Date: 2024-02-19 20:28:25 Duration: 16s882ms
-
UPDATE "stock_move" SET "date" = '2024-02-19 18:11:27', "state" = 'done', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (812717, 812718, 812719, 812720, 812721, 812722, 812723, 812724, 812725, 812726, 812727, 812728, 812729, 812730, 812731, 812732, 812734, 812735, 812736, 812737);
Date: 2024-02-19 18:11:41 Duration: 13s502ms
3 173ms 12s931ms 1s71ms 285 5m5s 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 #3
Day Hour Count Duration Avg duration Feb 19 09 2 1s304ms 652ms 12 7 7s794ms 1s113ms 13 21 19s439ms 925ms 14 63 1m6s 1s55ms 15 32 30s482ms 952ms 16 52 49s42ms 943ms 17 19 25s937ms 1s365ms 18 30 29s63ms 968ms 19 27 41s270ms 1s528ms 20 19 24s368ms 1s282ms 21 7 5s330ms 761ms 23 6 4s836ms 806ms -
UPDATE "stock_move" SET "date" = '2024-02-19 19:56:21', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (820096, 820097, 820098, 820099, 820100, 820101, 820102, 820103, 820104, 820086, 820087, 820088, 820089, 820090, 820091, 820092, 820093, 820094, 820095);
Date: 2024-02-19 19:56:34 Duration: 12s931ms
-
UPDATE "stock_move" SET "date" = '2024-02-19 17:00:44', "is_done" = true, "state" = 'done', "write_uid" = 1267, "write_date" = (now() at time zone 'UTC') WHERE id IN (809831, 809832, 809833, 809834, 809835, 809836, 809837, 809838, 809839, 809841, 809842, 809843, 809844, 809845, 809846, 809847, 809848);
Date: 2024-02-19 17:00:55 Duration: 11s109ms
-
UPDATE "stock_move" SET "date" = '2024-02-19 14:43:20', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (817971, 817972, 817973, 817975, 817976, 817977, 817978, 817980, 817981, 817982);
Date: 2024-02-19 14:43:33 Duration: 10s261ms
4 961ms 2s139ms 1s62ms 504 8m55s select "product_template".id from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) 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"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?)))) order by coalesce("product_template"."is_published", false) desc, "product_template"."website_sequence" asc, "product_template"."id" desc;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Feb 19 12 108 1m50s 1s19ms 13 27 28s999ms 1s74ms 14 90 1m42s 1s143ms 15 96 1m41s 1s57ms 16 75 1m18s 1s52ms 17 27 28s325ms 1s49ms 18 9 9s114ms 1s12ms 19 12 12s209ms 1s17ms 20 24 26s687ms 1s111ms 21 36 36s507ms 1s14ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') 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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%32-30-52-72%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%32-30-52-72%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%32-30-52-72%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%32-30-52-72%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%32-30-52-72%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%32-30-52-72%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2024-02-19 14:52:31 Duration: 2s139ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') 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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%2-1-1313-9%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%2-1-1313-9%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%2-1-1313-9%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%2-1-1313-9%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%2-1-1313-9%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%2-1-1313-9%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2024-02-19 15:29:48 Duration: 2s74ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') 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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%32-30-52-72%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%32-30-52-72%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%32-30-52-72%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%32-30-52-72%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%32-30-52-72%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%32-30-52-72%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2024-02-19 14:52:33 Duration: 1s895ms
5 257ms 15s532ms 905ms 400 6m2s update "stock_move" set "current_warehouse_qty" = ?.?, "date" = ?, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Feb 19 12 4 3s505ms 876ms 13 15 5s996ms 399ms 14 16 12s252ms 765ms 15 27 20s513ms 759ms 16 26 17s907ms 688ms 17 17 14s955ms 879ms 18 66 1m13s 1s113ms 19 151 2m31s 1s 20 64 56s818ms 887ms 21 13 5s361ms 412ms 23 1 292ms 292ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "date" = '2024-02-19 18:53:03', "state" = 'done', "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (809730, 809731, 809732, 809734, 809740, 809753, 809754, 809755, 809756, 809757, 809758, 809759, 809760, 809762, 809763, 809765, 809766, 809767, 809768, 809769, 809770, 809771, 809772);
Date: 2024-02-19 18:53:29 Duration: 15s532ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 3.0, "date" = '2024-02-19 18:53:03', "state" = 'done', "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (809764, 809733, 809735, 809736, 809737, 809738, 809739, 809743, 809744, 809745, 809746, 809747, 809748, 809750, 809752);
Date: 2024-02-19 18:53:39 Duration: 9s789ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 3.0, "date" = '2024-02-19 15:03:48', "state" = 'done', "write_uid" = 1017, "write_date" = (now() at time zone 'UTC') WHERE id IN (812362, 812363, 812364, 812368, 812370);
Date: 2024-02-19 15:03:55 Duration: 3s419ms
6 786ms 1s858ms 846ms 898 12m40s 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 Feb 19 12 38 31s613ms 831ms 13 105 1m29s 849ms 14 99 1m25s 859ms 15 127 1m51s 876ms 16 113 1m34s 835ms 17 68 56s54ms 824ms 18 80 1m8s 851ms 19 94 1m18s 835ms 20 102 1m26s 845ms 21 54 44s472ms 823ms 22 16 13s222ms 826ms 23 2 1s678ms 839ms -
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 ('%329071-62x%')) 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 ('%329071-62x%'))) 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 ('%329071-62x%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%329071-62x%')))))) 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: 2024-02-19 15:10:13 Duration: 1s858ms
-
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 ('%lfp3191%')) 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 ('%lfp3191%'))) 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 ('%lfp3191%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%lfp3191%')))))) 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: 2024-02-19 13:53:45 Duration: 1s735ms
-
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 ('%321-368%')) 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 ('%321-368%'))) 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 ('%321-368%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%321-368%')))))) 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: 2024-02-19 20:22:54 Duration: 1s555ms
7 133ms 6s981ms 803ms 561 7m30s 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 #7
Day Hour Count Duration Avg duration Feb 19 09 2 1s959ms 979ms 12 14 9s606ms 686ms 13 80 1m1s 766ms 14 108 1m33s 863ms 15 74 57s811ms 781ms 16 64 50s712ms 792ms 17 50 42s661ms 853ms 18 72 58s750ms 815ms 19 38 30s551ms 803ms 20 42 30s977ms 737ms 21 12 8s954ms 746ms 23 5 3s891ms 778ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 1.0, "date" = '2024-02-19 14:20:20', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (813312, 813313, 813303, 813304, 813305, 813309, 813310);
Date: 2024-02-19 14:20:30 Duration: 6s981ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "date" = '2024-02-19 17:34:22', "is_done" = true, "state" = 'done', "write_uid" = 1017, "write_date" = (now() at time zone 'UTC') WHERE id IN (809708, 809710, 809711, 809714, 809715, 809716, 809717);
Date: 2024-02-19 17:34:30 Duration: 4s464ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 1.0, "date" = '2024-02-19 19:39:45', "is_done" = true, "state" = 'done', "write_uid" = 964, "write_date" = (now() at time zone 'UTC') WHERE id IN (803849, 803850, 803851, 803852);
Date: 2024-02-19 19:39:49 Duration: 2s792ms
8 606ms 2s432ms 689ms 3,489 40m6s 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 #8
Day Hour Count Duration Avg duration Feb 19 12 283 3m9s 668ms 13 535 6m16s 702ms 14 535 6m17s 705ms 15 412 4m50s 704ms 16 427 4m50s 680ms 17 310 3m26s 666ms 18 313 3m36s 692ms 19 272 3m11s 702ms 20 316 3m32s 671ms 21 77 50s504ms 655ms 23 9 5s736ms 637ms -
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 ('%%78%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%7/8%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%7/8%'))) 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: 2024-02-19 14:08:31 Duration: 2s432ms
-
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 ('%%6531%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%6.5-3-1%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%6.5-3-1%'))) 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: 2024-02-19 14:08:31 Duration: 2s285ms
-
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 ('%%9499%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%9499%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%9499%'))) 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: 2024-02-19 14:49:16 Duration: 2s211ms
9 620ms 1s429ms 684ms 853 9m43s 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 #9
Day Hour Count Duration Avg duration Feb 19 12 99 1m8s 689ms 13 61 41s676ms 683ms 14 5 3s253ms 650ms 15 82 55s960ms 682ms 16 103 1m10s 685ms 17 55 37s32ms 673ms 18 102 1m11s 696ms 19 243 2m45s 683ms 20 42 29s594ms 704ms 21 61 40s499ms 663ms -
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 ('%%3089%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%3089%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%3089%'))) 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: 2024-02-19 16:33:52 Duration: 1s429ms
-
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 ('%%A8030%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%A-8030%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%A-8030%'))) 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: 2024-02-19 19:58:47 Duration: 1s215ms
-
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 ('%%lab4%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%lab4%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%lab4%'))) 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: 2024-02-19 18:15:05 Duration: 1s185ms
10 611ms 1s617ms 673ms 721 8m5s 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"."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 Feb 19 12 8 6s328ms 791ms 13 21 13s656ms 650ms 14 45 30s637ms 680ms 15 102 1m12s 715ms 16 101 1m7s 666ms 17 159 1m45s 660ms 18 80 54s613ms 682ms 19 73 49s810ms 682ms 20 31 21s499ms 693ms 21 31 19s620ms 632ms 22 70 44s418ms 634ms -
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 ('%%4309124%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4309124%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%4309124%'))) 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"."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: 2024-02-19 19:19:14 Duration: 1s617ms
-
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 ('%%lf14%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%lf14%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%lf14%'))) 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"."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: 2024-02-19 18:17:25 Duration: 1s151ms
-
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 ('%%820b7532%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%820.b7532%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%820.b7532%'))) 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"."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: 2024-02-19 15:24:34 Duration: 1s66ms
11 127ms 18s289ms 542ms 794 7m10s update "stock_move" set "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Feb 19 01 20 28s302ms 1s415ms 02 16 29s508ms 1s844ms 12 41 16s898ms 412ms 13 81 39s231ms 484ms 14 95 46s369ms 488ms 15 93 38s843ms 417ms 16 104 50s813ms 488ms 17 44 19s913ms 452ms 18 84 33s962ms 404ms 19 62 42s386ms 683ms 20 66 46s704ms 707ms 21 52 22s957ms 441ms 22 30 12s905ms 430ms 23 6 2s163ms 360ms -
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (820140, 820143, 820144, 820145, 820146, 820147, 820148, 820149, 820150, 820151, 820152, 820154, 820155, 820156, 820157, 820158, 820159, 820160, 820161, 820162, 820163, 820167, 820169, 820171, 820172, 820173, 820175, 820176, 820178, 820181, 820182, 820183, 820185, 820188, 820189, 820192, 820198, 820201, 820204, 820208, 820211, 820212, 820216, 820217, 820218, 820220, 820222);
Date: 2024-02-19 20:01:29 Duration: 18s289ms
-
UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (820105, 820106, 820107, 820108, 820109, 820110, 820111, 820112, 820113, 820114, 820115, 820116, 820117, 820118, 820119, 820120, 820121, 820122, 820123);
Date: 2024-02-19 19:38:22 Duration: 9s932ms
-
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (818498, 818500, 818502, 818504, 818506, 818508, 818509, 818511, 818513, 818515, 818517, 818519, 818521, 818523);
Date: 2024-02-19 02:21:54 Duration: 7s36ms
12 129ms 7s373ms 513ms 776 6m38s 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 Feb 19 09 4 2s136ms 534ms 12 17 8s758ms 515ms 13 77 35s170ms 456ms 14 184 1m40s 544ms 15 135 1m4s 476ms 16 78 32s917ms 422ms 17 53 30s542ms 576ms 18 70 36s298ms 518ms 19 62 36s28ms 581ms 20 50 28s41ms 560ms 21 18 9s438ms 524ms 23 28 14s641ms 522ms -
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (436969, 436970, 436971, 436972, 436973, 436974, 436975, 436976, 436977, 436978);
Date: 2024-02-19 14:43:40 Duration: 7s373ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1267, "write_date" = (now() at time zone 'UTC') WHERE id IN (437126, 437127, 437128, 437129, 437130, 437131, 437132, 437133, 437134, 437135, 437136, 437137, 437138, 437139, 437140, 437141, 437142);
Date: 2024-02-19 17:01:01 Duration: 6s534ms
-
UPDATE "stock_quant" SET "quantity" = 2.0, "reserved_quantity" = 0.0, "write_uid" = 1038, "write_date" = (now() at time zone 'UTC') WHERE id IN (356544, 370308, 370310, 50825, 50987, 261964, 337069, 50766, 238607, 50834, 238582, 417879, 245019, 50941);
Date: 2024-02-19 20:48:12 Duration: 5s411ms
13 120ms 6s453ms 467ms 737 5m44s 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 Feb 19 09 2 511ms 255ms 12 3 645ms 215ms 13 50 22s831ms 456ms 14 81 27s829ms 343ms 15 67 28s837ms 430ms 16 71 33s335ms 469ms 17 32 16s632ms 519ms 18 118 1m3s 538ms 19 124 1m1s 499ms 20 125 59s885ms 479ms 21 60 27s497ms 458ms 23 4 749ms 187ms -
UPDATE "stock_quant" SET "quantity" = 2.0, "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (406112, 50914, 397667, 406114, 337061, 50874, 50765, 198990, 50833, 50994, 50898, 50805, 50807, 50840, 412153, 412154, 412159);
Date: 2024-02-19 18:53:48 Duration: 6s453ms
-
UPDATE "stock_quant" SET "quantity" = 2.0, "write_uid" = 965, "write_date" = (now() at time zone 'UTC') WHERE id IN (143170, 348772, 143048, 143019, 143053, 417998, 143023, 143247, 348783, 348786, 343220, 429111, 237595, 429116, 143037, 411742);
Date: 2024-02-19 20:28:41 Duration: 6s220ms
-
UPDATE "stock_quant" SET "quantity" = 3.0, "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (370308, 370310, 50825, 50987, 261964, 337069, 50766, 238607, 50834, 238582, 417879, 370297, 245019, 50941);
Date: 2024-02-19 18:53:54 Duration: 5s680ms
14 120ms 2s375ms 454ms 10,524 1h19m45s 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 #14
Day Hour Count Duration Avg duration Feb 19 00 118 49s58ms 415ms 01 154 1m6s 432ms 02 155 1m2s 405ms 03 33 12s316ms 373ms 04 34 13s160ms 387ms 05 44 19s797ms 449ms 06 100 37s306ms 373ms 07 83 32s768ms 394ms 08 146 1m3s 433ms 09 165 1m10s 424ms 10 45 18s756ms 416ms 11 45 18s793ms 417ms 12 337 1m49s 324ms 13 930 6m48s 439ms 14 1,234 9m27s 459ms 15 1,336 8m59s 403ms 16 785 5m56s 454ms 17 976 8m16s 508ms 18 1,010 6m57s 413ms 19 939 9m31s 608ms 20 931 8m 515ms 21 602 4m10s 415ms 22 214 1m23s 388ms 23 108 40s178ms 372ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-02-19 19:10:01') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1254"', '["pointspring_master","calendar.alarm",51895]', '["pointspring_master","mail.channel",533]', '["pointspring_master","mail.channel",534]', '["pointspring_master","res.partner",51895]', '["pointspring_master","ir.needaction",51895]'))) ORDER BY "bus_bus"."id";
Date: 2024-02-19 19:10:53 Duration: 2s375ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-02-19 19:10:01') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19529]', '["pointspring_master","mail.channel",157]', '["pointspring_master","mail.channel",158]', '["pointspring_master","mail.channel",159]', '["pointspring_master","mail.channel",160]', '["pointspring_master","mail.channel",485]', '["pointspring_master","mail.channel",553]', '["pointspring_master","res.partner",19529]', '["pointspring_master","ir.needaction",19529]'))) ORDER BY "bus_bus"."id";
Date: 2024-02-19 19:10:53 Duration: 2s365ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-02-19 19:10:01') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_972"', '["pointspring_master","calendar.alarm",19510]', '["pointspring_master","mail.channel",84]', '["pointspring_master","mail.channel",85]', '["pointspring_master","mail.channel",86]', '["pointspring_master","mail.channel",87]', '["pointspring_master","mail.channel",531]', '["pointspring_master","res.partner",19510]', '["pointspring_master","ir.needaction",19510]'))) ORDER BY "bus_bus"."id";
Date: 2024-02-19 19:10:53 Duration: 2s299ms
15 336ms 1s424ms 363ms 3,286 19m53s 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 #15
Day Hour Count Duration Avg duration Feb 19 00 3 1s47ms 349ms 01 3 1s14ms 338ms 06 1 336ms 336ms 08 3 1s14ms 338ms 09 7 2s361ms 337ms 10 5 1s721ms 344ms 11 24 8s165ms 340ms 12 247 1m27s 355ms 13 490 2m56s 360ms 14 550 3m25s 373ms 15 394 2m26s 371ms 16 393 2m22s 361ms 17 255 1m30s 356ms 18 265 1m36s 364ms 19 210 1m17s 368ms 20 248 1m28s 357ms 21 126 44s323ms 351ms 22 29 9s830ms 338ms 23 33 11s333ms 343ms -
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_backend.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-472a842/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-02-19 14:04:04 Duration: 1s424ms
-
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.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-a54df00/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-02-19 15:29:47 Duration: 992ms
-
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_backend.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-bba3a16/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-02-19 19:19:14 Duration: 959ms
16 120ms 758ms 342ms 4,095 23m22s select "forecasted_data".id from "forecasted_data" where ("forecasted_data"."item_supply_plan_id" in (...)) order by "forecasted_data"."id";Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Feb 19 01 59 13s822ms 234ms 02 42 10s155ms 241ms 12 3 395ms 131ms 13 87 19s609ms 225ms 14 48 9s890ms 206ms 15 1,489 8m6s 326ms 16 484 3m4s 381ms 17 579 3m37s 376ms 18 762 4m57s 390ms 19 311 1m50s 353ms 20 95 19s700ms 207ms 21 104 25s389ms 244ms 22 18 3s448ms 191ms 23 14 3s72ms 219ms -
SELECT "forecasted_data".id FROM "forecasted_data" WHERE ("forecasted_data"."item_supply_plan_id" in (35595)) ORDER BY "forecasted_data"."id";
Date: 2024-02-19 15:45:30 Duration: 758ms
-
SELECT "forecasted_data".id FROM "forecasted_data" WHERE ("forecasted_data"."item_supply_plan_id" in (35792, 35071)) ORDER BY "forecasted_data"."id";
Date: 2024-02-19 15:06:15 Duration: 744ms
-
SELECT "forecasted_data".id FROM "forecasted_data" WHERE ("forecasted_data"."item_supply_plan_id" in (35800)) ORDER BY "forecasted_data"."id";
Date: 2024-02-19 16:26:20 Duration: 728ms
17 214ms 1s788ms 256ms 806 3m26s 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 Feb 19 09 5 1s280ms 256ms 12 26 6s901ms 265ms 13 73 18s145ms 248ms 14 222 55s527ms 250ms 15 133 35s801ms 269ms 16 37 9s133ms 246ms 17 54 13s57ms 241ms 18 94 27s176ms 289ms 19 40 10s89ms 252ms 20 52 12s823ms 246ms 21 29 7s21ms 242ms 23 41 9s503ms 231ms -
UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 0.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (331552, 331170, 331554, 331182, 331543, 331544, 331549, 331550);
Date: 2024-02-19 15:15:30 Duration: 1s788ms
-
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" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (336900, 336904, 336844, 336908, 336891, 336892, 336894);
Date: 2024-02-19 18:12:37 Duration: 1s595ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'to invoice', "open_qty_fil" = 0.0, "qty_delivered" = '1.00', "qty_to_invoice" = '1.00', "untaxed_amount_to_invoice" = '23.40', "write_uid" = 1022, "write_date" = (now() at time zone 'UTC') WHERE id IN (342451);
Date: 2024-02-19 18:17:25 Duration: 1s17ms
18 120ms 653ms 253ms 2,914 12m19s select "product_warehouse_inventory".id from "product_warehouse_inventory" where ("product_warehouse_inventory"."product_id" in (...)) order by "product_warehouse_inventory"."warehouse_name";Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Feb 19 00 2 260ms 130ms 01 72 10s749ms 149ms 02 35 5s374ms 153ms 12 1 237ms 237ms 13 89 14s762ms 165ms 14 49 7s788ms 158ms 15 1,132 4m27s 236ms 16 301 1m20s 268ms 17 392 1m54s 291ms 18 525 2m43s 312ms 19 212 58s407ms 275ms 20 29 4s205ms 145ms 21 44 7s165ms 162ms 22 23 3s293ms 143ms 23 8 1s155ms 144ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (180516, 180501, 180313, 180312, 180311, 180236, 180227, 179866, 179818, 179416, 179343, 179225, 178967, 178935, 178711, 178710, 178699, 178694, 178630, 178479, 180381, 179622, 179686, 178683)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-02-19 18:16:35 Duration: 653ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (181845, 182155, 182165, 182171, 182965, 182713)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-02-19 15:06:15 Duration: 614ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (220110, 219747, 219614, 218570, 216887, 216793, 216001, 215959, 215519, 215194, 215083, 215023, 214966, 214532, 214496, 214385, 214035, 213571, 213559, 213440, 213428, 213427, 213410, 213712, 213713, 219897, 213814, 243762, 216281, 216280, 216172, 215703, 215636, 215534, 214759, 214030, 213426, 215786, 213911, 214174, 216391)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-02-19 15:06:13 Duration: 602ms
19 219ms 666ms 248ms 727 3m 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 #19
Day Hour Count Duration Avg duration Feb 19 09 5 1s236ms 247ms 12 24 5s721ms 238ms 13 70 18s571ms 265ms 14 190 46s868ms 246ms 15 89 22s335ms 250ms 16 33 7s772ms 235ms 17 86 21s653ms 251ms 18 83 21s423ms 258ms 19 39 9s382ms 240ms 20 46 10s980ms 238ms 21 24 5s868ms 244ms 23 38 8s812ms 231ms -
UPDATE "sale_order_line" SET "invoice_status" = 'no', "qty_invoiced" = '57.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '6530.49', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1035, "write_date" = (now() at time zone 'UTC') WHERE id IN (320635);
Date: 2024-02-19 18:17:00 Duration: 666ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '1.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '86.70', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (342116);
Date: 2024-02-19 14:52:30 Duration: 581ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '2.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '88.44', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 965, "write_date" = (now() at time zone 'UTC') WHERE id IN (342325, 342326);
Date: 2024-02-19 17:03:41 Duration: 544ms
20 205ms 676ms 227ms 1,292 4m53s 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 #20
Day Hour Count Duration Avg duration Feb 19 12 408 1m31s 224ms 13 120 27s360ms 228ms 14 121 27s364ms 226ms 15 422 1m37s 230ms 16 29 6s667ms 229ms 17 47 10s223ms 217ms 18 56 13s224ms 236ms 19 39 8s643ms 221ms 20 34 7s564ms 222ms 21 14 3s116ms 222ms 22 2 419ms 209ms -
SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (320635)) ORDER BY "sale_line_report"."id";
Date: 2024-02-19 18:15:30 Duration: 676ms
-
SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (320635)) ORDER BY "sale_line_report"."id";
Date: 2024-02-19 18:15:30 Duration: 483ms
-
SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (342124)) ORDER BY "sale_line_report"."id";
Date: 2024-02-19 15:28:02 Duration: 470ms
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
- 71,103 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 1374 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 733 Max number of times the same event was reported
- 1,374 Total events found
Rank Times reported Error 1 733 ERROR: could not obtain lock on row in relation "..."
Times Reported Most Frequent Error / Event #1
Day Hour Count Feb 19 00 18 01 19 02 20 03 35 04 20 05 33 06 27 07 85 08 77 09 27 10 19 11 23 12 26 13 19 14 21 15 26 16 24 17 25 18 24 19 19 20 22 21 22 22 20 23 82 - 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=89 FOR UPDATE NOWAIT
Date: 2024-02-19 09:50:04
Statement: SELECT * FROM website_visitor where id = 5837 FOR NO KEY UPDATE NOWAIT
Date: 2024-02-19 18:28:06
Statement: SELECT 1 FROM stock_quant WHERE id = 147772 FOR UPDATE NOWAIT
Date: 2024-02-19 15:18:19
2 611 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #2
Day Hour Count Feb 19 00 1 01 2 03 1 06 1 08 1 09 10 11 2 12 120 13 63 14 99 15 104 16 47 17 29 18 40 19 40 20 35 21 11 22 3 23 2 - ERROR: could not serialize access due to concurrent update
Statement: UPDATE "bus_presence" SET "last_poll"='2024-02-19 09:53:52' WHERE id IN (154)
Date: 2024-02-19 09:53:52
3 20 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #3
Day Hour Count Feb 19 08 1 12 2 13 1 14 4 15 2 17 1 18 2 19 5 20 2 - ERROR: process 1002420 still waiting for ShareLock on transaction 240975718 after 1000.051 ms
- ERROR: process 1298796 still waiting for ShareLock on transaction 241040103 after 1000.048 ms
- ERROR: process 1597792 still waiting for ShareLock on transaction 241048744 after 1000.046 ms
Detail: Process holding the lock: 804529. Wait queue: 1002420.
Context: while updating tuple (4516,27) in relation "account_move"
Statement: UPDATE "account_move" SET "message_main_attachment_id"=5081124,"write_uid"=1041,"write_date"=(now() at time zone 'UTC') WHERE id IN (1213392)Date: 2024-02-19 13:23:27
Detail: Process holding the lock: 1317432. Wait queue: 1298796.
Context: while updating tuple (1323,31) in relation "account_payment"
Statement: update account_payment set write_uid='1213' where id='53279'Date: 2024-02-19 18:07:13
Detail: Process holding the lock: 1616908. Wait queue: 1597792.
Context: while updating tuple (4863,25) in relation "account_move"
Statement: UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1215170 AND sequence_prefix = (SELECT sequence_prefix FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1215170 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1 ) RETURNING name;Date: 2024-02-19 18:39:02
4 3 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Feb 19 13 3 - ERROR: syntax error at or near "Roll" at character 105
Statement: select max(id) from sale_history_line where (product_name is not null and product_name ilike '3/8"X250' Roll Air Brake Hose (ft)' and inventory_short_vendor_name ='Gates') or (product_id=179076) group by product_name
Date: 2024-02-19 13:37:38
5 3 ERROR: duplicate key value violates unique constraint "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Feb 19 14 1 16 1 20 1 - ERROR: duplicate key value violates unique constraint "fleet_vehicle_vin_sn_unique"
- ERROR: duplicate key value violates unique constraint "ir_property_unique_index"
- ERROR: duplicate key value violates unique constraint "fleet_vehicle_vehicle_unit_no_driver_id_unique"
Detail: Key (vin_sn)=(NB683223) 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'), '2024-02-19', true, 117, 0.0, 0.0, NULL, 1, NULL, 5, 36923, '2024-02-19', NULL, NULL, 0, 0.0, NULL, NULL, 2, 195, 29, NULL, '53', 0.0, NULL, 'miles', 0, 0.0, 0, 3, NULL, '53', 'NB683223') RETURNING idDate: 2024-02-19 14:27:51
Detail: Key (fields_id, COALESCE(company_id, 0), COALESCE(res_id, ''::character varying))=(6024, 1, res.partner,45014) already exists.
Statement: INSERT INTO "ir_property" ("id", "create_uid", "create_date", "write_uid", "write_date", "company_id", "fields_id", "name", "res_id", "type", "value_datetime") VALUES (nextval('ir_property_id_seq'), 981, (now() at time zone 'UTC'), 981, (now() at time zone 'UTC'), 1, 6024, 'payment_next_action_date', 'res.partner,45014', 'date', '2024-03-05') RETURNING idDate: 2024-02-19 20:30:03
Detail: Key (vehicle_unit_no, driver_id)=(2, 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'), '2024-02-19', true, 117, 0.0, 0.0, NULL, 1, NULL, 5, 34094, '2024-02-19', NULL, NULL, 0, 0.0, NULL, NULL, 952, 281, 28, NULL, 'C', 0.0, NULL, 'miles', 0, 0.0, 0, 3, NULL, '2', '6H324776') RETURNING idDate: 2024-02-19 16:14:45
6 1 ERROR: deadlock detected
Times Reported Most Frequent Error / Event #6
Day Hour Count Feb 19 20 1 - ERROR: deadlock detected
Detail: Process 1579516 waits for ShareLock on transaction 241079324; blocked by process 1325197. Process 1325197 waits for ShareLock on transaction 241079323; blocked by process 1579516. Process 1579516: UPDATE "sale_order_line" SET "currency_id"=2,"cus_part_route"=NULL,"cus_user_id"=1270,"margin"='7.00',"margin_percent"=0.42892156862745096,"order_partner_id"=39666,"purchase_price"='2.33',"salesman_id"=1270,"write_uid"=1263,"write_date"=(now() at time zone 'UTC') WHERE id IN (339943) Process 1325197: UPDATE "sale_order" SET "partner_id"=39666,"partner_invoice_id"=39666,"partner_shipping_id"=39666,"write_uid"=1263,"write_date"=(now() at time zone 'UTC') WHERE id IN (116935)
Context: while updating tuple (15338,12) in relation "sale_order_line"
Hint: See server log for query details.
Statement: UPDATE "sale_order_line" SET "currency_id"=2,"cus_part_route"=NULL,"cus_user_id"=1270,"margin"='7.00',"margin_percent"=0.42892156862745096,"order_partner_id"=39666,"purchase_price"='2.33',"salesman_id"=1270,"write_uid"=1263,"write_date"=(now() at time zone 'UTC') WHERE id IN (339943)Date: 2024-02-19 20:57:02
7 1 ERROR: could not serialize access due to concurrent delete
Times Reported Most Frequent Error / Event #7
Day Hour Count Feb 19 08 1 - ERROR: could not serialize access due to concurrent delete
Statement: DELETE FROM ir_attachment WHERE id IN (5080578, 5080577, 5080576, 5080575)
Date: 2024-02-19 08:59:06
8 1 ERROR: current transaction is aborted, commands ignored until end of transaction block
Times Reported Most Frequent Error / Event #8
Day Hour Count Feb 19 20 1 - ERROR: current transaction is aborted, commands ignored until end of transaction block
Statement: SELECT 1 FROM res_groups_users_rel WHERE uid=1181 AND gid IN (SELECT res_id FROM ir_model_data WHERE module='website' AND name='group_website_publisher')
Date: 2024-02-19 20:20:09
9 1 ERROR: null value in column "..." of relation "..." violates not-null constraint
Times Reported Most Frequent Error / Event #9
Day Hour Count Feb 19 16 1 - ERROR: null value in column "categ_id" of relation "product_template" violates not-null constraint
Detail: Failing row contains (263702, null, 3089414094, 1, null, null, null, product, null, 1.00, null, null, t, t, 1, 1, null, t, null, null, null, null, 1016, 2024-02-19 16:43:09.5688, 1016, 2024-02-19 16:43:09.5688, manual, no-message, null, no, delivery, 0, none, null, null, null, receive, no-message, null, null, no, 0, null, null, null, null, null, null, null, null, f, null, 1, 1, null, 459035, never, 0, , 45, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 2024-02-19, null, E, 1, null, null, f, f, no, null, 1, null, null, null, null, null, null, null, null, null, none, null, null, null, f, f, null, null, null, f, rfq, null, null, null, null).
Statement: INSERT INTO "product_template" ("id", "create_uid", "create_date", "write_uid", "write_date", "active", "allow_journal", "available_threshold", "branch_id", "categ_id", "core_qty", "custom_message", "expense_policy", "first_active_date", "global_class_code", "inventory_availability", "invoice_policy", "is_core", "is_direct_order_product", "is_mo_product", "is_published", "is_transmission", "linked_with_existing_core", "list_price", "name", "produce_delay", "purchase_line_warn", "purchase_method", "purchase_ok", "purchase_requisition", "sale_delay", "sale_line_warn", "sale_ok", "sequence", "service_form_type", "service_tracking", "service_type", "standard_carton_quanity", "tracking", "type", "uom_id", "uom_po_id", "website_sequence", "website_size_x", "website_size_y") VALUES (nextval('product_template_id_seq'), 1016, (now() at time zone 'UTC'), 1016, (now() at time zone 'UTC'), true, false, 0.0, 45, NULL, 1, '', 'no', '2024-02-19', 'E', 'never', 'delivery', false, false, false, false, false, 'no', '1.00', '3089414094', 0.0, 'no-message', 'receive', true, 'rfq', 0.0, 'no-message', true, 1, 'none', 'no', 'manual', 1, 'none', 'product', 1, 1, 459035, 1, 1) RETURNING idDate: 2024-02-19 16:43:09