pgBadger-
Global information
- Generated on Sat Mar 16 00:50:17 2024
- Log file: /var/log/postgresql/postgresql-14-main.log
- Parsed 180,340 log entries in 16s
- Log start from 2024-03-15 00:00:20 to 2024-03-15 23:55:13
-
Overview
Global Stats
- 1,251 Number of unique normalized queries
- 62,159 Number of queries
- 11h1m36s Total query duration
- 2024-03-15 00:00:20 First query
- 2024-03-15 23:55:13 Last query
- 72 queries/s at 2024-03-15 19:28:50 Query peak
- 11h1m36s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 11h1m36s Execute total duration
- 3,108 Number of events
- 9 Number of unique normalized events
- 2,325 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
- 62,159 Average queries per session
- 11h1m36s 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
- 72 queries/s Query Peak
- 2024-03-15 19:28:50 Date
SELECT Traffic
Key values
- 72 queries/s Query Peak
- 2024-03-15 19:28:50 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 10 queries/s Query Peak
- 2024-03-15 12:43:10 Date
Queries duration
Key values
- 11h1m36s 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) Mar 15 00 617 0ms 1m7s 2s312ms 1m33s 1m34s 1m38s 01 676 0ms 1m7s 2s236ms 1m34s 1m34s 1m35s 02 681 0ms 1m7s 2s226ms 1m34s 1m34s 1m35s 03 388 0ms 1m6s 1s658ms 1m6s 1m32s 1m36s 04 542 0ms 1m8s 2s216ms 1m12s 1m13s 1m35s 05 488 0ms 1m7s 2s434ms 1m7s 1m10s 1m17s 06 512 0ms 1m7s 2s443ms 1m33s 1m37s 1m37s 07 274 0ms 1m6s 2s58ms 1m17s 1m23s 1m35s 08 538 0ms 4m28s 3s295ms 1m36s 1m55s 4m29s 09 510 0ms 4m 3s382ms 1m42s 1m58s 4m44s 10 574 0ms 1m7s 1s940ms 1m20s 1m33s 1m37s 11 3,121 0ms 13s844ms 429ms 44s972ms 1m 1m16s 12 7,978 120ms 32s563ms 445ms 1m45s 1m54s 2m16s 13 7,276 120ms 12s228ms 442ms 1m36s 2m7s 2m27s 14 5,967 120ms 33s322ms 464ms 1m17s 1m31s 1m53s 15 6,936 120ms 1m3s 411ms 1m40s 1m47s 1m49s 16 5,188 120ms 20s818ms 402ms 58s31ms 1m10s 1m57s 17 6,313 120ms 1m5s 480ms 1m36s 1m54s 2m4s 18 5,891 120ms 24s263ms 518ms 1m22s 1m34s 2m16s 19 5,071 120ms 28s245ms 482ms 1m 1m44s 2m39s 20 2,198 120ms 5s376ms 473ms 38s284ms 57s970ms 1m35s 21 102 0ms 1s639ms 410ms 8s735ms 15s468ms 15s468ms 22 93 0ms 510ms 268ms 3s436ms 3s513ms 5s534ms 23 225 0ms 1m7s 1s373ms 21s376ms 1m17s 1m19s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 15 00 478 0 181ms 2s672ms 4s90ms 8s561ms 01 534 0 196ms 3s171ms 5s331ms 7s946ms 02 540 0 197ms 3s75ms 6s642ms 8s67ms 03 326 0 224ms 4s351ms 5s305ms 7s913ms 04 432 0 197ms 2s617ms 4s445ms 9s428ms 05 379 0 177ms 2s331ms 3s430ms 7s382ms 06 403 0 176ms 2s632ms 3s417ms 8s326ms 07 233 0 257ms 4s465ms 6s142ms 7s223ms 08 377 101 1s749ms 7s953ms 54s204ms 4m29s 09 349 101 1s751ms 8s475ms 49s786ms 4m44s 10 465 0 335ms 3s19ms 4s136ms 13s685ms 11 2,332 0 417ms 24s602ms 36s155ms 59s389ms 12 6,052 0 430ms 59s936ms 1m18s 1m43s 13 4,933 0 420ms 57s166ms 1m9s 1m19s 14 4,528 0 476ms 50s550ms 1m4s 1m25s 15 5,125 0 373ms 43s319ms 50s731ms 1m9s 16 4,032 0 395ms 42s200ms 47s610ms 55s270ms 17 4,992 0 443ms 50s496ms 1m11s 1m38s 18 3,810 0 464ms 35s75ms 57s660ms 1m44s 19 3,951 0 483ms 41s100ms 54s69ms 2m21s 20 1,605 0 469ms 21s741ms 26s321ms 56s884ms 21 75 0 408ms 2s435ms 3s431ms 14s954ms 22 92 0 269ms 2s915ms 3s436ms 5s534ms 23 181 0 221ms 2s495ms 3s289ms 8s488ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 15 00 0 0 139 0 9s642ms 28s18ms 1m16s 1m32s 01 1 1 140 0 9s905ms 25s102ms 1m16s 1m33s 02 0 0 140 0 10s66ms 28s48ms 1m16s 1m32s 03 1 0 61 0 9s198ms 15s617ms 25s156ms 1m30s 04 0 2 108 0 10s142ms 26s786ms 1m6s 1m8s 05 0 0 109 0 10s284ms 26s838ms 1m6s 1m7s 06 0 0 109 0 10s824ms 25s206ms 1m6s 1m33s 07 0 2 39 0 12s294ms 0ms 25s180ms 1m16s 08 0 1 59 0 15s610ms 0ms 1m16s 1m33s 09 0 0 60 0 15s616ms 0ms 1m16s 1m32s 10 1 48 60 0 8s786ms 1s549ms 17s151ms 1m31s 11 39 734 15 0 465ms 5s536ms 10s360ms 17s182ms 12 133 1,738 51 0 493ms 13s140ms 22s176ms 33s38ms 13 110 2,175 47 0 491ms 16s710ms 26s681ms 46s180ms 14 82 1,331 21 0 424ms 10s567ms 14s546ms 21s133ms 15 86 1,670 52 0 519ms 12s466ms 24s491ms 54s77ms 16 41 1,090 21 0 427ms 8s687ms 13s850ms 20s357ms 17 39 1,263 16 0 622ms 10s640ms 19s784ms 50s758ms 18 39 2,012 28 0 617ms 18s291ms 38s619ms 58s12ms 19 70 987 60 0 479ms 8s316ms 13s760ms 26s352ms 20 23 564 2 0 486ms 2s979ms 8s519ms 19s 21 0 27 0 0 418ms 0ms 514ms 8s272ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 2 15 26 0 6s245ms 1s919ms 17s343ms 1m16s Day Hour Prepare Bind Bind/Prepare Percentage of prepare Mar 15 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 Mar 15 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 Mar 15 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 Mar 15 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 Mar 15 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) Mar 15 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 Mar 15 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 Mar 15 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 Mar 15 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
- 33 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 21 1m5s 1s380ms 9s445ms 3s100ms update account_move set write_date = write_date where id = ( select id from account_move where journal_id = ? and name != ? and sequence_prefix !~ ? and move_type not in (...) and id != ? and sequence_prefix = ( select sequence_prefix from account_move where journal_id = ? and name != ? and sequence_prefix !~ ? and move_type not in (...) and id != ? order by id desc limit ?) order by sequence_number desc limit ?) returning name;-
UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1283246 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 != 1283246 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;
Date: 2024-03-15 16:07:11
2 1 22s548ms 22s548ms 22s548ms 22s548ms update "stock_quant" set "quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);-
UPDATE "stock_quant" SET "quantity" = 2.0, "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (406112, 421888, 370304, 370307, 50980, 424647, 50983, 349608, 251722, 343853, 443821, 238607, 50960, 337075, 50775, 412153, 51003);
Date: 2024-03-15 17:46:02
-
UPDATE "stock_quant" SET "quantity" = 2.0, "write_uid" = 1280, "write_date" = (now() at time zone 'UTC') WHERE id IN (281475, 443941, 291531, 143180, 348779, 186962, 300530, 429111, 256982, 358839, 429112, 369690, 390907, 143262);
Date: 2024-03-15 17:30:44
-
UPDATE "stock_quant" SET "quantity" = 2.0, "write_uid" = 1280, "write_date" = (now() at time zone 'UTC') WHERE id IN (281475, 443941, 291531, 143180, 348779, 186962, 300530, 429111, 256982, 358839, 429112, 369690, 390907, 143262);
Date: 2024-03-15 17:29:56
3 1 21s446ms 21s446ms 21s446ms 21s446ms 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 (...);-
UPDATE "stock_move" SET "branch_id" = 38, "picking_id" = 366644, "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 (858755, 858756, 858757, 858758, 858760, 858761, 858763, 858764, 858765, 858766, 858767, 858768, 858769, 858771);
Date: 2024-03-15 13:22:01
-
UPDATE "stock_move" SET "branch_id" = 39, "picking_id" = 366906, "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 (859211, 859212, 859213, 859214, 859215, 859216, 859217, 859218);
Date: 2024-03-15 15:26:33
-
UPDATE "stock_move" SET "branch_id" = 50, "picking_id" = 367081, "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 (859523, 859524, 859525, 859526, 859527, 859529, 859530);
Date: 2024-03-15 17:47:00
4 7 21s363ms 1s161ms 7s240ms 3s51ms 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" = 5160618, "write_uid" = 1020, "write_date" = (now() at time zone 'UTC') WHERE id IN (1282386);
Date: 2024-03-15 13:23:57
-
UPDATE "account_move" SET "message_main_attachment_id" = 5161304, "write_uid" = 994, "write_date" = (now() at time zone 'UTC') WHERE id IN (1283010);
Date: 2024-03-15 15:11:59
5 1 9s654ms 9s654ms 9s654ms 9s654ms update "sale_order_line" set "branch_id" = ?, "currency_id" = ?, "cus_date_order" = ?, "cus_part_route" = ?, "cus_user_id" = ?, "inventory_vendor_id" = ?, "is_core" = true, "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 (...);-
UPDATE "sale_order_line" SET "branch_id" = 38, "currency_id" = 2, "cus_date_order" = '2024-03-15 13:12:09', "cus_part_route" = 10, "cus_user_id" = 961, "inventory_vendor_id" = 2931, "is_core" = true, "is_service" = false, "margin" = '-33.18', "margin_percent" = 0.2501130710085934, "order_partner_id" = 36053, "price_reduce" = '22.11', "price_reduce_taxexcl" = '22.11', "price_reduce_taxinc" = '22.11', "price_subtotal" = '-132.66', "price_tax" = 0.0, "price_total" = '-132.66', "purchase_price" = '16.58', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 961, "untaxed_amount_invoiced" = '0.00', "untaxed_amount_to_invoice" = '0.00', "warehouse_id" = 36, "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (361567);
Date: 2024-03-15 13:15:15
-
UPDATE "sale_order_line" SET "branch_id" = 56, "currency_id" = 2, "cus_date_order" = '2024-03-13 17:37:00', "cus_part_route" = 2, "cus_user_id" = 1027, "inventory_vendor_id" = 2931, "is_core" = true, "is_service" = false, "margin" = '131.40', "margin_percent" = 0.24994293540287604, "order_partner_id" = 33735, "price_reduce" = '43.81', "price_reduce_taxexcl" = '43.81', "price_reduce_taxinc" = '43.81', "price_subtotal" = '525.72', "price_tax" = 0.0, "price_total" = '525.72', "purchase_price" = '32.86', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 1027, "untaxed_amount_invoiced" = '0.00', "untaxed_amount_to_invoice" = '0.00', "warehouse_id" = 46, "write_uid" = 1050, "write_date" = (now() at time zone 'UTC') WHERE id IN (361695);
Date: 2024-03-15 14:01:17
-
UPDATE "sale_order_line" SET "branch_id" = 38, "currency_id" = 2, "cus_date_order" = '2024-03-15 13:26:19', "cus_part_route" = 9, "cus_user_id" = 961, "inventory_vendor_id" = 2931, "is_core" = true, "is_service" = false, "margin" = '-25.88', "margin_percent" = 0.25009663703131035, "order_partner_id" = 41925, "price_reduce" = '25.87', "price_reduce_taxexcl" = '25.87', "price_reduce_taxinc" = '25.87', "price_subtotal" = '-103.48', "price_tax" = 0.0, "price_total" = '-103.48', "purchase_price" = '19.40', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 961, "untaxed_amount_invoiced" = '0.00', "untaxed_amount_to_invoice" = '0.00', "warehouse_id" = 36, "write_uid" = 1022, "write_date" = (now() at time zone 'UTC') WHERE id IN (361612);
Date: 2024-03-15 13:26:58
6 1 1s521ms 1s521ms 1s521ms 1s521ms insert into "edi_856_asn_header" ("id", "create_uid", "create_date", "write_uid", "write_date", "asn_date", "asn_number", "asn_time", "config_id", "edi_file", "errors", "inventory_vendor_id", "notes", "ship_date", "ship_time", "vendor_id") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), ?, ?, ?, ?, ?, ?, ?, ?, null, null, ?) returning id;-
INSERT INTO "edi_856_asn_header" ("id", "create_uid", "create_date", "write_uid", "write_date", "asn_date", "asn_number", "asn_time", "config_id", "edi_file", "errors", "inventory_vendor_id", "notes", "ship_date", "ship_time", "vendor_id") VALUES (nextval('edi_856_asn_header_id_seq'), 1, (now() at time zone 'UTC'), 1, (now() at time zone 'UTC'), '2024-03-14', 'FL6674105', '20:30', 2, '1.0" encoding="utf-8" ?> <message> <sender>9093930517</sender> <receiver>HTP004498267</receiver> <testindicator>P</testindicator> <asn_num>FL6674105</asn_num> <asn_date>2024-03-14</asn_date> <asn_time>20:30</asn_time> <act_ship_time>20240314</act_ship_time> <bill_of_land>FL6674105</bill_of_land> <pack_lst>6674105</pack_lst> <packaging_code>Container</packaging_code> <weight_qual>131</weight_qual> <weight_uom>Pound</weight_uom> <scac_code>Conway</scac_code> <transport_code>LTL Less Than Trailer Load</transport_code> <fob>Prepaid by Seller</fob> <o_level>1</o_level> <partys> <party> <ship_from>Gates Corporation</ship_from> <duns>074725037</duns> <qual>SF</qual> <dunns>074725037</dunns> </party> <party> <ship_to>POINT SPRING & DRIVESHAFT CO</ship_to> <qual>ST</qual> <mut_defined>0044982670002</mut_defined> </party> </partys> <orders> <order> <po_number>G-03089</po_number> <po_date>2024-03-11</po_date> <lines> <line> <line_id>1</line_id> <product_code>3VX335</product_code> <units_shipped>1</units_shipped> <uom>EA</uom> </line> <line> <line_id>11</line_id> <product_code>28760</product_code> <units_shipped>2</units_shipped> <uom>EA</uom> </line> <line> <line_id>2</line_id> <product_code>K100579HD</product_code> <units_shipped>2</units_shipped> <uom>EA</uom> </line> <line> <line_id>4</line_id> <product_code>28442</product_code> <units_shipped>1</units_shipped> <uom>EA</uom> </line> <line> <line_id>6</line_id> <product_code>K080585HD</product_code> <units_shipped>4</units_shipped> <uom>EA</uom> </line> <line> <line_id>7</line_id> <product_code>K120911HD</product_code> <units_shipped>1</units_shipped> <uom>EA</uom> </line> <line> <line_id>8</line_id> <product_code>K120911</product_code> <units_shipped>2</units_shipped> <uom>EA</uom> </line> <line> <line_id>9</line_id> <product_code>K060539</product_code> <units_shipped>1</units_shipped> <uom>EA</uom> </line> </lines> </order> </orders> </message>', '', 2978, 'Actual Ship Time : 20240314 Bill of Lading # : FL6674105 Packing List # : 6674105 Packaging Code : Standard Gross Weight : 131 Unit of Measurement : Kilogram SCAC Code : UPS (vendor: SKF) Transportation Code : Air Method of Payment : Collect Ship From : Gates Corporation Duns # : 074725037 Ship To : POINT SPRING & DRIVESHAFT CO Mutually Defined : 0044982670002 ', NULL, NULL, 30608) RETURNING id;
Date: 2024-03-15 03:45:07
-
INSERT INTO "edi_856_asn_header" ("id", "create_uid", "create_date", "write_uid", "write_date", "asn_date", "asn_number", "asn_time", "config_id", "edi_file", "errors", "inventory_vendor_id", "notes", "ship_date", "ship_time", "vendor_id") VALUES (nextval('edi_856_asn_header_id_seq'), 1, (now() at time zone 'UTC'), 1, (now() at time zone 'UTC'), '2024-03-14', '6673596', '18:42', 2, '1.0" encoding="utf-8" ?> <message> <sender>9093930517</sender> <receiver>HTP004498267</receiver> <testindicator>P</testindicator> <asn_num>6673596</asn_num> <asn_date>2024-03-14</asn_date> <asn_time>18:42</asn_time> <act_ship_time>20240314</act_ship_time> <bill_of_land>6673596</bill_of_land> <inv_carr_ref>733315192245</inv_carr_ref> <pack_lst>6673596</pack_lst> <packaging_code>Container</packaging_code> <weight_qual>7</weight_qual> <weight_uom>Pound</weight_uom> <scac_code>Federal Express Ground</scac_code> <transport_code>Parcel Post</transport_code> <fob>Prepaid by Seller</fob> <o_level>1</o_level> <partys> <party> <ship_from>Gates Corporation</ship_from> <duns>832610047</duns> <qual>SF</qual> <dunns>832610047</dunns> </party> <party> <ship_to>POINT SPRING & DRIVESHAFT CO</ship_to> <qual>ST</qual> <mut_defined>0044982670011</mut_defined> </party> </partys> <orders> <order> <po_number>S-00745</po_number> <po_date>2024-03-11</po_date> <lines> <line> <line_id>1</line_id> <product_code>G25170-0404</product_code> <units_shipped>10</units_shipped> <uom>EA</uom> </line> <line> <line_id>2</line_id> <product_code>G25170-1212</product_code> <units_shipped>4</units_shipped> <uom>EA</uom> </line> <line> <line_id>3</line_id> <product_code>G25105-0608</product_code> <units_shipped>5</units_shipped> <uom>EA</uom> </line> <line> <line_id>4</line_id> <product_code>G25170-0606</product_code> <units_shipped>5</units_shipped> <uom>EA</uom> </line> </lines> </order> </orders> </message>', '', 2978, 'Actual Ship Time : 20240314 Bill of Lading # : 6673596 PRO/Invoice Carrier''s Reference # : 733315192245 Packing List # : 6673596 Packaging Code : Standard Gross Weight : 7 Unit of Measurement : Kilogram SCAC Code : UPS (vendor: SKF) Transportation Code : Air Method of Payment : Collect Ship From : Gates Corporation Duns # : 832610047 Ship To : POINT SPRING & DRIVESHAFT CO Mutually Defined : 0044982670011 ', NULL, NULL, 30608) RETURNING id;
Date: 2024-03-15 01:45:02
-
INSERT INTO "edi_856_asn_header" ("id", "create_uid", "create_date", "write_uid", "write_date", "asn_date", "asn_number", "asn_time", "config_id", "edi_file", "errors", "inventory_vendor_id", "notes", "ship_date", "ship_time", "vendor_id") VALUES (nextval('edi_856_asn_header_id_seq'), 1, (now() at time zone 'UTC'), 1, (now() at time zone 'UTC'), '2024-03-14', 'FL6674105', '20:30', 2, '1.0" encoding="utf-8" ?> <message> <sender>9093930517</sender> <receiver>HTP004498267</receiver> <testindicator>P</testindicator> <asn_num>FL6674105</asn_num> <asn_date>2024-03-14</asn_date> <asn_time>20:30</asn_time> <act_ship_time>20240314</act_ship_time> <bill_of_land>FL6674105</bill_of_land> <pack_lst>6674105</pack_lst> <packaging_code>Container</packaging_code> <weight_qual>131</weight_qual> <weight_uom>Pound</weight_uom> <scac_code>Conway</scac_code> <transport_code>LTL Less Than Trailer Load</transport_code> <fob>Prepaid by Seller</fob> <o_level>1</o_level> <partys> <party> <ship_from>Gates Corporation</ship_from> <duns>074725037</duns> <qual>SF</qual> <dunns>074725037</dunns> </party> <party> <ship_to>POINT SPRING & DRIVESHAFT CO</ship_to> <qual>ST</qual> <mut_defined>0044982670002</mut_defined> </party> </partys> <orders> <order> <po_number>G-03089</po_number> <po_date>2024-03-11</po_date> <lines> <line> <line_id>1</line_id> <product_code>3VX335</product_code> <units_shipped>1</units_shipped> <uom>EA</uom> </line> <line> <line_id>11</line_id> <product_code>28760</product_code> <units_shipped>2</units_shipped> <uom>EA</uom> </line> <line> <line_id>2</line_id> <product_code>K100579HD</product_code> <units_shipped>2</units_shipped> <uom>EA</uom> </line> <line> <line_id>4</line_id> <product_code>28442</product_code> <units_shipped>1</units_shipped> <uom>EA</uom> </line> <line> <line_id>6</line_id> <product_code>K080585HD</product_code> <units_shipped>4</units_shipped> <uom>EA</uom> </line> <line> <line_id>7</line_id> <product_code>K120911HD</product_code> <units_shipped>1</units_shipped> <uom>EA</uom> </line> <line> <line_id>8</line_id> <product_code>K120911</product_code> <units_shipped>2</units_shipped> <uom>EA</uom> </line> <line> <line_id>9</line_id> <product_code>K060539</product_code> <units_shipped>1</units_shipped> <uom>EA</uom> </line> </lines> </order> </orders> </message>', '', 2978, 'Actual Ship Time : 20240314 Bill of Lading # : FL6674105 Packing List # : 6674105 Packaging Code : Standard Gross Weight : 131 Unit of Measurement : Kilogram SCAC Code : UPS (vendor: SKF) Transportation Code : Air Method of Payment : Collect Ship From : Gates Corporation Duns # : 074725037 Ship To : POINT SPRING & DRIVESHAFT CO Mutually Defined : 0044982670002 ', NULL, NULL, 30608) RETURNING id;
Date: 2024-03-15 03:45:07
7 1 1s346ms 1s346ms 1s346ms 1s346ms insert into "account_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "asset_id", "auto_post", "branch_id", "campaign_id", "carrier_id", "commercial_partner_id", "company_id", "currency_id", "date", "discount_amount_applied", "edi_billed", "edi_split_lock", "expense_choice", "extract_remote_id", "extract_state", "fiscal_position_id", "invoice_cash_rounding_id", "invoice_date", "invoice_date_due", "invoice_incoterm_id", "invoice_origin", "invoice_origin_new", "invoice_payment_term_id", "invoice_product_qty", "invoice_user_id", "is_edi_bill", "is_move_sent", "journal_id", "medium_id", "move_type", "narration", "open_invoice", "order_type", "partner_bank_id", "partner_id", "partner_shipping_id", "payment_reference", "ref", "source_id", "state", "team_id", "to_check", "to_check_negative") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), null, false, ?, null, ?, ?, ?, ?, ?, ?.?, false, false, null, ?, ?, null, null, null, ?, null, ?, ?, ?, ?.?, ?, false, false, ?, null, ?, ?, false, ?, ?, ?, ?, ?, ?, null, ?, ?, false, false) returning id;-
INSERT INTO "account_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "asset_id", "auto_post", "branch_id", "campaign_id", "carrier_id", "commercial_partner_id", "company_id", "currency_id", "date", "discount_amount_applied", "edi_billed", "edi_split_lock", "expense_choice", "extract_remote_id", "extract_state", "fiscal_position_id", "invoice_cash_rounding_id", "invoice_date", "invoice_date_due", "invoice_incoterm_id", "invoice_origin", "invoice_origin_new", "invoice_payment_term_id", "invoice_product_qty", "invoice_user_id", "is_edi_bill", "is_move_sent", "journal_id", "medium_id", "move_type", "narration", "open_invoice", "order_type", "partner_bank_id", "partner_id", "partner_shipping_id", "payment_reference", "ref", "source_id", "state", "team_id", "to_check", "to_check_negative") VALUES (nextval('account_move_id_seq'), 1267, (now() at time zone 'UTC'), 1267, (now() at time zone 'UTC'), NULL, false, 44, NULL, 1, 33886, 1, 2, '2024-03-15', 0.0, false, false, NULL, - 1, 'no_extract_requested', NULL, NULL, NULL, '2024-04-14', NULL, 'B-09239', 'sale.order,121724', 94, 1.0, 983, false, false, 1, NULL, 'out_invoice', '', false, 'sale', 1, 33886, 35515, '', '114-448960', NULL, 'draft', 1, false, false) RETURNING id;
Date: 2024-03-15 13:22:49
Queries that waited the most
Rank Wait time Query 1 22s548ms UPDATE "stock_quant" SET "quantity" = 13.0, "write_uid" = 1047, "write_date" = (now() at time zone 'UTC') WHERE id IN (376277);[ Date: 2024-03-15 19:49:16 ]
2 21s446ms UPDATE "stock_move" SET "branch_id" = 38, "picking_id" = 366653, "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 (858778, 858779);[ Date: 2024-03-15 13:23:10 ]
3 9s654ms UPDATE "sale_order_line" SET "branch_id" = 38, "currency_id" = 2, "cus_date_order" = '2024-03-15 13:21:17', "cus_part_route" = 9, "cus_user_id" = 961, "inventory_vendor_id" = 2931, "is_core" = true, "is_service" = false, "margin" = '-12.94', "margin_percent" = 0.25009663703131035, "order_partner_id" = 35398, "price_reduce" = '25.87', "price_reduce_taxexcl" = '25.87', "price_reduce_taxinc" = '25.87', "price_subtotal" = '-51.74', "price_tax" = 0.0, "price_total" = '-51.74', "purchase_price" = '19.40', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 961, "untaxed_amount_invoiced" = '0.00', "untaxed_amount_to_invoice" = '0.00', "warehouse_id" = 36, "write_uid" = 1022, "write_date" = (now() at time zone 'UTC') WHERE id IN (361595);[ Date: 2024-03-15 13:22:13 ]
4 9s445ms 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 != 1282420 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 != 1282420 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-03-15 13:26:32 ]
5 7s240ms UPDATE "account_move" SET "message_main_attachment_id" = 5160618, "write_uid" = 1020, "write_date" = (now() at time zone 'UTC') WHERE id IN (1282386);[ Date: 2024-03-15 13:23:57 ]
6 4s891ms 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 != 1282219 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 != 1282219 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-03-15 12:55:44 ]
7 4s711ms 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 != 1283832 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 != 1283832 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-03-15 18:11:24 ]
8 4s21ms 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 != 1282847 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 != 1282847 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-03-15 14:37:45 ]
9 4s18ms 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 != 1282090 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 != 1282090 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-03-15 12:31:13 ]
10 3s967ms UPDATE "account_move" SET "message_main_attachment_id" = 5160657, "write_uid" = 1245, "write_date" = (now() at time zone 'UTC') WHERE id IN (1282428);[ Date: 2024-03-15 13:26:32 ]
11 3s867ms 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 != 1282427 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 != 1282427 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-03-15 13:26:19 ]
12 3s768ms 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 != 1282492 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 != 1282492 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-03-15 13:32:20 ]
13 3s678ms UPDATE "account_move" SET "message_main_attachment_id" = 5160645, "write_uid" = 1047, "write_date" = (now() at time zone 'UTC') WHERE id IN (1282420);[ Date: 2024-03-15 13:26:19 ]
14 3s432ms 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 != 1282391 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 != 1282391 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-03-15 13:24:10 ]
15 3s176ms 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 != 1283246 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 != 1283246 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-03-15 16:07:11 ]
16 2s979ms 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 != 1282729 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 != 1282729 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-03-15 14:11:10 ]
17 2s916ms 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 != 1284145 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 != 1284145 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-03-15 19:21:27 ]
18 2s752ms 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 != 1283977 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 != 1283977 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-03-15 18:48:50 ]
19 2s666ms UPDATE "account_move" SET "message_main_attachment_id" = 5160597, "write_uid" = 1267, "write_date" = (now() at time zone 'UTC') WHERE id IN (1282358);[ Date: 2024-03-15 13:23:12 ]
20 2s433ms 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 != 1283011 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 != 1283011 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2024-03-15 15:11:51 ]
-
Queries
Queries by type
Key values
- 46,224 Total read queries
- 15,935 Total write queries
Queries by database
Key values
- unknown Main database
- 62,159 Requests
- 11h1m36s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 62,252 Requests
User Request type Count Duration unknown Total 62,252 11h5m45s copy to 202 23m45s cte 43 10s837ms delete 1,383 3h29m52s insert 667 2m47s select 46,296 5h18m7s update 13,661 1h51m2s Duration by user
Key values
- 11h5m45s (unknown) Main time consuming user
User Request type Count Duration unknown Total 62,252 11h5m45s copy to 202 23m45s cte 43 10s837ms delete 1,383 3h29m52s insert 667 2m47s select 46,296 5h18m7s update 13,661 1h51m2s Queries by host
Key values
- unknown Main host
- 62,252 Requests
- 11h5m45s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 62,159 Requests
- 11h1m36s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2024-03-15 18:09:59 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 43,996 100-500ms duration
Slowest individual queries
Rank Duration Query 1 4m28s COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2024-03-15 08:18:53 ]
2 4m COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2024-03-15 09:09:14 ]
3 1m46s COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;[ Date: 2024-03-15 08:12:36 ]
4 1m45s COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;[ Date: 2024-03-15 09:03:25 ]
5 1m39s COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;[ Date: 2024-03-15 09:05:13 ]
6 1m38s COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;[ Date: 2024-03-15 08:14:24 ]
7 1m8s DELETE FROM account_move_line WHERE id IN (4335484, 4335485, 4335486, 4335487, 4335488, 4335489, 4335490, 4335491, 4335492, 4346964, 4346965, 4346966, 4346967, 4346968, 4346969, 4346970, 4346971, 4346972, 4356382, 4356383, 4356384, 4356385, 4356386, 4356387, 4356437, 4356438, 4356439, 4356440, 4356441, 4356442, 4365977, 4365978, 4365979, 4365980, 4365981, 4365982, 4365983, 4365984, 4365985, 4365986, 4365987, 4365988, 4365989);[ Date: 2024-03-15 04:07:58 ]
8 1m8s DELETE FROM account_move_line WHERE id IN (4335484, 4335485, 4335486, 4335487, 4335488, 4335489, 4335490, 4335491, 4335492, 4346964, 4346965, 4346966, 4346967, 4346968, 4346969, 4346970, 4346971, 4346972, 4356382, 4356383, 4356384, 4356385, 4356386, 4356387, 4356437, 4356438, 4356439, 4356440, 4356441, 4356442, 4365977, 4365978, 4365979, 4365980, 4365981, 4365982, 4365983, 4365984, 4365985, 4365986, 4365987, 4365988, 4365989);[ Date: 2024-03-15 04:55:56 ]
9 1m7s DELETE FROM account_move_line WHERE id IN (4335484, 4335485, 4335486, 4335487, 4335488, 4335489, 4335490, 4335491, 4335492, 4346964, 4346965, 4346966, 4346967, 4346968, 4346969, 4346970, 4346971, 4346972, 4356382, 4356383, 4356384, 4356385, 4356386, 4356387, 4356437, 4356438, 4356439, 4356440, 4356441, 4356442, 4365977, 4365978, 4365979, 4365980, 4365981, 4365982, 4365983, 4365984, 4365985, 4365986, 4365987, 4365988, 4365989);[ Date: 2024-03-15 09:01:30 ]
10 1m7s DELETE FROM account_move_line WHERE id IN (4335484, 4335485, 4335486, 4335487, 4335488, 4335489, 4335490, 4335491, 4335492, 4346964, 4346965, 4346966, 4346967, 4346968, 4346969, 4346970, 4346971, 4346972, 4356382, 4356383, 4356384, 4356385, 4356386, 4356387, 4356437, 4356438, 4356439, 4356440, 4356441, 4356442, 4365977, 4365978, 4365979, 4365980, 4365981, 4365982, 4365983, 4365984, 4365985, 4365986, 4365987, 4365988, 4365989);[ Date: 2024-03-15 09:56:14 ]
11 1m7s DELETE FROM account_move_line WHERE id IN (4335484, 4335485, 4335486, 4335487, 4335488, 4335489, 4335490, 4335491, 4335492, 4346964, 4346965, 4346966, 4346967, 4346968, 4346969, 4346970, 4346971, 4346972, 4356382, 4356383, 4356384, 4356385, 4356386, 4356387, 4356437, 4356438, 4356439, 4356440, 4356441, 4356442, 4365977, 4365978, 4365979, 4365980, 4365981, 4365982, 4365983, 4365984, 4365985, 4365986, 4365987, 4365988, 4365989);[ Date: 2024-03-15 09:07:22 ]
12 1m7s DELETE FROM account_move_line WHERE id IN (4335484, 4335485, 4335486, 4335487, 4335488, 4335489, 4335490, 4335491, 4335492, 4346964, 4346965, 4346966, 4346967, 4346968, 4346969, 4346970, 4346971, 4346972, 4356382, 4356383, 4356384, 4356385, 4356386, 4356387, 4356437, 4356438, 4356439, 4356440, 4356441, 4356442, 4365977, 4365978, 4365979, 4365980, 4365981, 4365982, 4365983, 4365984, 4365985, 4365986, 4365987, 4365988, 4365989);[ Date: 2024-03-15 08:55:31 ]
13 1m7s DELETE FROM account_move_line WHERE id IN (4335484, 4335485, 4335486, 4335487, 4335488, 4335489, 4335490, 4335491, 4335492, 4346964, 4346965, 4346966, 4346967, 4346968, 4346969, 4346970, 4346971, 4346972, 4356382, 4356383, 4356384, 4356385, 4356386, 4356387, 4356437, 4356438, 4356439, 4356440, 4356441, 4356442, 4365977, 4365978, 4365979, 4365980, 4365981, 4365982, 4365983, 4365984, 4365985, 4365986, 4365987, 4365988, 4365989);[ Date: 2024-03-15 08:13:25 ]
14 1m7s DELETE FROM account_move_line WHERE id IN (4335484, 4335485, 4335486, 4335487, 4335488, 4335489, 4335490, 4335491, 4335492, 4346964, 4346965, 4346966, 4346967, 4346968, 4346969, 4346970, 4346971, 4346972, 4356382, 4356383, 4356384, 4356385, 4356386, 4356387, 4356437, 4356438, 4356439, 4356440, 4356441, 4356442, 4365977, 4365978, 4365979, 4365980, 4365981, 4365982, 4365983, 4365984, 4365985, 4365986, 4365987, 4365988, 4365989);[ Date: 2024-03-15 10:55:49 ]
15 1m7s DELETE FROM account_move_line WHERE id IN (4335484, 4335485, 4335486, 4335487, 4335488, 4335489, 4335490, 4335491, 4335492, 4346964, 4346965, 4346966, 4346967, 4346968, 4346969, 4346970, 4346971, 4346972, 4356382, 4356383, 4356384, 4356385, 4356386, 4356387, 4356437, 4356438, 4356439, 4356440, 4356441, 4356442, 4365977, 4365978, 4365979, 4365980, 4365981, 4365982, 4365983, 4365984, 4365985, 4365986, 4365987, 4365988, 4365989);[ Date: 2024-03-15 06:02:01 ]
16 1m7s DELETE FROM account_move_line WHERE id IN (4335484, 4335485, 4335486, 4335487, 4335488, 4335489, 4335490, 4335491, 4335492, 4346964, 4346965, 4346966, 4346967, 4346968, 4346969, 4346970, 4346971, 4346972, 4356382, 4356383, 4356384, 4356385, 4356386, 4356387, 4356437, 4356438, 4356439, 4356440, 4356441, 4356442, 4365977, 4365978, 4365979, 4365980, 4365981, 4365982, 4365983, 4365984, 4365985, 4365986, 4365987, 4365988, 4365989);[ Date: 2024-03-15 02:08:23 ]
17 1m7s DELETE FROM account_move_line WHERE id IN (4335484, 4335485, 4335486, 4335487, 4335488, 4335489, 4335490, 4335491, 4335492, 4346964, 4346965, 4346966, 4346967, 4346968, 4346969, 4346970, 4346971, 4346972, 4356382, 4356383, 4356384, 4356385, 4356386, 4356387, 4356437, 4356438, 4356439, 4356440, 4356441, 4356442, 4365977, 4365978, 4365979, 4365980, 4365981, 4365982, 4365983, 4365984, 4365985, 4365986, 4365987, 4365988, 4365989);[ Date: 2024-03-15 08:19:27 ]
18 1m7s DELETE FROM account_move_line WHERE id IN (4335484, 4335485, 4335486, 4335487, 4335488, 4335489, 4335490, 4335491, 4335492, 4346964, 4346965, 4346966, 4346967, 4346968, 4346969, 4346970, 4346971, 4346972, 4356382, 4356383, 4356384, 4356385, 4356386, 4356387, 4356437, 4356438, 4356439, 4356440, 4356441, 4356442, 4365977, 4365978, 4365979, 4365980, 4365981, 4365982, 4365983, 4365984, 4365985, 4365986, 4365987, 4365988, 4365989);[ Date: 2024-03-15 05:55:52 ]
19 1m7s DELETE FROM account_move_line WHERE id IN (4335484, 4335485, 4335486, 4335487, 4335488, 4335489, 4335490, 4335491, 4335492, 4346964, 4346965, 4346966, 4346967, 4346968, 4346969, 4346970, 4346971, 4346972, 4356382, 4356383, 4356384, 4356385, 4356386, 4356387, 4356437, 4356438, 4356439, 4356440, 4356441, 4356442, 4365977, 4365978, 4365979, 4365980, 4365981, 4365982, 4365983, 4365984, 4365985, 4365986, 4365987, 4365988, 4365989);[ Date: 2024-03-15 02:50:22 ]
20 1m7s DELETE FROM account_move_line WHERE id IN (4335484, 4335485, 4335486, 4335487, 4335488, 4335489, 4335490, 4335491, 4335492, 4346964, 4346965, 4346966, 4346967, 4346968, 4346969, 4346970, 4346971, 4346972, 4356382, 4356383, 4356384, 4356385, 4356386, 4356387, 4356437, 4356438, 4356439, 4356440, 4356441, 4356442, 4365977, 4365978, 4365979, 4365980, 4365981, 4365982, 4365983, 4365984, 4365985, 4365986, 4365987, 4365988, 4365989);[ Date: 2024-03-15 02:56:30 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h52m19s 699 1s526ms 1m8s 14s792ms delete from account_move_line where id in (...);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 15 00 89 18m50s 12s702ms 01 90 19m56s 13s294ms 02 90 19m59s 13s325ms 03 39 8m 12s317ms 04 69 15m45s 13s707ms 05 69 15m43s 13s679ms 06 70 16m50s 14s442ms 07 25 7m19s 17s583ms 08 39 13m59s 21s537ms 09 40 14m1s 21s34ms 10 39 13m45s 21s164ms 11 1 1s572ms 1s572ms 12 4 18s499ms 4s624ms 13 3 7s932ms 2s644ms 14 1 4s977ms 4s977ms 15 4 1m17s 19s334ms 16 3 25s685ms 8s561ms 17 2 1m11s 35s832ms 18 3 11s295ms 3s765ms 19 2 31s376ms 15s688ms 23 17 3m55s 13s856ms -
DELETE FROM account_move_line WHERE id IN (4335484, 4335485, 4335486, 4335487, 4335488, 4335489, 4335490, 4335491, 4335492, 4346964, 4346965, 4346966, 4346967, 4346968, 4346969, 4346970, 4346971, 4346972, 4356382, 4356383, 4356384, 4356385, 4356386, 4356387, 4356437, 4356438, 4356439, 4356440, 4356441, 4356442, 4365977, 4365978, 4365979, 4365980, 4365981, 4365982, 4365983, 4365984, 4365985, 4365986, 4365987, 4365988, 4365989);
Date: 2024-03-15 04:07:58 Duration: 1m8s
-
DELETE FROM account_move_line WHERE id IN (4335484, 4335485, 4335486, 4335487, 4335488, 4335489, 4335490, 4335491, 4335492, 4346964, 4346965, 4346966, 4346967, 4346968, 4346969, 4346970, 4346971, 4346972, 4356382, 4356383, 4356384, 4356385, 4356386, 4356387, 4356437, 4356438, 4356439, 4356440, 4356441, 4356442, 4365977, 4365978, 4365979, 4365980, 4365981, 4365982, 4365983, 4365984, 4365985, 4365986, 4365987, 4365988, 4365989);
Date: 2024-03-15 04:55:56 Duration: 1m8s
-
DELETE FROM account_move_line WHERE id IN (4335484, 4335485, 4335486, 4335487, 4335488, 4335489, 4335490, 4335491, 4335492, 4346964, 4346965, 4346966, 4346967, 4346968, 4346969, 4346970, 4346971, 4346972, 4356382, 4356383, 4356384, 4356385, 4356386, 4356387, 4356437, 4356438, 4356439, 4356440, 4356441, 4356442, 4365977, 4365978, 4365979, 4365980, 4365981, 4365982, 4365983, 4365984, 4365985, 4365986, 4365987, 4365988, 4365989);
Date: 2024-03-15 09:01:30 Duration: 1m7s
2 1h11m19s 13,447 120ms 2s124ms 318ms select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 15 00 65 22s884ms 352ms 01 124 40s719ms 328ms 02 120 40s616ms 338ms 03 135 43s910ms 325ms 04 131 38s62ms 290ms 05 77 20s484ms 266ms 06 102 24s560ms 240ms 07 83 28s760ms 346ms 08 149 50s154ms 336ms 09 159 59s817ms 376ms 10 134 30s47ms 224ms 11 589 2m41s 274ms 12 1,973 10m13s 311ms 13 1,633 7m53s 289ms 14 1,623 7m23s 273ms 15 1,304 6m58s 321ms 16 1,089 5m38s 310ms 17 1,297 5m34s 257ms 18 1,205 7m27s 371ms 19 992 8m16s 500ms 20 319 1m53s 356ms 21 29 7s235ms 249ms 22 86 23s572ms 274ms 23 29 6s675ms 230ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-15 19:27:58') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1031"', '["pointspring_master","calendar.alarm",19569]', '["pointspring_master","mail.channel",121]', '["pointspring_master","mail.channel",122]', '["pointspring_master","mail.channel",454]', '["pointspring_master","mail.channel",521]', '["pointspring_master","mail.channel",585]', '["pointspring_master","mail.channel",586]', '["pointspring_master","res.partner",19569]', '["pointspring_master","ir.needaction",19569]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-15 19:28:50 Duration: 2s124ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-15 19:27:58') AND ("bus_bus"."channel" in ('"bundle_changed"', '["pointspring_master","calendar.alarm",19563]', '["pointspring_master","mail.channel",249]', '["pointspring_master","mail.channel",250]', '["pointspring_master","mail.channel",251]', '["pointspring_master","mail.channel",451]', '["pointspring_master","mail.channel",460]', '["pointspring_master","mail.channel",513]', '["pointspring_master","res.partner",19563]', '["pointspring_master","ir.needaction",19563]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-15 19:28:50 Duration: 2s115ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-15 19:27:58') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1267"', '["pointspring_master","calendar.alarm",52604]', '["pointspring_master","res.partner",52604]', '["pointspring_master","ir.needaction",52604]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-15 19:28:50 Duration: 2s109ms
3 44m50s 3,865 604ms 2s445ms 696ms 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 Mar 15 10 10 6s460ms 646ms 11 161 1m51s 694ms 12 582 6m57s 717ms 13 502 5m51s 699ms 14 472 5m25s 688ms 15 374 4m18s 692ms 16 275 3m7s 682ms 17 463 5m23s 698ms 18 465 5m29s 708ms 19 353 4m1s 683ms 20 187 2m3s 659ms 21 11 7s102ms 645ms 23 10 6s408ms 640ms -
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 ('%%ubw7%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%ubw7%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%ubw7%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-15 18:30:06 Duration: 2s445ms
-
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 ('%%3434%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%343-4%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%343-4%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-15 18:30:06 Duration: 2s378ms
-
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 ('%%ubw70%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%ubw70%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%ubw70%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-15 18:30:06 Duration: 2s126ms
4 27m10s 378 1s582ms 8s440ms 4s312ms delete from account_move where id in (...);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 15 00 50 3m29s 4s195ms 01 50 3m29s 4s188ms 02 50 3m30s 4s200ms 03 22 1m28s 4s19ms 04 39 2m49s 4s338ms 05 40 2m57s 4s427ms 06 39 2m48s 4s329ms 07 14 1m3s 4s560ms 08 20 1m35s 4s797ms 09 20 1m35s 4s779ms 10 20 1m36s 4s823ms 15 2 8s282ms 4s141ms 16 1 3s276ms 3s276ms 17 1 3s205ms 3s205ms 19 1 3s203ms 3s203ms 23 9 27s508ms 3s56ms -
DELETE FROM account_move WHERE id IN (1240817, 1244356, 1247269, 1247291, 1250038);
Date: 2024-03-15 04:14:02 Duration: 8s440ms
-
DELETE FROM account_move WHERE id IN (1240817, 1244356, 1247269, 1247291, 1250038);
Date: 2024-03-15 06:44:12 Duration: 8s243ms
-
DELETE FROM account_move WHERE id IN (1240817, 1244356, 1247269, 1247291, 1250038);
Date: 2024-03-15 06:56:17 Duration: 8s184ms
5 16m59s 1,459 616ms 1s934ms 698ms 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 #5
Day Hour Count Duration Avg duration Mar 15 11 91 1m1s 678ms 12 226 2m43s 721ms 13 89 1m6s 741ms 14 9 6s84ms 676ms 15 158 1m49s 693ms 16 232 2m44s 710ms 17 282 3m16s 695ms 18 217 2m28s 682ms 19 51 34s42ms 667ms 20 104 1m9s 666ms -
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 ('%%12x%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%1/2x%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%1/2x%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-15 16:56:52 Duration: 1s934ms
-
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 ('%%N228437%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%N2-28-437%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%N2-28-437%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-15 13:41:58 Duration: 1s531ms
-
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 ('%%N22843%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%N2-28-43%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%N2-28-43%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-15 13:41:57 Duration: 1s455ms
6 16m20s 2,573 352ms 757ms 381ms 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 #6
Day Hour Count Duration Avg duration Mar 15 00 3 1s71ms 357ms 02 7 2s534ms 362ms 05 1 356ms 356ms 07 5 1s786ms 357ms 08 21 7s654ms 364ms 10 19 6s969ms 366ms 11 254 1m33s 367ms 12 411 2m40s 391ms 13 340 2m11s 388ms 14 241 1m30s 376ms 15 250 1m36s 384ms 16 251 1m34s 377ms 17 276 1m47s 388ms 18 215 1m21s 379ms 19 158 59s934ms 379ms 20 111 40s719ms 366ms 21 7 2s502ms 357ms 23 3 1s71ms 357ms -
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.report_assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-5826980/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-15 17:06:27 Duration: 757ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_backend.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-03cb21f/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-15 13:23:08 Duration: 747ms
-
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/%-fb6cd24/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-15 17:34:20 Duration: 745ms
7 10m39s 744 792ms 1s453ms 859ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (("product_template"."is_core" is null or "product_template"."is_core" = false) and (("product_template"."type" in (...)) and (((((unaccent ("product_template"."default_code"::text) ilike unaccent (?)) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null)))) or unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?)) or false) or (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent (?)))))) and (("product_template"."company_id" in (...)) or "product_template"."company_id" is null) order by coalesce("product_template__name"."value", "product_template"."name") limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 15 10 8 6s518ms 814ms 11 33 27s512ms 833ms 12 118 1m44s 881ms 13 98 1m24s 860ms 14 132 1m52s 851ms 15 77 1m6s 864ms 16 64 54s68ms 844ms 17 102 1m29s 873ms 18 46 40s25ms 870ms 19 42 35s464ms 844ms 20 23 18s995ms 825ms 23 1 808ms 808ms -
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 ('%tra-2726%')) 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 ('%tra-2726%'))) 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 ('%tra-2726%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%tra-2726%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2024-03-15 13:23:56 Duration: 1s453ms
-
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 ('%hbv125%')) 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 ('%hbv125%'))) 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 ('%hbv125%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%hbv125%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2024-03-15 17:54:00 Duration: 1s373ms
-
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 ('%338-758a%')) 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 ('%338-758a%'))) 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 ('%338-758a%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%338-758a%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2024-03-15 12:51:16 Duration: 1s369ms
8 10m13s 691 303ms 3s863ms 888ms 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 Mar 15 10 4 3s172ms 793ms 11 31 24s950ms 804ms 12 85 1m13s 865ms 13 114 1m49s 959ms 14 63 52s120ms 827ms 15 92 1m22s 898ms 16 34 30s590ms 899ms 17 74 1m12s 973ms 18 104 1m24s 810ms 19 58 49s151ms 847ms 20 30 29s531ms 984ms 21 2 2s291ms 1s145ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 1.0, "date" = '2024-03-15 15:26:59', "is_done" = true, "state" = 'done', "write_uid" = 1043, "write_date" = (now() at time zone 'UTC') WHERE id IN (859212, 859213, 859215, 859216, 859217);
Date: 2024-03-15 15:27:08 Duration: 3s863ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 8.0, "date" = '2024-03-15 13:32:23', "is_done" = true, "state" = 'done', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (849676, 849684);
Date: 2024-03-15 13:32:46 Duration: 2s471ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 6.0, "date" = '2024-03-15 13:32:23', "is_done" = true, "state" = 'done', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (849672, 849666);
Date: 2024-03-15 13:32:37 Duration: 2s426ms
9 9m5s 510 959ms 2s208ms 1s69ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and ((("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?)))) order by coalesce("product_template"."is_published", false) desc, "product_template"."website_sequence" asc, "product_template"."id" desc limit ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 15 08 4 3s940ms 985ms 09 3 3s31ms 1s10ms 10 3 2s963ms 987ms 11 35 38s275ms 1s93ms 12 17 18s152ms 1s67ms 13 49 55s151ms 1s125ms 14 18 18s687ms 1s38ms 15 101 1m46s 1s52ms 16 24 24s168ms 1s7ms 17 32 36s547ms 1s142ms 18 97 1m47s 1s108ms 19 97 1m40s 1s32ms 20 30 30s608ms 1s20ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%15-729%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%15-729%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%15-729%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%15-729%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%15-729%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%15-729%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;
Date: 2024-03-15 15:57:01 Duration: 2s208ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%6.5-4-4571-1C%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%6.5-4-4571-1C%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%6.5-4-4571-1C%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%6.5-4-4571-1C%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%6.5-4-4571-1C%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%6.5-4-4571-1C%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;
Date: 2024-03-15 18:40:53 Duration: 2s36ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%6.5-4-4571-%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%6.5-4-4571-%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%6.5-4-4571-%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%6.5-4-4571-%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%6.5-4-4571-%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%6.5-4-4571-%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;
Date: 2024-03-15 18:40:54 Duration: 2s35ms
10 8m55s 510 969ms 2s554ms 1s50ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and ((("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?)))) order by coalesce("product_template"."is_published", false) desc, "product_template"."website_sequence" asc, "product_template"."id" desc;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 15 11 24 24s751ms 1s31ms 12 21 23s925ms 1s139ms 13 39 41s864ms 1s73ms 14 39 40s210ms 1s31ms 15 105 1m50s 1s52ms 16 21 22s24ms 1s48ms 17 30 32s3ms 1s66ms 18 63 1m7s 1s64ms 19 141 2m25s 1s35ms 20 27 27s257ms 1s9ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%e1308e%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%e1308e%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%e1308e%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%e1308e%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%e1308e%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%e1308e%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2024-03-15 18:21:45 Duration: 2s554ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%15-729%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%15-729%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%15-729%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%15-729%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%15-729%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%15-729%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2024-03-15 15:57:01 Duration: 2s147ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%OR275491X%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%OR275491X%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%OR275491X%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%OR275491X%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%OR275491X%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%OR275491X%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2024-03-15 19:57:17 Duration: 2s9ms
11 8m52s 896 145ms 9s770ms 594ms update "stock_quant" set "quantity" = ?.?, "reserved_quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 15 10 4 1s834ms 458ms 11 43 22s155ms 515ms 12 134 1m20s 604ms 13 171 1m45s 616ms 14 82 45s694ms 557ms 15 90 53s698ms 596ms 16 67 38s23ms 567ms 17 59 39s708ms 673ms 18 151 1m29s 591ms 19 56 31s289ms 558ms 20 37 23s190ms 626ms 21 2 1s709ms 854ms -
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (446592, 446593, 446595, 446597, 448529, 449300, 448504, 448379, 448318, 447207, 447209, 447211, 138607, 447219, 447220, 448500, 448502, 448376, 448506, 446587, 446588, 446590);
Date: 2024-03-15 18:08:32 Duration: 9s770ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1001, "write_date" = (now() at time zone 'UTC') WHERE id IN (209163, 174359, 25502, 28063, 23970, 304164, 304166, 304173, 422830, 31279, 264242, 225477, 224070, 31305, 27987, 364503, 25048, 27745, 25058, 27765, 304124);
Date: 2024-03-15 12:43:03 Duration: 9s647ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (222979, 46502, 249311, 319436, 319439, 46514, 213075, 46516, 43031, 408827, 249310, 46495);
Date: 2024-03-15 17:47:16 Duration: 5s473ms
12 8m29s 2 4m 4m28s 4m14s copy public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 15 08 1 4m28s 4m28s 09 1 4m 4m -
COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2024-03-15 08:18:53 Duration: 4m28s
-
COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2024-03-15 09:09:14 Duration: 4m
13 7m48s 906 293ms 1s489ms 516ms select id from product_warehouse_inventory where coalesce(loc_check_qty, ?) < coalesce(max_product_uom_qty, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 15 11 55 20s698ms 376ms 12 55 27s247ms 495ms 13 177 1m23s 471ms 14 46 20s36ms 435ms 18 89 34s95ms 383ms 19 333 3m3s 550ms 20 151 1m39s 658ms -
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2024-03-15 19:33:05 Duration: 1s489ms
-
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2024-03-15 19:33:05 Duration: 1s439ms
-
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2024-03-15 19:33:05 Duration: 1s419ms
14 7m26s 422 952ms 2s88ms 1s57ms select count(?) from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and ((("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?))));Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 15 08 4 3s936ms 984ms 09 3 2s944ms 981ms 10 3 2s943ms 981ms 11 32 34s210ms 1s69ms 12 17 18s853ms 1s109ms 13 37 41s37ms 1s109ms 14 15 15s635ms 1s42ms 15 85 1m30s 1s62ms 16 16 16s137ms 1s8ms 17 22 24s338ms 1s106ms 18 84 1m29s 1s68ms 19 77 1m19s 1s27ms 20 27 27s25ms 1s -
SELECT count(1) FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%15-7%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%15-7%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%15-7%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%15-7%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%15-7%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%15-7%'))));
Date: 2024-03-15 15:57:01 Duration: 2s88ms
-
SELECT count(1) FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%6.5-4-4571%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%6.5-4-4571%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%6.5-4-4571%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%6.5-4-4571%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%6.5-4-4571%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%6.5-4-4571%'))));
Date: 2024-03-15 18:40:54 Duration: 2s45ms
-
SELECT count(1) FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%15-72%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%15-72%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%15-72%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%15-72%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%15-72%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%15-72%'))));
Date: 2024-03-15 15:57:02 Duration: 1s916ms
15 6m51s 628 146ms 24s263ms 654ms update "stock_move" set "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 15 10 5 1s380ms 276ms 11 28 11s304ms 403ms 12 76 53s737ms 707ms 13 101 57s900ms 573ms 14 75 33s67ms 440ms 15 60 37s480ms 624ms 16 46 18s65ms 392ms 17 54 35s84ms 649ms 18 78 1m42s 1s319ms 19 75 41s110ms 548ms 20 27 18s395ms 681ms 21 1 297ms 297ms 23 2 462ms 231ms -
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (859648, 859649, 859650, 859651, 859652, 859653, 859654, 859655, 859656, 859657, 859658, 859659, 859660, 859663, 859607, 859608, 859609, 859610, 859611, 859612, 859613, 859614, 859615, 859616, 859617, 859618, 859619, 859620, 859621, 859622, 859623, 859624, 859625, 859626, 859627, 859628, 859629, 859630, 859631, 859632, 859633, 859634, 859635, 859636, 859637, 859638, 859639, 859640, 859641, 859642, 859643, 859644, 859645, 859646, 859647);
Date: 2024-03-15 18:04:23 Duration: 24s263ms
-
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (859808, 859809, 859810, 859811, 859812, 859813, 859814, 859815, 859816, 859817, 859818, 859819, 859820, 859821, 859822, 859823, 859824, 859825, 859826, 859827, 859828, 859829, 859830, 859831, 859832, 859834, 859835, 859836, 859837, 859838, 859840, 859841);
Date: 2024-03-15 18:56:17 Duration: 15s
-
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 978, "write_date" = (now() at time zone 'UTC') WHERE id IN (859577, 859578, 859579, 859580, 859581, 859582, 859583, 859584, 859585, 859586, 859587, 859588, 859589, 859590, 859591, 859592, 859593, 859594, 859595, 859596, 859597, 859598, 859599);
Date: 2024-03-15 18:01:37 Duration: 10s393ms
16 5m37s 1,947 152ms 462ms 173ms select coalesce(sum(pwi.max_product_uom_qty), ?) as tmq from forecasted_data fd inner join item_supply_plan as isp on isp.id = fd.item_supply_plan_id inner join product_warehouse_inventory pwi on fd.product_id = pwi.product_id and isp.branch_id = pwi.replenish_branch_id where isp.id = ? and fd.product_id = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 15 12 35 6s333ms 180ms 13 40 6s918ms 172ms 14 76 12s798ms 168ms 15 692 1m59s 172ms 16 443 1m16s 172ms 17 445 1m17s 174ms 18 60 11s744ms 195ms 19 132 22s77ms 167ms 20 24 3s933ms 163ms -
SELECT COALESCE(SUM(pwi.max_product_uom_qty), 0) AS TMQ from forecasted_data fd INNER JOIN item_supply_plan AS isp ON isp.id = fd.item_supply_plan_id INNER JOIN product_warehouse_inventory pwi ON fd.product_id = pwi.product_id AND isp.branch_id = pwi.replenish_branch_id where isp.id = 37062 and fd.product_id = 208664;
Date: 2024-03-15 18:40:53 Duration: 462ms
-
SELECT COALESCE(SUM(pwi.max_product_uom_qty), 0) AS TMQ from forecasted_data fd INNER JOIN item_supply_plan AS isp ON isp.id = fd.item_supply_plan_id INNER JOIN product_warehouse_inventory pwi ON fd.product_id = pwi.product_id AND isp.branch_id = pwi.replenish_branch_id where isp.id = 37100 and fd.product_id = 204126;
Date: 2024-03-15 15:30:08 Duration: 350ms
-
SELECT COALESCE(SUM(pwi.max_product_uom_qty), 0) AS TMQ from forecasted_data fd INNER JOIN item_supply_plan AS isp ON isp.id = fd.item_supply_plan_id INNER JOIN product_warehouse_inventory pwi ON fd.product_id = pwi.product_id AND isp.branch_id = pwi.replenish_branch_id where isp.id = 37244 and fd.product_id = 220009;
Date: 2024-03-15 17:06:26 Duration: 335ms
17 5m31s 259 175ms 18s471ms 1s281ms 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 #17
Day Hour Count Duration Avg duration Mar 15 11 17 17s612ms 1s36ms 12 43 1m5s 1s519ms 13 49 45s115ms 920ms 14 23 27s911ms 1s213ms 15 32 45s417ms 1s419ms 16 22 20s502ms 931ms 17 20 30s175ms 1s508ms 18 30 51s510ms 1s717ms 19 14 14s823ms 1s58ms 20 9 13s480ms 1s497ms -
UPDATE "stock_move" SET "date" = '2024-03-15 18:07:35', "is_done" = true, "state" = 'done', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (859649, 859654, 859661, 859662, 859663, 859613, 859614, 859615, 859616, 859617, 859619, 859620, 859622, 859631, 859632, 859633, 859634, 859635, 859636, 859637, 859638, 859639, 859640, 859641);
Date: 2024-03-15 18:09:04 Duration: 18s471ms
-
UPDATE "stock_move" SET "date" = '2024-03-15 12:42:32', "is_done" = true, "state" = 'done', "write_uid" = 1001, "write_date" = (now() at time zone 'UTC') WHERE id IN (858543, 858544, 858545, 858546, 858547, 858548, 858549, 858550, 858551, 858552, 858553, 858554, 858555, 858556, 858557, 858558, 858559, 858560, 858561, 858562, 858563, 858564);
Date: 2024-03-15 12:42:50 Duration: 17s633ms
-
UPDATE "stock_move" SET "date" = '2024-03-15 17:46:59', "is_done" = true, "state" = 'done', "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (859488, 859489, 859490, 859491, 859492, 859493, 859494, 859495, 859496, 859497, 859498, 859499);
Date: 2024-03-15 17:47:09 Duration: 9s634ms
18 5m31s 2,157 132ms 238ms 153ms select "account_move".id from "account_move" where (("account_move"."edi_810_id" in (...)) and (("account_move"."id" not in (...)) or "account_move"."id" is null)) order by "account_move"."invoice_date_due";Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 15 00 300 45s949ms 153ms 01 296 45s73ms 152ms 02 300 45s999ms 153ms 03 131 20s122ms 153ms 04 209 32s149ms 153ms 05 210 32s370ms 154ms 06 210 32s481ms 154ms 07 86 13s40ms 151ms 08 117 18s109ms 154ms 09 120 18s537ms 154ms 10 120 18s411ms 153ms 23 58 8s850ms 152ms -
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (47003)) AND (("account_move"."id" not in (1281425)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-15 02:43:25 Duration: 238ms
-
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (47004)) AND (("account_move"."id" not in (1281610)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-15 05:44:46 Duration: 216ms
-
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (47008)) AND (("account_move"."id" not in (1239326)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-15 09:56:49 Duration: 210ms
19 5m26s 328 150ms 7s624ms 996ms 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 #19
Day Hour Count Duration Avg duration Mar 15 10 2 1s764ms 882ms 11 19 22s179ms 1s167ms 12 45 56s904ms 1s264ms 13 40 53s112ms 1s327ms 14 48 38s994ms 812ms 15 32 23s973ms 749ms 16 28 25s736ms 919ms 17 32 35s857ms 1s120ms 18 34 22s13ms 647ms 19 25 25s919ms 1s36ms 20 20 16s518ms 825ms 21 1 1s639ms 1s639ms 23 2 2s83ms 1s41ms -
UPDATE "stock_move" SET "branch_id" = 38, "picking_id" = 366644, "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 (858755, 858756, 858757, 858758, 858760, 858761, 858763, 858764, 858765, 858766, 858767, 858768, 858769, 858771);
Date: 2024-03-15 13:22:01 Duration: 7s624ms
-
UPDATE "stock_move" SET "branch_id" = 39, "picking_id" = 366906, "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 (859211, 859212, 859213, 859214, 859215, 859216, 859217, 859218);
Date: 2024-03-15 15:26:33 Duration: 5s85ms
-
UPDATE "stock_move" SET "branch_id" = 50, "picking_id" = 367081, "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 (859523, 859524, 859525, 859526, 859527, 859529, 859530);
Date: 2024-03-15 17:47:00 Duration: 5s66ms
20 4m48s 49 4s796ms 15s482ms 5s894ms delete from sale_order_line where id in (...);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 15 10 1 4s890ms 4s890ms 11 4 20s135ms 5s33ms 12 5 26s51ms 5s210ms 13 7 36s474ms 5s210ms 14 3 15s224ms 5s74ms 15 10 1m10s 7s45ms 17 6 36s579ms 6s96ms 18 9 59s610ms 6s623ms 19 2 9s668ms 4s834ms 20 2 9s738ms 4s869ms -
DELETE FROM sale_order_line WHERE id IN (360861, 360862, 360863);
Date: 2024-03-15 15:53:31 Duration: 15s482ms
-
DELETE FROM sale_order_line WHERE id IN (362160, 362161, 362162);
Date: 2024-03-15 18:38:09 Duration: 14s546ms
-
DELETE FROM sale_order_line WHERE id IN (362025, 362027);
Date: 2024-03-15 17:36:12 Duration: 10s61ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 13,447 1h11m19s 120ms 2s124ms 318ms select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 15 00 65 22s884ms 352ms 01 124 40s719ms 328ms 02 120 40s616ms 338ms 03 135 43s910ms 325ms 04 131 38s62ms 290ms 05 77 20s484ms 266ms 06 102 24s560ms 240ms 07 83 28s760ms 346ms 08 149 50s154ms 336ms 09 159 59s817ms 376ms 10 134 30s47ms 224ms 11 589 2m41s 274ms 12 1,973 10m13s 311ms 13 1,633 7m53s 289ms 14 1,623 7m23s 273ms 15 1,304 6m58s 321ms 16 1,089 5m38s 310ms 17 1,297 5m34s 257ms 18 1,205 7m27s 371ms 19 992 8m16s 500ms 20 319 1m53s 356ms 21 29 7s235ms 249ms 22 86 23s572ms 274ms 23 29 6s675ms 230ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-15 19:27:58') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1031"', '["pointspring_master","calendar.alarm",19569]', '["pointspring_master","mail.channel",121]', '["pointspring_master","mail.channel",122]', '["pointspring_master","mail.channel",454]', '["pointspring_master","mail.channel",521]', '["pointspring_master","mail.channel",585]', '["pointspring_master","mail.channel",586]', '["pointspring_master","res.partner",19569]', '["pointspring_master","ir.needaction",19569]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-15 19:28:50 Duration: 2s124ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-15 19:27:58') AND ("bus_bus"."channel" in ('"bundle_changed"', '["pointspring_master","calendar.alarm",19563]', '["pointspring_master","mail.channel",249]', '["pointspring_master","mail.channel",250]', '["pointspring_master","mail.channel",251]', '["pointspring_master","mail.channel",451]', '["pointspring_master","mail.channel",460]', '["pointspring_master","mail.channel",513]', '["pointspring_master","res.partner",19563]', '["pointspring_master","ir.needaction",19563]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-15 19:28:50 Duration: 2s115ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-15 19:27:58') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1267"', '["pointspring_master","calendar.alarm",52604]', '["pointspring_master","res.partner",52604]', '["pointspring_master","ir.needaction",52604]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-15 19:28:50 Duration: 2s109ms
2 3,865 44m50s 604ms 2s445ms 696ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where ((("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and ("product_product__product_tmpl_id"."sale_ok" is not null and "product_product__product_tmpl_id"."sale_ok" != false)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 15 10 10 6s460ms 646ms 11 161 1m51s 694ms 12 582 6m57s 717ms 13 502 5m51s 699ms 14 472 5m25s 688ms 15 374 4m18s 692ms 16 275 3m7s 682ms 17 463 5m23s 698ms 18 465 5m29s 708ms 19 353 4m1s 683ms 20 187 2m3s 659ms 21 11 7s102ms 645ms 23 10 6s408ms 640ms -
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 ('%%ubw7%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%ubw7%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%ubw7%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-15 18:30:06 Duration: 2s445ms
-
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 ('%%3434%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%343-4%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%343-4%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-15 18:30:06 Duration: 2s378ms
-
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 ('%%ubw70%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%ubw70%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%ubw70%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-15 18:30:06 Duration: 2s126ms
3 2,573 16m20s 352ms 757ms 381ms select "ir_attachment".id from "ir_attachment" where (("ir_attachment"."res_field" is null and (unaccent ("ir_attachment"."url"::text) like unaccent (?))) and (not ((unaccent ("ir_attachment"."url"::text) like unaccent (?))))) order by "ir_attachment"."id" desc;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 15 00 3 1s71ms 357ms 02 7 2s534ms 362ms 05 1 356ms 356ms 07 5 1s786ms 357ms 08 21 7s654ms 364ms 10 19 6s969ms 366ms 11 254 1m33s 367ms 12 411 2m40s 391ms 13 340 2m11s 388ms 14 241 1m30s 376ms 15 250 1m36s 384ms 16 251 1m34s 377ms 17 276 1m47s 388ms 18 215 1m21s 379ms 19 158 59s934ms 379ms 20 111 40s719ms 366ms 21 7 2s502ms 357ms 23 3 1s71ms 357ms -
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.report_assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-5826980/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-15 17:06:27 Duration: 757ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_backend.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-03cb21f/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-15 13:23:08 Duration: 747ms
-
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/%-fb6cd24/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-15 17:34:20 Duration: 745ms
4 2,157 5m31s 132ms 238ms 153ms select "account_move".id from "account_move" where (("account_move"."edi_810_id" in (...)) and (("account_move"."id" not in (...)) or "account_move"."id" is null)) order by "account_move"."invoice_date_due";Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 15 00 300 45s949ms 153ms 01 296 45s73ms 152ms 02 300 45s999ms 153ms 03 131 20s122ms 153ms 04 209 32s149ms 153ms 05 210 32s370ms 154ms 06 210 32s481ms 154ms 07 86 13s40ms 151ms 08 117 18s109ms 154ms 09 120 18s537ms 154ms 10 120 18s411ms 153ms 23 58 8s850ms 152ms -
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (47003)) AND (("account_move"."id" not in (1281425)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-15 02:43:25 Duration: 238ms
-
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (47004)) AND (("account_move"."id" not in (1281610)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-15 05:44:46 Duration: 216ms
-
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (47008)) AND (("account_move"."id" not in (1239326)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-15 09:56:49 Duration: 210ms
5 1,947 5m37s 152ms 462ms 173ms select coalesce(sum(pwi.max_product_uom_qty), ?) as tmq from forecasted_data fd inner join item_supply_plan as isp on isp.id = fd.item_supply_plan_id inner join product_warehouse_inventory pwi on fd.product_id = pwi.product_id and isp.branch_id = pwi.replenish_branch_id where isp.id = ? and fd.product_id = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 15 12 35 6s333ms 180ms 13 40 6s918ms 172ms 14 76 12s798ms 168ms 15 692 1m59s 172ms 16 443 1m16s 172ms 17 445 1m17s 174ms 18 60 11s744ms 195ms 19 132 22s77ms 167ms 20 24 3s933ms 163ms -
SELECT COALESCE(SUM(pwi.max_product_uom_qty), 0) AS TMQ from forecasted_data fd INNER JOIN item_supply_plan AS isp ON isp.id = fd.item_supply_plan_id INNER JOIN product_warehouse_inventory pwi ON fd.product_id = pwi.product_id AND isp.branch_id = pwi.replenish_branch_id where isp.id = 37062 and fd.product_id = 208664;
Date: 2024-03-15 18:40:53 Duration: 462ms
-
SELECT COALESCE(SUM(pwi.max_product_uom_qty), 0) AS TMQ from forecasted_data fd INNER JOIN item_supply_plan AS isp ON isp.id = fd.item_supply_plan_id INNER JOIN product_warehouse_inventory pwi ON fd.product_id = pwi.product_id AND isp.branch_id = pwi.replenish_branch_id where isp.id = 37100 and fd.product_id = 204126;
Date: 2024-03-15 15:30:08 Duration: 350ms
-
SELECT COALESCE(SUM(pwi.max_product_uom_qty), 0) AS TMQ from forecasted_data fd INNER JOIN item_supply_plan AS isp ON isp.id = fd.item_supply_plan_id INNER JOIN product_warehouse_inventory pwi ON fd.product_id = pwi.product_id AND isp.branch_id = pwi.replenish_branch_id where isp.id = 37244 and fd.product_id = 220009;
Date: 2024-03-15 17:06:26 Duration: 335ms
6 1,459 16m59s 616ms 1s934ms 698ms 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 Mar 15 11 91 1m1s 678ms 12 226 2m43s 721ms 13 89 1m6s 741ms 14 9 6s84ms 676ms 15 158 1m49s 693ms 16 232 2m44s 710ms 17 282 3m16s 695ms 18 217 2m28s 682ms 19 51 34s42ms 667ms 20 104 1m9s 666ms -
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 ('%%12x%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%1/2x%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%1/2x%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-15 16:56:52 Duration: 1s934ms
-
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 ('%%N228437%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%N2-28-437%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%N2-28-437%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-15 13:41:58 Duration: 1s531ms
-
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 ('%%N22843%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%N2-28-43%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%N2-28-43%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-15 13:41:57 Duration: 1s455ms
7 1,247 4m8s 169ms 1s195ms 198ms select min("sale_report".id) as id, count("sale_report".id) AS "product_id_count", sum("sale_report"."product_uom_qty") AS "product_uom_qty", "sale_report"."product_id" AS "product_id" from "sale_report" left join "product_product" AS "sale_report__product_id" on ("sale_report"."product_id" = "sale_report__product_id"."id") left join "product_template" AS "sale_report__product_id__product_tmpl_id" on ("sale_report__product_id"."product_tmpl_id" = "sale_report__product_id__product_tmpl_id"."id") left join "ir_translation" AS "sale_report__product_id__product_tmpl_id__name" on ("sale_report__product_id__product_tmpl_id"."id" = "sale_report__product_id__product_tmpl_id__name"."res_id" and "sale_report__product_id__product_tmpl_id__name"."type" = ? and "sale_report__product_id__product_tmpl_id__name"."name" = ? and "sale_report__product_id__product_tmpl_id__name"."lang" = ? and "sale_report__product_id__product_tmpl_id__name"."value" != ?) where ((("sale_report"."state" in (...)) and ("sale_report"."product_id" in (...))) and ("sale_report"."date" >= ?)) and ("sale_report"."company_id" is null or ("sale_report"."company_id" in (...))) group by "sale_report"."product_id", "sale_report__product_id"."default_code", coalesce("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id" order by "sale_report__product_id"."default_code", coalesce("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id";Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 15 10 3 600ms 200ms 11 80 15s185ms 189ms 12 186 38s920ms 209ms 13 136 27s313ms 200ms 14 148 28s700ms 193ms 15 125 24s30ms 192ms 16 113 22s265ms 197ms 17 165 33s787ms 204ms 18 100 20s78ms 200ms 19 133 26s650ms 200ms 20 49 8s820ms 180ms 21 1 185ms 185ms 23 8 1s508ms 188ms -
SELECT min("sale_report".id) AS id, count("sale_report".id) AS "product_id_count", sum("sale_report"."product_uom_qty") AS "product_uom_qty", "sale_report"."product_id" as "product_id" FROM "sale_report" LEFT JOIN "product_product" AS "sale_report__product_id" ON ("sale_report"."product_id" = "sale_report__product_id"."id") LEFT JOIN "product_template" AS "sale_report__product_id__product_tmpl_id" ON ("sale_report__product_id"."product_tmpl_id" = "sale_report__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "sale_report__product_id__product_tmpl_id__name" ON ("sale_report__product_id__product_tmpl_id"."id" = "sale_report__product_id__product_tmpl_id__name"."res_id" AND "sale_report__product_id__product_tmpl_id__name"."type" = 'model' AND "sale_report__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "sale_report__product_id__product_tmpl_id__name"."lang" = 'en_US' AND "sale_report__product_id__product_tmpl_id__name"."value" != '') WHERE ((("sale_report"."state" in ('sale', 'done', 'paid')) AND ("sale_report"."product_id" in (238934))) AND ("sale_report"."date" >= '2023-03-16 00:00:00')) AND ("sale_report"."company_id" IS NULL OR ("sale_report"."company_id" in (1))) GROUP BY "sale_report"."product_id", "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id" ORDER BY "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id";
Date: 2024-03-15 19:17:19 Duration: 1s195ms
-
SELECT min("sale_report".id) AS id, count("sale_report".id) AS "product_id_count", sum("sale_report"."product_uom_qty") AS "product_uom_qty", "sale_report"."product_id" as "product_id" FROM "sale_report" LEFT JOIN "product_product" AS "sale_report__product_id" ON ("sale_report"."product_id" = "sale_report__product_id"."id") LEFT JOIN "product_template" AS "sale_report__product_id__product_tmpl_id" ON ("sale_report__product_id"."product_tmpl_id" = "sale_report__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "sale_report__product_id__product_tmpl_id__name" ON ("sale_report__product_id__product_tmpl_id"."id" = "sale_report__product_id__product_tmpl_id__name"."res_id" AND "sale_report__product_id__product_tmpl_id__name"."type" = 'model' AND "sale_report__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "sale_report__product_id__product_tmpl_id__name"."lang" = 'en_US' AND "sale_report__product_id__product_tmpl_id__name"."value" != '') WHERE ((("sale_report"."state" in ('sale', 'done', 'paid')) AND ("sale_report"."product_id" in (173211))) AND ("sale_report"."date" >= '2023-03-16 00:00:00')) AND ("sale_report"."company_id" IS NULL OR ("sale_report"."company_id" in (1))) GROUP BY "sale_report"."product_id", "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id" ORDER BY "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id";
Date: 2024-03-15 18:40:53 Duration: 1s22ms
-
SELECT min("sale_report".id) AS id, count("sale_report".id) AS "product_id_count", sum("sale_report"."product_uom_qty") AS "product_uom_qty", "sale_report"."product_id" as "product_id" FROM "sale_report" LEFT JOIN "product_product" AS "sale_report__product_id" ON ("sale_report"."product_id" = "sale_report__product_id"."id") LEFT JOIN "product_template" AS "sale_report__product_id__product_tmpl_id" ON ("sale_report__product_id"."product_tmpl_id" = "sale_report__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "sale_report__product_id__product_tmpl_id__name" ON ("sale_report__product_id__product_tmpl_id"."id" = "sale_report__product_id__product_tmpl_id__name"."res_id" AND "sale_report__product_id__product_tmpl_id__name"."type" = 'model' AND "sale_report__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "sale_report__product_id__product_tmpl_id__name"."lang" = 'en_US' AND "sale_report__product_id__product_tmpl_id__name"."value" != '') WHERE ((("sale_report"."state" in ('sale', 'done', 'paid')) AND ("sale_report"."product_id" in (174405))) AND ("sale_report"."date" >= '2023-03-16 00:00:00')) AND ("sale_report"."company_id" IS NULL OR ("sale_report"."company_id" in (1))) GROUP BY "sale_report"."product_id", "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id" ORDER BY "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id";
Date: 2024-03-15 19:25:44 Duration: 910ms
8 1,123 3m21s 159ms 343ms 179ms select res_partner.id from "res_partner" where (("res_partner"."active" = true) and (((unaccent ("res_partner"."name"::text) ilike unaccent (?)) or (unaccent ("res_partner"."ref"::text) ilike unaccent (?))) or (unaccent ("res_partner"."display_name"::text) ilike unaccent (?)))) 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 #8
Day Hour Count Duration Avg duration Mar 15 10 12 2s84ms 173ms 11 76 13s84ms 172ms 12 122 22s467ms 184ms 13 163 29s933ms 183ms 14 96 17s132ms 178ms 15 177 31s944ms 180ms 16 121 21s899ms 180ms 17 126 23s176ms 183ms 18 85 15s150ms 178ms 19 120 20s580ms 171ms 20 22 3s764ms 171ms 23 3 500ms 166ms -
SELECT res_partner.id FROM "res_partner" WHERE (("res_partner"."active" = true) AND (((unaccent ("res_partner"."name"::text) ilike unaccent ('%t-05773%')) OR (unaccent ("res_partner"."ref"::text) ilike unaccent ('%t-05773%'))) OR (unaccent ("res_partner"."display_name"::text) ilike unaccent ('%t-05773%')))) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%t-05773%') OR unaccent (res_partner.display_name) ilike unaccent ('%t-05773%') OR unaccent (res_partner.ref) ilike unaccent ('%t-05773%') OR unaccent (res_partner.vat) ilike unaccent ('t-05773')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%t-05773%') desc, unaccent (res_partner.display_name);
Date: 2024-03-15 17:34:20 Duration: 343ms
-
SELECT res_partner.id FROM "res_partner" WHERE (("res_partner"."active" = true) AND (((unaccent ("res_partner"."name"::text) ilike unaccent ('%cresson%')) OR (unaccent ("res_partner"."ref"::text) ilike unaccent ('%cresson%'))) OR (unaccent ("res_partner"."display_name"::text) ilike unaccent ('%cresson%')))) 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 ('%cresson%') OR unaccent (res_partner.display_name) ilike unaccent ('%cresson%') OR unaccent (res_partner.ref) ilike unaccent ('%cresson%') OR unaccent (res_partner.vat) ilike unaccent ('cresson')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%cresson%') desc, unaccent (res_partner.display_name);
Date: 2024-03-15 15:52:29 Duration: 328ms
-
SELECT res_partner.id FROM "res_partner" WHERE (("res_partner"."active" = true) AND (((unaccent ("res_partner"."name"::text) ilike unaccent ('%c%')) OR (unaccent ("res_partner"."ref"::text) ilike unaccent ('%c%'))) OR (unaccent ("res_partner"."display_name"::text) ilike unaccent ('%c%')))) 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 ('%c%') OR unaccent (res_partner.display_name) ilike unaccent ('%c%') OR unaccent (res_partner.ref) ilike unaccent ('%c%') OR unaccent (res_partner.vat) ilike unaccent ('c')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%c%') desc, unaccent (res_partner.display_name);
Date: 2024-03-15 15:15:27 Duration: 326ms
9 1,106 2m56s 139ms 1s980ms 159ms update "stock_quant" set "reserved_quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 15 10 6 918ms 153ms 11 58 9s3ms 155ms 12 172 28s223ms 164ms 13 159 24s767ms 155ms 14 103 15s945ms 154ms 15 109 16s893ms 154ms 16 89 17s76ms 191ms 17 93 14s775ms 158ms 18 188 28s997ms 154ms 19 76 11s580ms 152ms 20 48 7s324ms 152ms 21 2 294ms 147ms 23 3 437ms 145ms -
UPDATE "stock_quant" SET "reserved_quantity" = 0.0, "write_uid" = 1001, "write_date" = (now() at time zone 'UTC') WHERE id IN (222979, 46502, 46495, 319436, 319439, 46514, 213075, 46516, 43031, 408827, 249310, 249311);
Date: 2024-03-15 16:38:09 Duration: 1s980ms
-
UPDATE "stock_quant" SET "reserved_quantity" = 0.0, "write_uid" = 1001, "write_date" = (now() at time zone 'UTC') WHERE id IN (222979, 46502, 46495, 319436, 319439, 46514, 213075, 46516, 43031, 408827, 249310, 249311);
Date: 2024-03-15 16:37:48 Duration: 1s819ms
-
UPDATE "stock_quant" SET "reserved_quantity" = 1.0, "write_uid" = 1245, "write_date" = (now() at time zone 'UTC') WHERE id IN (374675);
Date: 2024-03-15 12:46:55 Duration: 566ms
10 1,044 2m59s 134ms 632ms 171ms select min("account_move".id) as id, count("account_move".id) AS "debit_origin_id_count", "account_move"."debit_origin_id" AS "debit_origin_id" from "account_move" left join "account_move" AS "account_move__debit_origin_id" on ("account_move"."debit_origin_id" = "account_move__debit_origin_id"."id") where ("account_move"."debit_origin_id" in (...)) and ("account_move"."company_id" is null or ("account_move"."company_id" in (...))) group by "account_move"."debit_origin_id", "account_move__debit_origin_id"."invoice_date_due" order by "account_move__debit_origin_id"."invoice_date_due";Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 15 10 1 150ms 150ms 11 75 12s564ms 167ms 12 155 27s737ms 178ms 13 205 35s189ms 171ms 14 106 18s18ms 169ms 15 81 13s420ms 165ms 16 92 16s118ms 175ms 17 134 23s728ms 177ms 18 95 16s307ms 171ms 19 55 8s955ms 162ms 20 41 6s577ms 160ms 21 4 649ms 162ms -
SELECT min("account_move".id) AS id, count("account_move".id) AS "debit_origin_id_count", "account_move"."debit_origin_id" as "debit_origin_id" FROM "account_move" LEFT JOIN "account_move" AS "account_move__debit_origin_id" ON ("account_move"."debit_origin_id" = "account_move__debit_origin_id"."id") WHERE ("account_move"."debit_origin_id" in (1282204)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) GROUP BY "account_move"."debit_origin_id", "account_move__debit_origin_id"."invoice_date_due" ORDER BY "account_move__debit_origin_id"."invoice_date_due";
Date: 2024-03-15 12:52:07 Duration: 632ms
-
SELECT min("account_move".id) AS id, count("account_move".id) AS "debit_origin_id_count", "account_move"."debit_origin_id" as "debit_origin_id" FROM "account_move" LEFT JOIN "account_move" AS "account_move__debit_origin_id" ON ("account_move"."debit_origin_id" = "account_move__debit_origin_id"."id") WHERE ("account_move"."debit_origin_id" in (1283583)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) GROUP BY "account_move"."debit_origin_id", "account_move__debit_origin_id"."invoice_date_due" ORDER BY "account_move__debit_origin_id"."invoice_date_due";
Date: 2024-03-15 17:41:44 Duration: 449ms
-
SELECT min("account_move".id) AS id, count("account_move".id) AS "debit_origin_id_count", "account_move"."debit_origin_id" as "debit_origin_id" FROM "account_move" LEFT JOIN "account_move" AS "account_move__debit_origin_id" ON ("account_move"."debit_origin_id" = "account_move__debit_origin_id"."id") WHERE ("account_move"."debit_origin_id" in (1284040)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) GROUP BY "account_move"."debit_origin_id", "account_move__debit_origin_id"."invoice_date_due" ORDER BY "account_move__debit_origin_id"."invoice_date_due";
Date: 2024-03-15 18:55:52 Duration: 388ms
11 906 7m48s 293ms 1s489ms 516ms select id from product_warehouse_inventory where coalesce(loc_check_qty, ?) < coalesce(max_product_uom_qty, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 15 11 55 20s698ms 376ms 12 55 27s247ms 495ms 13 177 1m23s 471ms 14 46 20s36ms 435ms 18 89 34s95ms 383ms 19 333 3m3s 550ms 20 151 1m39s 658ms -
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2024-03-15 19:33:05 Duration: 1s489ms
-
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2024-03-15 19:33:05 Duration: 1s439ms
-
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2024-03-15 19:33:05 Duration: 1s419ms
12 899 4m8s 241ms 1s15ms 276ms 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 #12
Day Hour Count Duration Avg duration Mar 15 10 4 1s115ms 278ms 11 61 16s744ms 274ms 12 111 30s658ms 276ms 13 213 59s480ms 279ms 14 103 27s854ms 270ms 15 92 25s837ms 280ms 16 85 23s354ms 274ms 17 68 20s17ms 294ms 18 68 18s505ms 272ms 19 58 15s239ms 262ms 20 34 9s240ms 271ms 21 2 491ms 245ms -
UPDATE "sale_order_line" SET "invoice_status" = 'to invoice', "open_qty_fil" = 0.0, "qty_delivered" = '20.00', "qty_to_invoice" = '20.00', "untaxed_amount_to_invoice" = '12.20', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (359089, 359091, 359092);
Date: 2024-03-15 17:05:26 Duration: 1s15ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 20.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (359089, 359091, 359092);
Date: 2024-03-15 17:05:20 Duration: 808ms
-
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" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (358857, 358861, 358863);
Date: 2024-03-15 16:08:36 Duration: 795ms
13 896 8m52s 145ms 9s770ms 594ms update "stock_quant" set "quantity" = ?.?, "reserved_quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 15 10 4 1s834ms 458ms 11 43 22s155ms 515ms 12 134 1m20s 604ms 13 171 1m45s 616ms 14 82 45s694ms 557ms 15 90 53s698ms 596ms 16 67 38s23ms 567ms 17 59 39s708ms 673ms 18 151 1m29s 591ms 19 56 31s289ms 558ms 20 37 23s190ms 626ms 21 2 1s709ms 854ms -
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (446592, 446593, 446595, 446597, 448529, 449300, 448504, 448379, 448318, 447207, 447209, 447211, 138607, 447219, 447220, 448500, 448502, 448376, 448506, 446587, 446588, 446590);
Date: 2024-03-15 18:08:32 Duration: 9s770ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1001, "write_date" = (now() at time zone 'UTC') WHERE id IN (209163, 174359, 25502, 28063, 23970, 304164, 304166, 304173, 422830, 31279, 264242, 225477, 224070, 31305, 27987, 364503, 25048, 27745, 25058, 27765, 304124);
Date: 2024-03-15 12:43:03 Duration: 9s647ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (222979, 46502, 249311, 319436, 319439, 46514, 213075, 46516, 43031, 408827, 249310, 46495);
Date: 2024-03-15 17:47:16 Duration: 5s473ms
14 869 2m13s 133ms 204ms 153ms select "account_move".id from "account_move" where ("account_move"."edi_810_id" in (...)) order by "account_move"."invoice_date_due";Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 15 00 110 16s843ms 153ms 01 110 16s775ms 152ms 02 110 16s899ms 153ms 03 55 8s495ms 154ms 04 90 13s798ms 153ms 05 90 13s708ms 152ms 06 90 13s834ms 153ms 07 38 5s822ms 153ms 08 49 7s529ms 153ms 09 50 7s826ms 156ms 10 50 7s614ms 152ms 23 27 4s82ms 151ms -
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (47004, 47006, 47008, 47009, 47012, 47015, 47019, 47021, 47026, 47027, 47030, 47034, 47035, 47036, 47038, 47039, 47042, 47048, 47049, 47050, 47051, 47054, 47055, 47056, 47057, 47059, 47063, 47066, 47067, 47068, 47070, 47071, 47073, 47074, 47075, 47076, 47077, 47079, 47080, 47082)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-15 09:36:15 Duration: 204ms
-
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (47003, 47004, 47006, 47008, 47009, 47012, 47015, 47019, 47021, 47026, 47027, 47030, 47034, 47035, 47036, 47038, 47039, 47042, 47048, 47049, 47050, 47051, 47054, 47055, 47056, 47057, 47059, 47063, 47066, 47067, 47068, 47070, 47071, 47073, 47074, 47075, 47076, 47077, 47079)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-15 06:19:01 Duration: 201ms
-
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (47000, 47003, 47004, 47006, 47008, 47009, 47012, 47015, 47019, 47021, 47026, 47027, 47030, 47034, 47035, 47036, 47038, 47039, 47042, 47048, 47049, 47050, 47051, 47054, 47055, 47056, 47057, 47059, 47063, 47066, 47067, 47068, 47070, 47071, 47073, 47074, 47075, 47076, 47077, 47079)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-15 06:48:24 Duration: 201ms
15 826 1m53s 120ms 389ms 137ms select "product_warehouse_inventory".id from "product_warehouse_inventory" where (("product_warehouse_inventory"."warehouse_id" = ?) and ("product_warehouse_inventory"."product_id" = ?)) order by "product_warehouse_inventory"."warehouse_name" limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 15 11 12 1s544ms 128ms 12 236 32s620ms 138ms 13 54 7s273ms 134ms 14 42 5s498ms 130ms 15 169 22s502ms 133ms 16 85 11s473ms 134ms 17 110 14s706ms 133ms 18 64 10s386ms 162ms 19 49 6s698ms 136ms 20 5 635ms 127ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."warehouse_id" = 45) AND ("product_warehouse_inventory"."product_id" = 222070)) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 1;
Date: 2024-03-15 18:21:43 Duration: 389ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."warehouse_id" = 45) AND ("product_warehouse_inventory"."product_id" = 232188)) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 1;
Date: 2024-03-15 18:21:43 Duration: 389ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."warehouse_id" = 45) AND ("product_warehouse_inventory"."product_id" = 185242)) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 1;
Date: 2024-03-15 18:21:44 Duration: 320ms
16 813 2m14s 139ms 4s136ms 165ms select count(?) from mail_tracking_value v left join mail_message m on (v.mail_message_id = m.id) join purchase_order po on (po.id = m.res_id) where m.create_date >= ? and m.model = ? and m.message_type = ? and v.old_value_char = ? and v.new_value_char = ? and po.company_id = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 15 02 1 185ms 185ms 10 4 4s745ms 1s186ms 11 27 4s926ms 182ms 12 77 13s319ms 172ms 13 74 11s569ms 156ms 14 56 9s236ms 164ms 15 149 23s493ms 157ms 16 129 20s444ms 158ms 17 80 13s586ms 169ms 18 47 7s373ms 156ms 19 153 23s307ms 152ms 20 15 2s245ms 149ms 21 1 143ms 143ms -
SELECT COUNT(1) FROM mail_tracking_value v LEFT JOIN mail_message m ON (v.mail_message_id = m.id) JOIN purchase_order po ON (po.id = m.res_id) WHERE m.create_date >= '2024-03-08 10:22:35' AND m.model = 'purchase.order' AND m.message_type = 'notification' AND v.old_value_char = 'RFQ' AND v.new_value_char = 'RFQ Sent' AND po.company_id = 1;
Date: 2024-03-15 10:22:39 Duration: 4s136ms
-
SELECT COUNT(1) FROM mail_tracking_value v LEFT JOIN mail_message m ON (v.mail_message_id = m.id) JOIN purchase_order po ON (po.id = m.res_id) WHERE m.create_date >= '2024-03-08 12:04:35' AND m.model = 'purchase.order' AND m.message_type = 'notification' AND v.old_value_char = 'RFQ' AND v.new_value_char = 'RFQ Sent' AND po.company_id = 1;
Date: 2024-03-15 12:04:35 Duration: 350ms
-
SELECT COUNT(1) FROM mail_tracking_value v LEFT JOIN mail_message m ON (v.mail_message_id = m.id) JOIN purchase_order po ON (po.id = m.res_id) WHERE m.create_date >= '2024-03-08 17:34:19' AND m.model = 'purchase.order' AND m.message_type = 'notification' AND v.old_value_char = 'RFQ' AND v.new_value_char = 'RFQ Sent' AND po.company_id = 1;
Date: 2024-03-15 17:34:19 Duration: 301ms
17 805 3m37s 239ms 775ms 270ms 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 #17
Day Hour Count Duration Avg duration Mar 15 10 4 1s44ms 261ms 11 45 12s410ms 275ms 12 100 27s763ms 277ms 13 184 50s338ms 273ms 14 92 24s571ms 267ms 15 81 21s716ms 268ms 16 65 17s372ms 267ms 17 65 18s369ms 282ms 18 75 19s716ms 262ms 19 52 13s292ms 255ms 20 40 10s885ms 272ms 21 2 502ms 251ms -
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '20.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '12.20', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (359089, 359091, 359092);
Date: 2024-03-15 17:05:59 Duration: 775ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '1.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '23.74', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1037, "write_date" = (now() at time zone 'UTC') WHERE id IN (361517, 361518);
Date: 2024-03-15 12:56:57 Duration: 586ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '1.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '43.53', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1021, "write_date" = (now() at time zone 'UTC') WHERE id IN (361649);
Date: 2024-03-15 14:21:51 Duration: 578ms
18 744 10m39s 792ms 1s453ms 859ms 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 #18
Day Hour Count Duration Avg duration Mar 15 10 8 6s518ms 814ms 11 33 27s512ms 833ms 12 118 1m44s 881ms 13 98 1m24s 860ms 14 132 1m52s 851ms 15 77 1m6s 864ms 16 64 54s68ms 844ms 17 102 1m29s 873ms 18 46 40s25ms 870ms 19 42 35s464ms 844ms 20 23 18s995ms 825ms 23 1 808ms 808ms -
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 ('%tra-2726%')) 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 ('%tra-2726%'))) 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 ('%tra-2726%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%tra-2726%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2024-03-15 13:23:56 Duration: 1s453ms
-
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 ('%hbv125%')) 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 ('%hbv125%'))) 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 ('%hbv125%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%hbv125%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2024-03-15 17:54:00 Duration: 1s373ms
-
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 ('%338-758a%')) 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 ('%338-758a%'))) 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 ('%338-758a%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%338-758a%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2024-03-15 12:51:16 Duration: 1s369ms
19 699 2h52m19s 1s526ms 1m8s 14s792ms delete from account_move_line where id in (...);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 15 00 89 18m50s 12s702ms 01 90 19m56s 13s294ms 02 90 19m59s 13s325ms 03 39 8m 12s317ms 04 69 15m45s 13s707ms 05 69 15m43s 13s679ms 06 70 16m50s 14s442ms 07 25 7m19s 17s583ms 08 39 13m59s 21s537ms 09 40 14m1s 21s34ms 10 39 13m45s 21s164ms 11 1 1s572ms 1s572ms 12 4 18s499ms 4s624ms 13 3 7s932ms 2s644ms 14 1 4s977ms 4s977ms 15 4 1m17s 19s334ms 16 3 25s685ms 8s561ms 17 2 1m11s 35s832ms 18 3 11s295ms 3s765ms 19 2 31s376ms 15s688ms 23 17 3m55s 13s856ms -
DELETE FROM account_move_line WHERE id IN (4335484, 4335485, 4335486, 4335487, 4335488, 4335489, 4335490, 4335491, 4335492, 4346964, 4346965, 4346966, 4346967, 4346968, 4346969, 4346970, 4346971, 4346972, 4356382, 4356383, 4356384, 4356385, 4356386, 4356387, 4356437, 4356438, 4356439, 4356440, 4356441, 4356442, 4365977, 4365978, 4365979, 4365980, 4365981, 4365982, 4365983, 4365984, 4365985, 4365986, 4365987, 4365988, 4365989);
Date: 2024-03-15 04:07:58 Duration: 1m8s
-
DELETE FROM account_move_line WHERE id IN (4335484, 4335485, 4335486, 4335487, 4335488, 4335489, 4335490, 4335491, 4335492, 4346964, 4346965, 4346966, 4346967, 4346968, 4346969, 4346970, 4346971, 4346972, 4356382, 4356383, 4356384, 4356385, 4356386, 4356387, 4356437, 4356438, 4356439, 4356440, 4356441, 4356442, 4365977, 4365978, 4365979, 4365980, 4365981, 4365982, 4365983, 4365984, 4365985, 4365986, 4365987, 4365988, 4365989);
Date: 2024-03-15 04:55:56 Duration: 1m8s
-
DELETE FROM account_move_line WHERE id IN (4335484, 4335485, 4335486, 4335487, 4335488, 4335489, 4335490, 4335491, 4335492, 4346964, 4346965, 4346966, 4346967, 4346968, 4346969, 4346970, 4346971, 4346972, 4356382, 4356383, 4356384, 4356385, 4356386, 4356387, 4356437, 4356438, 4356439, 4356440, 4356441, 4356442, 4365977, 4365978, 4365979, 4365980, 4365981, 4365982, 4365983, 4365984, 4365985, 4365986, 4365987, 4365988, 4365989);
Date: 2024-03-15 09:01:30 Duration: 1m7s
20 691 10m13s 303ms 3s863ms 888ms update "stock_move" set "current_warehouse_qty" = ?.?, "date" = ?, "is_done" = true, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 15 10 4 3s172ms 793ms 11 31 24s950ms 804ms 12 85 1m13s 865ms 13 114 1m49s 959ms 14 63 52s120ms 827ms 15 92 1m22s 898ms 16 34 30s590ms 899ms 17 74 1m12s 973ms 18 104 1m24s 810ms 19 58 49s151ms 847ms 20 30 29s531ms 984ms 21 2 2s291ms 1s145ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 1.0, "date" = '2024-03-15 15:26:59', "is_done" = true, "state" = 'done', "write_uid" = 1043, "write_date" = (now() at time zone 'UTC') WHERE id IN (859212, 859213, 859215, 859216, 859217);
Date: 2024-03-15 15:27:08 Duration: 3s863ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 8.0, "date" = '2024-03-15 13:32:23', "is_done" = true, "state" = 'done', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (849676, 849684);
Date: 2024-03-15 13:32:46 Duration: 2s471ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 6.0, "date" = '2024-03-15 13:32:23', "is_done" = true, "state" = 'done', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (849672, 849666);
Date: 2024-03-15 13:32:37 Duration: 2s426ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 4m 4m28s 4m14s 2 8m29s copy public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 15 08 1 4m28s 4m28s 09 1 4m 4m -
COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2024-03-15 08:18:53 Duration: 4m28s
-
COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2024-03-15 09:09:14 Duration: 4m
2 1s526ms 1m8s 14s792ms 699 2h52m19s delete from account_move_line where id in (...);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 15 00 89 18m50s 12s702ms 01 90 19m56s 13s294ms 02 90 19m59s 13s325ms 03 39 8m 12s317ms 04 69 15m45s 13s707ms 05 69 15m43s 13s679ms 06 70 16m50s 14s442ms 07 25 7m19s 17s583ms 08 39 13m59s 21s537ms 09 40 14m1s 21s34ms 10 39 13m45s 21s164ms 11 1 1s572ms 1s572ms 12 4 18s499ms 4s624ms 13 3 7s932ms 2s644ms 14 1 4s977ms 4s977ms 15 4 1m17s 19s334ms 16 3 25s685ms 8s561ms 17 2 1m11s 35s832ms 18 3 11s295ms 3s765ms 19 2 31s376ms 15s688ms 23 17 3m55s 13s856ms -
DELETE FROM account_move_line WHERE id IN (4335484, 4335485, 4335486, 4335487, 4335488, 4335489, 4335490, 4335491, 4335492, 4346964, 4346965, 4346966, 4346967, 4346968, 4346969, 4346970, 4346971, 4346972, 4356382, 4356383, 4356384, 4356385, 4356386, 4356387, 4356437, 4356438, 4356439, 4356440, 4356441, 4356442, 4365977, 4365978, 4365979, 4365980, 4365981, 4365982, 4365983, 4365984, 4365985, 4365986, 4365987, 4365988, 4365989);
Date: 2024-03-15 04:07:58 Duration: 1m8s
-
DELETE FROM account_move_line WHERE id IN (4335484, 4335485, 4335486, 4335487, 4335488, 4335489, 4335490, 4335491, 4335492, 4346964, 4346965, 4346966, 4346967, 4346968, 4346969, 4346970, 4346971, 4346972, 4356382, 4356383, 4356384, 4356385, 4356386, 4356387, 4356437, 4356438, 4356439, 4356440, 4356441, 4356442, 4365977, 4365978, 4365979, 4365980, 4365981, 4365982, 4365983, 4365984, 4365985, 4365986, 4365987, 4365988, 4365989);
Date: 2024-03-15 04:55:56 Duration: 1m8s
-
DELETE FROM account_move_line WHERE id IN (4335484, 4335485, 4335486, 4335487, 4335488, 4335489, 4335490, 4335491, 4335492, 4346964, 4346965, 4346966, 4346967, 4346968, 4346969, 4346970, 4346971, 4346972, 4356382, 4356383, 4356384, 4356385, 4356386, 4356387, 4356437, 4356438, 4356439, 4356440, 4356441, 4356442, 4365977, 4365978, 4365979, 4365980, 4365981, 4365982, 4365983, 4365984, 4365985, 4365986, 4365987, 4365988, 4365989);
Date: 2024-03-15 09:01:30 Duration: 1m7s
3 4s796ms 15s482ms 5s894ms 49 4m48s delete from sale_order_line where id in (...);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 15 10 1 4s890ms 4s890ms 11 4 20s135ms 5s33ms 12 5 26s51ms 5s210ms 13 7 36s474ms 5s210ms 14 3 15s224ms 5s74ms 15 10 1m10s 7s45ms 17 6 36s579ms 6s96ms 18 9 59s610ms 6s623ms 19 2 9s668ms 4s834ms 20 2 9s738ms 4s869ms -
DELETE FROM sale_order_line WHERE id IN (360861, 360862, 360863);
Date: 2024-03-15 15:53:31 Duration: 15s482ms
-
DELETE FROM sale_order_line WHERE id IN (362160, 362161, 362162);
Date: 2024-03-15 18:38:09 Duration: 14s546ms
-
DELETE FROM sale_order_line WHERE id IN (362025, 362027);
Date: 2024-03-15 17:36:12 Duration: 10s61ms
4 1s582ms 8s440ms 4s312ms 378 27m10s delete from account_move where id in (...);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 15 00 50 3m29s 4s195ms 01 50 3m29s 4s188ms 02 50 3m30s 4s200ms 03 22 1m28s 4s19ms 04 39 2m49s 4s338ms 05 40 2m57s 4s427ms 06 39 2m48s 4s329ms 07 14 1m3s 4s560ms 08 20 1m35s 4s797ms 09 20 1m35s 4s779ms 10 20 1m36s 4s823ms 15 2 8s282ms 4s141ms 16 1 3s276ms 3s276ms 17 1 3s205ms 3s205ms 19 1 3s203ms 3s203ms 23 9 27s508ms 3s56ms -
DELETE FROM account_move WHERE id IN (1240817, 1244356, 1247269, 1247291, 1250038);
Date: 2024-03-15 04:14:02 Duration: 8s440ms
-
DELETE FROM account_move WHERE id IN (1240817, 1244356, 1247269, 1247291, 1250038);
Date: 2024-03-15 06:44:12 Duration: 8s243ms
-
DELETE FROM account_move WHERE id IN (1240817, 1244356, 1247269, 1247291, 1250038);
Date: 2024-03-15 06:56:17 Duration: 8s184ms
5 175ms 18s471ms 1s281ms 259 5m31s 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 Mar 15 11 17 17s612ms 1s36ms 12 43 1m5s 1s519ms 13 49 45s115ms 920ms 14 23 27s911ms 1s213ms 15 32 45s417ms 1s419ms 16 22 20s502ms 931ms 17 20 30s175ms 1s508ms 18 30 51s510ms 1s717ms 19 14 14s823ms 1s58ms 20 9 13s480ms 1s497ms -
UPDATE "stock_move" SET "date" = '2024-03-15 18:07:35', "is_done" = true, "state" = 'done', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (859649, 859654, 859661, 859662, 859663, 859613, 859614, 859615, 859616, 859617, 859619, 859620, 859622, 859631, 859632, 859633, 859634, 859635, 859636, 859637, 859638, 859639, 859640, 859641);
Date: 2024-03-15 18:09:04 Duration: 18s471ms
-
UPDATE "stock_move" SET "date" = '2024-03-15 12:42:32', "is_done" = true, "state" = 'done', "write_uid" = 1001, "write_date" = (now() at time zone 'UTC') WHERE id IN (858543, 858544, 858545, 858546, 858547, 858548, 858549, 858550, 858551, 858552, 858553, 858554, 858555, 858556, 858557, 858558, 858559, 858560, 858561, 858562, 858563, 858564);
Date: 2024-03-15 12:42:50 Duration: 17s633ms
-
UPDATE "stock_move" SET "date" = '2024-03-15 17:46:59', "is_done" = true, "state" = 'done', "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (859488, 859489, 859490, 859491, 859492, 859493, 859494, 859495, 859496, 859497, 859498, 859499);
Date: 2024-03-15 17:47:09 Duration: 9s634ms
6 959ms 2s208ms 1s69ms 510 9m5s select "product_template".id from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and ((("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?)))) order by coalesce("product_template"."is_published", false) desc, "product_template"."website_sequence" asc, "product_template"."id" desc limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 15 08 4 3s940ms 985ms 09 3 3s31ms 1s10ms 10 3 2s963ms 987ms 11 35 38s275ms 1s93ms 12 17 18s152ms 1s67ms 13 49 55s151ms 1s125ms 14 18 18s687ms 1s38ms 15 101 1m46s 1s52ms 16 24 24s168ms 1s7ms 17 32 36s547ms 1s142ms 18 97 1m47s 1s108ms 19 97 1m40s 1s32ms 20 30 30s608ms 1s20ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%15-729%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%15-729%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%15-729%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%15-729%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%15-729%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%15-729%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;
Date: 2024-03-15 15:57:01 Duration: 2s208ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%6.5-4-4571-1C%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%6.5-4-4571-1C%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%6.5-4-4571-1C%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%6.5-4-4571-1C%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%6.5-4-4571-1C%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%6.5-4-4571-1C%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;
Date: 2024-03-15 18:40:53 Duration: 2s36ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%6.5-4-4571-%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%6.5-4-4571-%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%6.5-4-4571-%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%6.5-4-4571-%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%6.5-4-4571-%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%6.5-4-4571-%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;
Date: 2024-03-15 18:40:54 Duration: 2s35ms
7 952ms 2s88ms 1s57ms 422 7m26s select count(?) from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and ((("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?))));Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 15 08 4 3s936ms 984ms 09 3 2s944ms 981ms 10 3 2s943ms 981ms 11 32 34s210ms 1s69ms 12 17 18s853ms 1s109ms 13 37 41s37ms 1s109ms 14 15 15s635ms 1s42ms 15 85 1m30s 1s62ms 16 16 16s137ms 1s8ms 17 22 24s338ms 1s106ms 18 84 1m29s 1s68ms 19 77 1m19s 1s27ms 20 27 27s25ms 1s -
SELECT count(1) FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%15-7%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%15-7%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%15-7%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%15-7%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%15-7%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%15-7%'))));
Date: 2024-03-15 15:57:01 Duration: 2s88ms
-
SELECT count(1) FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%6.5-4-4571%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%6.5-4-4571%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%6.5-4-4571%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%6.5-4-4571%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%6.5-4-4571%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%6.5-4-4571%'))));
Date: 2024-03-15 18:40:54 Duration: 2s45ms
-
SELECT count(1) FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%15-72%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%15-72%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%15-72%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%15-72%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%15-72%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%15-72%'))));
Date: 2024-03-15 15:57:02 Duration: 1s916ms
8 969ms 2s554ms 1s50ms 510 8m55s select "product_template".id from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and ((("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?)))) order by coalesce("product_template"."is_published", false) desc, "product_template"."website_sequence" asc, "product_template"."id" desc;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 15 11 24 24s751ms 1s31ms 12 21 23s925ms 1s139ms 13 39 41s864ms 1s73ms 14 39 40s210ms 1s31ms 15 105 1m50s 1s52ms 16 21 22s24ms 1s48ms 17 30 32s3ms 1s66ms 18 63 1m7s 1s64ms 19 141 2m25s 1s35ms 20 27 27s257ms 1s9ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%e1308e%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%e1308e%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%e1308e%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%e1308e%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%e1308e%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%e1308e%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2024-03-15 18:21:45 Duration: 2s554ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%15-729%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%15-729%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%15-729%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%15-729%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%15-729%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%15-729%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2024-03-15 15:57:01 Duration: 2s147ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%OR275491X%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%OR275491X%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%OR275491X%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%OR275491X%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%OR275491X%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%OR275491X%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2024-03-15 19:57:17 Duration: 2s9ms
9 150ms 7s624ms 996ms 328 5m26s 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 #9
Day Hour Count Duration Avg duration Mar 15 10 2 1s764ms 882ms 11 19 22s179ms 1s167ms 12 45 56s904ms 1s264ms 13 40 53s112ms 1s327ms 14 48 38s994ms 812ms 15 32 23s973ms 749ms 16 28 25s736ms 919ms 17 32 35s857ms 1s120ms 18 34 22s13ms 647ms 19 25 25s919ms 1s36ms 20 20 16s518ms 825ms 21 1 1s639ms 1s639ms 23 2 2s83ms 1s41ms -
UPDATE "stock_move" SET "branch_id" = 38, "picking_id" = 366644, "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 (858755, 858756, 858757, 858758, 858760, 858761, 858763, 858764, 858765, 858766, 858767, 858768, 858769, 858771);
Date: 2024-03-15 13:22:01 Duration: 7s624ms
-
UPDATE "stock_move" SET "branch_id" = 39, "picking_id" = 366906, "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 (859211, 859212, 859213, 859214, 859215, 859216, 859217, 859218);
Date: 2024-03-15 15:26:33 Duration: 5s85ms
-
UPDATE "stock_move" SET "branch_id" = 50, "picking_id" = 367081, "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 (859523, 859524, 859525, 859526, 859527, 859529, 859530);
Date: 2024-03-15 17:47:00 Duration: 5s66ms
10 303ms 3s863ms 888ms 691 10m13s 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 Mar 15 10 4 3s172ms 793ms 11 31 24s950ms 804ms 12 85 1m13s 865ms 13 114 1m49s 959ms 14 63 52s120ms 827ms 15 92 1m22s 898ms 16 34 30s590ms 899ms 17 74 1m12s 973ms 18 104 1m24s 810ms 19 58 49s151ms 847ms 20 30 29s531ms 984ms 21 2 2s291ms 1s145ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 1.0, "date" = '2024-03-15 15:26:59', "is_done" = true, "state" = 'done', "write_uid" = 1043, "write_date" = (now() at time zone 'UTC') WHERE id IN (859212, 859213, 859215, 859216, 859217);
Date: 2024-03-15 15:27:08 Duration: 3s863ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 8.0, "date" = '2024-03-15 13:32:23', "is_done" = true, "state" = 'done', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (849676, 849684);
Date: 2024-03-15 13:32:46 Duration: 2s471ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 6.0, "date" = '2024-03-15 13:32:23', "is_done" = true, "state" = 'done', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (849672, 849666);
Date: 2024-03-15 13:32:37 Duration: 2s426ms
11 792ms 1s453ms 859ms 744 10m39s 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 #11
Day Hour Count Duration Avg duration Mar 15 10 8 6s518ms 814ms 11 33 27s512ms 833ms 12 118 1m44s 881ms 13 98 1m24s 860ms 14 132 1m52s 851ms 15 77 1m6s 864ms 16 64 54s68ms 844ms 17 102 1m29s 873ms 18 46 40s25ms 870ms 19 42 35s464ms 844ms 20 23 18s995ms 825ms 23 1 808ms 808ms -
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 ('%tra-2726%')) 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 ('%tra-2726%'))) 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 ('%tra-2726%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%tra-2726%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2024-03-15 13:23:56 Duration: 1s453ms
-
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 ('%hbv125%')) 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 ('%hbv125%'))) 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 ('%hbv125%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%hbv125%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2024-03-15 17:54:00 Duration: 1s373ms
-
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 ('%338-758a%')) 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 ('%338-758a%'))) 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 ('%338-758a%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%338-758a%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2024-03-15 12:51:16 Duration: 1s369ms
12 616ms 1s934ms 698ms 1,459 16m59s 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 #12
Day Hour Count Duration Avg duration Mar 15 11 91 1m1s 678ms 12 226 2m43s 721ms 13 89 1m6s 741ms 14 9 6s84ms 676ms 15 158 1m49s 693ms 16 232 2m44s 710ms 17 282 3m16s 695ms 18 217 2m28s 682ms 19 51 34s42ms 667ms 20 104 1m9s 666ms -
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 ('%%12x%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%1/2x%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%1/2x%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-15 16:56:52 Duration: 1s934ms
-
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 ('%%N228437%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%N2-28-437%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%N2-28-437%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-15 13:41:58 Duration: 1s531ms
-
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 ('%%N22843%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%N2-28-43%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%N2-28-43%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-15 13:41:57 Duration: 1s455ms
13 604ms 2s445ms 696ms 3,865 44m50s 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 #13
Day Hour Count Duration Avg duration Mar 15 10 10 6s460ms 646ms 11 161 1m51s 694ms 12 582 6m57s 717ms 13 502 5m51s 699ms 14 472 5m25s 688ms 15 374 4m18s 692ms 16 275 3m7s 682ms 17 463 5m23s 698ms 18 465 5m29s 708ms 19 353 4m1s 683ms 20 187 2m3s 659ms 21 11 7s102ms 645ms 23 10 6s408ms 640ms -
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 ('%%ubw7%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%ubw7%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%ubw7%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-15 18:30:06 Duration: 2s445ms
-
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 ('%%3434%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%343-4%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%343-4%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-15 18:30:06 Duration: 2s378ms
-
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 ('%%ubw70%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%ubw70%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%ubw70%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-15 18:30:06 Duration: 2s126ms
14 146ms 24s263ms 654ms 628 6m51s update "stock_move" set "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 15 10 5 1s380ms 276ms 11 28 11s304ms 403ms 12 76 53s737ms 707ms 13 101 57s900ms 573ms 14 75 33s67ms 440ms 15 60 37s480ms 624ms 16 46 18s65ms 392ms 17 54 35s84ms 649ms 18 78 1m42s 1s319ms 19 75 41s110ms 548ms 20 27 18s395ms 681ms 21 1 297ms 297ms 23 2 462ms 231ms -
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (859648, 859649, 859650, 859651, 859652, 859653, 859654, 859655, 859656, 859657, 859658, 859659, 859660, 859663, 859607, 859608, 859609, 859610, 859611, 859612, 859613, 859614, 859615, 859616, 859617, 859618, 859619, 859620, 859621, 859622, 859623, 859624, 859625, 859626, 859627, 859628, 859629, 859630, 859631, 859632, 859633, 859634, 859635, 859636, 859637, 859638, 859639, 859640, 859641, 859642, 859643, 859644, 859645, 859646, 859647);
Date: 2024-03-15 18:04:23 Duration: 24s263ms
-
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (859808, 859809, 859810, 859811, 859812, 859813, 859814, 859815, 859816, 859817, 859818, 859819, 859820, 859821, 859822, 859823, 859824, 859825, 859826, 859827, 859828, 859829, 859830, 859831, 859832, 859834, 859835, 859836, 859837, 859838, 859840, 859841);
Date: 2024-03-15 18:56:17 Duration: 15s
-
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 978, "write_date" = (now() at time zone 'UTC') WHERE id IN (859577, 859578, 859579, 859580, 859581, 859582, 859583, 859584, 859585, 859586, 859587, 859588, 859589, 859590, 859591, 859592, 859593, 859594, 859595, 859596, 859597, 859598, 859599);
Date: 2024-03-15 18:01:37 Duration: 10s393ms
15 145ms 9s770ms 594ms 896 8m52s update "stock_quant" set "quantity" = ?.?, "reserved_quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 15 10 4 1s834ms 458ms 11 43 22s155ms 515ms 12 134 1m20s 604ms 13 171 1m45s 616ms 14 82 45s694ms 557ms 15 90 53s698ms 596ms 16 67 38s23ms 567ms 17 59 39s708ms 673ms 18 151 1m29s 591ms 19 56 31s289ms 558ms 20 37 23s190ms 626ms 21 2 1s709ms 854ms -
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (446592, 446593, 446595, 446597, 448529, 449300, 448504, 448379, 448318, 447207, 447209, 447211, 138607, 447219, 447220, 448500, 448502, 448376, 448506, 446587, 446588, 446590);
Date: 2024-03-15 18:08:32 Duration: 9s770ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1001, "write_date" = (now() at time zone 'UTC') WHERE id IN (209163, 174359, 25502, 28063, 23970, 304164, 304166, 304173, 422830, 31279, 264242, 225477, 224070, 31305, 27987, 364503, 25048, 27745, 25058, 27765, 304124);
Date: 2024-03-15 12:43:03 Duration: 9s647ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (222979, 46502, 249311, 319436, 319439, 46514, 213075, 46516, 43031, 408827, 249310, 46495);
Date: 2024-03-15 17:47:16 Duration: 5s473ms
16 293ms 1s489ms 516ms 906 7m48s select id from product_warehouse_inventory where coalesce(loc_check_qty, ?) < coalesce(max_product_uom_qty, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 15 11 55 20s698ms 376ms 12 55 27s247ms 495ms 13 177 1m23s 471ms 14 46 20s36ms 435ms 18 89 34s95ms 383ms 19 333 3m3s 550ms 20 151 1m39s 658ms -
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2024-03-15 19:33:05 Duration: 1s489ms
-
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2024-03-15 19:33:05 Duration: 1s439ms
-
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2024-03-15 19:33:05 Duration: 1s419ms
17 352ms 757ms 381ms 2,573 16m20s 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 #17
Day Hour Count Duration Avg duration Mar 15 00 3 1s71ms 357ms 02 7 2s534ms 362ms 05 1 356ms 356ms 07 5 1s786ms 357ms 08 21 7s654ms 364ms 10 19 6s969ms 366ms 11 254 1m33s 367ms 12 411 2m40s 391ms 13 340 2m11s 388ms 14 241 1m30s 376ms 15 250 1m36s 384ms 16 251 1m34s 377ms 17 276 1m47s 388ms 18 215 1m21s 379ms 19 158 59s934ms 379ms 20 111 40s719ms 366ms 21 7 2s502ms 357ms 23 3 1s71ms 357ms -
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.report_assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-5826980/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-15 17:06:27 Duration: 757ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_backend.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-03cb21f/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-15 13:23:08 Duration: 747ms
-
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/%-fb6cd24/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-15 17:34:20 Duration: 745ms
18 120ms 2s124ms 318ms 13,447 1h11m19s select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 15 00 65 22s884ms 352ms 01 124 40s719ms 328ms 02 120 40s616ms 338ms 03 135 43s910ms 325ms 04 131 38s62ms 290ms 05 77 20s484ms 266ms 06 102 24s560ms 240ms 07 83 28s760ms 346ms 08 149 50s154ms 336ms 09 159 59s817ms 376ms 10 134 30s47ms 224ms 11 589 2m41s 274ms 12 1,973 10m13s 311ms 13 1,633 7m53s 289ms 14 1,623 7m23s 273ms 15 1,304 6m58s 321ms 16 1,089 5m38s 310ms 17 1,297 5m34s 257ms 18 1,205 7m27s 371ms 19 992 8m16s 500ms 20 319 1m53s 356ms 21 29 7s235ms 249ms 22 86 23s572ms 274ms 23 29 6s675ms 230ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-15 19:27:58') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1031"', '["pointspring_master","calendar.alarm",19569]', '["pointspring_master","mail.channel",121]', '["pointspring_master","mail.channel",122]', '["pointspring_master","mail.channel",454]', '["pointspring_master","mail.channel",521]', '["pointspring_master","mail.channel",585]', '["pointspring_master","mail.channel",586]', '["pointspring_master","res.partner",19569]', '["pointspring_master","ir.needaction",19569]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-15 19:28:50 Duration: 2s124ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-15 19:27:58') AND ("bus_bus"."channel" in ('"bundle_changed"', '["pointspring_master","calendar.alarm",19563]', '["pointspring_master","mail.channel",249]', '["pointspring_master","mail.channel",250]', '["pointspring_master","mail.channel",251]', '["pointspring_master","mail.channel",451]', '["pointspring_master","mail.channel",460]', '["pointspring_master","mail.channel",513]', '["pointspring_master","res.partner",19563]', '["pointspring_master","ir.needaction",19563]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-15 19:28:50 Duration: 2s115ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-15 19:27:58') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1267"', '["pointspring_master","calendar.alarm",52604]', '["pointspring_master","res.partner",52604]', '["pointspring_master","ir.needaction",52604]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-15 19:28:50 Duration: 2s109ms
19 241ms 1s15ms 276ms 899 4m8s 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 Mar 15 10 4 1s115ms 278ms 11 61 16s744ms 274ms 12 111 30s658ms 276ms 13 213 59s480ms 279ms 14 103 27s854ms 270ms 15 92 25s837ms 280ms 16 85 23s354ms 274ms 17 68 20s17ms 294ms 18 68 18s505ms 272ms 19 58 15s239ms 262ms 20 34 9s240ms 271ms 21 2 491ms 245ms -
UPDATE "sale_order_line" SET "invoice_status" = 'to invoice', "open_qty_fil" = 0.0, "qty_delivered" = '20.00', "qty_to_invoice" = '20.00', "untaxed_amount_to_invoice" = '12.20', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (359089, 359091, 359092);
Date: 2024-03-15 17:05:26 Duration: 1s15ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 20.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (359089, 359091, 359092);
Date: 2024-03-15 17:05:20 Duration: 808ms
-
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" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (358857, 358861, 358863);
Date: 2024-03-15 16:08:36 Duration: 795ms
20 239ms 775ms 270ms 805 3m37s update "sale_order_line" set "invoice_status" = ?, "qty_invoiced" = ?, "qty_to_invoice" = ?, "untaxed_amount_invoiced" = ?, "untaxed_amount_to_invoice" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 15 10 4 1s44ms 261ms 11 45 12s410ms 275ms 12 100 27s763ms 277ms 13 184 50s338ms 273ms 14 92 24s571ms 267ms 15 81 21s716ms 268ms 16 65 17s372ms 267ms 17 65 18s369ms 282ms 18 75 19s716ms 262ms 19 52 13s292ms 255ms 20 40 10s885ms 272ms 21 2 502ms 251ms -
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '20.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '12.20', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (359089, 359091, 359092);
Date: 2024-03-15 17:05:59 Duration: 775ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '1.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '23.74', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1037, "write_date" = (now() at time zone 'UTC') WHERE id IN (361517, 361518);
Date: 2024-03-15 12:56:57 Duration: 586ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '1.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '43.53', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1021, "write_date" = (now() at time zone 'UTC') WHERE id IN (361649);
Date: 2024-03-15 14:21:51 Duration: 578ms
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
- 68,654 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 3108 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 2,325 Max number of times the same event was reported
- 3,108 Total events found
Rank Times reported Error 1 2,325 ERROR: could not obtain lock on row in relation "..."
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 15 00 211 01 222 02 227 03 123 04 170 05 164 06 167 07 150 08 206 09 155 10 171 11 45 12 23 13 24 14 26 15 22 16 28 17 22 18 21 19 18 20 21 21 21 22 26 23 62 - ERROR: could not obtain lock on row in relation "ir_cron"
Statement: SELECT * FROM ir_cron WHERE numbercall != 0 AND active AND nextcall <= (now() at time zone 'UTC') AND id=67 FOR UPDATE NOWAIT
Date: 2024-03-15 11:50:10
2 516 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 15 02 11 03 9 08 15 09 13 10 6 11 25 12 96 13 108 14 30 15 41 16 34 17 25 18 32 19 23 20 35 21 1 22 10 23 2 - ERROR: could not serialize access due to concurrent update
Statement: UPDATE "bus_presence" SET "last_poll"='2024-03-15 11:52:01',"last_presence"='2024-03-15 11:52:00.969838' WHERE id IN (30)
Date: 2024-03-15 11:52:01
3 117 ERROR: current transaction is aborted, commands ignored until end of transaction block
Times Reported Most Frequent Error / Event #3
Day Hour Count Mar 15 00 10 01 10 02 10 03 5 04 10 05 10 06 10 07 5 08 22 09 9 10 10 23 6 - 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'), '658320824B', 'Match', '3.2755954265594482') RETURNING id
Date: 2024-03-15 05:50:35
4 107 ERROR: new row for relation "..." violates check constraint "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Mar 15 00 10 01 10 02 10 03 5 04 10 05 10 06 10 07 5 08 10 09 9 10 10 14 2 23 6 - ERROR: new row for relation "account_move_line" violates check constraint "account_move_line_check_amount_currency_balance_sign"
- ERROR: new row for relation "account_move_line" violates check constraint "account_move_line_check_credit_debit"
Detail: Failing row contains (4330352, 1239326, /, 2024-02-27, 658320824B, draft, 2, 1, 2, 14, 50048, 10, , 1.00, -566.69, 0.00, 0.00, 578.25, -578.25, -566.69, -566.69, -566.69, f, f, 2024-04-27, 2, 30608, null, null, null, null, null, null, null, null, null, t, null, , -578.25, -566.69, null, null, null, null, null, t, 1050, 2024-02-29 14:44:41.157952, 1, 2024-03-15 05:48:16.779237, null, null, null, null, null, null, null, 56, Indiana, null, new_product, 1, 566.69, null, null, null, null, null, null, null, null, null, t, null, exception, null, null, null, null, null, f, f, null, f, f, f).
Statement: UPDATE "account_move_line" SET "amount_currency"='-566.69',"amount_residual_currency"='-566.69',"price_subtotal"='-566.69',"price_total"='-566.69',"price_unit"='-566.69',"sign_price_subtotal"='566.69',"write_uid"=1,"write_date"=(now() at time zone 'UTC') WHERE id IN (4330352)Date: 2024-03-15 05:50:35
Detail: Failing row contains (4506833, 1282860, null, null, null, null, null, 1, 2, 1531, null, 10, Adjust current portion to 5 yr schedule, 1.00, null, 0.00, 67970.92, 67970.92, null, 0.00, null, null, null, f, null, 2, null, null, null, null, null, null, null, null, null, null, t, null, null, null, null, null, null, null, null, null, null, 1254, 2024-03-15 14:42:15.014904, 1254, 2024-03-15 14:42:15.014904, null, null, null, null, null, null, null, 36, null, null, new_product, 1, null, null, null, null, null, null, null, null, null, null, t, null, null, null, null, null, null, null, f, f, null, f, f, f).
Statement: INSERT INTO "account_move_line" ("id", "create_uid", "create_date", "write_uid", "write_date", "account_id", "amount_currency", "blocked", "branch_id", "company_currency_id", "company_id", "credit", "currency_id", "debit", "discount", "display_type", "is_carry_forward", "is_discount", "is_extra_line", "is_sale_tax", "is_visible_in_report", "is_writeoff", "move_id", "move_options", "name", "quantity", "sequence", "sign_product_qty", "tax_exigible") VALUES (nextval('account_move_line_id_seq'), 1254, (now() at time zone 'UTC'), 1254, (now() at time zone 'UTC'), 1531, '0.00', false, 36, 2, 1, '67970.92', 2, '67970.92', '0.00', NULL, false, false, false, false, true, false, 1282860, 'new_product', 'Adjust current portion to 5 yr schedule', '1.00', 10, 1.0, true) RETURNING idDate: 2024-03-15 14:42:15
5 31 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #5
Day Hour Count Mar 15 03 1 12 3 13 10 14 5 15 4 16 2 17 1 18 3 19 2 - ERROR: process 2816305 still waiting for ShareLock on transaction 247096872 after 1000.042 ms
- ERROR: process 2815548 still waiting for ShareLock on transaction 247099579 after 1000.039 ms
- ERROR: process 2815877 still waiting for ShareLock on transaction 247101869 after 1000.050 ms
Detail: Process holding the lock: 2815723. Wait queue: 2816305.
Context: while updating tuple (15805,25) 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 != 1282090 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 != 1282090 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1 ) RETURNING name;Date: 2024-03-15 12:31:10
Detail: Process holding the lock: 2816644. Wait queue: 2815548.
Context: while updating tuple (15814,43) 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 != 1282175 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 != 1282175 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1 ) RETURNING name;Date: 2024-03-15 12:43:49
Detail: Process holding the lock: 2815627. Wait queue: 2815877.
Context: while updating tuple (15824,13) 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 != 1282219 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 != 1282219 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1 ) RETURNING name;Date: 2024-03-15 12:55:40
6 6 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Mar 15 10 6 - ERROR: syntax error at or near "inner" at character 1
- ERROR: syntax error at or near "m" at character 1
- ERROR: syntax error at or near "distinct" at character 204
Statement: inner join uom_uom uom1 on uom1.id = ps.product_uom inner join uom_uoselect distinct(ro.id) from stock_move sm left join repair_order ro on sm.repair_id = ro.id where sm.state not in ('done','cancel') and ro.state in ('done', '2binvoiced') and sm.product_id = 171437 group by ro.id having count(ro.id) > 1;
Date: 2024-03-15 10:44:47
Statement: m uom2 on uom2.id = ps.rec_uom where product_uom=rec_uom and min_qty != receive_qty;
Date: 2024-03-15 10:44:47
Statement: select ps.product_code,ps.name, ps.min_qty,uom1.name,ps.receive_qty,uom2.name, ps.product_tmpl_id from product_supplierinfo ps inner join uom_uom uom1 on uom1.id = ps.product_uom inner join uom_uoselect distinct(ro.id) from stock_move sm left join repair_order ro on sm.repair_id = ro.id where sm.state not in ('done','cancel') and ro.state in ('done', '2binvoiced') and sm.product_id = 171437 group by ro.id having count(ro.id) > 1;
Date: 2024-03-15 10:44:52
7 2 ERROR: could not serialize access due to concurrent delete
Times Reported Most Frequent Error / Event #7
Day Hour Count Mar 15 11 2 - ERROR: could not serialize access due to concurrent delete
Statement: DELETE FROM account_tax_sale_order_line_rel WHERE sale_order_line_id IN (361323) AND account_tax_id IN (2120)
Date: 2024-03-15 11:45:08
8 2 ERROR: could not create unique index "..."
Times Reported Most Frequent Error / Event #8
Day Hour Count Mar 15 08 2 - ERROR: could not create unique index "vendor_account_master_unique_acc_no"
Detail: Key (account_number)=(0002609) is duplicated.
Statement: ALTER TABLE "vendor_account_master" ADD CONSTRAINT "vendor_account_master_unique_acc_no" unique (account_number)Date: 2024-03-15 08:42:07
9 2 LOG: process ... still waiting for ExclusiveLock on tuple (...) of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #9
Day Hour Count Mar 15 13 2 - ERROR: process 2815785 still waiting for ExclusiveLock on tuple (15859,3) of relation 42418 of database 65946 after 1000.049 ms
- ERROR: process 2816589 still waiting for ExclusiveLock on tuple (15835,34) of relation 42418 of database 65946 after 1000.043 ms
Detail: Process holding the lock: 2815562. Wait queue: 2815785.
Statement: UPDATE "account_move" SET "message_main_attachment_id"=5160645,"write_uid"=1047,"write_date"=(now() at time zone 'UTC') WHERE id IN (1282420)Date: 2024-03-15 13:26:16
Detail: Process holding the lock: 2816258. Wait queue: 2816589.
Statement: UPDATE "account_move" SET "message_main_attachment_id"=5160657,"write_uid"=1245,"write_date"=(now() at time zone 'UTC') WHERE id IN (1282428)Date: 2024-03-15 13:26:29