pgBadger-
Global information
- Generated on Fri Mar 10 23:50:47 2023
- Log file: /var/log/postgresql/postgresql-14-main.log
- Parsed 247,774 log entries in 45s
- Log start from 2023-03-09 00:00:03 to 2023-03-09 23:59:42
-
Overview
Global Stats
- 1,066 Number of unique normalized queries
- 85,670 Number of queries
- 11h3m5s Total query duration
- 2023-03-09 00:00:07 First query
- 2023-03-09 23:59:42 Last query
- 42 queries/s at 2023-03-09 14:29:31 Query peak
- 11h3m5s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 11h3m5s Execute total duration
- 5,757 Number of events
- 20 Number of unique normalized events
- 3,225 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
- 85,670 Average queries per session
- 11h3m5s 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
- 42 queries/s Query Peak
- 2023-03-09 14:29:31 Date
SELECT Traffic
Key values
- 41 queries/s Query Peak
- 2023-03-09 14:29:31 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 11 queries/s Query Peak
- 2023-03-09 21:00:46 Date
Queries duration
Key values
- 11h3m5s 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 09 00 91 0ms 4s838ms 372ms 1s510ms 2s147ms 11s368ms 01 137 0ms 2s247ms 575ms 4s504ms 6s888ms 36s837ms 02 28 0ms 157ms 129ms 248ms 266ms 301ms 03 43 0ms 139ms 127ms 258ms 275ms 522ms 04 36 0ms 173ms 130ms 249ms 277ms 371ms 05 50 0ms 495ms 137ms 388ms 409ms 665ms 06 100 0ms 1s417ms 329ms 1s839ms 3s582ms 5s331ms 07 86 0ms 2s548ms 481ms 2s286ms 4s523ms 12s548ms 08 35 0ms 5s50ms 390ms 147ms 268ms 9s820ms 09 114 0ms 38s488ms 2s125ms 23s596ms 51s773ms 59s339ms 10 522 0ms 20s776ms 512ms 15s573ms 36s145ms 1m 11 244 0ms 4s949ms 436ms 6s99ms 9s67ms 27s342ms 12 3,787 0ms 8s656ms 537ms 1m6s 1m24s 1m49s 13 11,329 120ms 53s443ms 482ms 2m16s 2m45s 3m10s 14 10,051 120ms 35s630ms 451ms 2m3s 2m13s 2m38s 15 7,390 120ms 36s836ms 454ms 1m42s 1m51s 2m7s 16 7,505 120ms 36s106ms 467ms 1m53s 2m21s 2m45s 17 6,866 120ms 19s70ms 478ms 1m39s 2m4s 2m14s 18 8,478 120ms 25s912ms 369ms 1m40s 2m16s 3m2s 19 8,159 120ms 22s816ms 383ms 1m27s 1m34s 1m39s 20 5,363 120ms 18s782ms 445ms 1m22s 1m25s 2m14s 21 11,767 120ms 18s431ms 578ms 4m30s 6m 6m48s 22 2,830 0ms 18s831ms 377ms 59s254ms 1m26s 1m28s 23 659 0ms 5s461ms 359ms 11s291ms 16s503ms 32s798ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 09 00 77 0 215ms 257ms 1s411ms 1s574ms 01 123 0 572ms 258ms 4s304ms 7s744ms 02 28 0 129ms 125ms 248ms 277ms 03 43 0 127ms 137ms 258ms 372ms 04 36 0 130ms 134ms 249ms 278ms 05 50 0 137ms 254ms 388ms 495ms 06 100 0 329ms 789ms 1s839ms 3s808ms 07 86 0 481ms 370ms 2s286ms 6s377ms 08 33 0 251ms 126ms 147ms 423ms 09 37 61 2s231ms 265ms 1s892ms 59s208ms 10 433 0 360ms 1s125ms 2s889ms 52s61ms 11 193 0 356ms 2s219ms 3s393ms 8s831ms 12 2,524 0 356ms 25s261ms 36s771ms 50s477ms 13 7,176 0 323ms 52s467ms 1m17s 1m30s 14 6,463 37 293ms 45s127ms 58s320ms 1m20s 15 4,945 0 282ms 31s736ms 39s898ms 54s300ms 16 5,114 47 288ms 35s919ms 50s402ms 59s430ms 17 4,495 0 253ms 29s501ms 37s458ms 47s781ms 18 6,253 0 229ms 31s833ms 43s746ms 1m45s 19 6,021 0 249ms 37s987ms 50s489ms 1m1s 20 3,500 0 285ms 23s19ms 27s114ms 39s662ms 21 10,412 0 530ms 2m57s 4m26s 5m46s 22 2,522 0 299ms 23s605ms 51s613ms 1m20s 23 514 0 235ms 2s566ms 9s300ms 13s820ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 09 00 4 8 2 0 1s237ms 0ms 0ms 3s684ms 01 1 9 4 0 600ms 0ms 0ms 598ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 2 0 0 2s686ms 0ms 0ms 0ms 09 0 16 0 0 1s474ms 0ms 0ms 0ms 10 0 57 20 0 1s292ms 0ms 405ms 8s922ms 11 10 41 0 0 737ms 0ms 326ms 2s797ms 12 155 1,039 6 0 939ms 17s886ms 31s773ms 46s829ms 13 471 3,514 12 0 780ms 48s756ms 1m9s 1m21s 14 388 2,949 24 0 771ms 40s973ms 52s395ms 1m18s 15 163 2,116 19 0 846ms 33s750ms 45s694ms 1m10s 16 192 1,998 16 0 909ms 32s710ms 46s969ms 1m21s 17 230 1,979 32 0 949ms 33s93ms 49s719ms 1m22s 18 249 1,798 20 0 801ms 23s820ms 34s768ms 1m3s 19 220 1,747 10 0 812ms 27s172ms 34s825ms 50s836ms 20 233 1,529 9 0 778ms 17s304ms 37s66ms 58s915ms 21 168 1,088 6 0 940ms 15s627ms 25s409ms 55s299ms 22 86 183 1 0 936ms 2s72ms 6s225ms 19s910ms 23 22 120 3 0 799ms 1s808ms 4s95ms 7s536ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Mar 09 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 09 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 09 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 09 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 09 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 09 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 09 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 09 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 09 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
- 1,416 locks Total
Type Object Count Total Duration Average Duration (s) AccessExclusiveLock 67 1m39s 1s482ms tuple 67 1m39s 1s482ms AccessShareLock 7 17s170ms 2s452ms relation 7 17s170ms 2s452ms ExclusiveLock 7 14s962ms 2s137ms tuple 7 14s962ms 2s137ms RowExclusiveLock 5 18s886ms 3s777ms relation 5 18s886ms 3s777ms ShareLock 1,330 44m19s 1s999ms relation 13 25s457ms 1s958ms transaction 1,317 43m54s 2s Total 1,416 46m49s 1s984ms Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1,324 35m53s 1s1ms 8s905ms 1s626ms delete from ir_attachment where id in (...);-
DELETE FROM ir_attachment WHERE id IN (1092588);
Date: 2023-03-09 10:29:49
-
DELETE FROM ir_attachment WHERE id IN (1092601);
Date: 2023-03-09 10:30:15
-
DELETE FROM ir_attachment WHERE id IN (1096455);
Date: 2023-03-09 12:45:24
2 2 2m47s 1m12s 1m35s 1m23s with dupes as ( select min(id) as to_update_quant_id, (array_agg(id order by id))[? :array_length(array_agg(id), ?)] as to_delete_quant_ids, sum(reserved_quantity) as reserved_quantity, sum(quantity) as quantity from stock_quant group by product_id, company_id, location_id, lot_id, package_id, owner_id, in_date, move_options having count(id) > ? ), _up as ( update stock_quant q set quantity = d.quantity, reserved_quantity = d.reserved_quantity from dupes d where d.to_update_quant_id = q.id) delete from stock_quant where id in ( select unnest(to_delete_quant_ids) from dupes);-
WITH dupes AS ( SELECT min(id) as to_update_quant_id, (array_agg(id ORDER BY id))[2:array_length(array_agg(id), 1)] as to_delete_quant_ids, SUM(reserved_quantity) as reserved_quantity, SUM(quantity) as quantity FROM stock_quant GROUP BY product_id, company_id, location_id, lot_id, package_id, owner_id, in_date, move_options HAVING count(id) > 1 ), _up AS ( UPDATE stock_quant q SET quantity = d.quantity, reserved_quantity = d.reserved_quantity FROM dupes d WHERE d.to_update_quant_id = q.id) DELETE FROM stock_quant WHERE id in ( SELECT unnest(to_delete_quant_ids) from dupes);
Date: 2023-03-09 19:09:15
-
WITH dupes AS ( SELECT min(id) as to_update_quant_id, (array_agg(id ORDER BY id))[2:array_length(array_agg(id), 1)] as to_delete_quant_ids, SUM(reserved_quantity) as reserved_quantity, SUM(quantity) as quantity FROM stock_quant GROUP BY product_id, company_id, location_id, lot_id, package_id, owner_id, in_date, move_options HAVING count(id) > 1 ), _up AS ( UPDATE stock_quant q SET quantity = d.quantity, reserved_quantity = d.reserved_quantity FROM dupes d WHERE d.to_update_quant_id = q.id) DELETE FROM stock_quant WHERE id in ( SELECT unnest(to_delete_quant_ids) from dupes);
Date: 2023-03-09 15:40:29
-
WITH dupes AS ( SELECT min(id) as to_update_quant_id, (array_agg(id ORDER BY id))[2:array_length(array_agg(id), 1)] as to_delete_quant_ids, SUM(reserved_quantity) as reserved_quantity, SUM(quantity) as quantity FROM stock_quant GROUP BY product_id, company_id, location_id, lot_id, package_id, owner_id, in_date, move_options HAVING count(id) > 1 ), _up AS ( UPDATE stock_quant q SET quantity = d.quantity, reserved_quantity = d.reserved_quantity FROM dupes d WHERE d.to_update_quant_id = q.id) DELETE FROM stock_quant WHERE id in ( SELECT unnest(to_delete_quant_ids) from dupes);
Date: 2023-03-09 14:23:18
3 43 2m27s 1s210ms 8s768ms 3s434ms 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 != 423007 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 != 423007 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;
Date: 2023-03-09 12:55:19
4 1 1m19s 1m19s 1m19s 1m19s update "sale_order_line" set "branch_id" = ?, "currency_id" = ?, "cus_date_order" = ?, "cus_part_route" = ?, "cus_user_id" = ?, "inventory_vendor_id" = ?, "is_service" = false, "margin" = ?, "margin_percent" = ?.?, "order_partner_id" = ?, "price_reduce" = ?, "price_reduce_taxexcl" = ?, "price_reduce_taxinc" = ?, "price_subtotal" = ?, "price_tax" = ?.?, "price_total" = ?, "purchase_price" = ?, "qty_delivered_method" = ?, "qty_invoiced" = ?, "qty_to_invoice" = ?, "salesman_id" = ?, "untaxed_amount_invoiced" = ?, "untaxed_amount_to_invoice" = ?, "warehouse_id" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);-
UPDATE "sale_order_line" SET "branch_id" = 48, "currency_id" = 2, "cus_date_order" = '2023-03-09 21:34:36', "cus_part_route" = 39, "cus_user_id" = 965, "inventory_vendor_id" = 3026, "is_service" = false, "margin" = '19.32', "margin_percent" = 0.41001697792869274, "order_partner_id" = 42029, "price_reduce" = '23.56', "price_reduce_taxexcl" = '23.56', "price_reduce_taxinc" = '23.56', "price_subtotal" = '47.12', "price_tax" = 0.0, "price_total" = '47.12', "purchase_price" = '13.90', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 965, "untaxed_amount_invoiced" = '0.00', "untaxed_amount_to_invoice" = '0.00', "warehouse_id" = 45, "write_uid" = 979, "write_date" = (now() at time zone 'UTC') WHERE id IN (103924);
Date: 2023-03-09 21:36:11
-
UPDATE "sale_order_line" SET "branch_id" = 38, "currency_id" = 2, "cus_date_order" = '2023-03-09 14:32:19', "cus_part_route" = 6, "cus_user_id" = 1008, "inventory_vendor_id" = 2931, "is_service" = false, "margin" = '-17.22', "margin_percent" = 0.2499274310595065, "order_partner_id" = 39498, "price_reduce" = '34.45', "price_reduce_taxexcl" = '34.45', "price_reduce_taxinc" = '34.45', "price_subtotal" = '-68.90', "price_tax" = 0.0, "price_total" = '-68.90', "purchase_price" = '25.84', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 1008, "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 (103328);
Date: 2023-03-09 14:32:53
-
UPDATE "sale_order_line" SET "branch_id" = 44, "currency_id" = 2, "cus_date_order" = '2023-03-09 13:39:40', "cus_part_route" = 54, "cus_user_id" = 973, "inventory_vendor_id" = 2928, "is_service" = false, "margin" = '72.28', "margin_percent" = 0.43003331746787243, "order_partner_id" = 50219, "price_reduce" = '84.04', "price_reduce_taxexcl" = '84.04', "price_reduce_taxinc" = '84.04', "price_subtotal" = '168.08', "price_tax" = 0.0, "price_total" = '168.08', "purchase_price" = '47.90', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 973, "untaxed_amount_invoiced" = '0.00', "untaxed_amount_to_invoice" = '0.00', "warehouse_id" = 41, "write_uid" = 973, "write_date" = (now() at time zone 'UTC') WHERE id IN (103188);
Date: 2023-03-09 13:41:05
5 5 1m11s 8s773ms 18s576ms 14s358ms update "sale_order_line" set "branch_id" = ?, "warehouse_id" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);-
UPDATE "sale_order_line" SET "branch_id" = 39, "warehouse_id" = 37, "write_uid" = 1141, "write_date" = (now() at time zone 'UTC') WHERE id IN (101619);
Date: 2023-03-09 20:59:28
-
UPDATE "sale_order_line" SET "branch_id" = 39, "warehouse_id" = 37, "write_uid" = 1141, "write_date" = (now() at time zone 'UTC') WHERE id IN (101619);
Date: 2023-03-09 20:59:05
-
UPDATE "sale_order_line" SET "branch_id" = 39, "warehouse_id" = 37, "write_uid" = 1141, "write_date" = (now() at time zone 'UTC') WHERE id IN (101619);
Date: 2023-03-09 21:00:14
6 1 1m 1m 1m 1m update "stock_move_line" set "date" = ?, "product_qty" = ?.?, "product_uom_qty" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);-
UPDATE "stock_move_line" SET "date" = '2023-03-09 15:23:36', "product_qty" = 0.0, "product_uom_qty" = '0.00', "write_uid" = 989, "write_date" = (now() at time zone 'UTC') WHERE id IN (307834, 307835);
Date: 2023-03-09 15:24:40
7 9 26s210ms 1s195ms 4s395ms 2s912ms 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" = 1099152, "write_uid" = 955, "write_date" = (now() at time zone 'UTC') WHERE id IN (469148);
Date: 2023-03-09 13:49:18
8 6 13s543ms 1s951ms 2s822ms 2s257ms create index if not exists account_move_to_check_idx on account_move (journal_id) where to_check = true; create index if not exists account_move_payment_idx on account_move (journal_id, state, payment_state, move_type, date);-
CREATE INDEX IF NOT EXISTS account_move_to_check_idx ON account_move (journal_id) WHERE to_check = true; CREATE INDEX IF NOT EXISTS account_move_payment_idx ON account_move (journal_id, state, payment_state, move_type, date);
Date: 2023-03-09 18:41:28
-
CREATE INDEX IF NOT EXISTS account_move_to_check_idx ON account_move (journal_id) WHERE to_check = true; CREATE INDEX IF NOT EXISTS account_move_payment_idx ON account_move (journal_id, state, payment_state, move_type, date);
Date: 2023-03-09 18:41:48
-
CREATE INDEX IF NOT EXISTS account_move_to_check_idx ON account_move (journal_id) WHERE to_check = true; CREATE INDEX IF NOT EXISTS account_move_payment_idx ON account_move (journal_id, state, payment_state, move_type, date);
Date: 2023-03-09 10:29:51
9 1 12s955ms 12s955ms 12s955ms 12s955ms update account_move set write_date = write_date where id = ( select id from account_move where journal_id = ? and name != ? and sequence_prefix !~ ? and move_type not in (...) and sequence_prefix = ( select sequence_prefix from account_move where journal_id = ? and name != ? and sequence_prefix !~ ? and move_type not in (...) order by id desc limit ?) order by sequence_number desc limit ?) returning name;-
UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;
Date: 2023-03-09 17:41:48
10 7 11s913ms 1s407ms 1s998ms 1s701ms create unique index if not exists product_product_combination_unique on product_product (product_tmpl_id, combination_indices) where active is true;-
CREATE UNIQUE INDEX IF NOT EXISTS product_product_combination_unique ON product_product (product_tmpl_id, combination_indices) WHERE active is true;
Date: 2023-03-09 10:30:43
-
CREATE UNIQUE INDEX IF NOT EXISTS product_product_combination_unique ON product_product (product_tmpl_id, combination_indices) WHERE active is true;
Date: 2023-03-09 18:41:45
-
CREATE UNIQUE INDEX IF NOT EXISTS product_product_combination_unique ON product_product (product_tmpl_id, combination_indices) WHERE active is true;
Date: 2023-03-09 18:41:40
11 5 11s604ms 1s46ms 3s130ms 2s320ms select "ir_model_fields".id from "ir_model_fields" where ("ir_model_fields"."model" = ?) order by "ir_model_fields"."name";-
SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'res.partner') ORDER BY "ir_model_fields"."name";
Date: 2023-03-09 10:30:29
-
SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'res.partner') ORDER BY "ir_model_fields"."name";
Date: 2023-03-09 18:41:34
-
SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.product') ORDER BY "ir_model_fields"."name";
Date: 2023-03-09 18:41:34
12 1 11s70ms 11s70ms 11s70ms 11s70ms update "stock_move" set "date" = ?, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);-
UPDATE "stock_move" SET "date" = '2023-03-09 13:54:07', "state" = 'done', "write_uid" = 958, "write_date" = (now() at time zone 'UTC') WHERE id IN (288297, 288298, 288299, 288300, 288302, 288303, 288304, 288305, 288306, 288307, 288308, 288309, 288310, 288312, 288313, 288314, 288315, 288316, 288317, 288318, 288319, 288320, 288321, 288322, 288323, 288324, 288325, 288326, 288327, 288328, 288329, 288330, 288331, 288332, 288333, 288334, 288335, 288336, 288337, 288338, 288339, 288340, 288341, 288342, 288343, 288344, 288345, 288346, 288347, 288348, 288349, 288350, 288351, 288352);
Date: 2023-03-09 13:55:05
-
UPDATE "stock_move" SET "date" = '2023-03-09 15:37:59', "state" = 'done', "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (292480, 292481, 292482, 292483, 292484, 292485, 292486, 292488, 292489, 292490, 292491, 292493, 292494, 292495, 292496, 292497, 292498, 292499, 292500, 292501, 292502, 292503, 292504, 292505, 292506, 292507, 292508, 292510, 292511, 292512, 292513, 292514, 292515, 292516, 292517, 292518, 292519, 292520, 292521);
Date: 2023-03-09 15:38:35
-
UPDATE "stock_move" SET "date" = '2023-03-09 15:22:36', "state" = 'done', "write_uid" = 989, "write_date" = (now() at time zone 'UTC') WHERE id IN (309252, 309147, 309156, 309158, 308904, 309164, 309171, 309172, 308917, 309176, 308923, 309181, 309182, 309185, 309186, 309192, 309193, 309194, 309195, 309198, 309328, 309330, 309203, 309209, 309216, 309222, 309224, 309225, 309226, 309229, 309230, 309231, 309233, 309234, 309237);
Date: 2023-03-09 15:23:13
13 1 10s466ms 10s466ms 10s466ms 10s466ms update "product_warehouse_inventory" set "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);-
UPDATE "product_warehouse_inventory" SET "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (98176, 98177, 98178, 98179, 98180, 98181, 98182, 98183, 331914, 105367, 98327, 98329, 98328, 98330, 98331, 98206, 98207, 98208, 98209, 98210, 98211, 98212, 98213, 98214, 98087, 98088, 98089, 98090, 98091, 98092, 98093, 98094, 98345, 98346, 98347, 98349, 98248, 98249, 98250, 98251, 98252, 98253, 98254, 98255, 98256, 98344, 98149, 98278, 98279, 98280, 98281, 98282, 98283, 98284, 98285, 98286, 98152, 98153, 98155, 98154, 98157, 98156, 98175, 98150, 98151);
Date: 2023-03-09 17:35:24
14 1 7s83ms 7s83ms 7s83ms 7s83ms update "repair_line" set "qty_delivered_method" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);-
UPDATE "repair_line" SET "qty_delivered_method" = 'stock_move', "write_uid" = 1031, "write_date" = (now() at time zone 'UTC') WHERE id IN (19937, 20134, 20135, 20136, 20137, 20138, 20139, 20140, 20141, 20142, 20143, 20368, 20144, 20145, 20146, 20147, 20148, 20149, 20150, 20214);
Date: 2023-03-09 20:07:54
-
UPDATE "repair_line" SET "qty_delivered_method" = 'stock_move', "write_uid" = 968, "write_date" = (now() at time zone 'UTC') WHERE id IN (20556, 20557, 20558, 20559, 20560, 20561, 20562, 20563, 20564, 20565, 20566, 20567, 20568, 20569, 20570);
Date: 2023-03-09 20:08:18
-
UPDATE "repair_line" SET "qty_delivered_method" = 'stock_move', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (20480, 20481, 20482, 20483, 20470, 20472, 20473, 20474, 20475, 20476, 20477, 20478, 20479);
Date: 2023-03-09 15:02:46
15 1 5s455ms 5s455ms 5s455ms 5s455ms update "sale_order_line" set "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);-
UPDATE "sale_order_line" SET "write_uid" = 1140, "write_date" = (now() at time zone 'UTC') WHERE id IN (103008, 103040, 103042, 103013, 103014, 103037, 103045, 103049, 103018, 103053, 103025, 103030, 103063, 103064, 103034, 103003, 103004, 103005, 103007);
Date: 2023-03-09 13:13:33
-
UPDATE "sale_order_line" SET "write_uid" = 1141, "write_date" = (now() at time zone 'UTC') WHERE id IN (103809, 103813, 103814, 103048, 101619, 102495);
Date: 2023-03-09 20:58:40
-
UPDATE "sale_order_line" SET "write_uid" = 1147, "write_date" = (now() at time zone 'UTC') WHERE id IN (103028, 103029, 103031, 103033, 103036);
Date: 2023-03-09 13:07:08
16 1 3s471ms 3s471ms 3s471ms 3s471ms update "account_move" set "access_token" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);-
UPDATE "account_move" SET "access_token" = '1fa78b14-2a3c-45da-bcde-e4086e855262', "write_uid" = 953, "write_date" = (now() at time zone 'UTC') WHERE id IN (469401);
Date: 2023-03-09 14:15:53
17 1 3s131ms 3s131ms 3s131ms 3s131ms select name, id from ir_model_fields where model = ?;-
SELECT name, id FROM ir_model_fields WHERE model = 'ir.actions.report';
Date: 2023-03-09 18:41:34
-
SELECT name, id FROM ir_model_fields WHERE model = 'ir.actions.report';
Date: 2023-03-09 18:41:34
18 1 2s498ms 2s498ms 2s498ms 2s498ms update "product_warehouse_inventory" set "lead_days" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);-
UPDATE "product_warehouse_inventory" SET "lead_days" = 10, "write_uid" = 1019, "write_date" = (now() at time zone 'UTC') WHERE id IN (39221);
Date: 2023-03-09 15:36:41
-
UPDATE "product_warehouse_inventory" SET "lead_days" = 10, "write_uid" = 1019, "write_date" = (now() at time zone 'UTC') WHERE id IN (39221);
Date: 2023-03-09 15:36:41
19 1 2s434ms 2s434ms 2s434ms 2s434ms select f.name, d.json_value from ir_default d join ir_model_fields f on d.field_id = f.id where f.model = ? and (d.user_id is null or d.user_id = ?) and (d.company_id is null or d.company_id = ?) and d.condition is null order by d.user_id, d.company_id, d.id;-
SELECT f.name, d.json_value FROM ir_default d JOIN ir_model_fields f ON d.field_id = f.id WHERE f.model = 'website.visitor' AND (d.user_id IS NULL OR d.user_id = 4) AND (d.company_id IS NULL OR d.company_id = 1) AND d.condition IS NULL ORDER BY d.user_id, d.company_id, d.id;
Date: 2023-03-09 18:41:34
-
SELECT f.name, d.json_value FROM ir_default d JOIN ir_model_fields f ON d.field_id = f.id WHERE f.model = 'ir.attachment' AND (d.user_id IS NULL OR d.user_id = 1) AND (d.company_id IS NULL OR d.company_id = 1) AND d.condition IS NULL ORDER BY d.user_id, d.company_id, d.id;
Date: 2023-03-09 10:30:29
-
SELECT f.name, d.json_value FROM ir_default d JOIN ir_model_fields f ON d.field_id = f.id WHERE f.model = 'website.visitor' AND (d.user_id IS NULL OR d.user_id = 4) AND (d.company_id IS NULL OR d.company_id = 1) AND d.condition IS NULL ORDER BY d.user_id, d.company_id, d.id;
Date: 2023-03-09 10:30:01
20 1 2s374ms 2s374ms 2s374ms 2s374ms insert into "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "price_unit", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "purchase_line_id", "sequence", "state", "warehouse_id") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), false, null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, null, ?, ?, ?.?, ?, ?, ?, ?, ?, true, ?, ?, ?, ?) returning id;-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "price_unit", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "purchase_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 997, (now() at time zone 'UTC'), 997, (now() at time zone 'UTC'), false, NULL, 44, 1, '2023-03-09 21:39:16.504912', '2023-03-09 21:39:16.504912', '[TBB-ST] Terminal Blue16-14 Butt HS', 65510, 429, 4, 'new_product', '[TBB-ST] Terminal Blue16-14 Butt HS', 'B-00656', NULL, 90162, 321, 9.0, '0', 'make_to_stock', 193789, 98, '2.00', true, 44838, 10, 'draft', 41) RETURNING id;
Date: 2023-03-09 21:39:42
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "price_unit", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "purchase_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1012, (now() at time zone 'UTC'), 1012, (now() at time zone 'UTC'), false, NULL, 37, 1, '2023-03-09 20:09:03.262393', '2023-03-09 20:09:03.262393', '[M65157] Shock Absorber', 65400, 381, 4, 'new_product', '[M65157] Shock Absorber', 'G-00907', NULL, 90005, 273, 52.65, '0', 'make_to_stock', 219717, 1, '4.00', true, 44795, 10, 'draft', 35) RETURNING id;
Date: 2023-03-09 20:10:18
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "price_unit", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "purchase_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1012, (now() at time zone 'UTC'), 1012, (now() at time zone 'UTC'), false, NULL, 37, 1, '2023-03-09 16:07:32.191329', '2023-03-09 16:07:32.191329', '[N3-28-97] Tube Weld Yoke', 65268, 381, 4, 'new_product', '[N3-28-97] Tube Weld Yoke', 'G-00895', NULL, 89772, 273, 17.02, '0', 'make_to_stock', 172046, 1, '2.00', true, 44519, 10, 'draft', 35) RETURNING id;
Date: 2023-03-09 18:12:04
21 1 2s297ms 2s297ms 2s297ms 2s297ms insert into "account_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "auto_post", "branch_id", "currency_id", "date", "edi_billed", "edi_split_lock", "extract_remote_id", "extract_state", "invoice_incoterm_id", "invoice_product_qty", "invoice_user_id", "is_edi_bill", "is_move_sent", "journal_id", "move_type", "open_invoice", "partner_id", "ref", "state", "stock_move_id", "team_id", "to_check", "to_check_negative") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), false, ?, ?, ?, false, false, ?, ?, null, ?.?, ?, false, false, ?, ?, false, ?, ?, ?, ?, ?, false, false) returning id;-
INSERT INTO "account_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "auto_post", "branch_id", "currency_id", "date", "edi_billed", "edi_split_lock", "extract_remote_id", "extract_state", "invoice_incoterm_id", "invoice_product_qty", "invoice_user_id", "is_edi_bill", "is_move_sent", "journal_id", "move_type", "open_invoice", "partner_id", "ref", "state", "stock_move_id", "team_id", "to_check", "to_check_negative") VALUES (nextval('account_move_id_seq'), 965, (now() at time zone 'UTC'), 965, (now() at time zone 'UTC'), false, 48, 2, '2023-03-09', false, false, - 1, 'no_extract_requested', NULL, 1.0, 965, false, false, 6, 'entry', false, 33656, '13-T/IN/04130 - [RB-308] Bushing', 'draft', 310042, 1, false, false) RETURNING id;
Date: 2023-03-09 18:41:16
-
INSERT INTO "account_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "auto_post", "branch_id", "currency_id", "date", "edi_billed", "edi_split_lock", "extract_remote_id", "extract_state", "invoice_incoterm_id", "invoice_product_qty", "invoice_user_id", "is_edi_bill", "is_move_sent", "journal_id", "move_type", "open_invoice", "partner_id", "ref", "state", "stock_move_id", "team_id", "to_check", "to_check_negative") VALUES (nextval('account_move_id_seq'), 965, (now() at time zone 'UTC'), 965, (now() at time zone 'UTC'), false, 48, 2, '2023-03-09', false, false, - 1, 'no_extract_requested', NULL, 1.0, 965, false, false, 6, 'entry', false, 33656, '13-T/IN/04130 - [RB-308] Bushing', 'draft', 310042, 1, false, false) RETURNING id;
Date: 2023-03-09 18:41:16
22 1 1s307ms 1s307ms 1s307ms 1s307ms insert into "ir_model" ("model", "name", "order", "info", "state", "transient", "is_mail_thread", "is_mail_activity", "is_mail_blacklist") values (?, ?, ?, ?, ?, false, false, false, false), (?, ?, ?, ?, ?, false, false, false, false) on conflict (model) do update set ("model", "name", "order", "info", "state", "transient", "is_mail_thread", "is_mail_activity", "is_mail_blacklist") = (excluded."model", excluded."name", excluded."order", excluded."info", excluded."state", excluded."transient", excluded."is_mail_thread", excluded."is_mail_activity", excluded."is_mail_blacklist") returning id;-
INSERT INTO "ir_model" ("model", "name", "order", "info", "state", "transient", "is_mail_thread", "is_mail_activity", "is_mail_blacklist") VALUES ('product.warehouse.inventory', 'Product Warehouse Inventory', 'id', ' Main super-class for regular database-persisted Odoo models. Odoo models are created by inheriting from this class:: class user(Model): ... The system will later instantiate the class once per database (on which the class'' module is installed). ', 'base', false, false, false, false), ('sale.order.line', 'Sales Order Line', 'id asc', 'Defines getters to have a common facade for order and invoice lines in TaxCloud.', 'base', false, false, false, false) ON CONFLICT (model) DO UPDATE SET ("model", "name", "order", "info", "state", "transient", "is_mail_thread", "is_mail_activity", "is_mail_blacklist") = (EXCLUDED."model", EXCLUDED."name", EXCLUDED."order", EXCLUDED."info", EXCLUDED."state", EXCLUDED."transient", EXCLUDED."is_mail_thread", EXCLUDED."is_mail_activity", EXCLUDED."is_mail_blacklist") RETURNING id;
Date: 2023-03-09 18:42:18
23 1 1s155ms 1s155ms 1s155ms 1s155ms update "account_move" set "is_move_sent" = true, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);-
UPDATE "account_move" SET "is_move_sent" = true, "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (469534);
Date: 2023-03-09 14:31:13
Queries that waited the most
Rank Wait time Query 1 1m35s WITH dupes AS ( SELECT min(id) as to_update_quant_id, (array_agg(id ORDER BY id))[2:array_length(array_agg(id), 1)] as to_delete_quant_ids, SUM(reserved_quantity) as reserved_quantity, SUM(quantity) as quantity FROM stock_quant GROUP BY product_id, company_id, location_id, lot_id, package_id, owner_id, in_date, move_options HAVING count(id) > 1 ), _up AS ( UPDATE stock_quant q SET quantity = d.quantity, reserved_quantity = d.reserved_quantity FROM dupes d WHERE d.to_update_quant_id = q.id) DELETE FROM stock_quant WHERE id in ( SELECT unnest(to_delete_quant_ids) from dupes);[ Date: 2023-03-09 15:40:09 ]
2 1m19s UPDATE "sale_order_line" SET "branch_id" = 37, "currency_id" = 2, "cus_date_order" = '2023-03-09 13:54:08', "cus_part_route" = 3, "cus_user_id" = 992, "inventory_vendor_id" = 2952, "is_service" = false, "margin" = '5.18', "margin_percent" = 0.8633333333333333, "order_partner_id" = 37700, "price_reduce" = '3.00', "price_reduce_taxexcl" = '3.00', "price_reduce_taxinc" = '3.00', "price_subtotal" = '6.00', "price_tax" = 0.0, "price_total" = '6.00', "purchase_price" = '0.41', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 992, "untaxed_amount_invoiced" = '0.00', "untaxed_amount_to_invoice" = '0.00', "warehouse_id" = 35, "write_uid" = 984, "write_date" = (now() at time zone 'UTC') WHERE id IN (103251);[ Date: 2023-03-09 13:56:44 ]
3 1m12s WITH dupes AS ( SELECT min(id) as to_update_quant_id, (array_agg(id ORDER BY id))[2:array_length(array_agg(id), 1)] as to_delete_quant_ids, SUM(reserved_quantity) as reserved_quantity, SUM(quantity) as quantity FROM stock_quant GROUP BY product_id, company_id, location_id, lot_id, package_id, owner_id, in_date, move_options HAVING count(id) > 1 ), _up AS ( UPDATE stock_quant q SET quantity = d.quantity, reserved_quantity = d.reserved_quantity FROM dupes d WHERE d.to_update_quant_id = q.id) DELETE FROM stock_quant WHERE id in ( SELECT unnest(to_delete_quant_ids) from dupes);[ Date: 2023-03-09 15:40:09 ]
4 1m UPDATE "stock_move_line" SET "date" = '2023-03-09 15:23:36', "product_qty" = 0.0, "product_uom_qty" = '0.00', "write_uid" = 989, "write_date" = (now() at time zone 'UTC') WHERE id IN (307834, 307835);[ Date: 2023-03-09 15:24:40 ]
5 18s576ms UPDATE "sale_order_line" SET "branch_id" = 39, "warehouse_id" = 37, "write_uid" = 1141, "write_date" = (now() at time zone 'UTC') WHERE id IN (101619);[ Date: 2023-03-09 20:59:28 ]
6 17s996ms UPDATE "sale_order_line" SET "branch_id" = 39, "warehouse_id" = 37, "write_uid" = 1141, "write_date" = (now() at time zone 'UTC') WHERE id IN (101619);[ Date: 2023-03-09 20:59:05 ]
7 14s513ms UPDATE "sale_order_line" SET "branch_id" = 39, "warehouse_id" = 37, "write_uid" = 1141, "write_date" = (now() at time zone 'UTC') WHERE id IN (101619);[ Date: 2023-03-09 21:00:14 ]
8 12s955ms UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2023-03-09 17:41:48 ]
9 11s934ms UPDATE "sale_order_line" SET "branch_id" = 39, "warehouse_id" = 37, "write_uid" = 1141, "write_date" = (now() at time zone 'UTC') WHERE id IN (101619);[ Date: 2023-03-09 21:00:37 ]
10 11s70ms UPDATE "stock_move" SET "date" = '2023-03-09 15:37:15', "state" = 'done', "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (292480, 292481, 292482, 292483, 292484, 292485, 292486, 292488, 292489, 292490, 292491, 292493, 292494, 292495, 292496, 292497, 292498, 292499, 292500, 292501, 292502, 292503, 292504, 292505, 292506, 292507, 292508, 292510, 292511, 292512, 292513, 292514, 292515, 292516, 292517, 292518, 292519, 292520, 292521);[ Date: 2023-03-09 15:37:52 ]
11 10s466ms UPDATE "product_warehouse_inventory" SET "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (98176, 98177, 98178, 98179, 98180, 98181, 98182, 98183, 331914, 105367, 98327, 98329, 98328, 98330, 98331, 98206, 98207, 98208, 98209, 98210, 98211, 98212, 98213, 98214, 98087, 98088, 98089, 98090, 98091, 98092, 98093, 98094, 98345, 98346, 98347, 98349, 98248, 98249, 98250, 98251, 98252, 98253, 98254, 98255, 98256, 98344, 98149, 98278, 98279, 98280, 98281, 98282, 98283, 98284, 98285, 98286, 98152, 98153, 98155, 98154, 98157, 98156, 98175, 98150, 98151);[ Date: 2023-03-09 17:35:24 ]
12 8s905ms DELETE FROM ir_attachment WHERE id IN (1092588);[ Date: 2023-03-09 10:29:49 ]
13 8s773ms UPDATE "sale_order_line" SET "branch_id" = 39, "warehouse_id" = 37, "write_uid" = 1141, "write_date" = (now() at time zone 'UTC') WHERE id IN (101619);[ Date: 2023-03-09 20:59:50 ]
14 8s768ms 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 != 469461 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 != 469461 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2023-03-09 14:19:31 ]
15 8s430ms 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 != 437224 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 != 437224 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2023-03-09 21:14:08 ]
16 7s349ms UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 437138 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 437138 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2023-03-09 18:38:00 ]
17 7s83ms UPDATE "repair_line" SET "qty_delivered_method" = 'stock_move', "write_uid" = 968, "write_date" = (now() at time zone 'UTC') WHERE id IN (20556, 20557, 20558, 20559, 20560, 20561, 20562, 20563, 20564, 20565, 20566, 20567, 20568, 20569, 20570);[ Date: 2023-03-09 20:08:11 ]
18 6s629ms UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 273749 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 273749 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2023-03-09 17:33:41 ]
19 5s589ms 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 != 470111 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 != 470111 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2023-03-09 15:51:59 ]
20 5s499ms UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 470640 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.*?)(?:((?<=\D)|(?<=^))((19|20|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 470640 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name;[ Date: 2023-03-09 17:11:16 ]
-
Queries
Queries by type
Key values
- 61,178 Total read queries
- 24,492 Total write queries
Queries by database
Key values
- unknown Main database
- 85,670 Requests
- 11h3m5s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 85,708 Requests
User Request type Count Duration unknown Total 85,708 11h3m19s copy to 145 9m11s cte 1,362 5m31s ddl 16 26s786ms delete 186 5m20s insert 2,594 39m46s select 61,208 5h26m14s update 20,197 4h36m48s Duration by user
Key values
- 11h3m19s (unknown) Main time consuming user
User Request type Count Duration unknown Total 85,708 11h3m19s copy to 145 9m11s cte 1,362 5m31s ddl 16 26s786ms delete 186 5m20s insert 2,594 39m46s select 61,208 5h26m14s update 20,197 4h36m48s Queries by host
Key values
- unknown Main host
- 85,708 Requests
- 11h3m19s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 85,670 Requests
- 11h3m5s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2023-03-09 15:01:03 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 57,045 100-500ms duration
Slowest individual queries
Rank Duration Query 1 53s443ms UPDATE "stock_move" SET "date" = '2023-03-09 13:54:07', "state" = 'done', "write_uid" = 958, "write_date" = (now() at time zone 'UTC') WHERE id IN (288297, 288298, 288299, 288300, 288302, 288303, 288304, 288305, 288306, 288307, 288308, 288309, 288310, 288312, 288313, 288314, 288315, 288316, 288317, 288318, 288319, 288320, 288321, 288322, 288323, 288324, 288325, 288326, 288327, 288328, 288329, 288330, 288331, 288332, 288333, 288334, 288335, 288336, 288337, 288338, 288339, 288340, 288341, 288342, 288343, 288344, 288345, 288346, 288347, 288348, 288349, 288350, 288351, 288352);[ Date: 2023-03-09 13:55:05 ]
2 38s488ms COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;[ Date: 2023-03-09 09:01:38 ]
3 36s836ms UPDATE "stock_move" SET "date" = '2023-03-09 15:37:59', "state" = 'done', "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (292480, 292481, 292482, 292483, 292484, 292485, 292486, 292488, 292489, 292490, 292491, 292493, 292494, 292495, 292496, 292497, 292498, 292499, 292500, 292501, 292502, 292503, 292504, 292505, 292506, 292507, 292508, 292510, 292511, 292512, 292513, 292514, 292515, 292516, 292517, 292518, 292519, 292520, 292521);[ Date: 2023-03-09 15:38:35 ]
4 36s106ms COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;[ Date: 2023-03-09 16:51:59 ]
5 35s630ms COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;[ Date: 2023-03-09 14:32:24 ]
6 34s225ms UPDATE "stock_move" SET "date" = '2023-03-09 15:22:36', "state" = 'done', "write_uid" = 989, "write_date" = (now() at time zone 'UTC') WHERE id IN (309252, 309147, 309156, 309158, 308904, 309164, 309171, 309172, 308917, 309176, 308923, 309181, 309182, 309185, 309186, 309192, 309193, 309194, 309195, 309198, 309328, 309330, 309203, 309209, 309216, 309222, 309224, 309225, 309226, 309229, 309230, 309231, 309233, 309234, 309237);[ Date: 2023-03-09 15:23:13 ]
7 33s678ms UPDATE "stock_move" SET "is_done" = true, "write_uid" = 989, "write_date" = (now() at time zone 'UTC') WHERE id IN (309252, 309147, 309156, 309158, 308903, 308904, 309164, 309171, 309172, 308917, 309176, 308923, 309181, 309182, 309185, 309186, 309192, 309193, 309194, 309195, 309198, 309328, 309330, 309203, 309209, 309216, 309222, 309224, 309225, 309226, 309229, 309230, 309231, 309233, 309234, 309237);[ Date: 2023-03-09 15:24:38 ]
8 29s776ms UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (309252, 309147, 309156, 309158, 308903, 309164, 309171, 309172, 309176, 308923, 309181, 309182, 309185, 309186, 309192, 309193, 309194, 309195, 309198, 309203, 309209, 309216, 309222, 309224, 309225, 309226, 309229, 309230, 309231, 309233, 309234, 309237);[ Date: 2023-03-09 14:53:59 ]
9 25s912ms UPDATE "stock_move" SET "date" = '2023-03-09 18:11:21', "state" = 'done', "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (302131, 302133, 302134, 302135, 302136, 302138, 302140, 302141, 302142, 302143, 302144, 302146, 302147, 302148, 302151, 302152, 302154, 302155, 302156, 302157, 302159, 302161, 302163, 302164, 302165);[ Date: 2023-03-09 18:11:47 ]
10 25s658ms COPY public.company_transfer (id, to_ship, inventory_vendor, internal_reference, product_name, from_wh_on_reserve, on_hand, on_order, usage, to_warehouse, request_qty, request_date, open_qty, customer, order_date, document, product_id, create_uid, create_date, write_uid, write_date, act_open_qty, to_warehouse_htm, to_ship_htm, open_receiving, ready_to_rx, not_ready_to_rx, bo_qty_char, order_date_char, customer_id, document_char, ship_to_htm, warehouse_to_htm, cat_vendor_short_name, done_qty, notes) TO stdout;[ Date: 2023-03-09 09:00:52 ]
11 24s829ms COPY public.company_transfer (id, to_ship, inventory_vendor, internal_reference, product_name, from_wh_on_reserve, on_hand, on_order, usage, to_warehouse, request_qty, request_date, open_qty, customer, order_date, document, product_id, create_uid, create_date, write_uid, write_date, act_open_qty, to_warehouse_htm, to_ship_htm, open_receiving, ready_to_rx, not_ready_to_rx, bo_qty_char, order_date_char, customer_id, document_char, ship_to_htm, warehouse_to_htm, cat_vendor_short_name, done_qty, notes) TO stdout;[ Date: 2023-03-09 14:31:40 ]
12 23s714ms COPY public.company_transfer (id, to_ship, inventory_vendor, internal_reference, product_name, from_wh_on_reserve, on_hand, on_order, usage, to_warehouse, request_qty, request_date, open_qty, customer, order_date, document, product_id, create_uid, create_date, write_uid, write_date, act_open_qty, to_warehouse_htm, to_ship_htm, open_receiving, ready_to_rx, not_ready_to_rx, bo_qty_char, order_date_char, customer_id, document_char, ship_to_htm, warehouse_to_htm, cat_vendor_short_name, done_qty, notes) TO stdout;[ Date: 2023-03-09 16:51:16 ]
13 22s816ms UPDATE "stock_move" SET "date" = '2023-03-09 19:20:54', "state" = 'done', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (310144, 310146, 310147, 310148, 310149, 310150, 310151, 310154, 310155, 310156, 310160, 310161, 310163, 310165, 310129, 310134, 310136, 310137, 310138, 310139, 310140, 310141, 310142);[ Date: 2023-03-09 19:21:19 ]
14 22s266ms UPDATE "stock_move" SET "date" = '2023-03-09 15:36:56', "state" = 'done', "write_uid" = 1019, "write_date" = (now() at time zone 'UTC') WHERE id IN (292524, 292525, 292526, 292527, 292528, 292529, 292530, 292531, 292532, 292533, 292534, 292535, 292536, 292537, 292538, 292539, 292540, 292542, 292543, 292544, 292545, 292546);[ Date: 2023-03-09 15:37:18 ]
15 21s118ms UPDATE "stock_move" SET "is_done" = true, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (310144, 310146, 310147, 310148, 310149, 310150, 310151, 310154, 310155, 310156, 310160, 310161, 310163, 310165, 310129, 310134, 310136, 310137, 310138, 310139, 310140, 310141, 310142);[ Date: 2023-03-09 19:22:11 ]
16 20s776ms DELETE FROM account_move_line WHERE id IN (1309464, 1309465, 1309466, 1309467, 1309468, 1309469, 1309470, 1309471, 1309472, 1309473, 1309474, 1309475, 1309476, 1309477, 1309478, 1309479, 1309480, 1309481, 1309482, 1309483, 1309484, 1309485, 1309486, 1309487, 1309488, 1309489, 1309490, 1309491, 1309492, 1309493, 1309494, 1309495, 1309496, 1309497, 1309498, 1309499, 1309500, 1309501, 1309502, 1309503, 1309504, 1309505, 1309506, 1309507, 1309508, 1309509, 1309510, 1309511, 1309512, 1309513, 1309514, 1309515, 1309516, 1309517, 1309518, 1309519, 1309520, 1309521, 1777337, 1777338);[ Date: 2023-03-09 10:23:41 ]
17 20s136ms COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage) TO stdout;[ Date: 2023-03-09 09:03:11 ]
18 20s122ms UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (310144, 310146, 310147, 310148, 310149, 310150, 310151, 310154, 310155, 310156, 310160, 310161, 310163, 310165, 310128, 310136, 310137, 310138, 310139, 310140, 310141, 310142);[ Date: 2023-03-09 19:12:47 ]
19 19s143ms COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;[ Date: 2023-03-09 09:01:59 ]
20 19s70ms UPDATE "stock_move" SET "date" = '2023-03-09 17:27:55', "state" = 'done', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (305536, 305537, 305538, 305539, 305541, 305519, 305520, 305521, 305522, 305523, 305524, 305525, 305526, 305527, 305528, 305529, 305531, 305532, 305533, 305534, 305535);[ Date: 2023-03-09 17:28:14 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 47m 2,221 622ms 8s15ms 1s269ms select "item_list_line".id from "item_list_line" where (((("item_list_line"."active" = true) and ("item_list_line"."product_id" = ?)) and (("item_list_line"."method" not in (...)) or "item_list_line"."method" is null)) and ("item_list_line"."item_demand_plan_id" = ?)) order by "item_list_line"."id" limit ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 09 14 28 19s980ms 713ms 21 1,944 43m30s 1s342ms 22 249 3m9s 762ms -
SELECT "item_list_line".id FROM "item_list_line" WHERE (((("item_list_line"."active" = true) AND ("item_list_line"."product_id" = 195662)) AND (("item_list_line"."method" not in (7, 8)) OR "item_list_line"."method" IS NULL)) AND ("item_list_line"."item_demand_plan_id" = 2853)) ORDER BY "item_list_line"."id" LIMIT 1;
Date: 2023-03-09 21:31:50 Duration: 8s15ms
-
SELECT "item_list_line".id FROM "item_list_line" WHERE (((("item_list_line"."active" = true) AND ("item_list_line"."product_id" = 194841)) AND (("item_list_line"."method" not in (7, 8)) OR "item_list_line"."method" IS NULL)) AND ("item_list_line"."item_demand_plan_id" = 2857)) ORDER BY "item_list_line"."id" LIMIT 1;
Date: 2023-03-09 21:32:35 Duration: 7s480ms
-
SELECT "item_list_line".id FROM "item_list_line" WHERE (((("item_list_line"."active" = true) AND ("item_list_line"."product_id" = 194821)) AND (("item_list_line"."method" not in (7, 8)) OR "item_list_line"."method" IS NULL)) AND ("item_list_line"."item_demand_plan_id" = 2859)) ORDER BY "item_list_line"."id" LIMIT 1;
Date: 2023-03-09 21:32:49 Duration: 7s309ms
2 36m30s 3,851 485ms 1s264ms 568ms 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 09 01 32 17s216ms 538ms 11 59 31s994ms 542ms 12 273 2m29s 549ms 13 929 8m56s 577ms 14 454 4m17s 566ms 15 300 2m47s 559ms 16 343 3m14s 565ms 17 235 2m13s 566ms 18 341 3m16s 577ms 19 323 3m2s 565ms 20 329 3m3s 556ms 21 183 1m51s 611ms 22 32 17s386ms 543ms 23 18 9s670ms 537ms -
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 ('%%562112436%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%562.112436%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%562.112436%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-03-09 21:32:23 Duration: 1s264ms
-
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 ('%%5621124%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%562.1124%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%562.1124%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-03-09 21:32:22 Duration: 1s234ms
-
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 ('%%562%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%562.%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%562.%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-03-09 21:32:20 Duration: 1s77ms
3 32m12s 1,086 848ms 29s776ms 1s779ms update "stock_move" set "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 09 11 2 5s380ms 2s690ms 12 74 2m14s 1s819ms 13 170 5m49s 2s54ms 14 136 4m12s 1s857ms 15 90 3m5s 2s64ms 16 126 3m45s 1s792ms 17 127 4m4s 1s928ms 18 115 2m22s 1s242ms 19 101 2m42s 1s606ms 20 74 1m45s 1s431ms 21 60 1m52s 1s874ms 22 4 4s532ms 1s133ms 23 7 6s362ms 908ms -
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (309252, 309147, 309156, 309158, 308903, 309164, 309171, 309172, 309176, 308923, 309181, 309182, 309185, 309186, 309192, 309193, 309194, 309195, 309198, 309203, 309209, 309216, 309222, 309224, 309225, 309226, 309229, 309230, 309231, 309233, 309234, 309237);
Date: 2023-03-09 14:53:59 Duration: 29s776ms
-
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (310144, 310146, 310147, 310148, 310149, 310150, 310151, 310154, 310155, 310156, 310160, 310161, 310163, 310165, 310128, 310136, 310137, 310138, 310139, 310140, 310141, 310142);
Date: 2023-03-09 19:12:47 Duration: 20s122ms
-
UPDATE "stock_move" SET "state" = 'assigned', "write_uid" = 1037, "write_date" = (now() at time zone 'UTC') WHERE id IN (309312, 309313, 309314, 309315, 309316, 309318, 309319, 309320, 309303, 309304, 309305, 309306, 309307, 309308, 309309, 309310, 309311);
Date: 2023-03-09 15:07:38 Duration: 16s138ms
4 31m18s 788 875ms 53s443ms 2s384ms update "stock_move" set "date" = ?, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 09 09 1 10s19ms 10s19ms 10 4 6s430ms 1s607ms 12 47 1m44s 2s223ms 13 125 4m54s 2s353ms 14 147 4m41s 1s913ms 15 77 4m54s 3s829ms 16 86 3m12s 2s239ms 17 72 3m4s 2s561ms 18 67 2m28s 2s215ms 19 73 2m35s 2s130ms 20 46 1m55s 2s514ms 21 27 1m14s 2s763ms 22 4 5s417ms 1s354ms 23 12 10s872ms 906ms -
UPDATE "stock_move" SET "date" = '2023-03-09 13:54:07', "state" = 'done', "write_uid" = 958, "write_date" = (now() at time zone 'UTC') WHERE id IN (288297, 288298, 288299, 288300, 288302, 288303, 288304, 288305, 288306, 288307, 288308, 288309, 288310, 288312, 288313, 288314, 288315, 288316, 288317, 288318, 288319, 288320, 288321, 288322, 288323, 288324, 288325, 288326, 288327, 288328, 288329, 288330, 288331, 288332, 288333, 288334, 288335, 288336, 288337, 288338, 288339, 288340, 288341, 288342, 288343, 288344, 288345, 288346, 288347, 288348, 288349, 288350, 288351, 288352);
Date: 2023-03-09 13:55:05 Duration: 53s443ms
-
UPDATE "stock_move" SET "date" = '2023-03-09 15:37:59', "state" = 'done', "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (292480, 292481, 292482, 292483, 292484, 292485, 292486, 292488, 292489, 292490, 292491, 292493, 292494, 292495, 292496, 292497, 292498, 292499, 292500, 292501, 292502, 292503, 292504, 292505, 292506, 292507, 292508, 292510, 292511, 292512, 292513, 292514, 292515, 292516, 292517, 292518, 292519, 292520, 292521);
Date: 2023-03-09 15:38:35 Duration: 36s836ms
-
UPDATE "stock_move" SET "date" = '2023-03-09 15:22:36', "state" = 'done', "write_uid" = 989, "write_date" = (now() at time zone 'UTC') WHERE id IN (309252, 309147, 309156, 309158, 308904, 309164, 309171, 309172, 308917, 309176, 308923, 309181, 309182, 309185, 309186, 309192, 309193, 309194, 309195, 309198, 309328, 309330, 309203, 309209, 309216, 309222, 309224, 309225, 309226, 309229, 309230, 309231, 309233, 309234, 309237);
Date: 2023-03-09 15:23:13 Duration: 34s225ms
5 26m11s 11,108 120ms 431ms 141ms select "product_warehouse_inventory".id from "product_warehouse_inventory" where ("product_warehouse_inventory"."product_id" in (...)) order by "product_warehouse_inventory"."warehouse_name";Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 09 06 15 1s967ms 131ms 07 10 1s248ms 124ms 09 2 260ms 130ms 10 107 13s845ms 129ms 11 8 1s670ms 208ms 12 261 34s587ms 132ms 13 621 1m22s 133ms 14 642 1m26s 134ms 15 589 1m17s 130ms 16 1,239 2m42s 131ms 17 638 1m23s 130ms 18 1,305 2m52s 131ms 19 1,119 2m25s 129ms 20 310 40s381ms 130ms 21 2,853 8m10s 171ms 22 1,210 2m35s 128ms 23 179 22s557ms 126ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (195469, 193789, 193839, 193847, 193848, 193866, 193924, 193931, 193946, 193950, 193983, 194068, 194069, 194109, 194125, 194147, 194173, 194198, 194200, 194203, 194250, 194333, 194376, 194422, 194433, 194436, 194437, 194455, 194475, 194491, 194519, 194546, 194549, 194558, 194562, 194563, 194586, 194592, 194621, 194628, 194634, 194648, 194650, 194662, 194678, 194703, 194705, 194706, 194711, 194712, 194713, 194719, 194731, 194739, 194740, 194744, 194749, 194751, 194752, 194761, 194768, 194770, 194771, 194793, 194821, 194823, 194828, 194830, 194834, 194836, 194837, 194841, 194845, 194859, 194865, 194871, 194872, 194874, 194875, 194877, 194891, 194925, 194929, 194930, 194931, 194932, 194955, 194958, 194964, 194967, 194970, 194976, 194979, 195002, 195010, 195017, 195022, 195026, 195031, 195035, 195046, 195047, 195049, 195051, 195053, 195056, 195062, 195064, 195065, 195069, 195083, 195090, 195092, 195099, 195103, 195107, 195144, 195145, 195160, 195161, 195162, 195164, 195165, 195168, 195170, 195179, 195202, 195210, 195218, 195219, 195223, 195224, 195229, 195230, 195231, 195232, 195233, 195241, 195253, 195255, 195256, 195262, 195263, 195267, 195268, 195373, 195385, 195399, 195410, 195416, 195467, 195545, 195574, 195577, 195592, 195593, 195616, 195644, 195646, 195651, 195652, 195662, 195667, 195671, 195680, 195701, 195742, 195783, 195785, 195802, 195808, 195835, 195836, 195842, 195851, 195852, 195854, 195863, 195866, 195869, 195915, 195916, 195918, 195927, 195930, 195950, 195953, 195983, 195984, 195985, 195986, 195987, 195988, 195989, 195990, 195991, 195992, 195993, 195994, 195995, 195996, 195998, 196000, 196001, 196003, 196005, 196015, 196020)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2023-03-09 21:30:35 Duration: 431ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (194424, 193791, 193795, 193821, 193842, 193847, 193867, 193947, 193951, 193960, 193975, 193981, 194009, 194111, 194112, 194126, 194130, 194169, 194176, 194180, 194198, 194200, 194203, 194239, 194250, 194252, 194259, 194261, 194265, 194278, 194334, 194417, 194419, 194434, 194436, 194437, 194476, 194477, 194481, 194522, 194546, 194548, 194552, 194558, 194562, 194565, 194587, 194589, 194592, 194596, 194618, 194620, 194621, 194625, 194628, 194634, 194647, 194650, 194653, 194659, 194660, 194661, 194662, 194663, 194668, 194670, 194678, 194700, 194705, 194719, 194749, 194751, 194752, 194761, 194765, 194768, 194778, 194821, 194825, 194834, 194836, 194841, 194845, 194859, 194877, 194891, 194893, 194901, 194905, 194925, 194926, 194932, 194958, 195019, 195035, 195064, 195069, 195081, 195083, 195090, 195103, 195134, 195135, 195138, 195144, 195145, 195146, 195149, 195150, 195151, 195160, 195161, 195164, 195165, 195167, 195168, 195170, 195171, 195173, 195175, 195179, 195182, 195207, 195208, 195210, 195211, 195218, 195219, 195223, 195224, 195229, 195230, 195231, 195239, 195255, 195256, 195261, 195262, 195263, 195266, 195267, 195268, 195275, 195276, 195279, 195284, 195286, 195319, 195335, 195344, 195373, 195385, 195399, 195410, 195416, 195466, 195468, 195471, 195489, 195506, 195519, 195574, 195577, 195638, 195644, 195649, 195658, 195662, 195665, 195667, 195668, 195679, 195680, 195745, 195746, 195781, 195783, 195787, 195791, 195842, 195851, 195856, 195858, 195918, 195924, 195927, 195964, 195966, 195983, 195984, 195985, 195986, 195987, 195988, 195989, 195990, 195991, 195992, 195993, 195994, 195995, 195997, 195998, 196001, 196003, 196005)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2023-03-09 21:29:28 Duration: 426ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (195995, 193789, 193792, 193812, 193822, 193901, 193944, 193947, 194100, 194112, 194125, 194198, 194200, 194204, 194250, 194259, 194265, 194376, 194418, 194426, 194436, 194437, 194476, 194477, 194546, 194548, 194549, 194550, 194552, 194554, 194558, 194562, 194586, 194589, 194592, 194596, 194620, 194621, 194625, 194634, 194650, 194660, 194661, 194662, 194666, 194668, 194701, 194705, 194706, 194719, 194727, 194752, 194760, 194765, 194766, 194768, 194770, 194821, 194823, 194828, 194829, 194831, 194834, 194838, 194839, 194841, 194845, 194859, 194874, 194875, 194891, 194893, 194958, 194967, 195022, 195031, 195046, 195047, 195049, 195051, 195053, 195069, 195081, 195083, 195087, 195090, 195092, 195095, 195096, 195103, 195144, 195145, 195146, 195150, 195151, 195160, 195161, 195162, 195164, 195166, 195167, 195169, 195170, 195176, 195179, 195181, 195182, 195210, 195214, 195216, 195218, 195219, 195223, 195226, 195230, 195238, 195252, 195253, 195258, 195259, 195261, 195262, 195263, 195267, 195268, 195271, 195272, 195273, 195274, 195279, 195282, 195284, 195318, 195342, 195350, 195351, 195352, 195370, 195373, 195385, 195399, 195410, 195466, 195468, 195471, 195506, 195545, 195608, 195614, 195641, 195644, 195649, 195653, 195662, 195667, 195670, 195671, 195679, 195701, 195710, 195714, 195722, 195723, 195733, 195735, 195741, 195750, 195751, 195753, 195755, 195756, 195759, 195767, 195774, 195776, 195781, 195785, 195787, 195801, 195809, 195811, 195836, 195839, 195840, 195842, 195851, 195859, 195860, 195866, 195869, 195892, 195894, 195915, 195918, 195919, 195930, 195950, 195983, 195984, 195985, 195986, 195987, 195988, 195989, 195990, 195992, 195998, 196003, 196015, 196018, 196020, 196026, 196029)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2023-03-09 21:31:53 Duration: 421ms
6 24m29s 1,222 862ms 18s865ms 1s202ms update "stock_move" set "current_warehouse_qty" = ?.?, "is_done" = true, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 09 09 2 9s971ms 4s985ms 10 6 6s325ms 1s54ms 12 29 38s899ms 1s341ms 13 146 3m 1s238ms 14 201 3m37s 1s83ms 15 176 4m5s 1s393ms 16 142 2m51s 1s205ms 17 141 2m33s 1s87ms 18 116 2m10s 1s126ms 19 114 2m4s 1s94ms 20 84 1m47s 1s277ms 21 47 1m7s 1s436ms 22 6 5s456ms 909ms 23 12 10s753ms 896ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "is_done" = true, "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (292480, 292481, 292483, 292484, 292516, 292518, 292519, 292488, 292489, 292490, 292520, 292521, 292497, 292498, 292499, 292500, 292501, 292504, 292508, 292511);
Date: 2023-03-09 15:39:10 Duration: 18s865ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "is_done" = true, "write_uid" = 1019, "write_date" = (now() at time zone 'UTC') WHERE id IN (292524, 292525, 292526, 292527, 292528, 292529, 292530, 292531, 292532, 292533, 292534, 292535, 292536, 292537, 292538, 292539);
Date: 2023-03-09 15:37:43 Duration: 15s641ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 1.0, "is_done" = true, "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (292512, 292513, 292514, 292517, 292486, 292491, 292493, 292494, 292495, 292503, 292505, 292506, 292507);
Date: 2023-03-09 15:39:23 Duration: 12s319ms
7 22m30s 2,253 370ms 2s904ms 599ms select date_part(?, invoice_date) as year, date_part(?, invoice_date) as month, date_part(?, invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = ? and item_demand_plan_id = ? group by product_id, date_part(?, invoice_date), date_part(?, invoice_date), date_part(?, invoice_date) order by date_part(?, invoice_date), date_part(?, invoice_date), date_part(?, invoice_date);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 09 14 28 11s626ms 415ms 21 1,960 20m26s 625ms 22 265 1m53s 426ms -
select date_part('year', invoice_date) as Year, date_part('month', invoice_date) as Month, date_part('day', invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = 195989 and item_demand_plan_id = 2852 group by product_id, date_part('month', invoice_date), date_part('year', invoice_date), date_part('day', invoice_date) order by date_part('year', invoice_date), date_part('month', invoice_date), date_part('day', invoice_date);
Date: 2023-03-09 21:31:35 Duration: 2s904ms
-
select date_part('year', invoice_date) as Year, date_part('month', invoice_date) as Month, date_part('day', invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = 195651 and item_demand_plan_id = 2853 group by product_id, date_part('month', invoice_date), date_part('year', invoice_date), date_part('day', invoice_date) order by date_part('year', invoice_date), date_part('month', invoice_date), date_part('day', invoice_date);
Date: 2023-03-09 21:31:35 Duration: 2s896ms
-
select date_part('year', invoice_date) as Year, date_part('month', invoice_date) as Month, date_part('day', invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = 195968 and item_demand_plan_id = 2856 group by product_id, date_part('month', invoice_date), date_part('year', invoice_date), date_part('day', invoice_date) order by date_part('year', invoice_date), date_part('month', invoice_date), date_part('day', invoice_date);
Date: 2023-03-09 21:32:20 Duration: 2s868ms
8 17m11s 7,536 121ms 254ms 136ms 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 #8
Day Hour Count Duration Avg duration Mar 09 12 134 17s544ms 130ms 13 1,039 2m24s 138ms 14 1,229 2m46s 135ms 15 371 49s218ms 132ms 16 399 53s133ms 133ms 17 510 1m7s 132ms 18 1,717 4m8s 144ms 19 1,006 2m13s 133ms 20 785 1m43s 131ms 21 239 33s228ms 139ms 23 107 13s698ms 128ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."warehouse_id" = 43) AND ("product_warehouse_inventory"."product_id" = 177545)) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 1;
Date: 2023-03-09 18:36:07 Duration: 254ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."warehouse_id" = 42) AND ("product_warehouse_inventory"."product_id" = 190944)) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 1;
Date: 2023-03-09 16:08:35 Duration: 251ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."warehouse_id" = 36) AND ("product_warehouse_inventory"."product_id" = 228231)) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 1;
Date: 2023-03-09 14:25:51 Duration: 249ms
9 15m15s 887 864ms 4s999ms 1s32ms update "stock_move" set "delay_alert_date" = ?, "is_done" = false, "picking_code" = ?, "product_qty" = ?.?, "reference" = ?, "unit_factor" = ?.?, "weight" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 09 11 7 6s352ms 907ms 12 45 47s25ms 1s45ms 13 173 3m1s 1s49ms 14 97 1m45s 1s89ms 15 82 1m23s 1s21ms 16 64 1m1s 968ms 17 60 1m3s 1s52ms 18 97 1m42s 1s61ms 19 90 1m26s 964ms 20 84 1m21s 972ms 21 64 1m9s 1s89ms 22 11 13s512ms 1s228ms 23 13 11s661ms 897ms -
UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "picking_code" = 'outgoing', "product_qty" = 1.0, "reference" = '11-N/OUT/04579', "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 953, "write_date" = (now() at time zone 'UTC') WHERE id IN (308996, 308997, 308998, 309000, 309001);
Date: 2023-03-09 14:10:51 Duration: 4s999ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "picking_code" = 'outgoing', "product_qty" = 2.0, "reference" = '11-N/OUT/04570', "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1009, "write_date" = (now() at time zone 'UTC') WHERE id IN (308658, 308659, 308660, 308663);
Date: 2023-03-09 13:25:16 Duration: 3s748ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "picking_code" = 'outgoing', "product_qty" = 8.0, "reference" = '05-F/OUT/02615', "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (308888, 308886, 308878);
Date: 2023-03-09 13:57:04 Duration: 2s906ms
10 13m26s 1,419 521ms 902ms 568ms 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 #10
Day Hour Count Duration Avg duration Mar 09 12 55 30s256ms 550ms 13 245 2m20s 573ms 14 338 3m14s 575ms 15 109 1m1s 566ms 16 130 1m12s 560ms 17 111 1m2s 563ms 18 124 1m11s 578ms 19 200 1m53s 567ms 20 67 36s952ms 551ms 21 40 22s321ms 558ms -
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 ('%%SPL25%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%SPL25%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%SPL25%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-03-09 14:58:03 Duration: 902ms
-
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 ('%%430215%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%430215%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%430215%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-03-09 14:52:53 Duration: 869ms
-
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 ('%%n211%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%n2-1-1%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%n2-1-1%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-03-09 14:48:01 Duration: 866ms
11 12m59s 5,204 120ms 476ms 149ms 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 #11
Day Hour Count Duration Avg duration Mar 09 00 31 3s886ms 125ms 01 29 3s689ms 127ms 02 28 3s622ms 129ms 03 43 5s501ms 127ms 04 36 4s713ms 130ms 05 49 6s367ms 129ms 06 40 5s126ms 128ms 07 42 5s365ms 127ms 08 31 3s980ms 128ms 09 27 3s398ms 125ms 10 46 5s910ms 128ms 11 47 6s152ms 130ms 12 184 24s862ms 135ms 13 603 1m27s 144ms 14 567 1m20s 142ms 15 491 1m7s 137ms 16 454 1m2s 137ms 17 367 48s724ms 132ms 18 396 56s911ms 143ms 19 389 53s979ms 138ms 20 301 40s821ms 135ms 21 812 2m50s 210ms 22 134 20s782ms 155ms 23 57 7s450ms 130ms -
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/1/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-a54df00/1/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-03-09 21:31:53 Duration: 476ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/1/web.assets_common_lazy.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-5ea4658/1/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-03-09 21:32:47 Duration: 472ms
-
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: 2023-03-09 13:05:46 Duration: 456ms
12 12m53s 806 869ms 1s452ms 959ms insert into "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "orderpoint_id", "origin", "partner_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "rule_id", "sale_line_id", "sequence", "state", "warehouse_id") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), false, null, null, ?, ?, ?, ?, ?, ?, ?, ?, ?, null, ?, ?, ?, ?, ?, ?, ?, ?, false, ?, ?, ?, ?, ?) returning id;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 09 11 7 6s307ms 901ms 12 46 42s844ms 931ms 13 179 2m58s 999ms 14 98 1m36s 981ms 15 88 1m23s 945ms 16 64 59s805ms 934ms 17 61 59s345ms 972ms 18 56 52s74ms 929ms 19 54 50s249ms 930ms 20 87 1m21s 935ms 21 55 52s600ms 956ms 22 5 4s783ms 956ms 23 6 5s398ms 899ms -
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "orderpoint_id", "origin", "partner_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "rule_id", "sale_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1, (now() at time zone 'UTC'), 1, (now() at time zone 'UTC'), false, NULL, NULL, 1, '2023-03-09 14:20:58', '2023-03-09 14:20:58', 'Butt Connector', 64975, 5, 389, 'new_product', '[83-3350-3] Butt Connector', NULL, 'C-03903', 38081, 282, '0', 'make_to_stock', 209373, 1, '1.00', false, 317, 103306, 10, 'draft', 36) RETURNING id;
Date: 2023-03-09 14:25:51 Duration: 1s452ms
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "orderpoint_id", "origin", "partner_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "rule_id", "sale_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1, (now() at time zone 'UTC'), 1, (now() at time zone 'UTC'), false, NULL, NULL, 1, '2023-03-09 21:26:14', '2023-03-09 21:26:14', 'AUTOMATIC BRAKE ADJUSTER KIT TRUCK TRAILER SABA WITH HARDWAR', 65471, 5, 429, 'new_product', '[40020231] AUTOMATIC BRAKE ADJUSTER KIT TRUCK TRAILER SABA WITH HARDWAR', NULL, 'B-02606', 42428, 322, '0', 'make_to_stock', 183894, 1, '4.00', false, 362, 103920, 10, 'draft', 41) RETURNING id;
Date: 2023-03-09 21:27:09 Duration: 1s431ms
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "orderpoint_id", "origin", "partner_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "rule_id", "sale_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1, (now() at time zone 'UTC'), 1, (now() at time zone 'UTC'), false, NULL, NULL, 1, '2023-03-09 14:23:36', '2023-03-09 14:23:36', 'Washer', 64976, 5, 445, 'new_product', '[E-581] Washer', NULL, 'N-03425', 50710, 338, '0', 'make_to_stock', 184788, 1, '12.00', false, 380, 103315, 10, 'draft', 43) RETURNING id;
Date: 2023-03-09 14:25:51 Duration: 1s338ms
13 12m38s 5,646 120ms 391ms 134ms select "product_warehouse_inventory".id from "product_warehouse_inventory" where ("product_warehouse_inventory"."product_tmpl_id" in (...)) order by "product_warehouse_inventory"."warehouse_name";Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 09 00 20 2s548ms 127ms 10 22 2s806ms 127ms 11 14 2s378ms 169ms 12 257 33s537ms 130ms 13 682 1m32s 135ms 14 723 1m36s 134ms 15 584 1m18s 133ms 16 552 1m12s 132ms 17 465 1m1s 131ms 18 624 1m23s 134ms 19 927 2m1s 131ms 20 448 57s827ms 129ms 21 228 37s876ms 166ms 22 96 13s688ms 142ms 23 4 514ms 128ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_tmpl_id" in (177232, 174031, 209762, 186269, 184804, 189761, 190267, 172967)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2023-03-09 21:31:54 Duration: 391ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_tmpl_id" in (195538, 195630, 195633, 195701, 196020, 196021, 196022, 196050)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2023-03-09 21:24:38 Duration: 376ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_tmpl_id" in (247171)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2023-03-09 21:27:56 Duration: 358ms
14 11m5s 278 879ms 16s998ms 2s393ms update "stock_move" set "branch_id" = ?, "picking_id" = ?, "related_core_purchase_line_id" = ?, "related_core_repair_line_id" = ?, "related_core_sale_line_id" = ?, "scrapped" = false, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 09 11 2 5s488ms 2s744ms 12 18 41s878ms 2s326ms 13 48 2m30s 3s138ms 14 42 1m27s 2s88ms 15 27 1m12s 2s691ms 16 25 45s435ms 1s817ms 17 20 45s211ms 2s260ms 18 23 36s288ms 1s577ms 19 30 50s254ms 1s675ms 20 23 1m8s 2s957ms 21 17 57s457ms 3s379ms 22 3 4s334ms 1s444ms -
UPDATE "stock_move" SET "branch_id" = 37, "picking_id" = 89101, "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 (308553, 308554, 308555, 308556, 308557, 308558, 308559, 308560, 308561, 308562, 308563, 308565, 308566, 308567, 308568, 308569, 308571);
Date: 2023-03-09 13:15:36 Duration: 16s998ms
-
UPDATE "stock_move" SET "branch_id" = 50, "picking_id" = 89398, "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 (309312, 309313, 309314, 309315, 309316, 309318, 309319, 309320, 309303, 309304, 309305, 309306, 309307, 309308, 309309, 309310, 309311);
Date: 2023-03-09 15:06:54 Duration: 16s177ms
-
UPDATE "stock_move" SET "branch_id" = 40, "picking_id" = 89193, "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 (308872, 308873, 308874, 308875, 308876, 308878, 308879, 308880, 308881, 308882, 308883, 308884, 308885, 308887, 308888, 308890);
Date: 2023-03-09 13:56:44 Duration: 15s581ms
15 9m52s 836 668ms 1s602ms 708ms 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 #15
Day Hour Count Duration Avg duration Mar 09 11 5 3s433ms 686ms 12 26 18s139ms 697ms 13 146 1m43s 711ms 14 119 1m24s 708ms 15 91 1m3s 700ms 16 98 1m8s 703ms 17 58 40s545ms 699ms 18 114 1m20s 709ms 19 96 1m7s 701ms 20 45 31s350ms 696ms 21 27 22s97ms 818ms 22 11 7s740ms 703ms -
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 ('%83-4350-3%')) 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 ('%83-4350-3%'))) 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 ('%83-4350-3%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%83-4350-3%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-03-09 21:30:23 Duration: 1s602ms
-
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 ('%83-4550-3%')) 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 ('%83-4550-3%'))) 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 ('%83-4550-3%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%83-4550-3%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-03-09 21:33:21 Duration: 1s487ms
-
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 ('%83-3550-3%')) 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 ('%83-3550-3%'))) 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 ('%83-3550-3%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%83-3550-3%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-03-09 21:20:25 Duration: 1s227ms
16 9m45s 551 866ms 8s278ms 1s62ms update "stock_move" set "current_warehouse_qty" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 09 12 65 1m2s 966ms 13 109 1m47s 987ms 14 71 1m10s 993ms 15 30 47s605ms 1s586ms 16 81 1m28s 1s86ms 17 88 1m36s 1s92ms 18 40 36s946ms 923ms 19 27 37s222ms 1s378ms 20 26 24s513ms 942ms 21 14 13s839ms 988ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 0.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (310144, 310148, 310149, 310151, 310129, 310161, 310163, 310134, 310137);
Date: 2023-03-09 19:21:31 Duration: 8s278ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 0.0, "write_uid" = 989, "write_date" = (now() at time zone 'UTC') WHERE id IN (308904, 309224, 309198, 308917, 309182);
Date: 2023-03-09 15:23:24 Duration: 4s735ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 1.0, "write_uid" = 989, "write_date" = (now() at time zone 'UTC') WHERE id IN (309186, 309158, 309226, 309171, 309203);
Date: 2023-03-09 15:23:36 Duration: 4s654ms
17 9m 212 870ms 13s715ms 2s551ms update "stock_move" set "picking_id" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 09 10 1 894ms 894ms 12 8 16s847ms 2s105ms 13 12 22s767ms 1s897ms 14 29 49s254ms 1s698ms 15 22 57s767ms 2s625ms 16 29 1m6s 2s300ms 17 27 54s314ms 2s11ms 18 26 1m28s 3s414ms 19 25 1m45s 4s207ms 20 22 45s15ms 2s46ms 21 11 33s428ms 3s38ms -
UPDATE "stock_move" SET "picking_id" = 89979, "write_uid" = 960, "write_date" = (now() at time zone 'UTC') WHERE id IN (302758, 292840, 292841, 292843, 292844, 292846, 292848, 292852, 292853, 292855, 292856, 292857, 292858, 292860, 292862);
Date: 2023-03-09 19:54:55 Duration: 13s715ms
-
UPDATE "stock_move" SET "picking_id" = 89958, "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (284833, 284840, 284873, 284842, 284874, 284844, 284875, 284882, 284852, 284885, 284886, 284887, 284859, 284860);
Date: 2023-03-09 19:41:56 Duration: 12s990ms
-
UPDATE "stock_move" SET "picking_id" = 89446, "write_uid" = 1005, "write_date" = (now() at time zone 'UTC') WHERE id IN (308553, 308554, 308555, 308556, 308557, 308559, 308560, 308561, 308563, 308566, 308567, 308568, 308571);
Date: 2023-03-09 15:44:12 Duration: 12s559ms
18 9m 295 871ms 15s777ms 1s832ms update "stock_move" set "delay_alert_date" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 09 12 29 49s50ms 1s691ms 13 49 1m18s 1s610ms 14 23 36s398ms 1s582ms 15 14 36s930ms 2s637ms 16 38 1m48s 2s846ms 17 45 2m9s 2s873ms 18 41 41s904ms 1s22ms 19 19 23s6ms 1s210ms 20 24 21s990ms 916ms 21 13 14s863ms 1s143ms -
UPDATE "stock_move" SET "delay_alert_date" = NULL, "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (292704, 205345, 205347, 292805, 278855, 292712, 269050, 257322, 213517, 276973, 213519, 292788, 292793, 292698, 292700, 292799);
Date: 2023-03-09 15:40:03 Duration: 15s777ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "write_uid" = 982, "write_date" = (now() at time zone 'UTC') WHERE id IN (301696, 301697, 301698, 301699, 301700, 301701, 301706, 301707, 301690, 301691, 301694, 301695);
Date: 2023-03-09 16:46:54 Duration: 11s277ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "write_uid" = 982, "write_date" = (now() at time zone 'UTC') WHERE id IN (203493, 301742, 301744, 301745, 301748, 301749, 301750, 301751, 301754, 301755, 301756, 301757);
Date: 2023-03-09 17:34:33 Duration: 10s785ms
19 8m37s 200 873ms 14s338ms 2s585ms update "stock_move" set "reference" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 09 10 1 908ms 908ms 12 8 17s660ms 2s207ms 13 12 22s438ms 1s869ms 14 29 49s962ms 1s722ms 15 20 51s911ms 2s595ms 16 27 1m9s 2s587ms 17 26 1m2s 2s419ms 18 21 1m3s 3s17ms 19 24 1m43s 4s299ms 20 21 43s502ms 2s71ms 21 11 31s334ms 2s848ms -
UPDATE "stock_move" SET "reference" = '04-V/IN/01940', "write_uid" = 960, "write_date" = (now() at time zone 'UTC') WHERE id IN (302758, 292840, 292841, 292843, 292844, 292846, 292848, 292852, 292853, 292855, 292856, 292857, 292858, 292860, 292862);
Date: 2023-03-09 19:55:11 Duration: 14s338ms
-
UPDATE "stock_move" SET "reference" = '02-G/IN/03224', "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (284833, 284840, 284873, 284842, 284874, 284844, 284875, 284882, 284852, 284885, 284886, 284887, 284859, 284860);
Date: 2023-03-09 19:42:12 Duration: 13s371ms
-
UPDATE "stock_move" SET "reference" = '02-G/OUT/06115', "write_uid" = 1005, "write_date" = (now() at time zone 'UTC') WHERE id IN (308553, 308554, 308555, 308556, 308557, 308559, 308560, 308561, 308563, 308566, 308567, 308568, 308571);
Date: 2023-03-09 15:44:33 Duration: 12s565ms
20 8m32s 3,091 154ms 304ms 165ms select res_partner.id from "res_partner" where ("res_partner"."active" = true) and (((("res_partner"."partner_share" is null or "res_partner"."partner_share" = false) or ("res_partner"."company_id" in (...))) or "res_partner"."company_id" is null) and (((("res_partner"."type" != ?) or "res_partner"."type" is null) or "res_partner"."type" is null) or ("res_partner"."type" = ?))) and (unaccent (res_partner.email) ilike unaccent (?) or unaccent (res_partner.display_name) ilike unaccent (?) or unaccent (res_partner.ref) ilike unaccent (?) or unaccent (res_partner.vat) ilike unaccent (?)) unaccent (res_partner.display_name);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 09 01 1 157ms 157ms 09 1 156ms 156ms 10 4 634ms 158ms 11 1 159ms 159ms 12 69 11s178ms 162ms 13 296 48s660ms 164ms 14 150 25s469ms 169ms 15 338 55s510ms 164ms 16 534 1m27s 164ms 17 742 2m2s 164ms 18 363 1m1s 168ms 19 371 1m1s 166ms 20 108 17s779ms 164ms 21 106 18s863ms 177ms 22 4 668ms 167ms 23 3 477ms 159ms -
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%49602%') OR unaccent (res_partner.display_name) ilike unaccent ('%49602%') OR unaccent (res_partner.ref) ilike unaccent ('%49602%') OR unaccent (res_partner.vat) ilike unaccent ('49602')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%49602%') desc, unaccent (res_partner.display_name);
Date: 2023-03-09 18:34:08 Duration: 304ms
-
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%i566344%') OR unaccent (res_partner.display_name) ilike unaccent ('%i566344%') OR unaccent (res_partner.ref) ilike unaccent ('%i566344%') OR unaccent (res_partner.vat) ilike unaccent ('i566344')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%i566344%') desc, unaccent (res_partner.display_name);
Date: 2023-03-09 13:08:40 Duration: 302ms
-
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%I-01122%') OR unaccent (res_partner.display_name) ilike unaccent ('%I-01122%') OR unaccent (res_partner.ref) ilike unaccent ('%I-01122%') OR unaccent (res_partner.vat) ilike unaccent ('I-01122')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%I-01122%') desc, unaccent (res_partner.display_name);
Date: 2023-03-09 21:23:28 Duration: 298ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 11,108 26m11s 120ms 431ms 141ms select "product_warehouse_inventory".id from "product_warehouse_inventory" where ("product_warehouse_inventory"."product_id" in (...)) order by "product_warehouse_inventory"."warehouse_name";Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 09 06 15 1s967ms 131ms 07 10 1s248ms 124ms 09 2 260ms 130ms 10 107 13s845ms 129ms 11 8 1s670ms 208ms 12 261 34s587ms 132ms 13 621 1m22s 133ms 14 642 1m26s 134ms 15 589 1m17s 130ms 16 1,239 2m42s 131ms 17 638 1m23s 130ms 18 1,305 2m52s 131ms 19 1,119 2m25s 129ms 20 310 40s381ms 130ms 21 2,853 8m10s 171ms 22 1,210 2m35s 128ms 23 179 22s557ms 126ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (195469, 193789, 193839, 193847, 193848, 193866, 193924, 193931, 193946, 193950, 193983, 194068, 194069, 194109, 194125, 194147, 194173, 194198, 194200, 194203, 194250, 194333, 194376, 194422, 194433, 194436, 194437, 194455, 194475, 194491, 194519, 194546, 194549, 194558, 194562, 194563, 194586, 194592, 194621, 194628, 194634, 194648, 194650, 194662, 194678, 194703, 194705, 194706, 194711, 194712, 194713, 194719, 194731, 194739, 194740, 194744, 194749, 194751, 194752, 194761, 194768, 194770, 194771, 194793, 194821, 194823, 194828, 194830, 194834, 194836, 194837, 194841, 194845, 194859, 194865, 194871, 194872, 194874, 194875, 194877, 194891, 194925, 194929, 194930, 194931, 194932, 194955, 194958, 194964, 194967, 194970, 194976, 194979, 195002, 195010, 195017, 195022, 195026, 195031, 195035, 195046, 195047, 195049, 195051, 195053, 195056, 195062, 195064, 195065, 195069, 195083, 195090, 195092, 195099, 195103, 195107, 195144, 195145, 195160, 195161, 195162, 195164, 195165, 195168, 195170, 195179, 195202, 195210, 195218, 195219, 195223, 195224, 195229, 195230, 195231, 195232, 195233, 195241, 195253, 195255, 195256, 195262, 195263, 195267, 195268, 195373, 195385, 195399, 195410, 195416, 195467, 195545, 195574, 195577, 195592, 195593, 195616, 195644, 195646, 195651, 195652, 195662, 195667, 195671, 195680, 195701, 195742, 195783, 195785, 195802, 195808, 195835, 195836, 195842, 195851, 195852, 195854, 195863, 195866, 195869, 195915, 195916, 195918, 195927, 195930, 195950, 195953, 195983, 195984, 195985, 195986, 195987, 195988, 195989, 195990, 195991, 195992, 195993, 195994, 195995, 195996, 195998, 196000, 196001, 196003, 196005, 196015, 196020)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2023-03-09 21:30:35 Duration: 431ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (194424, 193791, 193795, 193821, 193842, 193847, 193867, 193947, 193951, 193960, 193975, 193981, 194009, 194111, 194112, 194126, 194130, 194169, 194176, 194180, 194198, 194200, 194203, 194239, 194250, 194252, 194259, 194261, 194265, 194278, 194334, 194417, 194419, 194434, 194436, 194437, 194476, 194477, 194481, 194522, 194546, 194548, 194552, 194558, 194562, 194565, 194587, 194589, 194592, 194596, 194618, 194620, 194621, 194625, 194628, 194634, 194647, 194650, 194653, 194659, 194660, 194661, 194662, 194663, 194668, 194670, 194678, 194700, 194705, 194719, 194749, 194751, 194752, 194761, 194765, 194768, 194778, 194821, 194825, 194834, 194836, 194841, 194845, 194859, 194877, 194891, 194893, 194901, 194905, 194925, 194926, 194932, 194958, 195019, 195035, 195064, 195069, 195081, 195083, 195090, 195103, 195134, 195135, 195138, 195144, 195145, 195146, 195149, 195150, 195151, 195160, 195161, 195164, 195165, 195167, 195168, 195170, 195171, 195173, 195175, 195179, 195182, 195207, 195208, 195210, 195211, 195218, 195219, 195223, 195224, 195229, 195230, 195231, 195239, 195255, 195256, 195261, 195262, 195263, 195266, 195267, 195268, 195275, 195276, 195279, 195284, 195286, 195319, 195335, 195344, 195373, 195385, 195399, 195410, 195416, 195466, 195468, 195471, 195489, 195506, 195519, 195574, 195577, 195638, 195644, 195649, 195658, 195662, 195665, 195667, 195668, 195679, 195680, 195745, 195746, 195781, 195783, 195787, 195791, 195842, 195851, 195856, 195858, 195918, 195924, 195927, 195964, 195966, 195983, 195984, 195985, 195986, 195987, 195988, 195989, 195990, 195991, 195992, 195993, 195994, 195995, 195997, 195998, 196001, 196003, 196005)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2023-03-09 21:29:28 Duration: 426ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (195995, 193789, 193792, 193812, 193822, 193901, 193944, 193947, 194100, 194112, 194125, 194198, 194200, 194204, 194250, 194259, 194265, 194376, 194418, 194426, 194436, 194437, 194476, 194477, 194546, 194548, 194549, 194550, 194552, 194554, 194558, 194562, 194586, 194589, 194592, 194596, 194620, 194621, 194625, 194634, 194650, 194660, 194661, 194662, 194666, 194668, 194701, 194705, 194706, 194719, 194727, 194752, 194760, 194765, 194766, 194768, 194770, 194821, 194823, 194828, 194829, 194831, 194834, 194838, 194839, 194841, 194845, 194859, 194874, 194875, 194891, 194893, 194958, 194967, 195022, 195031, 195046, 195047, 195049, 195051, 195053, 195069, 195081, 195083, 195087, 195090, 195092, 195095, 195096, 195103, 195144, 195145, 195146, 195150, 195151, 195160, 195161, 195162, 195164, 195166, 195167, 195169, 195170, 195176, 195179, 195181, 195182, 195210, 195214, 195216, 195218, 195219, 195223, 195226, 195230, 195238, 195252, 195253, 195258, 195259, 195261, 195262, 195263, 195267, 195268, 195271, 195272, 195273, 195274, 195279, 195282, 195284, 195318, 195342, 195350, 195351, 195352, 195370, 195373, 195385, 195399, 195410, 195466, 195468, 195471, 195506, 195545, 195608, 195614, 195641, 195644, 195649, 195653, 195662, 195667, 195670, 195671, 195679, 195701, 195710, 195714, 195722, 195723, 195733, 195735, 195741, 195750, 195751, 195753, 195755, 195756, 195759, 195767, 195774, 195776, 195781, 195785, 195787, 195801, 195809, 195811, 195836, 195839, 195840, 195842, 195851, 195859, 195860, 195866, 195869, 195892, 195894, 195915, 195918, 195919, 195930, 195950, 195983, 195984, 195985, 195986, 195987, 195988, 195989, 195990, 195992, 195998, 196003, 196015, 196018, 196020, 196026, 196029)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2023-03-09 21:31:53 Duration: 421ms
2 7,536 17m11s 121ms 254ms 136ms 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 #2
Day Hour Count Duration Avg duration Mar 09 12 134 17s544ms 130ms 13 1,039 2m24s 138ms 14 1,229 2m46s 135ms 15 371 49s218ms 132ms 16 399 53s133ms 133ms 17 510 1m7s 132ms 18 1,717 4m8s 144ms 19 1,006 2m13s 133ms 20 785 1m43s 131ms 21 239 33s228ms 139ms 23 107 13s698ms 128ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."warehouse_id" = 43) AND ("product_warehouse_inventory"."product_id" = 177545)) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 1;
Date: 2023-03-09 18:36:07 Duration: 254ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."warehouse_id" = 42) AND ("product_warehouse_inventory"."product_id" = 190944)) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 1;
Date: 2023-03-09 16:08:35 Duration: 251ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."warehouse_id" = 36) AND ("product_warehouse_inventory"."product_id" = 228231)) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 1;
Date: 2023-03-09 14:25:51 Duration: 249ms
3 5,646 12m38s 120ms 391ms 134ms select "product_warehouse_inventory".id from "product_warehouse_inventory" where ("product_warehouse_inventory"."product_tmpl_id" in (...)) order by "product_warehouse_inventory"."warehouse_name";Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 09 00 20 2s548ms 127ms 10 22 2s806ms 127ms 11 14 2s378ms 169ms 12 257 33s537ms 130ms 13 682 1m32s 135ms 14 723 1m36s 134ms 15 584 1m18s 133ms 16 552 1m12s 132ms 17 465 1m1s 131ms 18 624 1m23s 134ms 19 927 2m1s 131ms 20 448 57s827ms 129ms 21 228 37s876ms 166ms 22 96 13s688ms 142ms 23 4 514ms 128ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_tmpl_id" in (177232, 174031, 209762, 186269, 184804, 189761, 190267, 172967)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2023-03-09 21:31:54 Duration: 391ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_tmpl_id" in (195538, 195630, 195633, 195701, 196020, 196021, 196022, 196050)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2023-03-09 21:24:38 Duration: 376ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_tmpl_id" in (247171)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2023-03-09 21:27:56 Duration: 358ms
4 5,204 12m59s 120ms 476ms 149ms select "ir_attachment".id from "ir_attachment" where (("ir_attachment"."res_field" is null and (unaccent ("ir_attachment"."url"::text) like unaccent (?))) and (not ((unaccent ("ir_attachment"."url"::text) like unaccent (?))))) order by "ir_attachment"."id" desc;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 09 00 31 3s886ms 125ms 01 29 3s689ms 127ms 02 28 3s622ms 129ms 03 43 5s501ms 127ms 04 36 4s713ms 130ms 05 49 6s367ms 129ms 06 40 5s126ms 128ms 07 42 5s365ms 127ms 08 31 3s980ms 128ms 09 27 3s398ms 125ms 10 46 5s910ms 128ms 11 47 6s152ms 130ms 12 184 24s862ms 135ms 13 603 1m27s 144ms 14 567 1m20s 142ms 15 491 1m7s 137ms 16 454 1m2s 137ms 17 367 48s724ms 132ms 18 396 56s911ms 143ms 19 389 53s979ms 138ms 20 301 40s821ms 135ms 21 812 2m50s 210ms 22 134 20s782ms 155ms 23 57 7s450ms 130ms -
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/1/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-a54df00/1/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-03-09 21:31:53 Duration: 476ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/1/web.assets_common_lazy.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-5ea4658/1/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-03-09 21:32:47 Duration: 472ms
-
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: 2023-03-09 13:05:46 Duration: 456ms
5 3,851 36m30s 485ms 1s264ms 568ms 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 #5
Day Hour Count Duration Avg duration Mar 09 01 32 17s216ms 538ms 11 59 31s994ms 542ms 12 273 2m29s 549ms 13 929 8m56s 577ms 14 454 4m17s 566ms 15 300 2m47s 559ms 16 343 3m14s 565ms 17 235 2m13s 566ms 18 341 3m16s 577ms 19 323 3m2s 565ms 20 329 3m3s 556ms 21 183 1m51s 611ms 22 32 17s386ms 543ms 23 18 9s670ms 537ms -
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 ('%%562112436%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%562.112436%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%562.112436%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-03-09 21:32:23 Duration: 1s264ms
-
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 ('%%5621124%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%562.1124%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%562.1124%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-03-09 21:32:22 Duration: 1s234ms
-
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 ('%%562%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%562.%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%562.%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-03-09 21:32:20 Duration: 1s77ms
6 3,114 6m48s 120ms 296ms 131ms select id from product_warehouse_inventory where product_id = ? and warehouse_id = ? and company_id = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 09 00 3 380ms 126ms 11 8 1s22ms 127ms 12 187 23s915ms 127ms 13 622 1m22s 131ms 14 461 1m 131ms 15 307 39s750ms 129ms 16 270 35s49ms 129ms 17 312 40s171ms 128ms 18 254 33s340ms 131ms 19 241 31s507ms 130ms 20 216 27s496ms 127ms 21 153 23s259ms 152ms 22 54 6s775ms 125ms 23 26 3s271ms 125ms -
select id from product_warehouse_inventory where product_id = 246533 and warehouse_id = 42 and company_id = 1;
Date: 2023-03-09 21:32:04 Duration: 296ms
-
select id from product_warehouse_inventory where product_id = 209392 and warehouse_id = 42 and company_id = 1;
Date: 2023-03-09 21:38:15 Duration: 291ms
-
select id from product_warehouse_inventory where product_id = 246536 and warehouse_id = 43 and company_id = 1;
Date: 2023-03-09 21:35:06 Duration: 272ms
7 3,091 8m32s 154ms 304ms 165ms select res_partner.id from "res_partner" where ("res_partner"."active" = true) and (((("res_partner"."partner_share" is null or "res_partner"."partner_share" = false) or ("res_partner"."company_id" in (...))) or "res_partner"."company_id" is null) and (((("res_partner"."type" != ?) or "res_partner"."type" is null) or "res_partner"."type" is null) or ("res_partner"."type" = ?))) and (unaccent (res_partner.email) ilike unaccent (?) or unaccent (res_partner.display_name) ilike unaccent (?) or unaccent (res_partner.ref) ilike unaccent (?) or unaccent (res_partner.vat) ilike unaccent (?)) unaccent (res_partner.display_name);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 09 01 1 157ms 157ms 09 1 156ms 156ms 10 4 634ms 158ms 11 1 159ms 159ms 12 69 11s178ms 162ms 13 296 48s660ms 164ms 14 150 25s469ms 169ms 15 338 55s510ms 164ms 16 534 1m27s 164ms 17 742 2m2s 164ms 18 363 1m1s 168ms 19 371 1m1s 166ms 20 108 17s779ms 164ms 21 106 18s863ms 177ms 22 4 668ms 167ms 23 3 477ms 159ms -
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%49602%') OR unaccent (res_partner.display_name) ilike unaccent ('%49602%') OR unaccent (res_partner.ref) ilike unaccent ('%49602%') OR unaccent (res_partner.vat) ilike unaccent ('49602')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%49602%') desc, unaccent (res_partner.display_name);
Date: 2023-03-09 18:34:08 Duration: 304ms
-
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%i566344%') OR unaccent (res_partner.display_name) ilike unaccent ('%i566344%') OR unaccent (res_partner.ref) ilike unaccent ('%i566344%') OR unaccent (res_partner.vat) ilike unaccent ('i566344')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%i566344%') desc, unaccent (res_partner.display_name);
Date: 2023-03-09 13:08:40 Duration: 302ms
-
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%I-01122%') OR unaccent (res_partner.display_name) ilike unaccent ('%I-01122%') OR unaccent (res_partner.ref) ilike unaccent ('%I-01122%') OR unaccent (res_partner.vat) ilike unaccent ('I-01122')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%I-01122%') desc, unaccent (res_partner.display_name);
Date: 2023-03-09 21:23:28 Duration: 298ms
8 2,253 22m30s 370ms 2s904ms 599ms select date_part(?, invoice_date) as year, date_part(?, invoice_date) as month, date_part(?, invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = ? and item_demand_plan_id = ? group by product_id, date_part(?, invoice_date), date_part(?, invoice_date), date_part(?, invoice_date) order by date_part(?, invoice_date), date_part(?, invoice_date), date_part(?, invoice_date);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 09 14 28 11s626ms 415ms 21 1,960 20m26s 625ms 22 265 1m53s 426ms -
select date_part('year', invoice_date) as Year, date_part('month', invoice_date) as Month, date_part('day', invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = 195989 and item_demand_plan_id = 2852 group by product_id, date_part('month', invoice_date), date_part('year', invoice_date), date_part('day', invoice_date) order by date_part('year', invoice_date), date_part('month', invoice_date), date_part('day', invoice_date);
Date: 2023-03-09 21:31:35 Duration: 2s904ms
-
select date_part('year', invoice_date) as Year, date_part('month', invoice_date) as Month, date_part('day', invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = 195651 and item_demand_plan_id = 2853 group by product_id, date_part('month', invoice_date), date_part('year', invoice_date), date_part('day', invoice_date) order by date_part('year', invoice_date), date_part('month', invoice_date), date_part('day', invoice_date);
Date: 2023-03-09 21:31:35 Duration: 2s896ms
-
select date_part('year', invoice_date) as Year, date_part('month', invoice_date) as Month, date_part('day', invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = 195968 and item_demand_plan_id = 2856 group by product_id, date_part('month', invoice_date), date_part('year', invoice_date), date_part('day', invoice_date) order by date_part('year', invoice_date), date_part('month', invoice_date), date_part('day', invoice_date);
Date: 2023-03-09 21:32:20 Duration: 2s868ms
9 2,221 47m 622ms 8s15ms 1s269ms select "item_list_line".id from "item_list_line" where (((("item_list_line"."active" = true) and ("item_list_line"."product_id" = ?)) and (("item_list_line"."method" not in (...)) or "item_list_line"."method" is null)) and ("item_list_line"."item_demand_plan_id" = ?)) order by "item_list_line"."id" limit ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 09 14 28 19s980ms 713ms 21 1,944 43m30s 1s342ms 22 249 3m9s 762ms -
SELECT "item_list_line".id FROM "item_list_line" WHERE (((("item_list_line"."active" = true) AND ("item_list_line"."product_id" = 195662)) AND (("item_list_line"."method" not in (7, 8)) OR "item_list_line"."method" IS NULL)) AND ("item_list_line"."item_demand_plan_id" = 2853)) ORDER BY "item_list_line"."id" LIMIT 1;
Date: 2023-03-09 21:31:50 Duration: 8s15ms
-
SELECT "item_list_line".id FROM "item_list_line" WHERE (((("item_list_line"."active" = true) AND ("item_list_line"."product_id" = 194841)) AND (("item_list_line"."method" not in (7, 8)) OR "item_list_line"."method" IS NULL)) AND ("item_list_line"."item_demand_plan_id" = 2857)) ORDER BY "item_list_line"."id" LIMIT 1;
Date: 2023-03-09 21:32:35 Duration: 7s480ms
-
SELECT "item_list_line".id FROM "item_list_line" WHERE (((("item_list_line"."active" = true) AND ("item_list_line"."product_id" = 194821)) AND (("item_list_line"."method" not in (7, 8)) OR "item_list_line"."method" IS NULL)) AND ("item_list_line"."item_demand_plan_id" = 2859)) ORDER BY "item_list_line"."id" LIMIT 1;
Date: 2023-03-09 21:32:49 Duration: 7s309ms
10 1,419 13m26s 521ms 902ms 568ms 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 #10
Day Hour Count Duration Avg duration Mar 09 12 55 30s256ms 550ms 13 245 2m20s 573ms 14 338 3m14s 575ms 15 109 1m1s 566ms 16 130 1m12s 560ms 17 111 1m2s 563ms 18 124 1m11s 578ms 19 200 1m53s 567ms 20 67 36s952ms 551ms 21 40 22s321ms 558ms -
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 ('%%SPL25%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%SPL25%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%SPL25%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-03-09 14:58:03 Duration: 902ms
-
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 ('%%430215%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%430215%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%430215%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-03-09 14:52:53 Duration: 869ms
-
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 ('%%n211%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%n2-1-1%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%n2-1-1%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-03-09 14:48:01 Duration: 866ms
11 1,230 2m45s 121ms 403ms 134ms update "stock_quant" set "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 09 11 6 766ms 127ms 12 69 9s40ms 131ms 13 229 31s144ms 136ms 14 160 21s663ms 135ms 15 132 17s456ms 132ms 16 105 13s807ms 131ms 17 145 19s574ms 134ms 18 100 13s565ms 135ms 19 113 14s891ms 131ms 20 78 10s144ms 130ms 21 82 12s49ms 146ms 22 5 625ms 125ms 23 6 894ms 149ms -
UPDATE "stock_quant" SET "reserved_quantity" = 0.0, "write_uid" = 1022, "write_date" = (now() at time zone 'UTC') WHERE id IN (58288, 58298, 175645);
Date: 2023-03-09 17:50:27 Duration: 403ms
-
UPDATE "stock_quant" SET "reserved_quantity" = 9.0, "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (237452);
Date: 2023-03-09 21:32:18 Duration: 356ms
-
UPDATE "stock_quant" SET "reserved_quantity" = 2.0, "write_uid" = 979, "write_date" = (now() at time zone 'UTC') WHERE id IN (233872);
Date: 2023-03-09 21:32:53 Duration: 326ms
12 1,222 24m29s 862ms 18s865ms 1s202ms update "stock_move" set "current_warehouse_qty" = ?.?, "is_done" = true, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 09 09 2 9s971ms 4s985ms 10 6 6s325ms 1s54ms 12 29 38s899ms 1s341ms 13 146 3m 1s238ms 14 201 3m37s 1s83ms 15 176 4m5s 1s393ms 16 142 2m51s 1s205ms 17 141 2m33s 1s87ms 18 116 2m10s 1s126ms 19 114 2m4s 1s94ms 20 84 1m47s 1s277ms 21 47 1m7s 1s436ms 22 6 5s456ms 909ms 23 12 10s753ms 896ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "is_done" = true, "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (292480, 292481, 292483, 292484, 292516, 292518, 292519, 292488, 292489, 292490, 292520, 292521, 292497, 292498, 292499, 292500, 292501, 292504, 292508, 292511);
Date: 2023-03-09 15:39:10 Duration: 18s865ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "is_done" = true, "write_uid" = 1019, "write_date" = (now() at time zone 'UTC') WHERE id IN (292524, 292525, 292526, 292527, 292528, 292529, 292530, 292531, 292532, 292533, 292534, 292535, 292536, 292537, 292538, 292539);
Date: 2023-03-09 15:37:43 Duration: 15s641ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 1.0, "is_done" = true, "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (292512, 292513, 292514, 292517, 292486, 292491, 292493, 292494, 292495, 292503, 292505, 292506, 292507);
Date: 2023-03-09 15:39:23 Duration: 12s319ms
13 1,209 2m40s 120ms 463ms 133ms with currency_rate as ( select r.currency_id, coalesce(r.company_id, c.id) as company_id, r.rate, r.name as date_start, ( select name from res_currency_rate r2 where r2.name > r.name and r2.currency_id = r.currency_id and (r2.company_id is null or r2.company_id = c.id) order by r2.name asc limit ?) as date_end from res_currency_rate r join res_company c on (r.company_id is null or r.company_id = c.id)) select l.product_id as product_id, sum(l.price_unit / ( case coalesce(cr.rate, ?) when ? then ?.? else cr.rate end) * l.quantity * ( case when i.move_type in (...) then ? else ? end) * ((? - l.discount) * ?.?)) / nullif (sum(l.quantity * ( case when i.move_type in (...) then ? else ? end)), ?) as avg_unit_price, sum(l.quantity * ( case when i.move_type in (...) then ? else ? end)) as num_qty, sum(abs(l.balance) * ( case when i.move_type in (...) then ? else ? end)) as total, sum(l.quantity * pt.list_price * ( case when i.move_type in (...) then ? else ? end)) as sale_expected from account_move_line l left join account_move i on (l.move_id = i.id) left join product_product product on (product.id = l.product_id) left join product_template pt on (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= coalesce(i.invoice_date, now()) and (cr.date_end is null or cr.date_end > coalesce(i.invoice_date, now()))) where l.product_id in (...) and i.state in (...) and i.payment_state in (...) and i.move_type in (...) and i.invoice_date between ? and ? and i.company_id = ? and l.display_type is null and l.exclude_from_invoice_tab = false group by l.product_id;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 09 10 5 612ms 122ms 12 61 7s763ms 127ms 13 148 19s437ms 131ms 14 147 18s997ms 129ms 15 132 17s95ms 129ms 16 131 17s21ms 129ms 17 121 15s578ms 128ms 18 125 16s367ms 130ms 19 153 19s993ms 130ms 20 88 11s486ms 130ms 21 71 12s245ms 172ms 22 27 4s306ms 159ms -
WITH currency_rate AS ( SELECT r.currency_id, COALESCE(r.company_id, c.id) as company_id, r.rate, r.name AS date_start, ( SELECT name FROM res_currency_rate r2 WHERE r2.name > r.name AND r2.currency_id = r.currency_id AND (r2.company_id is null or r2.company_id = c.id) ORDER BY r2.name ASC LIMIT 1) AS date_end FROM res_currency_rate r JOIN res_company c ON (r.company_id is null or r.company_id = c.id)) SELECT l.product_id as product_id, SUM(l.price_unit / ( CASE COALESCE(cr.rate, 0) WHEN 0 THEN 1.0 ELSE cr.rate END) * l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END) * ((100 - l.discount) * 0.01)) / NULLIF (SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)), 0) AS avg_unit_price, SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS num_qty, SUM(ABS(l.balance) * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS total, SUM(l.quantity * pt.list_price * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS sale_expected FROM account_move_line l LEFT JOIN account_move i ON (l.move_id = i.id) LEFT JOIN product_product product ON (product.id = l.product_id) LEFT JOIN product_template pt ON (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= COALESCE(i.invoice_date, NOW()) and (cr.date_end IS NULL OR cr.date_end > COALESCE(i.invoice_date, NOW()))) WHERE l.product_id IN (194346, 194718) AND i.state IN ('posted') AND i.payment_state IN ('not_paid', 'in_payment', 'paid') AND i.move_type IN ('out_invoice', 'out_refund') AND i.invoice_date BETWEEN '2023-01-01' AND '2023-12-31' AND i.company_id = 1 AND l.display_type IS NULL AND l.exclude_from_invoice_tab = false GROUP BY l.product_id;
Date: 2023-03-09 21:27:56 Duration: 463ms
-
WITH currency_rate AS ( SELECT r.currency_id, COALESCE(r.company_id, c.id) as company_id, r.rate, r.name AS date_start, ( SELECT name FROM res_currency_rate r2 WHERE r2.name > r.name AND r2.currency_id = r.currency_id AND (r2.company_id is null or r2.company_id = c.id) ORDER BY r2.name ASC LIMIT 1) AS date_end FROM res_currency_rate r JOIN res_company c ON (r.company_id is null or r.company_id = c.id)) SELECT l.product_id as product_id, SUM(l.price_unit / ( CASE COALESCE(cr.rate, 0) WHEN 0 THEN 1.0 ELSE cr.rate END) * l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END) * ((100 - l.discount) * 0.01)) / NULLIF (SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)), 0) AS avg_unit_price, SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS num_qty, SUM(ABS(l.balance) * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS total, SUM(l.quantity * pt.list_price * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS sale_expected FROM account_move_line l LEFT JOIN account_move i ON (l.move_id = i.id) LEFT JOIN product_product product ON (product.id = l.product_id) LEFT JOIN product_template pt ON (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= COALESCE(i.invoice_date, NOW()) and (cr.date_end IS NULL OR cr.date_end > COALESCE(i.invoice_date, NOW()))) WHERE l.product_id IN (177176, 173975, 209706, 186213, 184748, 189705, 190211, 172911) AND i.state IN ('posted') AND i.payment_state IN ('not_paid', 'in_payment', 'paid') AND i.move_type IN ('out_invoice', 'out_refund') AND i.invoice_date BETWEEN '2023-01-01' AND '2023-12-31' AND i.company_id = 1 AND l.display_type IS NULL AND l.exclude_from_invoice_tab = false GROUP BY l.product_id;
Date: 2023-03-09 21:31:52 Duration: 409ms
-
WITH currency_rate AS ( SELECT r.currency_id, COALESCE(r.company_id, c.id) as company_id, r.rate, r.name AS date_start, ( SELECT name FROM res_currency_rate r2 WHERE r2.name > r.name AND r2.currency_id = r.currency_id AND (r2.company_id is null or r2.company_id = c.id) ORDER BY r2.name ASC LIMIT 1) AS date_end FROM res_currency_rate r JOIN res_company c ON (r.company_id is null or r.company_id = c.id)) SELECT l.product_id as product_id, SUM(l.price_unit / ( CASE COALESCE(cr.rate, 0) WHEN 0 THEN 1.0 ELSE cr.rate END) * l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END) * ((100 - l.discount) * 0.01)) / NULLIF (SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)), 0) AS avg_unit_price, SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS num_qty, SUM(ABS(l.balance) * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS total, SUM(l.quantity * pt.list_price * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS sale_expected FROM account_move_line l LEFT JOIN account_move i ON (l.move_id = i.id) LEFT JOIN product_product product ON (product.id = l.product_id) LEFT JOIN product_template pt ON (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= COALESCE(i.invoice_date, NOW()) and (cr.date_end IS NULL OR cr.date_end > COALESCE(i.invoice_date, NOW()))) WHERE l.product_id IN (195482) AND i.state IN ('posted') AND i.payment_state IN ('not_paid', 'in_payment', 'paid') AND i.move_type IN ('out_invoice', 'out_refund') AND i.invoice_date BETWEEN '2023-01-01' AND '2023-12-31' AND i.company_id = 1 AND l.display_type IS NULL AND l.exclude_from_invoice_tab = false GROUP BY l.product_id;
Date: 2023-03-09 21:24:38 Duration: 388ms
14 1,089 3m54s 190ms 3s866ms 215ms update "sale_order_line" set "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 09 01 1 199ms 199ms 11 7 1s584ms 226ms 12 58 11s914ms 205ms 13 316 1m11s 224ms 14 116 24s336ms 209ms 15 134 27s754ms 207ms 16 73 15s270ms 209ms 17 65 13s733ms 211ms 18 79 16s716ms 211ms 19 72 15s909ms 220ms 20 102 21s990ms 215ms 21 59 12s735ms 215ms 22 7 1s394ms 199ms -
UPDATE "sale_order_line" SET "write_uid" = 1140, "write_date" = (now() at time zone 'UTC') WHERE id IN (103008, 103040, 103042, 103013, 103014, 103037, 103045, 103049, 103018, 103053, 103025, 103030, 103063, 103064, 103034, 103003, 103004, 103005, 103007);
Date: 2023-03-09 13:13:33 Duration: 3s866ms
-
UPDATE "sale_order_line" SET "write_uid" = 1141, "write_date" = (now() at time zone 'UTC') WHERE id IN (103809, 103813, 103814, 103048, 101619, 102495);
Date: 2023-03-09 20:58:40 Duration: 1s327ms
-
UPDATE "sale_order_line" SET "write_uid" = 1147, "write_date" = (now() at time zone 'UTC') WHERE id IN (103028, 103029, 103031, 103033, 103036);
Date: 2023-03-09 13:07:08 Duration: 994ms
15 1,086 32m12s 848ms 29s776ms 1s779ms 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 09 11 2 5s380ms 2s690ms 12 74 2m14s 1s819ms 13 170 5m49s 2s54ms 14 136 4m12s 1s857ms 15 90 3m5s 2s64ms 16 126 3m45s 1s792ms 17 127 4m4s 1s928ms 18 115 2m22s 1s242ms 19 101 2m42s 1s606ms 20 74 1m45s 1s431ms 21 60 1m52s 1s874ms 22 4 4s532ms 1s133ms 23 7 6s362ms 908ms -
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (309252, 309147, 309156, 309158, 308903, 309164, 309171, 309172, 309176, 308923, 309181, 309182, 309185, 309186, 309192, 309193, 309194, 309195, 309198, 309203, 309209, 309216, 309222, 309224, 309225, 309226, 309229, 309230, 309231, 309233, 309234, 309237);
Date: 2023-03-09 14:53:59 Duration: 29s776ms
-
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (310144, 310146, 310147, 310148, 310149, 310150, 310151, 310154, 310155, 310156, 310160, 310161, 310163, 310165, 310128, 310136, 310137, 310138, 310139, 310140, 310141, 310142);
Date: 2023-03-09 19:12:47 Duration: 20s122ms
-
UPDATE "stock_move" SET "state" = 'assigned', "write_uid" = 1037, "write_date" = (now() at time zone 'UTC') WHERE id IN (309312, 309313, 309314, 309315, 309316, 309318, 309319, 309320, 309303, 309304, 309305, 309306, 309307, 309308, 309309, 309310, 309311);
Date: 2023-03-09 15:07:38 Duration: 16s138ms
16 1,037 4m5s 206ms 818ms 236ms select "sale_history_line".id from "sale_history_line" where ("sale_history_line"."so_line_id" in (...)) order by "sale_history_line"."id";Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 09 01 1 223ms 223ms 11 8 1s839ms 229ms 12 58 13s137ms 226ms 13 223 54s829ms 245ms 14 140 33s491ms 239ms 15 157 35s972ms 229ms 16 61 14s628ms 239ms 17 68 16s61ms 236ms 18 85 20s84ms 236ms 19 56 12s854ms 229ms 20 108 24s396ms 225ms 21 61 15s722ms 257ms 22 9 1s961ms 217ms 23 2 446ms 223ms -
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (103137)) ORDER BY "sale_history_line"."id";
Date: 2023-03-09 13:27:51 Duration: 818ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (103925)) ORDER BY "sale_history_line"."id";
Date: 2023-03-09 21:38:58 Duration: 769ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (103924)) ORDER BY "sale_history_line"."id";
Date: 2023-03-09 21:38:57 Duration: 640ms
17 957 3m26s 192ms 1s244ms 215ms update "sale_order_line" set "invoice_status" = ?, "open_qty_fil" = ?.?, "qty_delivered" = ?, "qty_to_invoice" = ?, "untaxed_amount_to_invoice" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 09 09 11 2s179ms 198ms 10 9 1s785ms 198ms 12 30 6s420ms 214ms 13 102 22s235ms 217ms 14 226 47s807ms 211ms 15 164 34s763ms 211ms 16 86 18s681ms 217ms 17 81 17s715ms 218ms 18 69 15s634ms 226ms 19 68 14s717ms 216ms 20 62 13s33ms 210ms 21 40 9s386ms 234ms 22 7 1s394ms 199ms 23 2 403ms 201ms -
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" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (91425, 93569, 94410, 92850, 95956, 92854);
Date: 2023-03-09 18:12:46 Duration: 1s244ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 2.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 958, "write_date" = (now() at time zone 'UTC') WHERE id IN (85697, 100966, 91334, 11687);
Date: 2023-03-09 13:56:36 Duration: 802ms
-
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" = 1007, "write_date" = (now() at time zone 'UTC') WHERE id IN (41133, 45422, 45423);
Date: 2023-03-09 19:59:04 Duration: 669ms
18 896 2m15s 120ms 1s296ms 151ms update "stock_quant" set "quantity" = ?.?, "reserved_quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 09 09 2 1s427ms 713ms 10 6 893ms 148ms 12 22 3s967ms 180ms 13 98 15s500ms 158ms 14 174 25s557ms 146ms 15 139 21s274ms 153ms 16 117 17s700ms 151ms 17 71 10s976ms 154ms 18 83 11s553ms 139ms 19 62 8s456ms 136ms 20 67 10s3ms 149ms 21 50 8s17ms 160ms 22 4 505ms 126ms 23 1 130ms 130ms -
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (236993, 237001, 237006, 237008, 237010, 237012, 237014, 237016, 237018, 236991);
Date: 2023-03-09 09:59:41 Duration: 1s296ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 951, "write_date" = (now() at time zone 'UTC') WHERE id IN (236912, 236914, 236916, 236918);
Date: 2023-03-09 13:48:40 Duration: 716ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (238016, 238017, 238014, 237799);
Date: 2023-03-09 12:47:10 Duration: 699ms
19 887 15m15s 864ms 4s999ms 1s32ms update "stock_move" set "delay_alert_date" = ?, "is_done" = false, "picking_code" = ?, "product_qty" = ?.?, "reference" = ?, "unit_factor" = ?.?, "weight" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 09 11 7 6s352ms 907ms 12 45 47s25ms 1s45ms 13 173 3m1s 1s49ms 14 97 1m45s 1s89ms 15 82 1m23s 1s21ms 16 64 1m1s 968ms 17 60 1m3s 1s52ms 18 97 1m42s 1s61ms 19 90 1m26s 964ms 20 84 1m21s 972ms 21 64 1m9s 1s89ms 22 11 13s512ms 1s228ms 23 13 11s661ms 897ms -
UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "picking_code" = 'outgoing', "product_qty" = 1.0, "reference" = '11-N/OUT/04579', "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 953, "write_date" = (now() at time zone 'UTC') WHERE id IN (308996, 308997, 308998, 309000, 309001);
Date: 2023-03-09 14:10:51 Duration: 4s999ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "picking_code" = 'outgoing', "product_qty" = 2.0, "reference" = '11-N/OUT/04570', "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1009, "write_date" = (now() at time zone 'UTC') WHERE id IN (308658, 308659, 308660, 308663);
Date: 2023-03-09 13:25:16 Duration: 3s748ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "picking_code" = 'outgoing', "product_qty" = 8.0, "reference" = '05-F/OUT/02615', "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (308888, 308886, 308878);
Date: 2023-03-09 13:57:04 Duration: 2s906ms
20 836 9m52s 668ms 1s602ms 708ms 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 #20
Day Hour Count Duration Avg duration Mar 09 11 5 3s433ms 686ms 12 26 18s139ms 697ms 13 146 1m43s 711ms 14 119 1m24s 708ms 15 91 1m3s 700ms 16 98 1m8s 703ms 17 58 40s545ms 699ms 18 114 1m20s 709ms 19 96 1m7s 701ms 20 45 31s350ms 696ms 21 27 22s97ms 818ms 22 11 7s740ms 703ms -
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 ('%83-4350-3%')) 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 ('%83-4350-3%'))) 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 ('%83-4350-3%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%83-4350-3%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-03-09 21:30:23 Duration: 1s602ms
-
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 ('%83-4550-3%')) 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 ('%83-4550-3%'))) 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 ('%83-4550-3%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%83-4550-3%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-03-09 21:33:21 Duration: 1s487ms
-
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 ('%83-3550-3%')) 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 ('%83-3550-3%'))) 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 ('%83-3550-3%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%83-3550-3%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-03-09 21:20:25 Duration: 1s227ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 873ms 14s338ms 2s585ms 200 8m37s update "stock_move" set "reference" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 09 10 1 908ms 908ms 12 8 17s660ms 2s207ms 13 12 22s438ms 1s869ms 14 29 49s962ms 1s722ms 15 20 51s911ms 2s595ms 16 27 1m9s 2s587ms 17 26 1m2s 2s419ms 18 21 1m3s 3s17ms 19 24 1m43s 4s299ms 20 21 43s502ms 2s71ms 21 11 31s334ms 2s848ms -
UPDATE "stock_move" SET "reference" = '04-V/IN/01940', "write_uid" = 960, "write_date" = (now() at time zone 'UTC') WHERE id IN (302758, 292840, 292841, 292843, 292844, 292846, 292848, 292852, 292853, 292855, 292856, 292857, 292858, 292860, 292862);
Date: 2023-03-09 19:55:11 Duration: 14s338ms
-
UPDATE "stock_move" SET "reference" = '02-G/IN/03224', "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (284833, 284840, 284873, 284842, 284874, 284844, 284875, 284882, 284852, 284885, 284886, 284887, 284859, 284860);
Date: 2023-03-09 19:42:12 Duration: 13s371ms
-
UPDATE "stock_move" SET "reference" = '02-G/OUT/06115', "write_uid" = 1005, "write_date" = (now() at time zone 'UTC') WHERE id IN (308553, 308554, 308555, 308556, 308557, 308559, 308560, 308561, 308563, 308566, 308567, 308568, 308571);
Date: 2023-03-09 15:44:33 Duration: 12s565ms
2 870ms 13s715ms 2s551ms 212 9m update "stock_move" set "picking_id" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 09 10 1 894ms 894ms 12 8 16s847ms 2s105ms 13 12 22s767ms 1s897ms 14 29 49s254ms 1s698ms 15 22 57s767ms 2s625ms 16 29 1m6s 2s300ms 17 27 54s314ms 2s11ms 18 26 1m28s 3s414ms 19 25 1m45s 4s207ms 20 22 45s15ms 2s46ms 21 11 33s428ms 3s38ms -
UPDATE "stock_move" SET "picking_id" = 89979, "write_uid" = 960, "write_date" = (now() at time zone 'UTC') WHERE id IN (302758, 292840, 292841, 292843, 292844, 292846, 292848, 292852, 292853, 292855, 292856, 292857, 292858, 292860, 292862);
Date: 2023-03-09 19:54:55 Duration: 13s715ms
-
UPDATE "stock_move" SET "picking_id" = 89958, "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (284833, 284840, 284873, 284842, 284874, 284844, 284875, 284882, 284852, 284885, 284886, 284887, 284859, 284860);
Date: 2023-03-09 19:41:56 Duration: 12s990ms
-
UPDATE "stock_move" SET "picking_id" = 89446, "write_uid" = 1005, "write_date" = (now() at time zone 'UTC') WHERE id IN (308553, 308554, 308555, 308556, 308557, 308559, 308560, 308561, 308563, 308566, 308567, 308568, 308571);
Date: 2023-03-09 15:44:12 Duration: 12s559ms
3 879ms 16s998ms 2s393ms 278 11m5s update "stock_move" set "branch_id" = ?, "picking_id" = ?, "related_core_purchase_line_id" = ?, "related_core_repair_line_id" = ?, "related_core_sale_line_id" = ?, "scrapped" = false, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 09 11 2 5s488ms 2s744ms 12 18 41s878ms 2s326ms 13 48 2m30s 3s138ms 14 42 1m27s 2s88ms 15 27 1m12s 2s691ms 16 25 45s435ms 1s817ms 17 20 45s211ms 2s260ms 18 23 36s288ms 1s577ms 19 30 50s254ms 1s675ms 20 23 1m8s 2s957ms 21 17 57s457ms 3s379ms 22 3 4s334ms 1s444ms -
UPDATE "stock_move" SET "branch_id" = 37, "picking_id" = 89101, "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 (308553, 308554, 308555, 308556, 308557, 308558, 308559, 308560, 308561, 308562, 308563, 308565, 308566, 308567, 308568, 308569, 308571);
Date: 2023-03-09 13:15:36 Duration: 16s998ms
-
UPDATE "stock_move" SET "branch_id" = 50, "picking_id" = 89398, "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 (309312, 309313, 309314, 309315, 309316, 309318, 309319, 309320, 309303, 309304, 309305, 309306, 309307, 309308, 309309, 309310, 309311);
Date: 2023-03-09 15:06:54 Duration: 16s177ms
-
UPDATE "stock_move" SET "branch_id" = 40, "picking_id" = 89193, "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 (308872, 308873, 308874, 308875, 308876, 308878, 308879, 308880, 308881, 308882, 308883, 308884, 308885, 308887, 308888, 308890);
Date: 2023-03-09 13:56:44 Duration: 15s581ms
4 875ms 53s443ms 2s384ms 788 31m18s update "stock_move" set "date" = ?, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 09 09 1 10s19ms 10s19ms 10 4 6s430ms 1s607ms 12 47 1m44s 2s223ms 13 125 4m54s 2s353ms 14 147 4m41s 1s913ms 15 77 4m54s 3s829ms 16 86 3m12s 2s239ms 17 72 3m4s 2s561ms 18 67 2m28s 2s215ms 19 73 2m35s 2s130ms 20 46 1m55s 2s514ms 21 27 1m14s 2s763ms 22 4 5s417ms 1s354ms 23 12 10s872ms 906ms -
UPDATE "stock_move" SET "date" = '2023-03-09 13:54:07', "state" = 'done', "write_uid" = 958, "write_date" = (now() at time zone 'UTC') WHERE id IN (288297, 288298, 288299, 288300, 288302, 288303, 288304, 288305, 288306, 288307, 288308, 288309, 288310, 288312, 288313, 288314, 288315, 288316, 288317, 288318, 288319, 288320, 288321, 288322, 288323, 288324, 288325, 288326, 288327, 288328, 288329, 288330, 288331, 288332, 288333, 288334, 288335, 288336, 288337, 288338, 288339, 288340, 288341, 288342, 288343, 288344, 288345, 288346, 288347, 288348, 288349, 288350, 288351, 288352);
Date: 2023-03-09 13:55:05 Duration: 53s443ms
-
UPDATE "stock_move" SET "date" = '2023-03-09 15:37:59', "state" = 'done', "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (292480, 292481, 292482, 292483, 292484, 292485, 292486, 292488, 292489, 292490, 292491, 292493, 292494, 292495, 292496, 292497, 292498, 292499, 292500, 292501, 292502, 292503, 292504, 292505, 292506, 292507, 292508, 292510, 292511, 292512, 292513, 292514, 292515, 292516, 292517, 292518, 292519, 292520, 292521);
Date: 2023-03-09 15:38:35 Duration: 36s836ms
-
UPDATE "stock_move" SET "date" = '2023-03-09 15:22:36', "state" = 'done', "write_uid" = 989, "write_date" = (now() at time zone 'UTC') WHERE id IN (309252, 309147, 309156, 309158, 308904, 309164, 309171, 309172, 308917, 309176, 308923, 309181, 309182, 309185, 309186, 309192, 309193, 309194, 309195, 309198, 309328, 309330, 309203, 309209, 309216, 309222, 309224, 309225, 309226, 309229, 309230, 309231, 309233, 309234, 309237);
Date: 2023-03-09 15:23:13 Duration: 34s225ms
5 871ms 15s777ms 1s832ms 295 9m update "stock_move" set "delay_alert_date" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 09 12 29 49s50ms 1s691ms 13 49 1m18s 1s610ms 14 23 36s398ms 1s582ms 15 14 36s930ms 2s637ms 16 38 1m48s 2s846ms 17 45 2m9s 2s873ms 18 41 41s904ms 1s22ms 19 19 23s6ms 1s210ms 20 24 21s990ms 916ms 21 13 14s863ms 1s143ms -
UPDATE "stock_move" SET "delay_alert_date" = NULL, "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (292704, 205345, 205347, 292805, 278855, 292712, 269050, 257322, 213517, 276973, 213519, 292788, 292793, 292698, 292700, 292799);
Date: 2023-03-09 15:40:03 Duration: 15s777ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "write_uid" = 982, "write_date" = (now() at time zone 'UTC') WHERE id IN (301696, 301697, 301698, 301699, 301700, 301701, 301706, 301707, 301690, 301691, 301694, 301695);
Date: 2023-03-09 16:46:54 Duration: 11s277ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "write_uid" = 982, "write_date" = (now() at time zone 'UTC') WHERE id IN (203493, 301742, 301744, 301745, 301748, 301749, 301750, 301751, 301754, 301755, 301756, 301757);
Date: 2023-03-09 17:34:33 Duration: 10s785ms
6 848ms 29s776ms 1s779ms 1,086 32m12s update "stock_move" set "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 09 11 2 5s380ms 2s690ms 12 74 2m14s 1s819ms 13 170 5m49s 2s54ms 14 136 4m12s 1s857ms 15 90 3m5s 2s64ms 16 126 3m45s 1s792ms 17 127 4m4s 1s928ms 18 115 2m22s 1s242ms 19 101 2m42s 1s606ms 20 74 1m45s 1s431ms 21 60 1m52s 1s874ms 22 4 4s532ms 1s133ms 23 7 6s362ms 908ms -
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (309252, 309147, 309156, 309158, 308903, 309164, 309171, 309172, 309176, 308923, 309181, 309182, 309185, 309186, 309192, 309193, 309194, 309195, 309198, 309203, 309209, 309216, 309222, 309224, 309225, 309226, 309229, 309230, 309231, 309233, 309234, 309237);
Date: 2023-03-09 14:53:59 Duration: 29s776ms
-
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (310144, 310146, 310147, 310148, 310149, 310150, 310151, 310154, 310155, 310156, 310160, 310161, 310163, 310165, 310128, 310136, 310137, 310138, 310139, 310140, 310141, 310142);
Date: 2023-03-09 19:12:47 Duration: 20s122ms
-
UPDATE "stock_move" SET "state" = 'assigned', "write_uid" = 1037, "write_date" = (now() at time zone 'UTC') WHERE id IN (309312, 309313, 309314, 309315, 309316, 309318, 309319, 309320, 309303, 309304, 309305, 309306, 309307, 309308, 309309, 309310, 309311);
Date: 2023-03-09 15:07:38 Duration: 16s138ms
7 622ms 8s15ms 1s269ms 2,221 47m select "item_list_line".id from "item_list_line" where (((("item_list_line"."active" = true) and ("item_list_line"."product_id" = ?)) and (("item_list_line"."method" not in (...)) or "item_list_line"."method" is null)) and ("item_list_line"."item_demand_plan_id" = ?)) order by "item_list_line"."id" limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 09 14 28 19s980ms 713ms 21 1,944 43m30s 1s342ms 22 249 3m9s 762ms -
SELECT "item_list_line".id FROM "item_list_line" WHERE (((("item_list_line"."active" = true) AND ("item_list_line"."product_id" = 195662)) AND (("item_list_line"."method" not in (7, 8)) OR "item_list_line"."method" IS NULL)) AND ("item_list_line"."item_demand_plan_id" = 2853)) ORDER BY "item_list_line"."id" LIMIT 1;
Date: 2023-03-09 21:31:50 Duration: 8s15ms
-
SELECT "item_list_line".id FROM "item_list_line" WHERE (((("item_list_line"."active" = true) AND ("item_list_line"."product_id" = 194841)) AND (("item_list_line"."method" not in (7, 8)) OR "item_list_line"."method" IS NULL)) AND ("item_list_line"."item_demand_plan_id" = 2857)) ORDER BY "item_list_line"."id" LIMIT 1;
Date: 2023-03-09 21:32:35 Duration: 7s480ms
-
SELECT "item_list_line".id FROM "item_list_line" WHERE (((("item_list_line"."active" = true) AND ("item_list_line"."product_id" = 194821)) AND (("item_list_line"."method" not in (7, 8)) OR "item_list_line"."method" IS NULL)) AND ("item_list_line"."item_demand_plan_id" = 2859)) ORDER BY "item_list_line"."id" LIMIT 1;
Date: 2023-03-09 21:32:49 Duration: 7s309ms
8 862ms 18s865ms 1s202ms 1,222 24m29s update "stock_move" set "current_warehouse_qty" = ?.?, "is_done" = true, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 09 09 2 9s971ms 4s985ms 10 6 6s325ms 1s54ms 12 29 38s899ms 1s341ms 13 146 3m 1s238ms 14 201 3m37s 1s83ms 15 176 4m5s 1s393ms 16 142 2m51s 1s205ms 17 141 2m33s 1s87ms 18 116 2m10s 1s126ms 19 114 2m4s 1s94ms 20 84 1m47s 1s277ms 21 47 1m7s 1s436ms 22 6 5s456ms 909ms 23 12 10s753ms 896ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "is_done" = true, "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (292480, 292481, 292483, 292484, 292516, 292518, 292519, 292488, 292489, 292490, 292520, 292521, 292497, 292498, 292499, 292500, 292501, 292504, 292508, 292511);
Date: 2023-03-09 15:39:10 Duration: 18s865ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "is_done" = true, "write_uid" = 1019, "write_date" = (now() at time zone 'UTC') WHERE id IN (292524, 292525, 292526, 292527, 292528, 292529, 292530, 292531, 292532, 292533, 292534, 292535, 292536, 292537, 292538, 292539);
Date: 2023-03-09 15:37:43 Duration: 15s641ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 1.0, "is_done" = true, "write_uid" = 1016, "write_date" = (now() at time zone 'UTC') WHERE id IN (292512, 292513, 292514, 292517, 292486, 292491, 292493, 292494, 292495, 292503, 292505, 292506, 292507);
Date: 2023-03-09 15:39:23 Duration: 12s319ms
9 866ms 8s278ms 1s62ms 551 9m45s update "stock_move" set "current_warehouse_qty" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 09 12 65 1m2s 966ms 13 109 1m47s 987ms 14 71 1m10s 993ms 15 30 47s605ms 1s586ms 16 81 1m28s 1s86ms 17 88 1m36s 1s92ms 18 40 36s946ms 923ms 19 27 37s222ms 1s378ms 20 26 24s513ms 942ms 21 14 13s839ms 988ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 0.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (310144, 310148, 310149, 310151, 310129, 310161, 310163, 310134, 310137);
Date: 2023-03-09 19:21:31 Duration: 8s278ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 0.0, "write_uid" = 989, "write_date" = (now() at time zone 'UTC') WHERE id IN (308904, 309224, 309198, 308917, 309182);
Date: 2023-03-09 15:23:24 Duration: 4s735ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 1.0, "write_uid" = 989, "write_date" = (now() at time zone 'UTC') WHERE id IN (309186, 309158, 309226, 309171, 309203);
Date: 2023-03-09 15:23:36 Duration: 4s654ms
10 864ms 4s999ms 1s32ms 887 15m15s update "stock_move" set "delay_alert_date" = ?, "is_done" = false, "picking_code" = ?, "product_qty" = ?.?, "reference" = ?, "unit_factor" = ?.?, "weight" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 09 11 7 6s352ms 907ms 12 45 47s25ms 1s45ms 13 173 3m1s 1s49ms 14 97 1m45s 1s89ms 15 82 1m23s 1s21ms 16 64 1m1s 968ms 17 60 1m3s 1s52ms 18 97 1m42s 1s61ms 19 90 1m26s 964ms 20 84 1m21s 972ms 21 64 1m9s 1s89ms 22 11 13s512ms 1s228ms 23 13 11s661ms 897ms -
UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "picking_code" = 'outgoing', "product_qty" = 1.0, "reference" = '11-N/OUT/04579', "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 953, "write_date" = (now() at time zone 'UTC') WHERE id IN (308996, 308997, 308998, 309000, 309001);
Date: 2023-03-09 14:10:51 Duration: 4s999ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "picking_code" = 'outgoing', "product_qty" = 2.0, "reference" = '11-N/OUT/04570', "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1009, "write_date" = (now() at time zone 'UTC') WHERE id IN (308658, 308659, 308660, 308663);
Date: 2023-03-09 13:25:16 Duration: 3s748ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "picking_code" = 'outgoing', "product_qty" = 8.0, "reference" = '05-F/OUT/02615', "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (308888, 308886, 308878);
Date: 2023-03-09 13:57:04 Duration: 2s906ms
11 869ms 1s452ms 959ms 806 12m53s insert into "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "orderpoint_id", "origin", "partner_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "rule_id", "sale_line_id", "sequence", "state", "warehouse_id") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), false, null, null, ?, ?, ?, ?, ?, ?, ?, ?, ?, null, ?, ?, ?, ?, ?, ?, ?, ?, false, ?, ?, ?, ?, ?) returning id;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 09 11 7 6s307ms 901ms 12 46 42s844ms 931ms 13 179 2m58s 999ms 14 98 1m36s 981ms 15 88 1m23s 945ms 16 64 59s805ms 934ms 17 61 59s345ms 972ms 18 56 52s74ms 929ms 19 54 50s249ms 930ms 20 87 1m21s 935ms 21 55 52s600ms 956ms 22 5 4s783ms 956ms 23 6 5s398ms 899ms -
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "orderpoint_id", "origin", "partner_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "rule_id", "sale_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1, (now() at time zone 'UTC'), 1, (now() at time zone 'UTC'), false, NULL, NULL, 1, '2023-03-09 14:20:58', '2023-03-09 14:20:58', 'Butt Connector', 64975, 5, 389, 'new_product', '[83-3350-3] Butt Connector', NULL, 'C-03903', 38081, 282, '0', 'make_to_stock', 209373, 1, '1.00', false, 317, 103306, 10, 'draft', 36) RETURNING id;
Date: 2023-03-09 14:25:51 Duration: 1s452ms
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "orderpoint_id", "origin", "partner_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "rule_id", "sale_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1, (now() at time zone 'UTC'), 1, (now() at time zone 'UTC'), false, NULL, NULL, 1, '2023-03-09 21:26:14', '2023-03-09 21:26:14', 'AUTOMATIC BRAKE ADJUSTER KIT TRUCK TRAILER SABA WITH HARDWAR', 65471, 5, 429, 'new_product', '[40020231] AUTOMATIC BRAKE ADJUSTER KIT TRUCK TRAILER SABA WITH HARDWAR', NULL, 'B-02606', 42428, 322, '0', 'make_to_stock', 183894, 1, '4.00', false, 362, 103920, 10, 'draft', 41) RETURNING id;
Date: 2023-03-09 21:27:09 Duration: 1s431ms
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "orderpoint_id", "origin", "partner_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "rule_id", "sale_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1, (now() at time zone 'UTC'), 1, (now() at time zone 'UTC'), false, NULL, NULL, 1, '2023-03-09 14:23:36', '2023-03-09 14:23:36', 'Washer', 64976, 5, 445, 'new_product', '[E-581] Washer', NULL, 'N-03425', 50710, 338, '0', 'make_to_stock', 184788, 1, '12.00', false, 380, 103315, 10, 'draft', 43) RETURNING id;
Date: 2023-03-09 14:25:51 Duration: 1s338ms
12 668ms 1s602ms 708ms 836 9m52s select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (("product_template"."is_core" is null or "product_template"."is_core" = false) and (("product_template"."type" in (...)) and (((((unaccent ("product_template"."default_code"::text) ilike unaccent (?)) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null)))) or unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?)) or false) or (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent (?)))))) and (("product_template"."company_id" in (...)) or "product_template"."company_id" is null) order by coalesce("product_template__name"."value", "product_template"."name") limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 09 11 5 3s433ms 686ms 12 26 18s139ms 697ms 13 146 1m43s 711ms 14 119 1m24s 708ms 15 91 1m3s 700ms 16 98 1m8s 703ms 17 58 40s545ms 699ms 18 114 1m20s 709ms 19 96 1m7s 701ms 20 45 31s350ms 696ms 21 27 22s97ms 818ms 22 11 7s740ms 703ms -
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 ('%83-4350-3%')) 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 ('%83-4350-3%'))) 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 ('%83-4350-3%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%83-4350-3%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-03-09 21:30:23 Duration: 1s602ms
-
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 ('%83-4550-3%')) 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 ('%83-4550-3%'))) 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 ('%83-4550-3%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%83-4550-3%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-03-09 21:33:21 Duration: 1s487ms
-
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 ('%83-3550-3%')) 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 ('%83-3550-3%'))) 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 ('%83-3550-3%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%83-3550-3%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-03-09 21:20:25 Duration: 1s227ms
13 370ms 2s904ms 599ms 2,253 22m30s select date_part(?, invoice_date) as year, date_part(?, invoice_date) as month, date_part(?, invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = ? and item_demand_plan_id = ? group by product_id, date_part(?, invoice_date), date_part(?, invoice_date), date_part(?, invoice_date) order by date_part(?, invoice_date), date_part(?, invoice_date), date_part(?, invoice_date);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 09 14 28 11s626ms 415ms 21 1,960 20m26s 625ms 22 265 1m53s 426ms -
select date_part('year', invoice_date) as Year, date_part('month', invoice_date) as Month, date_part('day', invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = 195989 and item_demand_plan_id = 2852 group by product_id, date_part('month', invoice_date), date_part('year', invoice_date), date_part('day', invoice_date) order by date_part('year', invoice_date), date_part('month', invoice_date), date_part('day', invoice_date);
Date: 2023-03-09 21:31:35 Duration: 2s904ms
-
select date_part('year', invoice_date) as Year, date_part('month', invoice_date) as Month, date_part('day', invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = 195651 and item_demand_plan_id = 2853 group by product_id, date_part('month', invoice_date), date_part('year', invoice_date), date_part('day', invoice_date) order by date_part('year', invoice_date), date_part('month', invoice_date), date_part('day', invoice_date);
Date: 2023-03-09 21:31:35 Duration: 2s896ms
-
select date_part('year', invoice_date) as Year, date_part('month', invoice_date) as Month, date_part('day', invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = 195968 and item_demand_plan_id = 2856 group by product_id, date_part('month', invoice_date), date_part('year', invoice_date), date_part('day', invoice_date) order by date_part('year', invoice_date), date_part('month', invoice_date), date_part('day', invoice_date);
Date: 2023-03-09 21:32:20 Duration: 2s868ms
14 485ms 1s264ms 568ms 3,851 36m30s 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 #14
Day Hour Count Duration Avg duration Mar 09 01 32 17s216ms 538ms 11 59 31s994ms 542ms 12 273 2m29s 549ms 13 929 8m56s 577ms 14 454 4m17s 566ms 15 300 2m47s 559ms 16 343 3m14s 565ms 17 235 2m13s 566ms 18 341 3m16s 577ms 19 323 3m2s 565ms 20 329 3m3s 556ms 21 183 1m51s 611ms 22 32 17s386ms 543ms 23 18 9s670ms 537ms -
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 ('%%562112436%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%562.112436%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%562.112436%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-03-09 21:32:23 Duration: 1s264ms
-
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 ('%%5621124%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%562.1124%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%562.1124%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-03-09 21:32:22 Duration: 1s234ms
-
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 ('%%562%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%562.%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%562.%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-03-09 21:32:20 Duration: 1s77ms
15 521ms 902ms 568ms 1,419 13m26s 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 #15
Day Hour Count Duration Avg duration Mar 09 12 55 30s256ms 550ms 13 245 2m20s 573ms 14 338 3m14s 575ms 15 109 1m1s 566ms 16 130 1m12s 560ms 17 111 1m2s 563ms 18 124 1m11s 578ms 19 200 1m53s 567ms 20 67 36s952ms 551ms 21 40 22s321ms 558ms -
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 ('%%SPL25%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%SPL25%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%SPL25%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-03-09 14:58:03 Duration: 902ms
-
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 ('%%430215%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%430215%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%430215%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-03-09 14:52:53 Duration: 869ms
-
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 ('%%n211%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%n2-1-1%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%n2-1-1%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-03-09 14:48:01 Duration: 866ms
16 206ms 818ms 236ms 1,037 4m5s select "sale_history_line".id from "sale_history_line" where ("sale_history_line"."so_line_id" in (...)) order by "sale_history_line"."id";Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 09 01 1 223ms 223ms 11 8 1s839ms 229ms 12 58 13s137ms 226ms 13 223 54s829ms 245ms 14 140 33s491ms 239ms 15 157 35s972ms 229ms 16 61 14s628ms 239ms 17 68 16s61ms 236ms 18 85 20s84ms 236ms 19 56 12s854ms 229ms 20 108 24s396ms 225ms 21 61 15s722ms 257ms 22 9 1s961ms 217ms 23 2 446ms 223ms -
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (103137)) ORDER BY "sale_history_line"."id";
Date: 2023-03-09 13:27:51 Duration: 818ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (103925)) ORDER BY "sale_history_line"."id";
Date: 2023-03-09 21:38:58 Duration: 769ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (103924)) ORDER BY "sale_history_line"."id";
Date: 2023-03-09 21:38:57 Duration: 640ms
17 190ms 3s866ms 215ms 1,089 3m54s update "sale_order_line" set "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 09 01 1 199ms 199ms 11 7 1s584ms 226ms 12 58 11s914ms 205ms 13 316 1m11s 224ms 14 116 24s336ms 209ms 15 134 27s754ms 207ms 16 73 15s270ms 209ms 17 65 13s733ms 211ms 18 79 16s716ms 211ms 19 72 15s909ms 220ms 20 102 21s990ms 215ms 21 59 12s735ms 215ms 22 7 1s394ms 199ms -
UPDATE "sale_order_line" SET "write_uid" = 1140, "write_date" = (now() at time zone 'UTC') WHERE id IN (103008, 103040, 103042, 103013, 103014, 103037, 103045, 103049, 103018, 103053, 103025, 103030, 103063, 103064, 103034, 103003, 103004, 103005, 103007);
Date: 2023-03-09 13:13:33 Duration: 3s866ms
-
UPDATE "sale_order_line" SET "write_uid" = 1141, "write_date" = (now() at time zone 'UTC') WHERE id IN (103809, 103813, 103814, 103048, 101619, 102495);
Date: 2023-03-09 20:58:40 Duration: 1s327ms
-
UPDATE "sale_order_line" SET "write_uid" = 1147, "write_date" = (now() at time zone 'UTC') WHERE id IN (103028, 103029, 103031, 103033, 103036);
Date: 2023-03-09 13:07:08 Duration: 994ms
18 192ms 1s244ms 215ms 957 3m26s update "sale_order_line" set "invoice_status" = ?, "open_qty_fil" = ?.?, "qty_delivered" = ?, "qty_to_invoice" = ?, "untaxed_amount_to_invoice" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 09 09 11 2s179ms 198ms 10 9 1s785ms 198ms 12 30 6s420ms 214ms 13 102 22s235ms 217ms 14 226 47s807ms 211ms 15 164 34s763ms 211ms 16 86 18s681ms 217ms 17 81 17s715ms 218ms 18 69 15s634ms 226ms 19 68 14s717ms 216ms 20 62 13s33ms 210ms 21 40 9s386ms 234ms 22 7 1s394ms 199ms 23 2 403ms 201ms -
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" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (91425, 93569, 94410, 92850, 95956, 92854);
Date: 2023-03-09 18:12:46 Duration: 1s244ms
-
UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 2.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 958, "write_date" = (now() at time zone 'UTC') WHERE id IN (85697, 100966, 91334, 11687);
Date: 2023-03-09 13:56:36 Duration: 802ms
-
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" = 1007, "write_date" = (now() at time zone 'UTC') WHERE id IN (41133, 45422, 45423);
Date: 2023-03-09 19:59:04 Duration: 669ms
19 154ms 304ms 165ms 3,091 8m32s select res_partner.id from "res_partner" where ("res_partner"."active" = true) and (((("res_partner"."partner_share" is null or "res_partner"."partner_share" = false) or ("res_partner"."company_id" in (...))) or "res_partner"."company_id" is null) and (((("res_partner"."type" != ?) or "res_partner"."type" is null) or "res_partner"."type" is null) or ("res_partner"."type" = ?))) and (unaccent (res_partner.email) ilike unaccent (?) or unaccent (res_partner.display_name) ilike unaccent (?) or unaccent (res_partner.ref) ilike unaccent (?) or unaccent (res_partner.vat) ilike unaccent (?)) unaccent (res_partner.display_name);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 09 01 1 157ms 157ms 09 1 156ms 156ms 10 4 634ms 158ms 11 1 159ms 159ms 12 69 11s178ms 162ms 13 296 48s660ms 164ms 14 150 25s469ms 169ms 15 338 55s510ms 164ms 16 534 1m27s 164ms 17 742 2m2s 164ms 18 363 1m1s 168ms 19 371 1m1s 166ms 20 108 17s779ms 164ms 21 106 18s863ms 177ms 22 4 668ms 167ms 23 3 477ms 159ms -
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%49602%') OR unaccent (res_partner.display_name) ilike unaccent ('%49602%') OR unaccent (res_partner.ref) ilike unaccent ('%49602%') OR unaccent (res_partner.vat) ilike unaccent ('49602')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%49602%') desc, unaccent (res_partner.display_name);
Date: 2023-03-09 18:34:08 Duration: 304ms
-
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%i566344%') OR unaccent (res_partner.display_name) ilike unaccent ('%i566344%') OR unaccent (res_partner.ref) ilike unaccent ('%i566344%') OR unaccent (res_partner.vat) ilike unaccent ('i566344')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%i566344%') desc, unaccent (res_partner.display_name);
Date: 2023-03-09 13:08:40 Duration: 302ms
-
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%I-01122%') OR unaccent (res_partner.display_name) ilike unaccent ('%I-01122%') OR unaccent (res_partner.ref) ilike unaccent ('%I-01122%') OR unaccent (res_partner.vat) ilike unaccent ('I-01122')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%I-01122%') desc, unaccent (res_partner.display_name);
Date: 2023-03-09 21:23:28 Duration: 298ms
20 120ms 1s296ms 151ms 896 2m15s update "stock_quant" set "quantity" = ?.?, "reserved_quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 09 09 2 1s427ms 713ms 10 6 893ms 148ms 12 22 3s967ms 180ms 13 98 15s500ms 158ms 14 174 25s557ms 146ms 15 139 21s274ms 153ms 16 117 17s700ms 151ms 17 71 10s976ms 154ms 18 83 11s553ms 139ms 19 62 8s456ms 136ms 20 67 10s3ms 149ms 21 50 8s17ms 160ms 22 4 505ms 126ms 23 1 130ms 130ms -
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (236993, 237001, 237006, 237008, 237010, 237012, 237014, 237016, 237018, 236991);
Date: 2023-03-09 09:59:41 Duration: 1s296ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 951, "write_date" = (now() at time zone 'UTC') WHERE id IN (236912, 236914, 236916, 236918);
Date: 2023-03-09 13:48:40 Duration: 716ms
-
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (238016, 238017, 238014, 237799);
Date: 2023-03-09 12:47:10 Duration: 699ms
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
- 104,148 Log entries
Events distribution
Key values
- 0 PANIC entries
- 1 FATAL entries
- 5756 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 3,225 Max number of times the same event was reported
- 5,757 Total events found
Rank Times reported Error 1 3,225 ERROR: could not serialize access due to concurrent delete
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 09 00 81 01 98 02 107 03 139 04 117 05 153 06 96 07 145 08 100 09 94 10 98 11 93 12 118 13 176 14 170 15 339 16 150 17 113 18 114 19 135 20 124 21 166 22 126 23 173 - ERROR: could not serialize access due to concurrent delete
Statement: DELETE FROM ir_attachment WHERE id IN (1120437)
Date: 2023-03-09 23:50:19
2 1,317 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 09 00 35 01 32 02 41 03 48 04 50 05 58 06 32 07 53 08 32 09 34 10 41 11 37 12 50 13 85 14 85 15 138 16 62 17 64 18 56 19 55 20 56 21 71 22 48 23 54 - ERROR: process 4188665 still waiting for ShareLock on transaction 99659173 after 1000.045 ms
- ERROR: process 4188488 still waiting for ShareLock on transaction 99659177 after 1000.051 ms
- ERROR: process 4188665 still waiting for ShareLock on transaction 99659243 after 1000.049 ms
Detail: Process holding the lock: 4188515. Wait queue: 4188665.
Context: while deleting tuple (3305,8) in relation "ir_attachment"
Statement: DELETE FROM ir_attachment WHERE id IN (1120487)Date: 2023-03-09 23:51:53
Detail: Process holding the lock: 4188983. Wait queue: 4188488.
Context: while deleting tuple (3298,161) in relation "ir_attachment"
Statement: DELETE FROM ir_attachment WHERE id IN (1120492)Date: 2023-03-09 23:52:00
Detail: Process holding the lock: 4188661. Wait queue: 4188665.
Context: while deleting tuple (3230,218) in relation "ir_attachment"
Statement: DELETE FROM ir_attachment WHERE id IN (1120506)Date: 2023-03-09 23:52:51
3 645 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #3
Day Hour Count Mar 09 00 1 01 5 04 9 05 11 06 2 07 18 08 28 09 2 10 1 11 14 12 32 13 81 14 71 15 74 16 51 17 44 18 44 19 59 20 41 21 52 22 3 23 2 - ERROR: could not serialize access due to concurrent update
Statement: UPDATE "bus_presence" SET "last_poll"='2023-03-09 23:50:19',"last_presence"='2023-03-09 23:50:18.710166' WHERE id IN (66)
Date: 2023-03-09 23:50:19
4 360 ERROR: could not obtain lock on row in relation "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Mar 09 00 28 01 36 02 18 03 4 04 3 05 4 06 7 07 8 08 6 09 10 10 37 11 10 12 6 13 10 14 7 15 67 16 15 17 20 18 14 19 11 20 10 21 10 22 9 23 10 - ERROR: could not obtain lock on row in relation "ir_cron"
- ERROR: could not obtain lock on row in relation "website_visitor"
- ERROR: could not obtain lock on row in relation "stock_quant"
Statement: SELECT * FROM ir_cron WHERE numbercall != 0 AND active AND nextcall <= (now() at time zone 'UTC') AND id=67 FOR UPDATE NOWAIT
Date: 2023-03-09 23:50:08
Statement: SELECT * FROM website_visitor where id = 2500 FOR NO KEY UPDATE NOWAIT
Date: 2023-03-09 13:37:14
Statement: SELECT 1 FROM stock_quant WHERE id = 1924 FOR UPDATE NOWAIT
Date: 2023-03-09 15:23:36
5 82 ERROR: current transaction is aborted, commands ignored until end of transaction block
Times Reported Most Frequent Error / Event #5
Day Hour Count Mar 09 01 2 02 1 03 4 04 4 05 3 08 7 09 3 10 3 11 1 12 1 13 5 14 4 15 17 16 9 17 7 18 3 19 3 20 3 23 2 - ERROR: current transaction is aborted, commands ignored until end of transaction block
Statement: SELECT "ir_ui_view".id FROM "ir_ui_view" LEFT JOIN "website" AS "ir_ui_view__website_id" ON ("ir_ui_view"."website_id" = "ir_ui_view__website_id"."id") WHERE (("ir_ui_view"."active" = true) AND (("ir_ui_view"."key" = 'http_routing.http_error') AND (("ir_ui_view"."website_id" in (1)) OR "ir_ui_view"."website_id" IS NULL))) ORDER BY "ir_ui_view__website_id"."id" LIMIT 1
Date: 2023-03-09 01:06:36
6 67 LOG: process ... still waiting for AccessExclusiveLock on tuple (...) of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #6
Day Hour Count Mar 09 00 1 01 2 02 1 03 2 04 2 05 3 06 1 07 1 08 2 09 1 10 2 12 2 13 4 14 5 15 13 16 3 17 4 18 4 19 3 20 2 21 6 23 3 - ERROR: process 128339 still waiting for AccessExclusiveLock on tuple (3230,218) of relation 43604 of database 65946 after 1000.049 ms
- ERROR: process 3540432 still waiting for AccessExclusiveLock on tuple (3372,56) of relation 43604 of database 65946 after 1000.039 ms
- ERROR: process 3550455 still waiting for AccessExclusiveLock on tuple (3249,3) of relation 43604 of database 65946 after 1000.047 ms
Detail: Process holding the lock: 4188665. Wait queue: 128339.
Statement: DELETE FROM ir_attachment WHERE id IN (1120506)Date: 2023-03-09 23:52:52
Detail: Process holding the lock: 3550948. Wait queue: 3540432.
Statement: DELETE FROM ir_attachment WHERE id IN (1075205)Date: 2023-03-09 00:23:16
Detail: Process holding the lock: 3548598. Wait queue: 3550455, 3548039.
Statement: DELETE FROM ir_attachment WHERE id IN (1077717)Date: 2023-03-09 01:50:38
7 13 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #7
Day Hour Count Mar 09 10 6 18 7 - ERROR: process 3810742 still waiting for ShareLock on relation 42418 of database 65946 after 1000.062 ms
- ERROR: process 3810742 still waiting for ShareLock on relation 42418 of database 65946 after 1000.048 ms
- ERROR: process 3810742 still waiting for ShareLock on relation 44482 of database 65946 after 1000.035 ms
Detail: Process holding the lock: 3810732. Wait queue: 3810742.
Statement: CREATE INDEX IF NOT EXISTS account_move_to_check_idx ON account_move(journal_id) WHERE to_check = true; CREATE INDEX IF NOT EXISTS account_move_payment_idx ON account_move(journal_id, state, payment_state, move_type, date);Date: 2023-03-09 10:29:50
Detail: Process holding the lock: 3810187. Wait queue: 3810742.
Statement: CREATE INDEX IF NOT EXISTS account_move_to_check_idx ON account_move(journal_id) WHERE to_check = true; CREATE INDEX IF NOT EXISTS account_move_payment_idx ON account_move(journal_id, state, payment_state, move_type, date);Date: 2023-03-09 10:30:16
Detail: Processes holding the lock: 3810564, 3810203. Wait queue: 3810742.
Statement: CREATE UNIQUE INDEX IF NOT EXISTS product_product_combination_unique ON product_product (product_tmpl_id, combination_indices) WHERE active is trueDate: 2023-03-09 10:30:31
8 8 ERROR: deadlock detected
Times Reported Most Frequent Error / Event #8
Day Hour Count Mar 09 10 1 15 1 18 1 20 3 21 2 - ERROR: deadlock detected
- ERROR: deadlock detected
- ERROR: deadlock detected
Detail: Process 3810742 waits for AccessExclusiveLock on relation 43699 of database 65946; blocked by process 3810906. Process 3810906 waits for RowExclusiveLock on relation 44482 of database 65946; blocked by process 3810742. Process 3810742: ALTER TABLE ir_model_fields ALTER COLUMN website_form_blacklisted SET DEFAULT true Process 3810906: DELETE FROM ir_attachment WHERE id IN (1092596)
Hint: See server log for query details.
Statement: ALTER TABLE ir_model_fields ALTER COLUMN website_form_blacklisted SET DEFAULT trueDate: 2023-03-09 10:30:01
Detail: Process 4021102 waits for ShareLock on transaction 99566146; blocked by process 3820818. Process 3820818 waits for ShareLock on transaction 99565983; blocked by process 4021102. Process 4021102: UPDATE "stock_move" SET "date"='2023-03-09 15:36:05',"state"='done',"write_uid"=1016,"write_date"=(now() at time zone 'UTC') WHERE id IN (292480, 292481, 292482, 292483, 292484, 292485, 292486, 292488, 292489, 292490, 292491, 292493, 292494, 292495, 292496, 292497, 292498, 292499, 292500, 292501, 292502, 292503, 292504, 292505, 292506, 292507, 292508, 292510, 292511, 292512, 292513, 292514, 292515, 292516, 292517, 292518, 292519, 292520, 292521) Process 3820818: UPDATE "product_warehouse_inventory" SET "lead_days"=10,"write_uid"=1019,"write_date"=(now() at time zone 'UTC') WHERE id IN (39221)
Context: while updating tuple (495,9) in relation "product_warehouse_inventory" SQL statement "update product_warehouse_inventory set last_receive_date=Inventory.date , qty_last_receive=Inventory.product_uom_qty where product_id=NEW.product_id and warehouse_id=NEW.warehouse_id" PL/pgSQL function updated_in_last_receive_date_qty() line 10 at SQL statement
Hint: See server log for query details.
Statement: UPDATE "stock_move" SET "date"='2023-03-09 15:36:05',"state"='done',"write_uid"=1016,"write_date"=(now() at time zone 'UTC') WHERE id IN (292480, 292481, 292482, 292483, 292484, 292485, 292486, 292488, 292489, 292490, 292491, 292493, 292494, 292495, 292496, 292497, 292498, 292499, 292500, 292501, 292502, 292503, 292504, 292505, 292506, 292507, 292508, 292510, 292511, 292512, 292513, 292514, 292515, 292516, 292517, 292518, 292519, 292520, 292521)Date: 2023-03-09 15:36:41
Detail: Process 4188687 waits for AccessExclusiveLock on relation 43699 of database 65946; blocked by process 4188507. Process 4188507 waits for RowExclusiveLock on relation 44482 of database 65946; blocked by process 4188687. Process 4188687: ALTER TABLE ir_model_fields ALTER COLUMN website_form_blacklisted SET DEFAULT true Process 4188507: DELETE FROM ir_attachment WHERE id IN (1110192)
Hint: See server log for query details.
Statement: ALTER TABLE ir_model_fields ALTER COLUMN website_form_blacklisted SET DEFAULT trueDate: 2023-03-09 18:41:18
9 7 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 09 14 5 17 1 20 1 - ERROR: process 3820482 still waiting for ExclusiveLock on tuple (8893,11) of relation 42418 of database 65946 after 1000.059 ms
- ERROR: process 3820895 still waiting for ExclusiveLock on tuple (8865,24) of relation 42418 of database 65946 after 1000.076 ms
- ERROR: process 3820415 still waiting for ExclusiveLock on tuple (8865,24) of relation 42418 of database 65946 after 1000.057 ms
Detail: Process holding the lock: 3821077. Wait queue: 3820482.
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 != 469463 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 != 469463 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1 ) RETURNING name;Date: 2023-03-09 14:19:18
Detail: Process holding the lock: 3820913. Wait queue: 3820895.
Statement: UPDATE "account_move" SET "message_main_attachment_id"=1100195,"write_uid"=1043,"write_date"=(now() at time zone 'UTC') WHERE id IN (469462)Date: 2023-03-09 14:19:27
Detail: Process holding the lock: 3820913. Wait queue: 3820895, 3820415.
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 != 469466 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 != 469466 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1 ) RETURNING name;Date: 2023-03-09 14:19:30
10 7 LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #10
Day Hour Count Mar 09 10 2 18 5 - ERROR: process 3810034 still waiting for AccessShareLock on relation 43699 of database 65946 after 1000.042 ms at character 34
- ERROR: process 3810059 still waiting for AccessShareLock on relation 43699 of database 65946 after 1000.032 ms at character 34
- ERROR: process 4188620 still waiting for AccessShareLock on relation 43699 of database 65946 after 1000.042 ms at character 22
Detail: Process holding the lock: 3810742. Wait queue: 3810034.
Statement: SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'res.partner') ORDER BY "ir_model_fields"."name"Date: 2023-03-09 10:30:27
Detail: Process holding the lock: 3810742. Wait queue: 3810034, 3810059, 3810564.
Statement: SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'res.partner') ORDER BY "ir_model_fields"."name"Date: 2023-03-09 10:30:29
Detail: Process holding the lock: 4188687. Wait queue: 4188620, 4188576, 4188490, 4188514, 4188665.
Statement: SELECT name, id FROM ir_model_fields WHERE model='ir.actions.report'Date: 2023-03-09 18:41:32
11 6 ERROR: null value in column "..." of relation "..." violates not-null constraint
Times Reported Most Frequent Error / Event #11
Day Hour Count Mar 09 12 1 16 2 18 3 - ERROR: null value in column "categ_id" of relation "product_template" violates not-null constraint
- ERROR: null value in column "code" of relation "account_account" violates not-null constraint
Detail: Failing row contains (247918, null, 42710558, 1, null, null, null, product, null, 1.00, null, null, t, t, 1, 1, null, t, null, null, null, null, 954, 2023-03-09 12:23:38.962264, 954, 2023-03-09 12:23:38.962264, manual, no-message, null, no, delivery, 0, none, null, null, null, receive, no-message, null, null, no, 0, null, null, null, null, null, null, null, null, f, null, 1, 1, null, 386750, never, 0, , 45, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 2023-03-09, null, E, 1, null, null, f, f, yes, null, 1, null, null, null, null, null, null, null, null, null, none, null, null, null, f, f, null, null, null, f).
Statement: INSERT INTO "product_template" ("id", "create_uid", "create_date", "write_uid", "write_date", "active", "allow_journal", "available_threshold", "branch_id", "categ_id", "core_qty", "custom_message", "expense_policy", "first_active_date", "global_class_code", "inventory_availability", "invoice_policy", "is_core", "is_direct_order_product", "is_mo_product", "is_published", "is_transmission", "linked_with_existing_core", "list_price", "name", "produce_delay", "purchase_line_warn", "purchase_method", "purchase_ok", "sale_delay", "sale_line_warn", "sale_ok", "sequence", "service_form_type", "service_tracking", "service_type", "standard_carton_quanity", "tracking", "type", "uom_id", "uom_po_id", "website_sequence", "website_size_x", "website_size_y") VALUES (nextval('product_template_id_seq'), 954, (now() at time zone 'UTC'), 954, (now() at time zone 'UTC'), true, false, 0.0, 45, NULL, 1, '', 'no', '2023-03-09', 'E', 'never', 'delivery', false, false, false, false, false, 'yes', '1.00', '42710558', 0.0, 'no-message', 'receive', true, 0.0, 'no-message', true, 1, 'none', 'no', 'manual', 1, 'none', 'product', 1, 1, 386750, 1, 1) RETURNING idDate: 2023-03-09 12:23:39
Detail: Failing row contains (1539, 2120, null, null, f, null, null, null, f, null, 1, null, null, f, 1221, 2023-03-09 18:16:04.42685, 1221, 2023-03-09 18:16:04.42685, null, no, f).
Statement: INSERT INTO "account_account" ("id", "create_uid", "create_date", "write_uid", "write_date", "code", "company_id", "create_asset", "deprecated", "is_off_balance", "multiple_assets_per_line", "name", "reconcile") VALUES (nextval('account_account_id_seq'), 1221, (now() at time zone 'UTC'), 1221, (now() at time zone 'UTC'), NULL, 1, 'no', false, false, false, '2120', false) RETURNING idDate: 2023-03-09 18:16:04
12 5 LOG: process ... still waiting for RowExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #12
Day Hour Count Mar 09 10 3 18 2 - ERROR: process 3810732 still waiting for RowExclusiveLock on relation 42418 of database 65946 after 1000.047 ms
- ERROR: process 3810187 still waiting for RowExclusiveLock on relation 42418 of database 65946 after 1000.046 ms
- ERROR: process 3810237 still waiting for RowExclusiveLock on relation 42418 of database 65946 after 1000.042 ms
Detail: Process holding the lock: 3810742. Wait queue: 3810732.
Statement: DELETE FROM ir_attachment WHERE id IN (1092588)Date: 2023-03-09 10:29:41
Detail: Process holding the lock: 3810742. Wait queue: 3810187.
Statement: DELETE FROM ir_attachment WHERE id IN (1092601)Date: 2023-03-09 10:30:10
Detail: Process holding the lock: 3810742. Wait queue: 3810237.
Statement: DELETE FROM ir_attachment WHERE id IN (1092615)Date: 2023-03-09 10:30:41
13 3 ERROR: could not create unique index "..."
Times Reported Most Frequent Error / Event #13
Day Hour Count Mar 09 10 3 - ERROR: could not create unique index "vendor_account_master_unique_acc_no"
Detail: Key (account_number)=(P10394) is duplicated.
Statement: ALTER TABLE "vendor_account_master" ADD CONSTRAINT "vendor_account_master_unique_acc_no" unique (account_number)Date: 2023-03-09 10:29:40
14 3 ERROR: update or delete on table "..." violates foreign key constraint "..." on table "..."
Times Reported Most Frequent Error / Event #14
Day Hour Count Mar 09 15 3 - ERROR: update or delete on table "stock_production_lot" violates foreign key constraint "stock_quant_lot_id_fkey" on table "stock_quant"
Detail: Key (id)=(419) is still referenced from table "stock_quant".
Statement: DELETE FROM stock_production_lot WHERE id IN (419)Date: 2023-03-09 15:35:58
15 2 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #15
Day Hour Count Mar 09 12 1 15 1 - ERROR: column "standard_price" does not exist at character 66
- ERROR: column p.is_move_sent does not exist at character 152
Statement: select count(id) from product_template where has_core = True and standard_price != base_part_cost;
Date: 2023-03-09 12:14:02
Statement: select distinct(batch.id) from account_batch_payment batch inner join account_payment p on p.batch_payment_id = batch.id where batch.state = 'new' and p.is_move_sent= True and p.batch_payment_id is not null;
Date: 2023-03-09 15:06:44
16 2 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #16
Day Hour Count Mar 09 10 1 18 1 - ERROR: could not receive data from client: Connection reset by peer
Date: 2023-03-09 10:27:48
17 2 ERROR: missing FROM-clause entry for table "..."
Times Reported Most Frequent Error / Event #17
Day Hour Count Mar 09 06 2 - ERROR: missing FROM-clause entry for table "m" at character 56
Statement: select mv.id,mv.name,left(mv.name,1),b.prefix,mv.state,m.direct_order from account_move mv inner join res_branch b on b.id = mv.branch_id where left(mv.name,1) != b.prefix and mv.name !='/' and mv.name not ilike 'STJ%' and mv.move_type !='entry';
Date: 2023-03-09 06:35:37
18 1 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #18
Day Hour Count Mar 09 14 1 - FATAL: connection to client lost
Statement: COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage) TO stdout;
Date: 2023-03-09 14:33:45
19 1 LOG: could not send data to client: Connection reset by peer
Times Reported Most Frequent Error / Event #19
Day Hour Count Mar 09 14 1 - ERROR: could not send data to client: Connection reset by peer
Statement: COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage) TO stdout;
Date: 2023-03-09 14:33:45
20 1 ERROR: duplicate key value violates unique constraint "..."
Times Reported Most Frequent Error / Event #20
Day Hour Count Mar 09 14 1 - ERROR: duplicate key value violates unique constraint "fleet_vehicle_vehicle_unit_no_driver_id_unique"
Detail: Key (vehicle_unit_no, driver_id)=(729, 34094) already exists.
Statement: INSERT INTO "fleet_vehicle" ("id", "create_uid", "create_date", "write_uid", "write_date", "acquisition_date", "active", "brand_id", "car_value", "co2", "color", "company_id", "description", "doors", "driver_id", "first_contract_date", "fuel_type", "future_driver_id", "horsepower", "horsepower_tax", "license_plate", "location", "manager_id", "model_id", "model_vehicle_type", "model_year", "name", "net_car_value", "next_assignation_date", "odometer_unit", "power", "residual_value", "seats", "state_id", "transmission", "vehicle_unit_no", "vin_sn") VALUES (nextval('fleet_vehicle_id_seq'), 978, (now() at time zone 'UTC'), 978, (now() at time zone 'UTC'), '2023-03-09', true, 105, 0.0, 0.0, NULL, 1, NULL, 5, 34094, '2023-03-09', NULL, NULL, 0, 0.0, NULL, NULL, 2, 234, 28, NULL, 'F', 0.0, NULL, 'miles', 0, 0.0, 0, 3, NULL, '729', '2EA40729') RETURNING idDate: 2023-03-09 14:02:22