pgBadger-
Global information
- Generated on Sat Apr 29 23:50:21 2023
- Log file: /var/log/postgresql/postgresql-14-main.log
- Parsed 146,099 log entries in 20s
- Log start from 2023-04-28 00:00:03 to 2023-04-28 23:50:53
-
Overview
Global Stats
- 1,189 Number of unique normalized queries
- 52,421 Number of queries
- 8h35m33s Total query duration
- 2023-04-28 00:17:08 First query
- 2023-04-28 23:30:02 Last query
- 28 queries/s at 2023-04-28 21:35:26 Query peak
- 8h35m33s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h35m33s Execute total duration
- 2,669 Number of events
- 9 Number of unique normalized events
- 2,000 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
- 52,421 Average queries per session
- 8h35m33s 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
- 28 queries/s Query Peak
- 2023-04-28 21:35:26 Date
SELECT Traffic
Key values
- 28 queries/s Query Peak
- 2023-04-28 21:35:26 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 10 queries/s Query Peak
- 2023-04-28 14:27:28 Date
Queries duration
Key values
- 8h35m33s 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) Apr 28 00 239 0ms 5s912ms 249ms 8s647ms 21s91ms 21s91ms 01 132 0ms 272ms 149ms 3s760ms 7s382ms 7s382ms 02 256 0ms 705ms 166ms 8s874ms 11s882ms 11s882ms 03 240 0ms 689ms 161ms 7s252ms 8s803ms 8s803ms 04 117 0ms 527ms 163ms 6s900ms 6s900ms 6s900ms 05 214 0ms 364ms 153ms 14s737ms 14s737ms 14s737ms 06 200 0ms 282ms 152ms 6s439ms 6s769ms 6s769ms 07 367 0ms 3s341ms 212ms 8s81ms 10s662ms 10s913ms 08 293 0ms 1s833ms 254ms 5s988ms 11s47ms 12s6ms 09 366 0ms 52s745ms 798ms 51s411ms 54s968ms 1m20s 10 281 0ms 13s198ms 680ms 6s90ms 22s650ms 38s944ms 11 2,022 121ms 3s884ms 412ms 33s421ms 37s231ms 59s22ms 12 5,571 120ms 1m38s 457ms 1m12s 1m51s 2m15s 13 5,478 120ms 13s914ms 451ms 1m 1m2s 1m17s 14 4,952 120ms 16s295ms 469ms 1m8s 1m26s 1m59s 15 5,070 120ms 2m 974ms 4m 6m7s 6m9s 16 3,030 120ms 19s733ms 415ms 44s91ms 48s519ms 1m1s 17 3,702 120ms 1m2s 696ms 1m59s 2m37s 3m5s 18 4,937 120ms 26s674ms 513ms 1m28s 1m43s 2m23s 19 9,970 120ms 12s872ms 710ms 2m51s 3m7s 3m17s 20 4,282 120ms 4s173ms 757ms 1m21s 1m24s 1m42s 21 681 0ms 6s184ms 338ms 15s238ms 19s200ms 37s742ms 22 18 0ms 392ms 163ms 2s938ms 2s938ms 2s938ms 23 3 0ms 389ms 229ms 389ms 389ms 389ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Apr 28 00 228 0 156ms 6s480ms 8s237ms 8s647ms 01 132 0 149ms 3s168ms 3s760ms 7s382ms 02 256 0 166ms 6s509ms 8s874ms 11s882ms 03 240 0 161ms 5s803ms 7s252ms 8s803ms 04 117 0 163ms 3s554ms 6s900ms 6s900ms 05 214 0 153ms 4s804ms 14s737ms 14s737ms 06 200 0 152ms 6s81ms 6s439ms 6s769ms 07 365 0 211ms 5s163ms 8s81ms 10s662ms 08 284 0 247ms 5s441ms 5s988ms 12s6ms 09 299 65 802ms 7s672ms 51s411ms 1m20s 10 244 0 493ms 3s658ms 4s425ms 22s650ms 11 1,342 0 427ms 17s571ms 23s539ms 33s843ms 12 2,964 0 395ms 27s731ms 34s138ms 44s151ms 13 3,171 0 443ms 33s11ms 37s945ms 45s67ms 14 2,692 0 469ms 34s935ms 39s484ms 48s945ms 15 3,032 0 440ms 33s370ms 37s882ms 50s438ms 16 1,882 0 417ms 19s685ms 27s251ms 37s842ms 17 2,226 0 455ms 22s10ms 32s772ms 36s673ms 18 3,375 0 565ms 1m8s 1m12s 1m37s 19 8,775 0 741ms 2m19s 2m39s 3m6s 20 3,642 0 821ms 1m6s 1m10s 1m20s 21 593 0 323ms 9s182ms 13s22ms 37s531ms 22 18 0 163ms 0ms 2s938ms 2s938ms 23 3 0 229ms 298ms 389ms 389ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Apr 28 00 0 0 11 0 2s177ms 0ms 490ms 21s91ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 2 0 0 335ms 0ms 0ms 0ms 08 0 7 2 0 481ms 0ms 0ms 1s77ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 10 26 0 1s963ms 0ms 0ms 29s919ms 11 13 601 11 0 398ms 3s876ms 7s95ms 13s349ms 12 117 2,281 27 0 553ms 18s546ms 32s337ms 1m12s 13 92 1,974 47 0 489ms 15s240ms 24s732ms 43s244ms 14 84 1,964 16 0 496ms 14s616ms 24s153ms 57s865ms 15 54 1,723 36 0 1s921ms 14s813ms 2m7s 4m58s 16 38 953 33 0 442ms 5s763ms 9s929ms 29s297ms 17 11 1,239 23 0 1s156ms 9s518ms 26s649ms 2m19s 18 88 1,297 27 0 425ms 7s172ms 14s795ms 30s12ms 19 33 1,052 14 0 507ms 6s118ms 12s992ms 37s648ms 20 47 558 2 0 404ms 3s338ms 7s150ms 15s945ms 21 6 73 4 0 378ms 287ms 2s102ms 3s246ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Apr 28 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 Apr 28 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 Apr 28 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 Apr 28 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 Apr 28 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) Apr 28 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 Apr 28 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 Apr 28 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 Apr 28 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
- 147 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 79 46m6s 2s59ms 1m45s 35s15ms update "stock_picking" set "scheduled_date" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);-
UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);
Date: 2023-04-28 15:14:12
-
UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);
Date: 2023-04-28 15:06:41
-
UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);
Date: 2023-04-28 15:10:11
2 39 3m3s 1s58ms 1m14s 4s692ms 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 = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 596934 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 != 596934 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;
Date: 2023-04-28 10:18:47
3 1 1m38s 1m38s 1m38s 1m38s insert into "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "bom_line_id", "branch_id", "byproduct_id", "company_id", "consume_unbuild_id", "core_qty", "created_production_id", "date", "date_deadline", "description_picking", "dest_warehouse_id", "group_id", "inventory_id", "location_dest_id", "location_id", "move_options", "mrp_core_move", "mrp_finish_core_move", "name", "next_serial", "next_serial_count", "note", "operation_id", "orderpoint_id", "origin", "origin_returned_move_id", "partner_id", "picking_id", "picking_type_id", "price_unit", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "production_id", "propagate_cancel", "purchase_line_id", "raw_material_production_id", "related_bom_line_id", "repair_id", "repair_line_id", "restrict_partner_id", "rule_id", "sale_line_id", "sequence", "src_warehouse_id", "state", "to_refund", "unbuild_id", "warehouse_id", "workorder_id") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), false, null, null, ?, null, ?, null, ?.?, null, ?, null, null, null, ?, null, ?, ?, ?, false, false, ?, null, ?, null, null, null, ?, null, null, ?, ?, ?.?, ?, ?, ?, ?, ?, null, true, null, null, null, null, null, null, null, null, ?, null, ?, false, null, ?, null) returning id;-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "bom_line_id", "branch_id", "byproduct_id", "company_id", "consume_unbuild_id", "core_qty", "created_production_id", "date", "date_deadline", "description_picking", "dest_warehouse_id", "group_id", "inventory_id", "location_dest_id", "location_id", "move_options", "mrp_core_move", "mrp_finish_core_move", "name", "next_serial", "next_serial_count", "note", "operation_id", "orderpoint_id", "origin", "origin_returned_move_id", "partner_id", "picking_id", "picking_type_id", "price_unit", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "production_id", "propagate_cancel", "purchase_line_id", "raw_material_production_id", "related_bom_line_id", "repair_id", "repair_line_id", "restrict_partner_id", "rule_id", "sale_line_id", "sequence", "src_warehouse_id", "state", "to_refund", "unbuild_id", "warehouse_id", "workorder_id") VALUES (nextval('stock_move_id_seq'), 989, (now() at time zone 'UTC'), 989, (now() at time zone 'UTC'), false, NULL, NULL, 50, NULL, 1, NULL, 0.0, NULL, '2023-01-24 02:46:07.066209', NULL, NULL, NULL, 41884, NULL, 453, 468, 'new_product', false, false, '12-S/INT/01006', NULL, 0, NULL, NULL, NULL, '12-S/INT/01006', NULL, NULL, 57263, 349, 0.0, '0', 'make_to_stock', 178688, 1, '2.00', NULL, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, 'draft', false, NULL, 44, NULL) RETURNING id;
Date: 2023-04-28 11:43:01
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "bom_line_id", "branch_id", "byproduct_id", "company_id", "consume_unbuild_id", "core_qty", "created_production_id", "date", "date_deadline", "description_picking", "dest_warehouse_id", "group_id", "inventory_id", "location_dest_id", "location_id", "move_options", "mrp_core_move", "mrp_finish_core_move", "name", "next_serial", "next_serial_count", "note", "operation_id", "orderpoint_id", "origin", "origin_returned_move_id", "partner_id", "picking_id", "picking_type_id", "price_unit", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "production_id", "propagate_cancel", "purchase_line_id", "raw_material_production_id", "related_bom_line_id", "repair_id", "repair_line_id", "restrict_partner_id", "rule_id", "sale_line_id", "sequence", "src_warehouse_id", "state", "to_refund", "unbuild_id", "warehouse_id", "workorder_id") VALUES (nextval('stock_move_id_seq'), 989, (now() at time zone 'UTC'), 989, (now() at time zone 'UTC'), false, NULL, NULL, 37, NULL, 1, NULL, 0.0, NULL, '2022-11-14 20:24:24.744526', NULL, NULL, NULL, 11454, NULL, 381, 468, 'new_product', false, false, '02-G/INT/00516', NULL, 0, NULL, NULL, NULL, 'Warehouse Inventory Transfer to Greensburg', NULL, NULL, 13648, 277, 0.0, '0', 'make_to_stock', 203231, 1, '1.00', NULL, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, 'draft', false, NULL, 35, NULL) RETURNING id;
Date: 2023-04-28 12:27:32
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "bom_line_id", "branch_id", "byproduct_id", "company_id", "consume_unbuild_id", "core_qty", "created_production_id", "date", "date_deadline", "description_picking", "dest_warehouse_id", "group_id", "inventory_id", "location_dest_id", "location_id", "move_options", "mrp_core_move", "mrp_finish_core_move", "name", "next_serial", "next_serial_count", "note", "operation_id", "orderpoint_id", "origin", "origin_returned_move_id", "partner_id", "picking_id", "picking_type_id", "price_unit", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "production_id", "propagate_cancel", "purchase_line_id", "raw_material_production_id", "related_bom_line_id", "repair_id", "repair_line_id", "restrict_partner_id", "rule_id", "sale_line_id", "sequence", "src_warehouse_id", "state", "to_refund", "unbuild_id", "warehouse_id", "workorder_id") VALUES (nextval('stock_move_id_seq'), 1228, (now() at time zone 'UTC'), 1228, (now() at time zone 'UTC'), false, NULL, NULL, 46, NULL, 1, NULL, 0.0, NULL, '2023-02-01 19:33:54.795881', NULL, NULL, NULL, 46832, NULL, 468, 445, 'new_product', false, false, '11-N/INT/03761', NULL, 0, NULL, NULL, NULL, '11-N/INT/03761', NULL, NULL, 114641, 341, 0.0, '0', 'make_to_stock', 181430, 1, '1.00', NULL, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, 'draft', false, NULL, 43, NULL) RETURNING id;
Date: 2023-04-28 14:19:43
4 17 44s48ms 1s11ms 5s802ms 2s591ms 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" = 2450244, "write_uid" = 965, "write_date" = (now() at time zone 'UTC') WHERE id IN (599523);
Date: 2023-04-28 12:35:50
5 1 19s725ms 19s725ms 19s725ms 19s725ms 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 (...);-
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '2.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '58.72', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 971, "write_date" = (now() at time zone 'UTC') WHERE id IN (136699);
Date: 2023-04-28 17:23:47
-
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '1.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '104.99', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 965, "write_date" = (now() at time zone 'UTC') WHERE id IN (142408, 142409, 142407);
Date: 2023-04-28 16:20:05
-
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '-1.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '-6.02', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1023, "write_date" = (now() at time zone 'UTC') WHERE id IN (142413, 142414);
Date: 2023-04-28 15:47:15
6 4 12s947ms 1s281ms 4s135ms 3s236ms 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 sequence_prefix = ( select sequence_prefix from account_move where journal_id = ? and name != ? and sequence_prefix !~ ? and move_type not in (...) 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 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') ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;
Date: 2023-04-28 12:40:14
7 1 12s126ms 12s126ms 12s126ms 12s126ms 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 (...);-
UPDATE "sale_order_line" SET "invoice_status" = 'to invoice', "open_qty_fil" = 0.0, "qty_delivered" = '2.00', "qty_to_invoice" = '2.00', "untaxed_amount_to_invoice" = '58.72', "write_uid" = 971, "write_date" = (now() at time zone 'UTC') WHERE id IN (136699);
Date: 2023-04-28 17:23:16
-
UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 1.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1237, "write_date" = (now() at time zone 'UTC') WHERE id IN (117552, 117556, 132604, 117175);
Date: 2023-04-28 19:05:05
-
UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 4.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1018, "write_date" = (now() at time zone 'UTC') WHERE id IN (134601, 136266, 136212, 133941);
Date: 2023-04-28 13:23:33
8 2 7s191ms 1s822ms 5s369ms 3s595ms update "account_move" set "access_token" = ?, "is_move_sent" = true, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);-
UPDATE "account_move" SET "access_token" = 'b096cef9-75bc-41a2-b4a5-7826873958fb', "is_move_sent" = true, "write_uid" = 971, "write_date" = (now() at time zone 'UTC') WHERE id IN (599081);
Date: 2023-04-28 11:42:24
9 1 3s693ms 3s693ms 3s693ms 3s693ms insert into "sale_order" ("id", "create_uid", "create_date", "write_uid", "write_date", "analytic_account_id", "branch_id", "campaign_id", "carrier_id", "cart_recovery_email_sent", "client_order_ref", "commitment_date", "company_id", "date_order", "delivery", "exception_sale", "expense_choice", "fiscal_position_id", "incoterm", "is_cash_sale_order", "is_core_sale", "is_order_unlock", "is_self_used", "marked_as_lost", "medium_id", "name", "note", "opportunity_id", "order_type", "origin", "override_return_rule", "partner_id", "partner_invoice_id", "partner_shipping_id", "payment_term_id", "payment_term_need_password", "picking_policy", "pricelist_id", "project_id", "recompute_delivery_price", "require_payment", "require_signature", "sale_action", "sale_order_template_id", "sale_part_id", "sale_product_qty", "show_update_pricelist", "signed_by", "signed_on", "source_id", "special_instructions", "state", "team_id", "user_id", "validity_date", "warehouse_id") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), null, ?, null, ?, false, null, null, ?, ?, null, false, null, null, null, true, false, false, false, false, null, ?, ?, null, ?, null, false, ?, ?, ?, ?, false, ?, ?, null, false, false, false, ?, null, ?, ?.?, false, null, null, null, null, ?, ?, ?, ?, ?) returning id;-
INSERT INTO "sale_order" ("id", "create_uid", "create_date", "write_uid", "write_date", "analytic_account_id", "branch_id", "campaign_id", "carrier_id", "cart_recovery_email_sent", "client_order_ref", "commitment_date", "company_id", "date_order", "delivery", "exception_sale", "expense_choice", "fiscal_position_id", "incoterm", "is_cash_sale_order", "is_core_sale", "is_order_unlock", "is_self_used", "marked_as_lost", "medium_id", "name", "note", "opportunity_id", "order_type", "origin", "override_return_rule", "partner_id", "partner_invoice_id", "partner_shipping_id", "payment_term_id", "payment_term_need_password", "picking_policy", "pricelist_id", "project_id", "recompute_delivery_price", "require_payment", "require_signature", "sale_action", "sale_order_template_id", "sale_part_id", "sale_product_qty", "show_update_pricelist", "signed_by", "signed_on", "source_id", "special_instructions", "state", "team_id", "user_id", "validity_date", "warehouse_id") VALUES (nextval('sale_order_id_seq'), 994, (now() at time zone 'UTC'), 994, (now() at time zone 'UTC'), NULL, 45, NULL, 78, false, NULL, NULL, 1, '2023-04-28 17:27:15', NULL, false, NULL, NULL, NULL, true, false, false, false, false, NULL, 'I-07158', '', NULL, 'sale', NULL, false, 34093, 34093, 34093, 112, false, 'direct', 35, NULL, false, false, false, 1, NULL, 214706, 2.0, false, NULL, NULL, NULL, NULL, 'draft', 1, 994, '2023-10-25', 42) RETURNING id;
Date: 2023-04-28 17:27:42
10 1 3s144ms 3s144ms 3s144ms 3s144ms update "product_product" set "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);-
UPDATE "product_product" SET "write_uid" = 1237, "write_date" = (now() at time zone 'UTC') WHERE id IN (219784, 220174, 220178, 218901, 220183, 214040, 219680, 218161, 213429, 215733, 216761, 217017, 220219, 218683, 214461, 219850, 219736, 213599, 219750, 214379, 219122);
Date: 2023-04-28 17:27:08
11 1 1s863ms 1s863ms 1s863ms 1s863ms update "stock_move" set "date" = ?, "is_done" = true, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);-
UPDATE "stock_move" SET "date" = '2023-04-28 15:34:05', "is_done" = true, "state" = 'done', "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (391912, 391913, 391915, 391916, 391917, 391918, 391919, 391920, 391921, 391922, 391923);
Date: 2023-04-28 15:34:32
-
UPDATE "stock_move" SET "date" = '2023-04-28 12:09:25', "is_done" = true, "state" = 'done', "write_uid" = 1010, "write_date" = (now() at time zone 'UTC') WHERE id IN (391088, 391089, 391090, 391091, 391120, 391121, 391122, 391123, 391124, 391099, 391100, 391101);
Date: 2023-04-28 12:09:39
-
UPDATE "stock_move" SET "date" = '2023-04-28 14:29:41', "is_done" = true, "state" = 'done', "write_uid" = 1000, "write_date" = (now() at time zone 'UTC') WHERE id IN (391712, 391715, 391716, 391717, 391719, 391709, 391711);
Date: 2023-04-28 14:29:46
Queries that waited the most
Rank Wait time Query 1 1m45s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:14:52 ]
2 1m41s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:14:12 ]
3 1m38s INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "bom_line_id", "branch_id", "byproduct_id", "company_id", "consume_unbuild_id", "core_qty", "created_production_id", "date", "date_deadline", "description_picking", "dest_warehouse_id", "group_id", "inventory_id", "location_dest_id", "location_id", "move_options", "mrp_core_move", "mrp_finish_core_move", "name", "next_serial", "next_serial_count", "note", "operation_id", "orderpoint_id", "origin", "origin_returned_move_id", "partner_id", "picking_id", "picking_type_id", "price_unit", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "production_id", "propagate_cancel", "purchase_line_id", "raw_material_production_id", "related_bom_line_id", "repair_id", "repair_line_id", "restrict_partner_id", "rule_id", "sale_line_id", "sequence", "src_warehouse_id", "state", "to_refund", "unbuild_id", "warehouse_id", "workorder_id") VALUES (nextval('stock_move_id_seq'), 989, (now() at time zone 'UTC'), 989, (now() at time zone 'UTC'), false, NULL, NULL, 37, NULL, 1, NULL, 0.0, NULL, '2022-11-14 20:24:24.744526', NULL, NULL, NULL, 11454, NULL, 381, 468, 'new_product', false, false, '02-G/INT/00516', NULL, 0, NULL, NULL, NULL, 'Warehouse Inventory Transfer to Greensburg', NULL, NULL, 13648, 277, 0.0, '0', 'make_to_stock', 203231, 1, '1.00', NULL, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, 'draft', false, NULL, 35, NULL) RETURNING id;[ Date: 2023-04-28 12:31:42 ]
4 1m24s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:13:36 ]
5 1m20s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:10:27 ]
6 1m14s 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 != 596934 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 != 596934 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2023-04-28 10:18:47 ]
7 1m14s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:10:11 ]
8 1m7s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:09:35 ]
9 1m6s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:14:52 ]
10 1m6s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:13:00 ]
11 1m5s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:06:01 ]
12 1m4s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:09:00 ]
13 1m3s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:10:43 ]
14 48s135ms UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:08:23 ]
15 47s885ms UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:11:34 ]
16 47s404ms UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:12:07 ]
17 42s758ms UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:11:51 ]
18 40s230ms UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:06:41 ]
19 39s842ms UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:14:52 ]
20 39s709ms UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:12:24 ]
-
Queries
Queries by type
Key values
- 36,294 Total read queries
- 16,127 Total write queries
Queries by database
Key values
- unknown Main database
- 52,421 Requests
- 8h35m33s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 52,421 Requests
User Request type Count Duration unknown Total 52,421 8h35m33s copy to 65 4m1s cte 1,466 6m50s delete 279 6m33s insert 583 3m2s select 36,294 5h28m6s update 13,734 2h46m58s Duration by user
Key values
- 8h35m33s (unknown) Main time consuming user
User Request type Count Duration unknown Total 52,421 8h35m33s copy to 65 4m1s cte 1,466 6m50s delete 279 6m33s insert 583 3m2s select 36,294 5h28m6s update 13,734 2h46m58s Queries by host
Key values
- unknown Main host
- 52,421 Requests
- 8h35m33s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 52,421 Requests
- 8h35m33s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2023-04-28 20:02:23 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 27,161 100-500ms duration
Slowest individual queries
Rank Duration Query 1 2m UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:14:12 ]
2 1m45s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:06:41 ]
3 1m42s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:10:11 ]
4 1m42s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:13:36 ]
5 1m39s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:09:35 ]
6 1m38s UPDATE "stock_move" SET "date" = '2023-04-28 12:27:38', "state" = 'done', "write_uid" = 989, "write_date" = (now() at time zone 'UTC') WHERE id IN (149000, 319341, 319342, 301091, 324643, 220725, 123450, 319037, 238656, 265307, 187496, 127094, 279160, 251000, 232059, 127624, 297609, 127626, 254605, 254607, 309906, 324247, 324248, 297628, 297630, 297631, 138916, 190633, 321194, 335017, 321196, 321198, 321199, 145584, 246963, 288949, 208584, 205002, 205003, 205004, 334032, 316122, 316123, 316124, 316128, 316129, 316130, 316131, 316132, 316134, 316137, 316139, 316141, 230640, 230641, 304368, 304369, 316144, 323313, 301312, 135429, 260870, 311572, 306454, 306967, 295708, 295709, 295710, 309027, 309028, 309029, 309031, 330555, 333627, 301379, 244042, 313175, 250203, 290151, 247660, 247661, 247662, 286575, 247663, 247664, 247665, 247666, 307572, 307573, 313199, 307575, 307576, 313201, 313203, 313205, 313207, 313208, 313209, 313210, 132518, 132519, 337832, 139701, 333242, 338363, 308672, 332738, 316867, 171972, 171973, 316868, 158663, 330182, 330183, 332740, 293323, 332744, 189390, 189391, 263119, 326099, 326100, 304090, 304091, 304092, 125917, 125918, 304093, 304095, 139758, 306675, 154613, 139766);[ Date: 2023-04-28 12:29:22 ]
7 1m36s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:10:43 ]
8 1m30s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:10:27 ]
9 1m24s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:09:00 ]
10 1m20s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:11:00 ]
11 1m15s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:13:00 ]
12 1m8s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:06:01 ]
13 1m7s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:05:23 ]
14 1m7s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:04:12 ]
15 1m4s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:08:23 ]
16 1m4s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:11:51 ]
17 1m4s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:12:24 ]
18 1m2s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-27 16:00:00', "write_uid" = 1019, "write_date" = (now() at time zone 'UTC') WHERE id IN (130381);[ Date: 2023-04-28 17:21:49 ]
19 1m1s UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:04:48 ]
20 59s292ms UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);[ Date: 2023-04-28 15:12:07 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h34m31s 6,274 884ms 1s126ms 903ms select "sale_history_line".id from "sale_history_line" where (((("sale_history_line"."contact_reference" = ?) and ("sale_history_line"."inventory_short_vendor_name" = ?)) and ("sale_history_line"."product_name" = ?)) and (((("sale_history_line"."selling_branch" in (...)) and (("sale_history_line"."invoice_date" >= ?) and ("sale_history_line"."invoice_date" <= ?))) 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 (?)) and (("res_users"."share" is null or "res_users"."share" = false) or exists ( select ? 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 (...))) 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 (...))) or "res_users__partner_id"."company_id" is null) and (((("res_users__partner_id"."type" != ?) or "res_users__partner_id"."type" is null) or "res_users__partner_id"."type" is null) or ("res_users__partner_id"."type" = ?))))))) order by "sale_history_line"."invoice_date" desc;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Apr 28 19 3,200 48m24s 907ms 20 3,074 46m6s 899ms -
SELECT "sale_history_line".id FROM "sale_history_line" WHERE (((("sale_history_line"."contact_reference" = '11309') AND ("sale_history_line"."inventory_short_vendor_name" = 'Labor-Suspension')) AND ("sale_history_line"."product_name" = 'LAB2')) AND (((("sale_history_line"."selling_branch" in (46)) AND (("sale_history_line"."invoice_date" >= '2022-01-01') AND ("sale_history_line"."invoice_date" <= '2022-12-31'))) 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 ('%schaef%')) 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'))))))) ORDER BY "sale_history_line"."invoice_date" DESC;
Date: 2023-04-28 19:35:19 Duration: 1s126ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE (((("sale_history_line"."contact_reference" = '15909') AND ("sale_history_line"."inventory_short_vendor_name" = 'Misc Stock')) AND ("sale_history_line"."product_name" = '55111025AB')) AND (((("sale_history_line"."selling_branch" in (46)) AND (("sale_history_line"."invoice_date" >= '2022-01-01') AND ("sale_history_line"."invoice_date" <= '2022-12-31'))) 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 ('%schaef%')) 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'))))))) ORDER BY "sale_history_line"."invoice_date" DESC;
Date: 2023-04-28 19:42:10 Duration: 1s96ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE (((("sale_history_line"."contact_reference" = '15909') AND ("sale_history_line"."inventory_short_vendor_name" = 'Misc Stock')) AND ("sale_history_line"."product_name" = '68505585AA')) AND (((("sale_history_line"."selling_branch" in (46)) AND (("sale_history_line"."invoice_date" >= '2022-01-01') AND ("sale_history_line"."invoice_date" <= '2022-12-31'))) 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 ('%schaef%')) 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'))))))) ORDER BY "sale_history_line"."invoice_date" DESC;
Date: 2023-04-28 19:42:16 Duration: 1s73ms
2 1h3m34s 5,200 706ms 1s344ms 733ms select "sale_history_line".id from "sale_history_line" where ((("sale_history_line"."contact_reference" = ?) and ("sale_history_line"."product_name" = ?)) and (((("sale_history_line"."selling_branch" in (...)) and "sale_history_line"."company_id" is not null) 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 (?)) and (("res_users"."share" is null or "res_users"."share" = false) or exists ( select ? 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 (...))) 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 (...))) or "res_users__partner_id"."company_id" is null) and (((("res_users__partner_id"."type" != ?) or "res_users__partner_id"."type" is null) or "res_users__partner_id"."type" is null) or ("res_users__partner_id"."type" = ?)))))) and (("sale_history_line"."invoice_date" >= ?) and ("sale_history_line"."invoice_date" <= ?)))) order by "sale_history_line"."invoice_date" desc;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Apr 28 18 1,463 17m47s 729ms 19 3,737 45m47s 735ms -
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ((("sale_history_line"."contact_reference" = '66891') AND ("sale_history_line"."product_name" = '40720')) AND (((("sale_history_line"."selling_branch" in (46)) AND "sale_history_line"."company_id" IS NOT NULL) 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 ('%schaef%')) 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" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')))) ORDER BY "sale_history_line"."invoice_date" DESC;
Date: 2023-04-28 19:10:28 Duration: 1s344ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ((("sale_history_line"."contact_reference" = '17769') AND ("sale_history_line"."product_name" = 'SHIPPING')) AND (((("sale_history_line"."selling_branch" in (46)) AND "sale_history_line"."company_id" IS NOT NULL) 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 ('%schaef%')) 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" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')))) ORDER BY "sale_history_line"."invoice_date" DESC;
Date: 2023-04-28 19:10:27 Duration: 1s222ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ((("sale_history_line"."contact_reference" = '101425') AND ("sale_history_line"."product_name" = '05089')) AND (((("sale_history_line"."selling_branch" in (46)) AND "sale_history_line"."company_id" IS NOT NULL) 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 ('%schaef%')) 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" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')))) ORDER BY "sale_history_line"."invoice_date" DESC;
Date: 2023-04-28 19:00:48 Duration: 1s153ms
3 39m43s 47 2s59ms 2m 50s711ms update "stock_picking" set "scheduled_date" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Apr 28 14 3 20s267ms 6s755ms 15 31 32m48s 1m3s 17 13 6m34s 30s360ms -
UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);
Date: 2023-04-28 15:14:12 Duration: 2m
-
UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);
Date: 2023-04-28 15:06:41 Duration: 1m45s
-
UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);
Date: 2023-04-28 15:10:11 Duration: 1m42s
4 37m49s 3,889 539ms 1s187ms 583ms 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 #4
Day Hour Count Duration Avg duration Apr 28 10 13 7s361ms 566ms 11 141 1m20s 568ms 12 665 6m30s 586ms 13 471 4m37s 589ms 14 418 4m4s 584ms 15 528 5m10s 587ms 16 355 3m24s 576ms 17 262 2m31s 579ms 18 468 4m30s 578ms 19 452 4m26s 589ms 20 55 31s209ms 567ms 21 61 34s243ms 561ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%5014144x%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%5014144x%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%5014144x%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 12:31:45 Duration: 1s187ms
-
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 ('%%3230%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%3230%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%3230%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 15:06:03 Duration: 1s119ms
-
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 ('%%7539%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%7-539%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%7-539%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 18:09:04 Duration: 1s101ms
5 24m48s 189 305ms 1m38s 7s875ms update "stock_move" set "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 Apr 28 11 5 9s91ms 1s818ms 12 16 2m23s 8s965ms 13 29 1m51s 3s851ms 14 26 2m44s 6s308ms 15 51 8m55s 10s499ms 16 9 30s800ms 3s422ms 17 33 6m14s 11s338ms 18 10 1m12s 7s295ms 19 7 40s688ms 5s812ms 20 3 6s156ms 2s52ms -
UPDATE "stock_move" SET "date" = '2023-04-28 12:27:38', "state" = 'done', "write_uid" = 989, "write_date" = (now() at time zone 'UTC') WHERE id IN (149000, 319341, 319342, 301091, 324643, 220725, 123450, 319037, 238656, 265307, 187496, 127094, 279160, 251000, 232059, 127624, 297609, 127626, 254605, 254607, 309906, 324247, 324248, 297628, 297630, 297631, 138916, 190633, 321194, 335017, 321196, 321198, 321199, 145584, 246963, 288949, 208584, 205002, 205003, 205004, 334032, 316122, 316123, 316124, 316128, 316129, 316130, 316131, 316132, 316134, 316137, 316139, 316141, 230640, 230641, 304368, 304369, 316144, 323313, 301312, 135429, 260870, 311572, 306454, 306967, 295708, 295709, 295710, 309027, 309028, 309029, 309031, 330555, 333627, 301379, 244042, 313175, 250203, 290151, 247660, 247661, 247662, 286575, 247663, 247664, 247665, 247666, 307572, 307573, 313199, 307575, 307576, 313201, 313203, 313205, 313207, 313208, 313209, 313210, 132518, 132519, 337832, 139701, 333242, 338363, 308672, 332738, 316867, 171972, 171973, 316868, 158663, 330182, 330183, 332740, 293323, 332744, 189390, 189391, 263119, 326099, 326100, 304090, 304091, 304092, 125917, 125918, 304093, 304095, 139758, 306675, 154613, 139766);
Date: 2023-04-28 12:29:22 Duration: 1m38s
-
UPDATE "stock_move" SET "date" = '2023-04-28 18:33:56', "state" = 'done', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (385792, 385793, 385794, 385795, 385796, 385797, 385798, 385799, 385800, 385801, 385802, 385804, 385805, 385806, 385807, 385808, 385809, 385810, 385811, 385812, 385813, 385815, 385816, 385817, 385818, 385819, 385820, 385821, 385822, 385823, 385824, 385825, 385826, 385828, 385829, 385830, 385831, 385832, 385833, 385835, 385836, 385837, 385838, 385839, 385840, 385841, 385843, 385791);
Date: 2023-04-28 18:34:24 Duration: 26s674ms
-
UPDATE "stock_move" SET "date" = '2023-04-28 12:49:09', "state" = 'done', "write_uid" = 989, "write_date" = (now() at time zone 'UTC') WHERE id IN (203396, 243853, 237841, 251414, 251415, 228518, 237612, 339757, 343212, 281778, 251187, 238004, 270387, 334258, 340148, 321080, 233018, 332603, 238654, 304704, 267080, 287816, 322639, 340177, 216788, 315864, 238045, 248162, 230755, 238055, 253549, 309101, 312439);
Date: 2023-04-28 12:49:38 Duration: 23s878ms
6 11m7s 1,137 544ms 1s24ms 586ms 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 #6
Day Hour Count Duration Avg duration Apr 28 10 6 3s489ms 581ms 11 108 1m1s 569ms 12 157 1m31s 581ms 13 277 2m42s 587ms 14 67 40s414ms 603ms 15 109 1m7s 618ms 16 71 41s275ms 581ms 17 82 47s987ms 585ms 18 77 44s757ms 581ms 19 124 1m12s 586ms 20 59 33s856ms 573ms -
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 ('%%qpl%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%qpl-%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%qpl-%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 15:06:17 Duration: 1s24ms
-
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 ('%%qpl%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%qpl%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%qpl%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 15:06:17 Duration: 1s19ms
-
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 ('%%qplaex%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%qpl-a-ex%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%qpl-a-ex%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 15:06:18 Duration: 1s13ms
7 11m4s 376 142ms 16s651ms 1s766ms update "stock_quant" set "company_id" = ?, "inventory_vendor_id" = ?, "warehouse_id" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Apr 28 11 8 5s711ms 713ms 12 86 1m17s 905ms 13 67 1m1s 922ms 14 34 45s79ms 1s325ms 15 48 4m4s 5s83ms 16 13 18s646ms 1s434ms 17 52 2m31s 2s916ms 18 29 25s229ms 869ms 19 32 30s545ms 954ms 20 7 3s678ms 525ms -
UPDATE "stock_quant" SET "company_id" = 1, "inventory_vendor_id" = 3094, "warehouse_id" = 35, "write_uid" = 989, "write_date" = (now() at time zone 'UTC') WHERE id IN (284448, 284451, 284420, 284421, 284454, 284423, 284457, 284427, 284428, 284429, 284430, 284431, 284438, 284439, 284440, 284441, 284442, 284445, 284446, 284447);
Date: 2023-04-28 12:31:11 Duration: 16s651ms
-
UPDATE "stock_quant" SET "company_id" = 1, "inventory_vendor_id" = 3089, "warehouse_id" = 36, "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (285456, 285458, 285460, 285462, 285464, 285466, 285468, 285470, 285472, 285474, 285476, 285478, 285480, 285482, 285484, 285486, 285488, 285490, 285492, 285494, 285496, 285498, 285500, 285502, 285504, 285506, 285508, 285510);
Date: 2023-04-28 15:05:57 Duration: 12s975ms
-
UPDATE "stock_quant" SET "company_id" = 1, "inventory_vendor_id" = 3089, "warehouse_id" = 36, "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (285824, 285826, 285828, 285830, 285832, 285834, 285836, 285838, 285784, 285786, 285788, 285790, 285792, 285794, 285796, 285798, 285800, 285802, 285804, 285806, 285808, 285810, 285812, 285814, 285816, 285818, 285820, 285822);
Date: 2023-04-28 15:08:56 Duration: 12s653ms
8 10m28s 1,070 137ms 6s13ms 587ms update "stock_quant" set "quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Apr 28 11 60 40s300ms 671ms 12 156 1m46s 681ms 13 151 1m35s 633ms 14 94 52s945ms 563ms 15 140 1m13s 522ms 16 26 13s434ms 516ms 17 291 2m34s 530ms 18 63 44s569ms 707ms 19 70 42s369ms 605ms 20 19 5s796ms 305ms -
UPDATE "stock_quant" SET "quantity" = 0.0, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (59291, 167846, 167849, 167851, 167855, 167859, 167864, 167865, 167867);
Date: 2023-04-28 12:18:10 Duration: 6s13ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (189761, 276546, 276548, 1156, 276550, 275530, 222455, 275546, 275547);
Date: 2023-04-28 13:58:04 Duration: 3s849ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "write_uid" = 989, "write_date" = (now() at time zone 'UTC') WHERE id IN (173125, 246153, 197747, 254810, 232795, 244636);
Date: 2023-04-28 12:30:09 Duration: 3s183ms
9 9m46s 798 684ms 1s82ms 734ms 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 #9
Day Hour Count Duration Avg duration Apr 28 10 1 712ms 712ms 11 35 25s212ms 720ms 12 101 1m15s 743ms 13 131 1m36s 736ms 14 127 1m33s 736ms 15 96 1m11s 747ms 16 54 39s164ms 725ms 17 83 1m 724ms 18 59 43s51ms 729ms 19 85 1m2s 733ms 20 18 12s910ms 717ms 21 8 5s738ms 717ms -
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 ('%37-160%')) 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 ('%37-160%'))) 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 ('%37-160%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%37-160%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-04-28 15:06:19 Duration: 1s82ms
-
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 ('%3230951%')) 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 ('%3230951%'))) 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 ('%3230951%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%3230951%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-04-28 15:04:50 Duration: 1s6ms
-
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 ('%p315a189unab1056%')) 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 ('%p315a189unab1056%'))) 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 ('%p315a189unab1056%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%p315a189unab1056%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-04-28 18:14:03 Duration: 982ms
10 9m8s 673 367ms 2s801ms 815ms 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 #10
Day Hour Count Duration Avg duration Apr 28 11 44 34s408ms 782ms 12 154 2m7s 827ms 13 129 1m40s 780ms 14 84 1m12s 865ms 15 61 49s576ms 812ms 16 23 18s413ms 800ms 17 37 27s967ms 755ms 18 32 26s547ms 829ms 19 87 1m13s 848ms 20 21 16s298ms 776ms 21 1 695ms 695ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 4.0, "date" = '2023-04-28 19:52:36', "is_done" = true, "state" = 'done', "write_uid" = 1237, "write_date" = (now() at time zone 'UTC') WHERE id IN (337016, 337025, 337024);
Date: 2023-04-28 19:52:43 Duration: 2s801ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 4.0, "date" = '2023-04-28 13:28:46', "is_done" = true, "state" = 'done', "write_uid" = 1043, "write_date" = (now() at time zone 'UTC') WHERE id IN (389889, 391321);
Date: 2023-04-28 13:28:51 Duration: 2s363ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 4.0, "date" = '2023-04-28 19:21:39', "is_done" = true, "state" = 'done', "write_uid" = 994, "write_date" = (now() at time zone 'UTC') WHERE id IN (392512, 392510);
Date: 2023-04-28 19:21:42 Duration: 2s149ms
11 6m36s 673 547ms 891ms 589ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 28 07 25 14s100ms 564ms 10 12 6s770ms 564ms 11 9 5s181ms 575ms 12 59 34s595ms 586ms 13 41 23s892ms 582ms 14 120 1m10s 585ms 15 213 2m7s 597ms 16 48 28s426ms 592ms 17 94 56s207ms 597ms 18 22 12s700ms 577ms 19 10 5s715ms 571ms 20 20 11s269ms 563ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%EX4702KU%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%EX4702K-U%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%EX4702K-U%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 17:23:38 Duration: 891ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%EX4702KU%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%EX4702K-U%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%EX4702K-U%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 17:23:37 Duration: 868ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%L6048F%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%L6048F%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%L6048F%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 15:21:10 Duration: 841ms
12 6m31s 704 141ms 6s614ms 555ms 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 Apr 28 11 8 3s969ms 496ms 12 111 1m6s 598ms 13 122 1m5s 537ms 14 149 1m21s 549ms 15 70 43s332ms 619ms 16 47 27s933ms 594ms 17 34 17s827ms 524ms 18 39 22s252ms 570ms 19 96 47s754ms 497ms 20 27 13s737ms 508ms 21 1 404ms 404ms -
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (279169, 279171, 279173, 279174, 279176, 279177, 279181, 279183, 278521);
Date: 2023-04-28 15:34:20 Duration: 6s614ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1010, "write_date" = (now() at time zone 'UTC') WHERE id IN (156930, 89437, 284381, 87280, 284379, 91036, 91037);
Date: 2023-04-28 12:10:00 Duration: 3s545ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 979, "write_date" = (now() at time zone 'UTC') WHERE id IN (145719, 214319);
Date: 2023-04-28 15:06:05 Duration: 2s651ms
13 5m25s 2,149 120ms 414ms 151ms select count(distinct (so.id)) as total_orders from sale_order as so left join sale_order_line as sol on sol.order_id = so.id left join product_warehouse_inventory as pwi on pwi.product_id = sol.product_id left join stock_warehouse as sw on sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= ?::timestamp and so.date_order <= ?::timestamp and sol.product_id = ? and so.state in (...) and so.warehouse_id = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Apr 28 00 224 34s907ms 155ms 01 131 19s429ms 148ms 02 249 38s989ms 156ms 03 236 36s417ms 154ms 04 115 18s318ms 159ms 05 213 32s614ms 153ms 06 198 30s17ms 151ms 07 296 43s538ms 147ms 08 229 33s442ms 146ms 09 241 35s629ms 147ms 22 17 2s545ms 149ms -
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-10-28T04:30:01.755178'::timestamp and so.date_order <= '2023-04-28T04:30:01.755178'::timestamp and sol.product_id = 187489 and so.state in ('done', 'sale') and so.warehouse_id = 44;
Date: 2023-04-28 04:31:43 Duration: 414ms
-
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-10-28T00:30:12.671740'::timestamp and so.date_order <= '2023-04-28T00:30:12.671740'::timestamp and sol.product_id = 237158 and so.state in ('done', 'sale') and so.warehouse_id = 43;
Date: 2023-04-28 00:32:33 Duration: 371ms
-
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-10-28T05:30:01.304231'::timestamp and so.date_order <= '2023-04-28T05:30:01.304231'::timestamp and sol.product_id = 219375 and so.state in ('done', 'sale') and so.warehouse_id = 35;
Date: 2023-04-28 05:34:39 Duration: 364ms
14 5m23s 1,864 160ms 328ms 173ms select res_partner.id from "res_partner" where ("res_partner"."active" = true) and (((("res_partner"."partner_share" is null or "res_partner"."partner_share" = false) or ("res_partner"."company_id" in (...))) 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 #14
Day Hour Count Duration Avg duration Apr 28 10 35 5s914ms 168ms 11 150 25s182ms 167ms 12 258 45s335ms 175ms 13 212 36s991ms 174ms 14 200 35s271ms 176ms 15 216 39s148ms 181ms 16 314 53s506ms 170ms 17 166 28s244ms 170ms 18 124 21s625ms 174ms 19 126 21s900ms 173ms 20 63 10s574ms 167ms -
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 ('%00103%') OR unaccent (res_partner.display_name) ilike unaccent ('%00103%') OR unaccent (res_partner.ref) ilike unaccent ('%00103%') OR unaccent (res_partner.vat) ilike unaccent ('00103')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%00103%') desc, unaccent (res_partner.display_name);
Date: 2023-04-28 15:08:32 Duration: 328ms
-
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 ('%chaMPION%') OR unaccent (res_partner.display_name) ilike unaccent ('%chaMPION%') OR unaccent (res_partner.ref) ilike unaccent ('%chaMPION%') OR unaccent (res_partner.vat) ilike unaccent ('chaMPION')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%chaMPION%') desc, unaccent (res_partner.display_name);
Date: 2023-04-28 15:07:24 Duration: 312ms
-
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 ('%44951%') OR unaccent (res_partner.display_name) ilike unaccent ('%44951%') OR unaccent (res_partner.ref) ilike unaccent ('%44951%') OR unaccent (res_partner.vat) ilike unaccent ('44951')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%44951%') desc, unaccent (res_partner.display_name);
Date: 2023-04-28 15:04:44 Duration: 308ms
15 4m53s 1,866 146ms 426ms 157ms 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 Apr 28 00 3 482ms 160ms 06 1 148ms 148ms 07 4 592ms 148ms 08 4 639ms 159ms 09 10 1s500ms 150ms 10 8 1s236ms 154ms 11 88 13s275ms 150ms 12 317 49s590ms 156ms 13 310 49s234ms 158ms 14 263 41s669ms 158ms 15 230 38s104ms 165ms 16 103 15s783ms 153ms 17 151 23s20ms 152ms 18 183 28s430ms 155ms 19 134 21s252ms 158ms 20 51 7s847ms 153ms 21 4 594ms 148ms 23 2 298ms 149ms -
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/%-03af1d2/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-04-28 15:06:03 Duration: 426ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.report_assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-210dda0/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-04-28 15:06:05 Duration: 321ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.report_assets_common.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-c93381c/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-04-28 14:26:24 Duration: 315ms
16 4m26s 452 540ms 1s108ms 590ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where (((("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and ("product_product__product_tmpl_id"."purchase_ok" is not null and "product_product__product_tmpl_id"."purchase_ok" != false)) and (("product_product__product_tmpl_id"."type" != ?) or "product_product__product_tmpl_id"."type" is null)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Apr 28 11 16 9s241ms 577ms 12 41 24s636ms 600ms 13 3 1s809ms 603ms 14 51 29s644ms 581ms 15 82 52s365ms 638ms 16 48 27s472ms 572ms 17 107 1m1s 573ms 18 89 51s785ms 581ms 19 2 1s126ms 563ms 20 10 5s678ms 567ms 21 3 1s670ms 556ms -
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 ('%%be22%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%be22%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%be22%'))) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 15:14:16 Duration: 1s108ms
-
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 ('%%be2232%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%be2232%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%be2232%'))) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 15:14:17 Duration: 1s75ms
-
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 ('%%be223%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%be223%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%be223%'))) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 15:14:16 Duration: 1s51ms
17 4m17s 273 139ms 5s475ms 944ms update "stock_move" set "branch_id" = ?, "picking_id" = ?, "related_core_purchase_line_id" = ?, "related_core_repair_line_id" = ?, "related_core_sale_line_id" = ?, "scrapped" = false, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Apr 28 10 1 891ms 891ms 11 16 18s193ms 1s137ms 12 33 37s410ms 1s133ms 13 38 32s192ms 847ms 14 33 35s560ms 1s77ms 15 35 30s988ms 885ms 16 29 30s502ms 1s51ms 17 18 10s546ms 585ms 18 28 27s942ms 997ms 19 26 23s89ms 888ms 20 10 6s664ms 666ms 21 6 3s959ms 659ms -
UPDATE "stock_move" SET "branch_id" = 45, "picking_id" = 131426, "related_core_purchase_line_id" = NULL, "related_core_repair_line_id" = NULL, "related_core_sale_line_id" = NULL, "scrapped" = false, "state" = 'confirmed', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (391872, 391873, 391874, 391875, 391876, 391877, 391878, 391879, 391880, 391881, 391868, 391869, 391870, 391871);
Date: 2023-04-28 15:21:22 Duration: 5s475ms
-
UPDATE "stock_move" SET "branch_id" = 37, "picking_id" = 131720, "related_core_purchase_line_id" = NULL, "related_core_repair_line_id" = NULL, "related_core_sale_line_id" = NULL, "scrapped" = false, "state" = 'confirmed', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (392452, 392453, 392454, 392456, 392457, 392458, 392459, 392460);
Date: 2023-04-28 18:55:30 Duration: 5s246ms
-
UPDATE "stock_move" SET "branch_id" = 46, "picking_id" = 131038, "related_core_purchase_line_id" = NULL, "related_core_repair_line_id" = NULL, "related_core_sale_line_id" = NULL, "scrapped" = false, "state" = 'confirmed', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (391330, 391331, 391332, 391333, 391334, 391335, 391336, 391337, 391338, 391339);
Date: 2023-04-28 13:00:06 Duration: 4s727ms
18 4m9s 751 278ms 522ms 332ms select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Apr 28 11 28 8s187ms 292ms 12 83 28s743ms 346ms 13 439 2m26s 334ms 14 178 56s439ms 317ms 15 23 9s597ms 417ms -
select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;
Date: 2023-04-28 13:09:57 Duration: 522ms
-
select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;
Date: 2023-04-28 13:22:42 Duration: 505ms
-
select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;
Date: 2023-04-28 13:22:42 Duration: 505ms
19 4m3s 232 508ms 10s716ms 1s51ms 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 #19
Day Hour Count Duration Avg duration Apr 28 11 11 9s8ms 818ms 12 33 37s700ms 1s142ms 13 36 33s103ms 919ms 14 60 57s101ms 951ms 15 25 33s697ms 1s347ms 16 20 21s823ms 1s91ms 17 12 17s164ms 1s430ms 18 14 15s602ms 1s114ms 19 13 9s598ms 738ms 20 8 9s188ms 1s148ms -
UPDATE "stock_move" SET "date" = '2023-04-28 15:34:05', "is_done" = true, "state" = 'done', "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (391912, 391913, 391915, 391916, 391917, 391918, 391919, 391920, 391921, 391922, 391923);
Date: 2023-04-28 15:34:32 Duration: 10s716ms
-
UPDATE "stock_move" SET "date" = '2023-04-28 12:09:25', "is_done" = true, "state" = 'done', "write_uid" = 1010, "write_date" = (now() at time zone 'UTC') WHERE id IN (391088, 391089, 391090, 391091, 391120, 391121, 391122, 391123, 391124, 391099, 391100, 391101);
Date: 2023-04-28 12:09:39 Duration: 9s98ms
-
UPDATE "stock_move" SET "date" = '2023-04-28 14:29:41', "is_done" = true, "state" = 'done', "write_uid" = 1000, "write_date" = (now() at time zone 'UTC') WHERE id IN (391712, 391715, 391716, 391717, 391719, 391709, 391711);
Date: 2023-04-28 14:29:46 Duration: 4s719ms
20 4m2s 214 1s48ms 1s556ms 1s133ms select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Apr 28 11 32 35s22ms 1s94ms 13 41 47s547ms 1s159ms 14 59 1m7s 1s152ms 15 15 17s267ms 1s151ms 16 15 16s464ms 1s97ms 17 7 8s40ms 1s148ms 19 24 27s604ms 1s150ms 20 5 5s392ms 1s78ms 21 16 17s290ms 1s80ms -
select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;
Date: 2023-04-28 13:12:13 Duration: 1s556ms
-
select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;
Date: 2023-04-28 13:12:12 Duration: 1s525ms
-
select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;
Date: 2023-04-28 15:31:26 Duration: 1s372ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 6,274 1h34m31s 884ms 1s126ms 903ms select "sale_history_line".id from "sale_history_line" where (((("sale_history_line"."contact_reference" = ?) and ("sale_history_line"."inventory_short_vendor_name" = ?)) and ("sale_history_line"."product_name" = ?)) and (((("sale_history_line"."selling_branch" in (...)) and (("sale_history_line"."invoice_date" >= ?) and ("sale_history_line"."invoice_date" <= ?))) 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 (?)) and (("res_users"."share" is null or "res_users"."share" = false) or exists ( select ? 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 (...))) 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 (...))) or "res_users__partner_id"."company_id" is null) and (((("res_users__partner_id"."type" != ?) or "res_users__partner_id"."type" is null) or "res_users__partner_id"."type" is null) or ("res_users__partner_id"."type" = ?))))))) order by "sale_history_line"."invoice_date" desc;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Apr 28 19 3,200 48m24s 907ms 20 3,074 46m6s 899ms -
SELECT "sale_history_line".id FROM "sale_history_line" WHERE (((("sale_history_line"."contact_reference" = '11309') AND ("sale_history_line"."inventory_short_vendor_name" = 'Labor-Suspension')) AND ("sale_history_line"."product_name" = 'LAB2')) AND (((("sale_history_line"."selling_branch" in (46)) AND (("sale_history_line"."invoice_date" >= '2022-01-01') AND ("sale_history_line"."invoice_date" <= '2022-12-31'))) 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 ('%schaef%')) 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'))))))) ORDER BY "sale_history_line"."invoice_date" DESC;
Date: 2023-04-28 19:35:19 Duration: 1s126ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE (((("sale_history_line"."contact_reference" = '15909') AND ("sale_history_line"."inventory_short_vendor_name" = 'Misc Stock')) AND ("sale_history_line"."product_name" = '55111025AB')) AND (((("sale_history_line"."selling_branch" in (46)) AND (("sale_history_line"."invoice_date" >= '2022-01-01') AND ("sale_history_line"."invoice_date" <= '2022-12-31'))) 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 ('%schaef%')) 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'))))))) ORDER BY "sale_history_line"."invoice_date" DESC;
Date: 2023-04-28 19:42:10 Duration: 1s96ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE (((("sale_history_line"."contact_reference" = '15909') AND ("sale_history_line"."inventory_short_vendor_name" = 'Misc Stock')) AND ("sale_history_line"."product_name" = '68505585AA')) AND (((("sale_history_line"."selling_branch" in (46)) AND (("sale_history_line"."invoice_date" >= '2022-01-01') AND ("sale_history_line"."invoice_date" <= '2022-12-31'))) 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 ('%schaef%')) 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'))))))) ORDER BY "sale_history_line"."invoice_date" DESC;
Date: 2023-04-28 19:42:16 Duration: 1s73ms
2 5,200 1h3m34s 706ms 1s344ms 733ms select "sale_history_line".id from "sale_history_line" where ((("sale_history_line"."contact_reference" = ?) and ("sale_history_line"."product_name" = ?)) and (((("sale_history_line"."selling_branch" in (...)) and "sale_history_line"."company_id" is not null) 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 (?)) and (("res_users"."share" is null or "res_users"."share" = false) or exists ( select ? 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 (...))) 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 (...))) or "res_users__partner_id"."company_id" is null) and (((("res_users__partner_id"."type" != ?) or "res_users__partner_id"."type" is null) or "res_users__partner_id"."type" is null) or ("res_users__partner_id"."type" = ?)))))) and (("sale_history_line"."invoice_date" >= ?) and ("sale_history_line"."invoice_date" <= ?)))) order by "sale_history_line"."invoice_date" desc;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Apr 28 18 1,463 17m47s 729ms 19 3,737 45m47s 735ms -
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ((("sale_history_line"."contact_reference" = '66891') AND ("sale_history_line"."product_name" = '40720')) AND (((("sale_history_line"."selling_branch" in (46)) AND "sale_history_line"."company_id" IS NOT NULL) 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 ('%schaef%')) 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" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')))) ORDER BY "sale_history_line"."invoice_date" DESC;
Date: 2023-04-28 19:10:28 Duration: 1s344ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ((("sale_history_line"."contact_reference" = '17769') AND ("sale_history_line"."product_name" = 'SHIPPING')) AND (((("sale_history_line"."selling_branch" in (46)) AND "sale_history_line"."company_id" IS NOT NULL) 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 ('%schaef%')) 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" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')))) ORDER BY "sale_history_line"."invoice_date" DESC;
Date: 2023-04-28 19:10:27 Duration: 1s222ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ((("sale_history_line"."contact_reference" = '101425') AND ("sale_history_line"."product_name" = '05089')) AND (((("sale_history_line"."selling_branch" in (46)) AND "sale_history_line"."company_id" IS NOT NULL) 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 ('%schaef%')) 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" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')))) ORDER BY "sale_history_line"."invoice_date" DESC;
Date: 2023-04-28 19:00:48 Duration: 1s153ms
3 3,889 37m49s 539ms 1s187ms 583ms 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 Apr 28 10 13 7s361ms 566ms 11 141 1m20s 568ms 12 665 6m30s 586ms 13 471 4m37s 589ms 14 418 4m4s 584ms 15 528 5m10s 587ms 16 355 3m24s 576ms 17 262 2m31s 579ms 18 468 4m30s 578ms 19 452 4m26s 589ms 20 55 31s209ms 567ms 21 61 34s243ms 561ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%5014144x%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%5014144x%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%5014144x%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 12:31:45 Duration: 1s187ms
-
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 ('%%3230%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%3230%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%3230%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 15:06:03 Duration: 1s119ms
-
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 ('%%7539%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%7-539%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%7-539%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 18:09:04 Duration: 1s101ms
4 2,149 5m25s 120ms 414ms 151ms select count(distinct (so.id)) as total_orders from sale_order as so left join sale_order_line as sol on sol.order_id = so.id left join product_warehouse_inventory as pwi on pwi.product_id = sol.product_id left join stock_warehouse as sw on sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= ?::timestamp and so.date_order <= ?::timestamp and sol.product_id = ? and so.state in (...) and so.warehouse_id = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Apr 28 00 224 34s907ms 155ms 01 131 19s429ms 148ms 02 249 38s989ms 156ms 03 236 36s417ms 154ms 04 115 18s318ms 159ms 05 213 32s614ms 153ms 06 198 30s17ms 151ms 07 296 43s538ms 147ms 08 229 33s442ms 146ms 09 241 35s629ms 147ms 22 17 2s545ms 149ms -
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-10-28T04:30:01.755178'::timestamp and so.date_order <= '2023-04-28T04:30:01.755178'::timestamp and sol.product_id = 187489 and so.state in ('done', 'sale') and so.warehouse_id = 44;
Date: 2023-04-28 04:31:43 Duration: 414ms
-
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-10-28T00:30:12.671740'::timestamp and so.date_order <= '2023-04-28T00:30:12.671740'::timestamp and sol.product_id = 237158 and so.state in ('done', 'sale') and so.warehouse_id = 43;
Date: 2023-04-28 00:32:33 Duration: 371ms
-
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-10-28T05:30:01.304231'::timestamp and so.date_order <= '2023-04-28T05:30:01.304231'::timestamp and sol.product_id = 219375 and so.state in ('done', 'sale') and so.warehouse_id = 35;
Date: 2023-04-28 05:34:39 Duration: 364ms
5 1,866 4m53s 146ms 426ms 157ms 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 #5
Day Hour Count Duration Avg duration Apr 28 00 3 482ms 160ms 06 1 148ms 148ms 07 4 592ms 148ms 08 4 639ms 159ms 09 10 1s500ms 150ms 10 8 1s236ms 154ms 11 88 13s275ms 150ms 12 317 49s590ms 156ms 13 310 49s234ms 158ms 14 263 41s669ms 158ms 15 230 38s104ms 165ms 16 103 15s783ms 153ms 17 151 23s20ms 152ms 18 183 28s430ms 155ms 19 134 21s252ms 158ms 20 51 7s847ms 153ms 21 4 594ms 148ms 23 2 298ms 149ms -
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/%-03af1d2/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-04-28 15:06:03 Duration: 426ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.report_assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-210dda0/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-04-28 15:06:05 Duration: 321ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.report_assets_common.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-c93381c/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-04-28 14:26:24 Duration: 315ms
6 1,864 5m23s 160ms 328ms 173ms select res_partner.id from "res_partner" where ("res_partner"."active" = true) and (((("res_partner"."partner_share" is null or "res_partner"."partner_share" = false) or ("res_partner"."company_id" in (...))) 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 Apr 28 10 35 5s914ms 168ms 11 150 25s182ms 167ms 12 258 45s335ms 175ms 13 212 36s991ms 174ms 14 200 35s271ms 176ms 15 216 39s148ms 181ms 16 314 53s506ms 170ms 17 166 28s244ms 170ms 18 124 21s625ms 174ms 19 126 21s900ms 173ms 20 63 10s574ms 167ms -
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 ('%00103%') OR unaccent (res_partner.display_name) ilike unaccent ('%00103%') OR unaccent (res_partner.ref) ilike unaccent ('%00103%') OR unaccent (res_partner.vat) ilike unaccent ('00103')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%00103%') desc, unaccent (res_partner.display_name);
Date: 2023-04-28 15:08:32 Duration: 328ms
-
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 ('%chaMPION%') OR unaccent (res_partner.display_name) ilike unaccent ('%chaMPION%') OR unaccent (res_partner.ref) ilike unaccent ('%chaMPION%') OR unaccent (res_partner.vat) ilike unaccent ('chaMPION')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%chaMPION%') desc, unaccent (res_partner.display_name);
Date: 2023-04-28 15:07:24 Duration: 312ms
-
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 ('%44951%') OR unaccent (res_partner.display_name) ilike unaccent ('%44951%') OR unaccent (res_partner.ref) ilike unaccent ('%44951%') OR unaccent (res_partner.vat) ilike unaccent ('44951')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%44951%') desc, unaccent (res_partner.display_name);
Date: 2023-04-28 15:04:44 Duration: 308ms
7 1,273 3m40s 120ms 424ms 173ms with currency_rate as ( select r.currency_id, coalesce(r.company_id, c.id) as company_id, r.rate, r.name as date_start, ( select name from res_currency_rate r2 where r2.name > r.name and r2.currency_id = r.currency_id and (r2.company_id is null or r2.company_id = c.id) order by r2.name asc limit ?) as date_end from res_currency_rate r join res_company c on (r.company_id is null or r.company_id = c.id)) select l.product_id as product_id, sum(l.price_unit / ( case coalesce(cr.rate, ?) when ? then ?.? else cr.rate end) * l.quantity * ( case when i.move_type in (...) then ? else ? end) * ((? - l.discount) * ?.?)) / nullif (sum(l.quantity * ( case when i.move_type in (...) then ? else ? end)), ?) as avg_unit_price, sum(l.quantity * ( case when i.move_type in (...) then ? else ? end)) as num_qty, sum(abs(l.balance) * ( case when i.move_type in (...) then ? else ? end)) as total, sum(l.quantity * pt.list_price * ( case when i.move_type in (...) then ? else ? end)) as sale_expected from account_move_line l left join account_move i on (l.move_id = i.id) left join product_product product on (product.id = l.product_id) left join product_template pt on (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= coalesce(i.invoice_date, now()) and (cr.date_end is null or cr.date_end > coalesce(i.invoice_date, now()))) where l.product_id in (...) and i.state in (...) and i.payment_state in (...) and i.move_type in (...) and i.invoice_date between ? and ? and i.company_id = ? and l.display_type is null and l.exclude_from_invoice_tab = false group by l.product_id;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Apr 28 09 2 326ms 163ms 11 52 8s732ms 167ms 12 171 29s526ms 172ms 13 183 31s648ms 172ms 14 180 31s94ms 172ms 15 205 36s104ms 176ms 16 114 19s349ms 169ms 17 143 25s161ms 175ms 18 115 19s654ms 170ms 19 76 13s774ms 181ms 20 30 5s168ms 172ms 21 2 329ms 164ms -
WITH currency_rate AS ( SELECT r.currency_id, COALESCE(r.company_id, c.id) as company_id, r.rate, r.name AS date_start, ( SELECT name FROM res_currency_rate r2 WHERE r2.name > r.name AND r2.currency_id = r.currency_id AND (r2.company_id is null or r2.company_id = c.id) ORDER BY r2.name ASC LIMIT 1) AS date_end FROM res_currency_rate r JOIN res_company c ON (r.company_id is null or r.company_id = c.id)) SELECT l.product_id as product_id, SUM(l.price_unit / ( CASE COALESCE(cr.rate, 0) WHEN 0 THEN 1.0 ELSE cr.rate END) * l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END) * ((100 - l.discount) * 0.01)) / NULLIF (SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)), 0) AS avg_unit_price, SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS num_qty, SUM(ABS(l.balance) * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS total, SUM(l.quantity * pt.list_price * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS sale_expected FROM account_move_line l LEFT JOIN account_move i ON (l.move_id = i.id) LEFT JOIN product_product product ON (product.id = l.product_id) LEFT JOIN product_template pt ON (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= COALESCE(i.invoice_date, NOW()) and (cr.date_end IS NULL OR cr.date_end > COALESCE(i.invoice_date, NOW()))) WHERE l.product_id IN (203811) AND i.state IN ('posted') AND i.payment_state IN ('not_paid', 'in_payment', 'paid') AND i.move_type IN ('out_invoice', 'out_refund') AND i.invoice_date BETWEEN '2023-01-01' AND '2023-12-31' AND i.company_id = 1 AND l.display_type IS NULL AND l.exclude_from_invoice_tab = false GROUP BY l.product_id;
Date: 2023-04-28 19:05:46 Duration: 424ms
-
WITH currency_rate AS ( SELECT r.currency_id, COALESCE(r.company_id, c.id) as company_id, r.rate, r.name AS date_start, ( SELECT name FROM res_currency_rate r2 WHERE r2.name > r.name AND r2.currency_id = r.currency_id AND (r2.company_id is null or r2.company_id = c.id) ORDER BY r2.name ASC LIMIT 1) AS date_end FROM res_currency_rate r JOIN res_company c ON (r.company_id is null or r.company_id = c.id)) SELECT l.product_id as product_id, SUM(l.price_unit / ( CASE COALESCE(cr.rate, 0) WHEN 0 THEN 1.0 ELSE cr.rate END) * l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END) * ((100 - l.discount) * 0.01)) / NULLIF (SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)), 0) AS avg_unit_price, SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS num_qty, SUM(ABS(l.balance) * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS total, SUM(l.quantity * pt.list_price * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS sale_expected FROM account_move_line l LEFT JOIN account_move i ON (l.move_id = i.id) LEFT JOIN product_product product ON (product.id = l.product_id) LEFT JOIN product_template pt ON (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= COALESCE(i.invoice_date, NOW()) and (cr.date_end IS NULL OR cr.date_end > COALESCE(i.invoice_date, NOW()))) WHERE l.product_id IN (183353) AND i.state IN ('posted') AND i.payment_state IN ('not_paid', 'in_payment', 'paid') AND i.move_type IN ('out_invoice', 'out_refund') AND i.invoice_date BETWEEN '2023-01-01' AND '2023-12-31' AND i.company_id = 1 AND l.display_type IS NULL AND l.exclude_from_invoice_tab = false GROUP BY l.product_id;
Date: 2023-04-28 15:06:56 Duration: 254ms
-
WITH currency_rate AS ( SELECT r.currency_id, COALESCE(r.company_id, c.id) as company_id, r.rate, r.name AS date_start, ( SELECT name FROM res_currency_rate r2 WHERE r2.name > r.name AND r2.currency_id = r.currency_id AND (r2.company_id is null or r2.company_id = c.id) ORDER BY r2.name ASC LIMIT 1) AS date_end FROM res_currency_rate r JOIN res_company c ON (r.company_id is null or r.company_id = c.id)) SELECT l.product_id as product_id, SUM(l.price_unit / ( CASE COALESCE(cr.rate, 0) WHEN 0 THEN 1.0 ELSE cr.rate END) * l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END) * ((100 - l.discount) * 0.01)) / NULLIF (SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)), 0) AS avg_unit_price, SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS num_qty, SUM(ABS(l.balance) * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS total, SUM(l.quantity * pt.list_price * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS sale_expected FROM account_move_line l LEFT JOIN account_move i ON (l.move_id = i.id) LEFT JOIN product_product product ON (product.id = l.product_id) LEFT JOIN product_template pt ON (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= COALESCE(i.invoice_date, NOW()) and (cr.date_end IS NULL OR cr.date_end > COALESCE(i.invoice_date, NOW()))) WHERE l.product_id IN (248111, 206034) AND i.state IN ('posted') AND i.payment_state IN ('not_paid', 'in_payment', 'paid') AND i.move_type IN ('out_invoice', 'out_refund') AND i.invoice_date BETWEEN '2023-01-01' AND '2023-12-31' AND i.company_id = 1 AND l.display_type IS NULL AND l.exclude_from_invoice_tab = false GROUP BY l.product_id;
Date: 2023-04-28 15:04:43 Duration: 252ms
8 1,184 3m1s 133ms 2s388ms 152ms update "stock_quant" set "reserved_quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Apr 28 11 33 4s610ms 139ms 12 130 21s235ms 163ms 13 146 21s391ms 146ms 14 131 19s468ms 148ms 15 177 26s332ms 148ms 16 86 12s359ms 143ms 17 116 16s896ms 145ms 18 207 29s912ms 144ms 19 98 20s225ms 206ms 20 50 7s183ms 143ms 21 10 1s401ms 140ms -
UPDATE "stock_quant" SET "reserved_quantity" = 0.0, "write_uid" = 1237, "write_date" = (now() at time zone 'UTC') WHERE id IN (138915, 143748, 138885, 143750, 142665, 138922, 143754, 143756, 142669, 142668, 142672, 147569, 147570, 140339, 147572, 147573);
Date: 2023-04-28 12:17:31 Duration: 2s388ms
-
UPDATE "stock_quant" SET "reserved_quantity" = 4.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (255393, 962, 422, 1070, 218449, 916, 918, 214428);
Date: 2023-04-28 19:50:09 Duration: 1s165ms
-
UPDATE "stock_quant" SET "reserved_quantity" = 3.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (320, 1928, 744, 1228, 197583, 756, 764, 253533);
Date: 2023-04-28 19:50:08 Duration: 1s144ms
9 1,137 11m7s 544ms 1s24ms 586ms 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 Apr 28 10 6 3s489ms 581ms 11 108 1m1s 569ms 12 157 1m31s 581ms 13 277 2m42s 587ms 14 67 40s414ms 603ms 15 109 1m7s 618ms 16 71 41s275ms 581ms 17 82 47s987ms 585ms 18 77 44s757ms 581ms 19 124 1m12s 586ms 20 59 33s856ms 573ms -
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 ('%%qpl%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%qpl-%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%qpl-%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 15:06:17 Duration: 1s24ms
-
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 ('%%qpl%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%qpl%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%qpl%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 15:06:17 Duration: 1s19ms
-
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 ('%%qplaex%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%qpl-a-ex%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%qpl-a-ex%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 15:06:18 Duration: 1s13ms
10 1,070 10m28s 137ms 6s13ms 587ms update "stock_quant" set "quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Apr 28 11 60 40s300ms 671ms 12 156 1m46s 681ms 13 151 1m35s 633ms 14 94 52s945ms 563ms 15 140 1m13s 522ms 16 26 13s434ms 516ms 17 291 2m34s 530ms 18 63 44s569ms 707ms 19 70 42s369ms 605ms 20 19 5s796ms 305ms -
UPDATE "stock_quant" SET "quantity" = 0.0, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (59291, 167846, 167849, 167851, 167855, 167859, 167864, 167865, 167867);
Date: 2023-04-28 12:18:10 Duration: 6s13ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (189761, 276546, 276548, 1156, 276550, 275530, 222455, 275546, 275547);
Date: 2023-04-28 13:58:04 Duration: 3s849ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "write_uid" = 989, "write_date" = (now() at time zone 'UTC') WHERE id IN (173125, 246153, 197747, 254810, 232795, 244636);
Date: 2023-04-28 12:30:09 Duration: 3s183ms
11 886 3m22s 201ms 884ms 228ms select "sale_history_line".id from "sale_history_line" where ("sale_history_line"."so_line_id" in (...)) order by "sale_history_line"."id";Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 28 10 3 621ms 207ms 11 51 11s132ms 218ms 12 141 32s293ms 229ms 13 86 19s686ms 228ms 14 121 27s354ms 226ms 15 105 25s898ms 246ms 16 115 25s561ms 222ms 17 39 8s734ms 223ms 18 99 21s598ms 218ms 19 84 20s537ms 244ms 20 29 6s400ms 220ms 21 13 2s816ms 216ms -
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (142775)) ORDER BY "sale_history_line"."id";
Date: 2023-04-28 19:40:35 Duration: 884ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (141995)) ORDER BY "sale_history_line"."id";
Date: 2023-04-28 12:31:43 Duration: 368ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (142350)) ORDER BY "sale_history_line"."id";
Date: 2023-04-28 15:05:37 Duration: 362ms
12 833 2m58s 193ms 998ms 214ms update "sale_order_line" set "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Apr 28 10 3 623ms 207ms 11 92 19s989ms 217ms 12 129 28s316ms 219ms 13 85 18s131ms 213ms 14 103 21s955ms 213ms 15 96 20s835ms 217ms 16 93 19s413ms 208ms 17 42 8s868ms 211ms 18 79 16s541ms 209ms 19 70 15s253ms 217ms 20 31 6s691ms 215ms 21 10 2s68ms 206ms -
UPDATE "sale_order_line" SET "write_uid" = 1140, "write_date" = (now() at time zone 'UTC') WHERE id IN (141893, 141900, 141901, 141902, 141903, 141904);
Date: 2023-04-28 11:51:00 Duration: 998ms
-
UPDATE "sale_order_line" SET "write_uid" = 1150, "write_date" = (now() at time zone 'UTC') WHERE id IN (141984, 142010, 141988);
Date: 2023-04-28 12:31:58 Duration: 604ms
-
UPDATE "sale_order_line" SET "write_uid" = 1153, "write_date" = (now() at time zone 'UTC') WHERE id IN (142818, 142819);
Date: 2023-04-28 20:03:51 Duration: 422ms
13 815 3m15s 194ms 12s359ms 239ms 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 #13
Day Hour Count Duration Avg duration Apr 28 11 28 5s768ms 206ms 12 126 28s264ms 224ms 13 150 33s40ms 220ms 14 177 39s175ms 221ms 15 78 18s297ms 234ms 16 76 17s421ms 229ms 17 46 23s50ms 501ms 18 61 13s621ms 223ms 19 54 12s409ms 229ms 20 17 3s659ms 215ms 21 2 428ms 214ms -
UPDATE "sale_order_line" SET "invoice_status" = 'to invoice', "open_qty_fil" = 0.0, "qty_delivered" = '2.00', "qty_to_invoice" = '2.00', "untaxed_amount_to_invoice" = '58.72', "write_uid" = 971, "write_date" = (now() at time zone 'UTC') WHERE id IN (136699);
Date: 2023-04-28 17:23:16 Duration: 12s359ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 1.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1237, "write_date" = (now() at time zone 'UTC') WHERE id IN (117552, 117556, 132604, 117175);
Date: 2023-04-28 19:05:05 Duration: 827ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 4.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1018, "write_date" = (now() at time zone 'UTC') WHERE id IN (134601, 136266, 136212, 133941);
Date: 2023-04-28 13:23:33 Duration: 823ms
14 798 9m46s 684ms 1s82ms 734ms 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 #14
Day Hour Count Duration Avg duration Apr 28 10 1 712ms 712ms 11 35 25s212ms 720ms 12 101 1m15s 743ms 13 131 1m36s 736ms 14 127 1m33s 736ms 15 96 1m11s 747ms 16 54 39s164ms 725ms 17 83 1m 724ms 18 59 43s51ms 729ms 19 85 1m2s 733ms 20 18 12s910ms 717ms 21 8 5s738ms 717ms -
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 ('%37-160%')) 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 ('%37-160%'))) 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 ('%37-160%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%37-160%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-04-28 15:06:19 Duration: 1s82ms
-
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 ('%3230951%')) 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 ('%3230951%'))) 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 ('%3230951%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%3230951%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-04-28 15:04:50 Duration: 1s6ms
-
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 ('%p315a189unab1056%')) 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 ('%p315a189unab1056%'))) 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 ('%p315a189unab1056%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%p315a189unab1056%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-04-28 18:14:03 Duration: 982ms
15 751 4m9s 278ms 522ms 332ms select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Apr 28 11 28 8s187ms 292ms 12 83 28s743ms 346ms 13 439 2m26s 334ms 14 178 56s439ms 317ms 15 23 9s597ms 417ms -
select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;
Date: 2023-04-28 13:09:57 Duration: 522ms
-
select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;
Date: 2023-04-28 13:22:42 Duration: 505ms
-
select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;
Date: 2023-04-28 13:22:42 Duration: 505ms
16 726 2m56s 195ms 19s969ms 243ms 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 #16
Day Hour Count Duration Avg duration Apr 28 11 27 5s553ms 205ms 12 139 30s157ms 216ms 13 117 24s576ms 210ms 14 130 27s774ms 213ms 15 81 17s980ms 221ms 16 70 15s193ms 217ms 17 40 28s720ms 718ms 18 55 12s41ms 218ms 19 52 11s411ms 219ms 20 14 2s881ms 205ms 21 1 197ms 197ms -
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '2.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '58.72', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 971, "write_date" = (now() at time zone 'UTC') WHERE id IN (136699);
Date: 2023-04-28 17:23:47 Duration: 19s969ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '1.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '104.99', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 965, "write_date" = (now() at time zone 'UTC') WHERE id IN (142408, 142409, 142407);
Date: 2023-04-28 16:20:05 Duration: 616ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '-1.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '-6.02', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1023, "write_date" = (now() at time zone 'UTC') WHERE id IN (142413, 142414);
Date: 2023-04-28 15:47:15 Duration: 484ms
17 704 6m31s 141ms 6s614ms 555ms 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 Apr 28 11 8 3s969ms 496ms 12 111 1m6s 598ms 13 122 1m5s 537ms 14 149 1m21s 549ms 15 70 43s332ms 619ms 16 47 27s933ms 594ms 17 34 17s827ms 524ms 18 39 22s252ms 570ms 19 96 47s754ms 497ms 20 27 13s737ms 508ms 21 1 404ms 404ms -
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (279169, 279171, 279173, 279174, 279176, 279177, 279181, 279183, 278521);
Date: 2023-04-28 15:34:20 Duration: 6s614ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1010, "write_date" = (now() at time zone 'UTC') WHERE id IN (156930, 89437, 284381, 87280, 284379, 91036, 91037);
Date: 2023-04-28 12:10:00 Duration: 3s545ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 979, "write_date" = (now() at time zone 'UTC') WHERE id IN (145719, 214319);
Date: 2023-04-28 15:06:05 Duration: 2s651ms
18 673 9m8s 367ms 2s801ms 815ms 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 #18
Day Hour Count Duration Avg duration Apr 28 11 44 34s408ms 782ms 12 154 2m7s 827ms 13 129 1m40s 780ms 14 84 1m12s 865ms 15 61 49s576ms 812ms 16 23 18s413ms 800ms 17 37 27s967ms 755ms 18 32 26s547ms 829ms 19 87 1m13s 848ms 20 21 16s298ms 776ms 21 1 695ms 695ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 4.0, "date" = '2023-04-28 19:52:36', "is_done" = true, "state" = 'done', "write_uid" = 1237, "write_date" = (now() at time zone 'UTC') WHERE id IN (337016, 337025, 337024);
Date: 2023-04-28 19:52:43 Duration: 2s801ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 4.0, "date" = '2023-04-28 13:28:46', "is_done" = true, "state" = 'done', "write_uid" = 1043, "write_date" = (now() at time zone 'UTC') WHERE id IN (389889, 391321);
Date: 2023-04-28 13:28:51 Duration: 2s363ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 4.0, "date" = '2023-04-28 19:21:39', "is_done" = true, "state" = 'done', "write_uid" = 994, "write_date" = (now() at time zone 'UTC') WHERE id IN (392512, 392510);
Date: 2023-04-28 19:21:42 Duration: 2s149ms
19 673 6m36s 547ms 891ms 589ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where (((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 #19
Day Hour Count Duration Avg duration Apr 28 07 25 14s100ms 564ms 10 12 6s770ms 564ms 11 9 5s181ms 575ms 12 59 34s595ms 586ms 13 41 23s892ms 582ms 14 120 1m10s 585ms 15 213 2m7s 597ms 16 48 28s426ms 592ms 17 94 56s207ms 597ms 18 22 12s700ms 577ms 19 10 5s715ms 571ms 20 20 11s269ms 563ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%EX4702KU%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%EX4702K-U%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%EX4702K-U%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 17:23:38 Duration: 891ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%EX4702KU%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%EX4702K-U%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%EX4702K-U%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 17:23:37 Duration: 868ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%L6048F%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%L6048F%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%L6048F%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 15:21:10 Duration: 841ms
20 653 2m21s 195ms 340ms 216ms update "sale_order_line" set "branch_id" = ?, "currency_id" = ?, "cus_date_order" = ?, "cus_part_route" = ?, "cus_user_id" = ?, "inventory_vendor_id" = ?, "is_service" = false, "margin" = ?, "margin_percent" = ?.?, "order_partner_id" = ?, "price_reduce" = ?, "price_reduce_taxexcl" = ?, "price_reduce_taxinc" = ?, "price_subtotal" = ?, "price_tax" = ?.?, "price_total" = ?, "purchase_price" = ?, "qty_delivered_method" = ?, "qty_invoiced" = ?, "qty_to_invoice" = ?, "salesman_id" = ?, "untaxed_amount_invoiced" = ?, "untaxed_amount_to_invoice" = ?, "warehouse_id" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Apr 28 11 29 6s250ms 215ms 12 111 23s838ms 214ms 13 73 15s898ms 217ms 14 85 18s550ms 218ms 15 83 18s72ms 217ms 16 50 10s675ms 213ms 17 47 10s349ms 220ms 18 82 17s549ms 214ms 19 72 15s788ms 219ms 20 12 2s579ms 214ms 21 9 1s947ms 216ms -
UPDATE "sale_order_line" SET "branch_id" = 40, "currency_id" = 2, "cus_date_order" = '2023-04-27 18:32:44', "cus_part_route" = NULL, "cus_user_id" = 1039, "inventory_vendor_id" = 3098, "is_service" = false, "margin" = '0.84', "margin_percent" = 0.16, "order_partner_id" = 42334, "price_reduce" = '5.25', "price_reduce_taxexcl" = '5.25', "price_reduce_taxinc" = '5.25', "price_subtotal" = '5.25', "price_tax" = 0.0, "price_total" = '5.25', "purchase_price" = '4.41', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 1039, "untaxed_amount_invoiced" = '0.00', "untaxed_amount_to_invoice" = '0.00', "warehouse_id" = 38, "write_uid" = 1000, "write_date" = (now() at time zone 'UTC') WHERE id IN (142298);
Date: 2023-04-28 14:42:32 Duration: 340ms
-
UPDATE "sale_order_line" SET "branch_id" = 45, "currency_id" = 2, "cus_date_order" = '2023-04-28 14:57:38', "cus_part_route" = NULL, "cus_user_id" = 985, "inventory_vendor_id" = 3026, "is_service" = false, "margin" = '28.10', "margin_percent" = 0.550009786651008, "order_partner_id" = 41150, "price_reduce" = '51.09', "price_reduce_taxexcl" = '51.09', "price_reduce_taxinc" = '51.09', "price_subtotal" = '51.09', "price_tax" = 0.0, "price_total" = '51.09', "purchase_price" = '22.99', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 985, "untaxed_amount_invoiced" = '0.00', "untaxed_amount_to_invoice" = '0.00', "warehouse_id" = 42, "write_uid" = 1021, "write_date" = (now() at time zone 'UTC') WHERE id IN (142339);
Date: 2023-04-28 14:58:08 Duration: 314ms
-
UPDATE "sale_order_line" SET "branch_id" = 48, "currency_id" = 2, "cus_date_order" = '2023-04-28 13:08:46', "cus_part_route" = NULL, "cus_user_id" = 985, "inventory_vendor_id" = 2923, "is_service" = false, "margin" = '25.76', "margin_percent" = 0.5099980201940211, "order_partner_id" = 51501, "price_reduce" = '50.51', "price_reduce_taxexcl" = '50.51', "price_reduce_taxinc" = '50.51', "price_subtotal" = '50.51', "price_tax" = 0.0, "price_total" = '50.51', "purchase_price" = '24.75', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 985, "untaxed_amount_invoiced" = '0.00', "untaxed_amount_to_invoice" = '0.00', "warehouse_id" = 45, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (142143);
Date: 2023-04-28 13:12:26 Duration: 297ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2s59ms 2m 50s711ms 47 39m43s update "stock_picking" set "scheduled_date" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Apr 28 14 3 20s267ms 6s755ms 15 31 32m48s 1m3s 17 13 6m34s 30s360ms -
UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);
Date: 2023-04-28 15:14:12 Duration: 2m
-
UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);
Date: 2023-04-28 15:06:41 Duration: 1m45s
-
UPDATE "stock_picking" SET "scheduled_date" = '2023-04-26 16:36:39.258393', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (129213);
Date: 2023-04-28 15:10:11 Duration: 1m42s
2 305ms 1m38s 7s875ms 189 24m48s 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 Apr 28 11 5 9s91ms 1s818ms 12 16 2m23s 8s965ms 13 29 1m51s 3s851ms 14 26 2m44s 6s308ms 15 51 8m55s 10s499ms 16 9 30s800ms 3s422ms 17 33 6m14s 11s338ms 18 10 1m12s 7s295ms 19 7 40s688ms 5s812ms 20 3 6s156ms 2s52ms -
UPDATE "stock_move" SET "date" = '2023-04-28 12:27:38', "state" = 'done', "write_uid" = 989, "write_date" = (now() at time zone 'UTC') WHERE id IN (149000, 319341, 319342, 301091, 324643, 220725, 123450, 319037, 238656, 265307, 187496, 127094, 279160, 251000, 232059, 127624, 297609, 127626, 254605, 254607, 309906, 324247, 324248, 297628, 297630, 297631, 138916, 190633, 321194, 335017, 321196, 321198, 321199, 145584, 246963, 288949, 208584, 205002, 205003, 205004, 334032, 316122, 316123, 316124, 316128, 316129, 316130, 316131, 316132, 316134, 316137, 316139, 316141, 230640, 230641, 304368, 304369, 316144, 323313, 301312, 135429, 260870, 311572, 306454, 306967, 295708, 295709, 295710, 309027, 309028, 309029, 309031, 330555, 333627, 301379, 244042, 313175, 250203, 290151, 247660, 247661, 247662, 286575, 247663, 247664, 247665, 247666, 307572, 307573, 313199, 307575, 307576, 313201, 313203, 313205, 313207, 313208, 313209, 313210, 132518, 132519, 337832, 139701, 333242, 338363, 308672, 332738, 316867, 171972, 171973, 316868, 158663, 330182, 330183, 332740, 293323, 332744, 189390, 189391, 263119, 326099, 326100, 304090, 304091, 304092, 125917, 125918, 304093, 304095, 139758, 306675, 154613, 139766);
Date: 2023-04-28 12:29:22 Duration: 1m38s
-
UPDATE "stock_move" SET "date" = '2023-04-28 18:33:56', "state" = 'done', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (385792, 385793, 385794, 385795, 385796, 385797, 385798, 385799, 385800, 385801, 385802, 385804, 385805, 385806, 385807, 385808, 385809, 385810, 385811, 385812, 385813, 385815, 385816, 385817, 385818, 385819, 385820, 385821, 385822, 385823, 385824, 385825, 385826, 385828, 385829, 385830, 385831, 385832, 385833, 385835, 385836, 385837, 385838, 385839, 385840, 385841, 385843, 385791);
Date: 2023-04-28 18:34:24 Duration: 26s674ms
-
UPDATE "stock_move" SET "date" = '2023-04-28 12:49:09', "state" = 'done', "write_uid" = 989, "write_date" = (now() at time zone 'UTC') WHERE id IN (203396, 243853, 237841, 251414, 251415, 228518, 237612, 339757, 343212, 281778, 251187, 238004, 270387, 334258, 340148, 321080, 233018, 332603, 238654, 304704, 267080, 287816, 322639, 340177, 216788, 315864, 238045, 248162, 230755, 238055, 253549, 309101, 312439);
Date: 2023-04-28 12:49:38 Duration: 23s878ms
3 142ms 16s651ms 1s766ms 376 11m4s update "stock_quant" set "company_id" = ?, "inventory_vendor_id" = ?, "warehouse_id" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Apr 28 11 8 5s711ms 713ms 12 86 1m17s 905ms 13 67 1m1s 922ms 14 34 45s79ms 1s325ms 15 48 4m4s 5s83ms 16 13 18s646ms 1s434ms 17 52 2m31s 2s916ms 18 29 25s229ms 869ms 19 32 30s545ms 954ms 20 7 3s678ms 525ms -
UPDATE "stock_quant" SET "company_id" = 1, "inventory_vendor_id" = 3094, "warehouse_id" = 35, "write_uid" = 989, "write_date" = (now() at time zone 'UTC') WHERE id IN (284448, 284451, 284420, 284421, 284454, 284423, 284457, 284427, 284428, 284429, 284430, 284431, 284438, 284439, 284440, 284441, 284442, 284445, 284446, 284447);
Date: 2023-04-28 12:31:11 Duration: 16s651ms
-
UPDATE "stock_quant" SET "company_id" = 1, "inventory_vendor_id" = 3089, "warehouse_id" = 36, "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (285456, 285458, 285460, 285462, 285464, 285466, 285468, 285470, 285472, 285474, 285476, 285478, 285480, 285482, 285484, 285486, 285488, 285490, 285492, 285494, 285496, 285498, 285500, 285502, 285504, 285506, 285508, 285510);
Date: 2023-04-28 15:05:57 Duration: 12s975ms
-
UPDATE "stock_quant" SET "company_id" = 1, "inventory_vendor_id" = 3089, "warehouse_id" = 36, "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (285824, 285826, 285828, 285830, 285832, 285834, 285836, 285838, 285784, 285786, 285788, 285790, 285792, 285794, 285796, 285798, 285800, 285802, 285804, 285806, 285808, 285810, 285812, 285814, 285816, 285818, 285820, 285822);
Date: 2023-04-28 15:08:56 Duration: 12s653ms
4 1s48ms 1s556ms 1s133ms 214 4m2s select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Apr 28 11 32 35s22ms 1s94ms 13 41 47s547ms 1s159ms 14 59 1m7s 1s152ms 15 15 17s267ms 1s151ms 16 15 16s464ms 1s97ms 17 7 8s40ms 1s148ms 19 24 27s604ms 1s150ms 20 5 5s392ms 1s78ms 21 16 17s290ms 1s80ms -
select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;
Date: 2023-04-28 13:12:13 Duration: 1s556ms
-
select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;
Date: 2023-04-28 13:12:12 Duration: 1s525ms
-
select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;
Date: 2023-04-28 15:31:26 Duration: 1s372ms
5 508ms 10s716ms 1s51ms 232 4m3s update "stock_move" set "date" = ?, "is_done" = true, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Apr 28 11 11 9s8ms 818ms 12 33 37s700ms 1s142ms 13 36 33s103ms 919ms 14 60 57s101ms 951ms 15 25 33s697ms 1s347ms 16 20 21s823ms 1s91ms 17 12 17s164ms 1s430ms 18 14 15s602ms 1s114ms 19 13 9s598ms 738ms 20 8 9s188ms 1s148ms -
UPDATE "stock_move" SET "date" = '2023-04-28 15:34:05', "is_done" = true, "state" = 'done', "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (391912, 391913, 391915, 391916, 391917, 391918, 391919, 391920, 391921, 391922, 391923);
Date: 2023-04-28 15:34:32 Duration: 10s716ms
-
UPDATE "stock_move" SET "date" = '2023-04-28 12:09:25', "is_done" = true, "state" = 'done', "write_uid" = 1010, "write_date" = (now() at time zone 'UTC') WHERE id IN (391088, 391089, 391090, 391091, 391120, 391121, 391122, 391123, 391124, 391099, 391100, 391101);
Date: 2023-04-28 12:09:39 Duration: 9s98ms
-
UPDATE "stock_move" SET "date" = '2023-04-28 14:29:41', "is_done" = true, "state" = 'done', "write_uid" = 1000, "write_date" = (now() at time zone 'UTC') WHERE id IN (391712, 391715, 391716, 391717, 391719, 391709, 391711);
Date: 2023-04-28 14:29:46 Duration: 4s719ms
6 139ms 5s475ms 944ms 273 4m17s update "stock_move" set "branch_id" = ?, "picking_id" = ?, "related_core_purchase_line_id" = ?, "related_core_repair_line_id" = ?, "related_core_sale_line_id" = ?, "scrapped" = false, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Apr 28 10 1 891ms 891ms 11 16 18s193ms 1s137ms 12 33 37s410ms 1s133ms 13 38 32s192ms 847ms 14 33 35s560ms 1s77ms 15 35 30s988ms 885ms 16 29 30s502ms 1s51ms 17 18 10s546ms 585ms 18 28 27s942ms 997ms 19 26 23s89ms 888ms 20 10 6s664ms 666ms 21 6 3s959ms 659ms -
UPDATE "stock_move" SET "branch_id" = 45, "picking_id" = 131426, "related_core_purchase_line_id" = NULL, "related_core_repair_line_id" = NULL, "related_core_sale_line_id" = NULL, "scrapped" = false, "state" = 'confirmed', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (391872, 391873, 391874, 391875, 391876, 391877, 391878, 391879, 391880, 391881, 391868, 391869, 391870, 391871);
Date: 2023-04-28 15:21:22 Duration: 5s475ms
-
UPDATE "stock_move" SET "branch_id" = 37, "picking_id" = 131720, "related_core_purchase_line_id" = NULL, "related_core_repair_line_id" = NULL, "related_core_sale_line_id" = NULL, "scrapped" = false, "state" = 'confirmed', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (392452, 392453, 392454, 392456, 392457, 392458, 392459, 392460);
Date: 2023-04-28 18:55:30 Duration: 5s246ms
-
UPDATE "stock_move" SET "branch_id" = 46, "picking_id" = 131038, "related_core_purchase_line_id" = NULL, "related_core_repair_line_id" = NULL, "related_core_sale_line_id" = NULL, "scrapped" = false, "state" = 'confirmed', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (391330, 391331, 391332, 391333, 391334, 391335, 391336, 391337, 391338, 391339);
Date: 2023-04-28 13:00:06 Duration: 4s727ms
7 884ms 1s126ms 903ms 6,274 1h34m31s select "sale_history_line".id from "sale_history_line" where (((("sale_history_line"."contact_reference" = ?) and ("sale_history_line"."inventory_short_vendor_name" = ?)) and ("sale_history_line"."product_name" = ?)) and (((("sale_history_line"."selling_branch" in (...)) and (("sale_history_line"."invoice_date" >= ?) and ("sale_history_line"."invoice_date" <= ?))) 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 (?)) and (("res_users"."share" is null or "res_users"."share" = false) or exists ( select ? 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 (...))) 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 (...))) or "res_users__partner_id"."company_id" is null) and (((("res_users__partner_id"."type" != ?) or "res_users__partner_id"."type" is null) or "res_users__partner_id"."type" is null) or ("res_users__partner_id"."type" = ?))))))) order by "sale_history_line"."invoice_date" desc;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Apr 28 19 3,200 48m24s 907ms 20 3,074 46m6s 899ms -
SELECT "sale_history_line".id FROM "sale_history_line" WHERE (((("sale_history_line"."contact_reference" = '11309') AND ("sale_history_line"."inventory_short_vendor_name" = 'Labor-Suspension')) AND ("sale_history_line"."product_name" = 'LAB2')) AND (((("sale_history_line"."selling_branch" in (46)) AND (("sale_history_line"."invoice_date" >= '2022-01-01') AND ("sale_history_line"."invoice_date" <= '2022-12-31'))) 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 ('%schaef%')) 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'))))))) ORDER BY "sale_history_line"."invoice_date" DESC;
Date: 2023-04-28 19:35:19 Duration: 1s126ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE (((("sale_history_line"."contact_reference" = '15909') AND ("sale_history_line"."inventory_short_vendor_name" = 'Misc Stock')) AND ("sale_history_line"."product_name" = '55111025AB')) AND (((("sale_history_line"."selling_branch" in (46)) AND (("sale_history_line"."invoice_date" >= '2022-01-01') AND ("sale_history_line"."invoice_date" <= '2022-12-31'))) 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 ('%schaef%')) 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'))))))) ORDER BY "sale_history_line"."invoice_date" DESC;
Date: 2023-04-28 19:42:10 Duration: 1s96ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE (((("sale_history_line"."contact_reference" = '15909') AND ("sale_history_line"."inventory_short_vendor_name" = 'Misc Stock')) AND ("sale_history_line"."product_name" = '68505585AA')) AND (((("sale_history_line"."selling_branch" in (46)) AND (("sale_history_line"."invoice_date" >= '2022-01-01') AND ("sale_history_line"."invoice_date" <= '2022-12-31'))) 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 ('%schaef%')) 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'))))))) ORDER BY "sale_history_line"."invoice_date" DESC;
Date: 2023-04-28 19:42:16 Duration: 1s73ms
8 367ms 2s801ms 815ms 673 9m8s update "stock_move" set "current_warehouse_qty" = ?.?, "date" = ?, "is_done" = true, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Apr 28 11 44 34s408ms 782ms 12 154 2m7s 827ms 13 129 1m40s 780ms 14 84 1m12s 865ms 15 61 49s576ms 812ms 16 23 18s413ms 800ms 17 37 27s967ms 755ms 18 32 26s547ms 829ms 19 87 1m13s 848ms 20 21 16s298ms 776ms 21 1 695ms 695ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 4.0, "date" = '2023-04-28 19:52:36', "is_done" = true, "state" = 'done', "write_uid" = 1237, "write_date" = (now() at time zone 'UTC') WHERE id IN (337016, 337025, 337024);
Date: 2023-04-28 19:52:43 Duration: 2s801ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 4.0, "date" = '2023-04-28 13:28:46', "is_done" = true, "state" = 'done', "write_uid" = 1043, "write_date" = (now() at time zone 'UTC') WHERE id IN (389889, 391321);
Date: 2023-04-28 13:28:51 Duration: 2s363ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 4.0, "date" = '2023-04-28 19:21:39', "is_done" = true, "state" = 'done', "write_uid" = 994, "write_date" = (now() at time zone 'UTC') WHERE id IN (392512, 392510);
Date: 2023-04-28 19:21:42 Duration: 2s149ms
9 684ms 1s82ms 734ms 798 9m46s 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 #9
Day Hour Count Duration Avg duration Apr 28 10 1 712ms 712ms 11 35 25s212ms 720ms 12 101 1m15s 743ms 13 131 1m36s 736ms 14 127 1m33s 736ms 15 96 1m11s 747ms 16 54 39s164ms 725ms 17 83 1m 724ms 18 59 43s51ms 729ms 19 85 1m2s 733ms 20 18 12s910ms 717ms 21 8 5s738ms 717ms -
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 ('%37-160%')) 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 ('%37-160%'))) 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 ('%37-160%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%37-160%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-04-28 15:06:19 Duration: 1s82ms
-
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 ('%3230951%')) 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 ('%3230951%'))) 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 ('%3230951%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%3230951%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-04-28 15:04:50 Duration: 1s6ms
-
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 ('%p315a189unab1056%')) 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 ('%p315a189unab1056%'))) 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 ('%p315a189unab1056%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%p315a189unab1056%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-04-28 18:14:03 Duration: 982ms
10 706ms 1s344ms 733ms 5,200 1h3m34s select "sale_history_line".id from "sale_history_line" where ((("sale_history_line"."contact_reference" = ?) and ("sale_history_line"."product_name" = ?)) and (((("sale_history_line"."selling_branch" in (...)) and "sale_history_line"."company_id" is not null) 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 (?)) and (("res_users"."share" is null or "res_users"."share" = false) or exists ( select ? 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 (...))) 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 (...))) or "res_users__partner_id"."company_id" is null) and (((("res_users__partner_id"."type" != ?) or "res_users__partner_id"."type" is null) or "res_users__partner_id"."type" is null) or ("res_users__partner_id"."type" = ?)))))) and (("sale_history_line"."invoice_date" >= ?) and ("sale_history_line"."invoice_date" <= ?)))) order by "sale_history_line"."invoice_date" desc;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Apr 28 18 1,463 17m47s 729ms 19 3,737 45m47s 735ms -
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ((("sale_history_line"."contact_reference" = '66891') AND ("sale_history_line"."product_name" = '40720')) AND (((("sale_history_line"."selling_branch" in (46)) AND "sale_history_line"."company_id" IS NOT NULL) 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 ('%schaef%')) 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" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')))) ORDER BY "sale_history_line"."invoice_date" DESC;
Date: 2023-04-28 19:10:28 Duration: 1s344ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ((("sale_history_line"."contact_reference" = '17769') AND ("sale_history_line"."product_name" = 'SHIPPING')) AND (((("sale_history_line"."selling_branch" in (46)) AND "sale_history_line"."company_id" IS NOT NULL) 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 ('%schaef%')) 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" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')))) ORDER BY "sale_history_line"."invoice_date" DESC;
Date: 2023-04-28 19:10:27 Duration: 1s222ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ((("sale_history_line"."contact_reference" = '101425') AND ("sale_history_line"."product_name" = '05089')) AND (((("sale_history_line"."selling_branch" in (46)) AND "sale_history_line"."company_id" IS NOT NULL) 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 ('%schaef%')) 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" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')))) ORDER BY "sale_history_line"."invoice_date" DESC;
Date: 2023-04-28 19:00:48 Duration: 1s153ms
11 540ms 1s108ms 590ms 452 4m26s select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where (((("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and ("product_product__product_tmpl_id"."purchase_ok" is not null and "product_product__product_tmpl_id"."purchase_ok" != false)) and (("product_product__product_tmpl_id"."type" != ?) or "product_product__product_tmpl_id"."type" is null)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 28 11 16 9s241ms 577ms 12 41 24s636ms 600ms 13 3 1s809ms 603ms 14 51 29s644ms 581ms 15 82 52s365ms 638ms 16 48 27s472ms 572ms 17 107 1m1s 573ms 18 89 51s785ms 581ms 19 2 1s126ms 563ms 20 10 5s678ms 567ms 21 3 1s670ms 556ms -
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 ('%%be22%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%be22%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%be22%'))) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 15:14:16 Duration: 1s108ms
-
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 ('%%be2232%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%be2232%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%be2232%'))) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 15:14:17 Duration: 1s75ms
-
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 ('%%be223%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%be223%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%be223%'))) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 15:14:16 Duration: 1s51ms
12 547ms 891ms 589ms 673 6m36s select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Apr 28 07 25 14s100ms 564ms 10 12 6s770ms 564ms 11 9 5s181ms 575ms 12 59 34s595ms 586ms 13 41 23s892ms 582ms 14 120 1m10s 585ms 15 213 2m7s 597ms 16 48 28s426ms 592ms 17 94 56s207ms 597ms 18 22 12s700ms 577ms 19 10 5s715ms 571ms 20 20 11s269ms 563ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%EX4702KU%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%EX4702K-U%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%EX4702K-U%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 17:23:38 Duration: 891ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%EX4702KU%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%EX4702K-U%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%EX4702K-U%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 17:23:37 Duration: 868ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%L6048F%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%L6048F%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%L6048F%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 15:21:10 Duration: 841ms
13 137ms 6s13ms 587ms 1,070 10m28s 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 Apr 28 11 60 40s300ms 671ms 12 156 1m46s 681ms 13 151 1m35s 633ms 14 94 52s945ms 563ms 15 140 1m13s 522ms 16 26 13s434ms 516ms 17 291 2m34s 530ms 18 63 44s569ms 707ms 19 70 42s369ms 605ms 20 19 5s796ms 305ms -
UPDATE "stock_quant" SET "quantity" = 0.0, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (59291, 167846, 167849, 167851, 167855, 167859, 167864, 167865, 167867);
Date: 2023-04-28 12:18:10 Duration: 6s13ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (189761, 276546, 276548, 1156, 276550, 275530, 222455, 275546, 275547);
Date: 2023-04-28 13:58:04 Duration: 3s849ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "write_uid" = 989, "write_date" = (now() at time zone 'UTC') WHERE id IN (173125, 246153, 197747, 254810, 232795, 244636);
Date: 2023-04-28 12:30:09 Duration: 3s183ms
14 544ms 1s24ms 586ms 1,137 11m7s 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 Apr 28 10 6 3s489ms 581ms 11 108 1m1s 569ms 12 157 1m31s 581ms 13 277 2m42s 587ms 14 67 40s414ms 603ms 15 109 1m7s 618ms 16 71 41s275ms 581ms 17 82 47s987ms 585ms 18 77 44s757ms 581ms 19 124 1m12s 586ms 20 59 33s856ms 573ms -
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 ('%%qpl%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%qpl-%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%qpl-%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 15:06:17 Duration: 1s24ms
-
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 ('%%qpl%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%qpl%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%qpl%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 15:06:17 Duration: 1s19ms
-
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 ('%%qplaex%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%qpl-a-ex%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%qpl-a-ex%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 15:06:18 Duration: 1s13ms
15 539ms 1s187ms 583ms 3,889 37m49s 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 #15
Day Hour Count Duration Avg duration Apr 28 10 13 7s361ms 566ms 11 141 1m20s 568ms 12 665 6m30s 586ms 13 471 4m37s 589ms 14 418 4m4s 584ms 15 528 5m10s 587ms 16 355 3m24s 576ms 17 262 2m31s 579ms 18 468 4m30s 578ms 19 452 4m26s 589ms 20 55 31s209ms 567ms 21 61 34s243ms 561ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%5014144x%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%5014144x%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%5014144x%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 12:31:45 Duration: 1s187ms
-
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 ('%%3230%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%3230%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%3230%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 15:06:03 Duration: 1s119ms
-
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 ('%%7539%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%7-539%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%7-539%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-28 18:09:04 Duration: 1s101ms
16 141ms 6s614ms 555ms 704 6m31s update "stock_quant" set "quantity" = ?.?, "reserved_quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Apr 28 11 8 3s969ms 496ms 12 111 1m6s 598ms 13 122 1m5s 537ms 14 149 1m21s 549ms 15 70 43s332ms 619ms 16 47 27s933ms 594ms 17 34 17s827ms 524ms 18 39 22s252ms 570ms 19 96 47s754ms 497ms 20 27 13s737ms 508ms 21 1 404ms 404ms -
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (279169, 279171, 279173, 279174, 279176, 279177, 279181, 279183, 278521);
Date: 2023-04-28 15:34:20 Duration: 6s614ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1010, "write_date" = (now() at time zone 'UTC') WHERE id IN (156930, 89437, 284381, 87280, 284379, 91036, 91037);
Date: 2023-04-28 12:10:00 Duration: 3s545ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 979, "write_date" = (now() at time zone 'UTC') WHERE id IN (145719, 214319);
Date: 2023-04-28 15:06:05 Duration: 2s651ms
17 278ms 522ms 332ms 751 4m9s select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Apr 28 11 28 8s187ms 292ms 12 83 28s743ms 346ms 13 439 2m26s 334ms 14 178 56s439ms 317ms 15 23 9s597ms 417ms -
select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;
Date: 2023-04-28 13:09:57 Duration: 522ms
-
select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;
Date: 2023-04-28 13:22:42 Duration: 505ms
-
select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;
Date: 2023-04-28 13:22:42 Duration: 505ms
18 195ms 19s969ms 243ms 726 2m56s 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 #18
Day Hour Count Duration Avg duration Apr 28 11 27 5s553ms 205ms 12 139 30s157ms 216ms 13 117 24s576ms 210ms 14 130 27s774ms 213ms 15 81 17s980ms 221ms 16 70 15s193ms 217ms 17 40 28s720ms 718ms 18 55 12s41ms 218ms 19 52 11s411ms 219ms 20 14 2s881ms 205ms 21 1 197ms 197ms -
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '2.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '58.72', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 971, "write_date" = (now() at time zone 'UTC') WHERE id IN (136699);
Date: 2023-04-28 17:23:47 Duration: 19s969ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '1.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '104.99', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 965, "write_date" = (now() at time zone 'UTC') WHERE id IN (142408, 142409, 142407);
Date: 2023-04-28 16:20:05 Duration: 616ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '-1.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '-6.02', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1023, "write_date" = (now() at time zone 'UTC') WHERE id IN (142413, 142414);
Date: 2023-04-28 15:47:15 Duration: 484ms
19 194ms 12s359ms 239ms 815 3m15s 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 #19
Day Hour Count Duration Avg duration Apr 28 11 28 5s768ms 206ms 12 126 28s264ms 224ms 13 150 33s40ms 220ms 14 177 39s175ms 221ms 15 78 18s297ms 234ms 16 76 17s421ms 229ms 17 46 23s50ms 501ms 18 61 13s621ms 223ms 19 54 12s409ms 229ms 20 17 3s659ms 215ms 21 2 428ms 214ms -
UPDATE "sale_order_line" SET "invoice_status" = 'to invoice', "open_qty_fil" = 0.0, "qty_delivered" = '2.00', "qty_to_invoice" = '2.00', "untaxed_amount_to_invoice" = '58.72', "write_uid" = 971, "write_date" = (now() at time zone 'UTC') WHERE id IN (136699);
Date: 2023-04-28 17:23:16 Duration: 12s359ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 1.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1237, "write_date" = (now() at time zone 'UTC') WHERE id IN (117552, 117556, 132604, 117175);
Date: 2023-04-28 19:05:05 Duration: 827ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 4.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1018, "write_date" = (now() at time zone 'UTC') WHERE id IN (134601, 136266, 136212, 133941);
Date: 2023-04-28 13:23:33 Duration: 823ms
20 201ms 884ms 228ms 886 3m22s select "sale_history_line".id from "sale_history_line" where ("sale_history_line"."so_line_id" in (...)) order by "sale_history_line"."id";Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Apr 28 10 3 621ms 207ms 11 51 11s132ms 218ms 12 141 32s293ms 229ms 13 86 19s686ms 228ms 14 121 27s354ms 226ms 15 105 25s898ms 246ms 16 115 25s561ms 222ms 17 39 8s734ms 223ms 18 99 21s598ms 218ms 19 84 20s537ms 244ms 20 29 6s400ms 220ms 21 13 2s816ms 216ms -
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (142775)) ORDER BY "sale_history_line"."id";
Date: 2023-04-28 19:40:35 Duration: 884ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (141995)) ORDER BY "sale_history_line"."id";
Date: 2023-04-28 12:31:43 Duration: 368ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (142350)) ORDER BY "sale_history_line"."id";
Date: 2023-04-28 15:05:37 Duration: 362ms
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
- 58,460 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 2669 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 2,000 Max number of times the same event was reported
- 2,669 Total events found
Rank Times reported Error 1 2,000 ERROR: could not obtain lock on row in relation "..."
Times Reported Most Frequent Error / Event #1
Day Hour Count Apr 28 00 64 01 72 02 65 03 45 04 37 05 42 06 46 07 70 08 47 09 42 10 33 11 8 12 12 13 12 14 81 15 868 16 7 17 381 18 11 19 11 20 10 21 10 22 15 23 11 - ERROR: could not obtain lock on row in relation "ir_cron"
- ERROR: could not obtain lock on row in relation "stock_quant"
- ERROR: could not obtain lock on row in relation "res_partner"
Statement: SELECT * FROM ir_cron WHERE numbercall != 0 AND active AND nextcall <= (now() at time zone 'UTC') AND id=68 FOR UPDATE NOWAIT
Date: 2023-04-28 00:00:03
Statement: SELECT 1 FROM stock_quant WHERE id = 148288 FOR UPDATE NOWAIT
Date: 2023-04-28 12:43:55
Statement: SELECT "supplier_rank" FROM res_partner WHERE ID IN (32871, 30496) FOR UPDATE NOWAIT; UPDATE res_partner SET "supplier_rank" = "supplier_rank" + 1 WHERE id IN (32871, 30496)
Date: 2023-04-28 13:20:35
2 511 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #2
Day Hour Count Apr 28 03 1 06 1 07 2 08 1 09 1 10 10 11 33 12 103 13 93 14 78 15 83 16 14 17 36 18 27 19 18 20 6 21 3 23 1 - ERROR: could not serialize access due to concurrent update
Statement: UPDATE "bus_presence" SET "last_poll"='2023-04-28 03:08:13' WHERE id IN (31)
Date: 2023-04-28 03:08:13
3 112 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #3
Day Hour Count Apr 28 10 1 11 1 12 15 13 13 14 19 15 40 16 1 17 19 18 1 19 2 - ERROR: process 3402069 still waiting for ShareLock on transaction 108312596 after 1000.053 ms
- ERROR: process 3400406 still waiting for ShareLock on transaction 108322139 after 1000.044 ms
- ERROR: process 3402013 still waiting for ShareLock on transaction 108327702 after 1000.048 ms
Detail: Process holding the lock: 3410875. Wait queue: 3402069.
Context: while updating tuple (19259,48) 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 != 596934 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 != 596934 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1 ) RETURNING name;Date: 2023-04-28 10:17:34
Detail: Process holding the lock: 3400413. Wait queue: 3400406.
Context: while updating tuple (19582,41) in relation "account_move"
Statement: UPDATE "account_move" SET "access_token"='b096cef9-75bc-41a2-b4a5-7826873958fb',"is_move_sent"=true,"write_uid"=971,"write_date"=(now() at time zone 'UTC') WHERE id IN (599081)Date: 2023-04-28 11:42:23
Detail: Process holding the lock: 3400412. Wait queue: 3402013.
Context: while updating tuple (19599,55) in relation "account_move"
Statement: UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 431760 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 != 431760 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1 ) RETURNING name;Date: 2023-04-28 12:11:24
4 35 LOG: process ... still waiting for ExclusiveLock on tuple (...) of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #4
Day Hour Count Apr 28 12 1 13 1 14 2 15 31 - ERROR: process 3400406 still waiting for ExclusiveLock on tuple (19599,55) of relation 42418 of database 65946 after 1000.045 ms
- ERROR: process 3582761 still waiting for ExclusiveLock on tuple (19934,10) of relation 42418 of database 65946 after 1000.046 ms
- ERROR: process 3582760 still waiting for ExclusiveLock on tuple (20010,23) of relation 42418 of database 65946 after 1000.041 ms
Detail: Process holding the lock: 3402013. Wait queue: 3400406.
Statement: UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 579205 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 != 579205 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1 ) RETURNING name;Date: 2023-04-28 12:11:32
Detail: Process holding the lock: 3580615. Wait queue: 3582761.
Statement: UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 600245 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 != 600245 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1 ) RETURNING name;Date: 2023-04-28 13:49:48
Detail: Process holding the lock: 3577936. Wait queue: 3582760.
Statement: UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 430951 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 != 430951 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1 ) RETURNING name;Date: 2023-04-28 14:51:03
5 4 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Apr 28 07 1 08 2 10 1 - ERROR: syntax error at or near "nul" at character 407
- ERROR: syntax error at or near "and" at character 470
- ERROR: syntax error at or near "nullorder" at character 481
Statement: select st.id,p.id,p.name,pt.default_code,st.state,st.origin_returned_move_id from stock_move st inner join stock_picking p on p.id = st.picking_id inner join product_product pp on pp.id = st.product_id inner join product_template pt on pt.id = pp.product_tmpl_id where p.is_intra_com = True and pt.is_core= True and st.move_options='new_product' and st.sm_line_id is null and st.origin_returned_move_id is nul;
Date: 2023-04-28 07:54:27
Statement: select p.name, p.id,sm.id, sml.id, pp.id, sml.state,sml.move_options,p.transfer_id from stock_move_line sml left join product_product pp on sml.product_id = pp.id left join product_template pt on pt.id = pp.product_tmpl_id left join stock_picking p on p.id = sml.picking_id left join stock_move sm on sm.id = sml.move_id where pt.is_core = True and p.is_intra_com =True and sml.move_options = 'new_product' and sml.linked_has_core_ml_id is Null order by sml.state desc and sm.origin_returned_move_id is null;
Date: 2023-04-28 08:19:09
Statement: select p.name, p.id,sm.id, sml.id, pp.id, sml.state,sml.move_options,p.transfer_id from stock_move_line sml left join product_product pp on sml.product_id = pp.id left join product_template pt on pt.id = pp.product_tmpl_id left join stock_picking p on p.id = sml.picking_id left join stock_move sm on sm.id = sml.move_id where pt.is_core = True and p.is_intra_com =True and sml.move_options = 'new_product' and sml.linked_has_core_ml_id is Null and sm.origin_returned_move_id is nullorder by sml.state desc ;
Date: 2023-04-28 08:19:35
6 3 ERROR: current transaction is aborted, commands ignored until end of transaction block
Times Reported Most Frequent Error / Event #6
Day Hour Count Apr 28 16 3 - ERROR: current transaction is aborted, commands ignored until end of transaction block
Statement: INSERT INTO "edi_810_scheduler_details" ("id", "create_uid", "create_date", "write_uid", "write_date", "edi_810_ref", "rec_status", "total_time") VALUES (nextval('edi_810_scheduler_details_id_seq'), 1, (now() at time zone 'UTC'), 1, (now() at time zone 'UTC'), '5282391', 'Partial Match', '0.29875993728637695') RETURNING id
Date: 2023-04-28 16:17:04
7 2 ERROR: could not create unique index "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Apr 28 09 2 - ERROR: could not create unique index "vendor_account_master_unique_acc_no"
Detail: Key (account_number)=(P10394) is duplicated.
Statement: ALTER TABLE "vendor_account_master" ADD CONSTRAINT "vendor_account_master_unique_acc_no" unique (account_number)Date: 2023-04-28 09:56:47
8 1 ERROR: null value in column "..." of relation "..." violates not-null constraint
Times Reported Most Frequent Error / Event #8
Day Hour Count Apr 28 18 1 - ERROR: null value in column "categ_id" of relation "product_template" violates not-null constraint
Detail: Failing row contains (249800, null, ff5971nnflg, 1, null, null, null, product, null, 1.00, null, null, t, t, 1, 1, null, t, null, null, null, null, 971, 2023-04-28 18:19:53.295898, 971, 2023-04-28 18:19:53.295898, 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, 394940, never, 0, , 48, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 2023-04-28, null, E, 1, null, null, f, f, yes, null, 1, null, null, null, null, null, null, null, null, null, none, null, null, null, f, f, null, null, null, f, rfq).
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'), 971, (now() at time zone 'UTC'), 971, (now() at time zone 'UTC'), true, false, 0.0, 48, NULL, 1, '', 'no', '2023-04-28', 'E', 'never', 'delivery', false, false, false, false, false, 'yes', '1.00', 'ff5971nnflg', 0.0, 'no-message', 'receive', true, 'rfq', 0.0, 'no-message', true, 1, 'none', 'no', 'manual', 1, 'none', 'product', 1, 1, 394940, 1, 1) RETURNING idDate: 2023-04-28 18:19:53
9 1 ERROR: deadlock detected
Times Reported Most Frequent Error / Event #9
Day Hour Count Apr 28 17 1 - ERROR: deadlock detected
Detail: Process 3732029 waits for ShareLock on transaction 108399238; blocked by process 3905262. Process 3905262 waits for ShareLock on transaction 108399222; blocked by process 3732029. Process 3732029: UPDATE "product_product" SET "write_uid"=1237,"write_date"=(now() at time zone 'UTC') WHERE id IN (219784, 220174, 220178, 218901, 220183, 214040, 219680, 218161, 213429, 215733, 216761, 217017, 220219, 218683, 214461, 219850, 219736, 213599, 219750, 214379, 219122) Process 3905262: UPDATE "sale_order_line" SET "invoice_status"='invoiced',"qty_invoiced"='2.00',"qty_to_invoice"='0.00',"untaxed_amount_invoiced"='58.72',"untaxed_amount_to_invoice"='0.00',"write_uid"=971,"write_date"=(now() at time zone 'UTC') WHERE id IN (136699)
Context: while updating tuple (173,104) in relation "product_product"
Hint: See server log for query details.
Statement: UPDATE "product_product" SET "write_uid"=1237,"write_date"=(now() at time zone 'UTC') WHERE id IN (219784, 220174, 220178, 218901, 220183, 214040, 219680, 218161, 213429, 215733, 216761, 217017, 220219, 218683, 214461, 219850, 219736, 213599, 219750, 214379, 219122)Date: 2023-04-28 17:23:47