-
Global information
- Generated on Tue May 30 23:50:31 2023
- Log file: /var/log/postgresql/postgresql-14-main.log
- Parsed 62,011 log entries in 30s
- Log start from 2023-05-29 00:00:04 to 2023-05-29 23:59:34
-
Overview
Global Stats
- 317 Number of unique normalized queries
- 19,858 Number of queries
- 1h9m33s Total query duration
- 2023-05-29 00:00:04 First query
- 2023-05-29 23:59:34 Last query
- 16 queries/s at 2023-05-29 14:52:24 Query peak
- 1h9m33s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 1h9m33s Execute total duration
- 4,040 Number of events
- 14 Number of unique normalized events
- 3,209 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
- 19,858 Average queries per session
- 1h9m33s 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
- 16 queries/s Query Peak
- 2023-05-29 14:52:24 Date
SELECT Traffic
Key values
- 16 queries/s Query Peak
- 2023-05-29 14:52:24 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2023-05-29 23:56:31 Date
Queries duration
Key values
- 1h9m33s 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
Day Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 29 00 1,777 121ms 280ms 172ms 6s787ms 7s225ms 7s819ms 01 1,137 0ms 241ms 172ms 6s331ms 7s117ms 7s524ms 02 933 0ms 232ms 170ms 7s934ms 8s194ms 8s589ms 03 1,023 0ms 276ms 172ms 8s571ms 9s4ms 9s795ms 04 830 120ms 873ms 173ms 6s267ms 7s284ms 7s352ms 05 1,826 121ms 17s546ms 204ms 8s911ms 13s483ms 35s764ms 06 1,706 120ms 1s928ms 176ms 6s198ms 7s303ms 15s234ms 07 1,743 120ms 1s95ms 171ms 6s823ms 7s626ms 10s423ms 08 1,156 0ms 251ms 169ms 6s942ms 8s94ms 9s205ms 09 1,788 120ms 3m39s 449ms 42s600ms 1m7s 4m2s 10 1,214 0ms 1s444ms 176ms 6s711ms 7s504ms 7s927ms 11 977 0ms 8s5ms 222ms 6s884ms 15s335ms 18s607ms 12 1,623 120ms 260ms 170ms 6s133ms 6s550ms 6s853ms 13 966 0ms 2s237ms 209ms 6s100ms 6s822ms 8s668ms 14 95 0ms 8s399ms 431ms 6s743ms 8s580ms 8s580ms 15 147 0ms 4s434ms 342ms 7s56ms 7s527ms 9s48ms 16 29 0ms 195ms 158ms 967ms 1s45ms 1s45ms 17 16 0ms 175ms 152ms 912ms 912ms 912ms 18 76 0ms 787ms 313ms 1s23ms 16s582ms 16s582ms 19 54 0ms 201ms 151ms 1s25ms 1s93ms 1s93ms 20 37 0ms 181ms 150ms 781ms 785ms 785ms 21 18 0ms 175ms 147ms 738ms 738ms 738ms 22 98 0ms 234ms 146ms 2s460ms 2s789ms 2s789ms 23 589 0ms 2s540ms 261ms 12s391ms 14s336ms 15s338ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 29 00 1,777 0 172ms 6s440ms 6s787ms 7s811ms 01 1,137 0 172ms 6s105ms 6s331ms 7s524ms 02 933 0 170ms 7s263ms 7s934ms 8s589ms 03 1,023 0 172ms 7s593ms 8s571ms 9s795ms 04 828 0 172ms 5s819ms 6s267ms 7s352ms 05 1,820 0 195ms 6s794ms 8s911ms 13s937ms 06 1,706 0 176ms 5s695ms 6s198ms 7s829ms 07 1,741 0 170ms 6s203ms 6s823ms 9s215ms 08 1,156 0 169ms 6s90ms 6s942ms 9s205ms 09 1,720 68 449ms 8s229ms 34s487ms 1m7s 10 1,212 0 176ms 5s803ms 6s711ms 7s927ms 11 955 0 202ms 5s645ms 6s728ms 16s975ms 12 1,623 0 170ms 5s722ms 6s133ms 6s554ms 13 959 0 209ms 5s616ms 6s100ms 7s126ms 14 90 0 443ms 4s403ms 6s585ms 8s580ms 15 145 0 332ms 2s136ms 7s56ms 9s48ms 16 29 0 158ms 892ms 967ms 1s45ms 17 16 0 152ms 779ms 912ms 912ms 18 76 0 313ms 920ms 1s23ms 16s582ms 19 54 0 151ms 999ms 1s25ms 1s93ms 20 37 0 150ms 768ms 781ms 785ms 21 18 0 147ms 734ms 738ms 738ms 22 98 0 146ms 2s224ms 2s460ms 2s789ms 23 551 0 255ms 8s71ms 12s391ms 15s338ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 29 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 2 0 0 339ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 2 0 1s87ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 11 0 1s940ms 0ms 0ms 8s412ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 7 0 0 314ms 0ms 0ms 410ms 14 0 5 0 0 216ms 0ms 155ms 463ms 15 0 0 2 0 1s117ms 0ms 0ms 2s235ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 33 5 0 354ms 0ms 270ms 2s756ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare May 29 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second May 29 00 0 0.00/s 01 0 0.00/s 02 0 0.00/s 03 0 0.00/s 04 0 0.00/s 05 0 0.00/s 06 0 0.00/s 07 0 0.00/s 08 0 0.00/s 09 0 0.00/s 10 0 0.00/s 11 0 0.00/s 12 0 0.00/s 13 0 0.00/s 14 0 0.00/s 15 0 0.00/s 16 0 0.00/s 17 0 0.00/s 18 0 0.00/s 19 0 0.00/s 20 0 0.00/s 21 0 0.00/s 22 0 0.00/s 23 0 0.00/s Day Hour Count Average Duration Average idle time May 29 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
Day Hour Written buffers Write time Sync time Total time May 29 00 0 0s 0s 0s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 0 0s 0s 0s 04 0 0s 0s 0s 05 0 0s 0s 0s 06 0 0s 0s 0s 07 0 0s 0s 0s 08 0 0s 0s 0s 09 0 0s 0s 0s 10 0 0s 0s 0s 11 0 0s 0s 0s 12 0 0s 0s 0s 13 0 0s 0s 0s 14 0 0s 0s 0s 15 0 0s 0s 0s 16 0 0s 0s 0s 17 0 0s 0s 0s 18 0 0s 0s 0s 19 0 0s 0s 0s 20 0 0s 0s 0s 21 0 0s 0s 0s 22 0 0s 0s 0s 23 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 29 00 0 0 0 0 0s 0s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 0 0 0s 0s 04 0 0 0 0 0s 0s 05 0 0 0 0 0s 0s 06 0 0 0 0 0s 0s 07 0 0 0 0 0s 0s 08 0 0 0 0 0s 0s 09 0 0 0 0 0s 0s 10 0 0 0 0 0s 0s 11 0 0 0 0 0s 0s 12 0 0 0 0 0s 0s 13 0 0 0 0 0s 0s 14 0 0 0 0 0s 0s 15 0 0 0 0 0s 0s 16 0 0 0 0 0s 0s 17 0 0 0 0 0s 0s 18 0 0 0 0 0s 0s 19 0 0 0 0 0s 0s 20 0 0 0 0 0s 0s 21 0 0 0 0 0s 0s 22 0 0 0 0 0s 0s 23 0 0 0 0 0s 0s Day Hour Count Avg time (sec) May 29 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate May 29 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
Day Hour Count Total size Average size May 29 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
Day Hour VACUUMs ANALYZEs May 29 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
- AccessShareLock Main Lock Type
- 13 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 7 19s773ms 1s444ms 4s64ms 2s824ms select "ir_model_fields".id from "ir_model_fields" where ("ir_model_fields"."model" = ?) order by "ir_model_fields"."name";-
SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.template') ORDER BY "ir_model_fields"."name";
Date: 2023-05-29 11:22:07
-
SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.template') ORDER BY "ir_model_fields"."name";
Date: 2023-05-29 11:23:50
-
SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.template') ORDER BY "ir_model_fields"."name";
Date: 2023-05-29 11:22:07
2 4 18s517ms 1s857ms 7s987ms 4s629ms delete from ir_attachment where id in ( select id from ir_attachment where id in (...) for no key update skip locked);-
DELETE FROM ir_attachment WHERE id IN ( SELECT id FROM ir_attachment WHERE id in (2771992) FOR NO KEY UPDATE SKIP LOCKED);
Date: 2023-05-29 11:23:36
-
DELETE FROM ir_attachment WHERE id IN ( SELECT id FROM ir_attachment WHERE id in (2771886) FOR NO KEY UPDATE SKIP LOCKED);
Date: 2023-05-29 11:17:02
-
DELETE FROM ir_attachment WHERE id IN ( SELECT id FROM ir_attachment WHERE id in (2771974) FOR NO KEY UPDATE SKIP LOCKED);
Date: 2023-05-29 11:21:53
3 1 3s196ms 3s196ms 3s196ms 3s196ms 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 = '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-05-29 11:22:07
-
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-05-29 11:22:07
-
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-05-29 11:22:07
4 1 1s533ms 1s533ms 1s533ms 1s533ms update ir_module_module set state = ? where state in (...);-
UPDATE ir_module_module SET state = 'installed' WHERE state IN ('to remove', 'to upgrade');
Date: 2023-05-29 11:22:20
Queries that waited the most
Rank Wait time Query 1 7s987ms DELETE FROM ir_attachment WHERE id IN ( SELECT id FROM ir_attachment WHERE id in (2771992) FOR NO KEY UPDATE SKIP LOCKED);[ Date: 2023-05-29 11:23:36 ]
2 6s200ms DELETE FROM ir_attachment WHERE id IN ( SELECT id FROM ir_attachment WHERE id in (2771886) FOR NO KEY UPDATE SKIP LOCKED);[ Date: 2023-05-29 11:17:02 ]
3 4s64ms SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.template') ORDER BY "ir_model_fields"."name";[ Date: 2023-05-29 11:22:07 ]
4 3s900ms SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.template') ORDER BY "ir_model_fields"."name";[ Date: 2023-05-29 11:23:50 ]
5 3s196ms 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-05-29 11:22:07 ]
6 3s6ms SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.template') ORDER BY "ir_model_fields"."name";[ Date: 2023-05-29 11:22:07 ]
7 2s736ms SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.template') ORDER BY "ir_model_fields"."name";[ Date: 2023-05-29 11:22:07 ]
8 2s471ms DELETE FROM ir_attachment WHERE id IN ( SELECT id FROM ir_attachment WHERE id in (2771974) FOR NO KEY UPDATE SKIP LOCKED);[ Date: 2023-05-29 11:21:53 ]
9 2s466ms SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.template') ORDER BY "ir_model_fields"."name";[ Date: 2023-05-29 11:17:17 ]
10 2s155ms SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'psd_custom.inventory_vendor') ORDER BY "ir_model_fields"."name";[ Date: 2023-05-29 11:17:17 ]
11 1s857ms DELETE FROM ir_attachment WHERE id IN ( SELECT id FROM ir_attachment WHERE id in (2771975) FOR NO KEY UPDATE SKIP LOCKED);[ Date: 2023-05-29 11:21:58 ]
12 1s533ms UPDATE ir_module_module SET state = 'installed' WHERE state IN ('to remove', 'to upgrade');[ Date: 2023-05-29 11:22:20 ]
13 1s444ms SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.template') ORDER BY "ir_model_fields"."name";[ Date: 2023-05-29 10:58:32 ]
-
Queries
Queries by type
Key values
- 19,704 Total read queries
- 154 Total write queries
Queries by database
Key values
- unknown Main database
- 19,858 Requests
- 1h9m33s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 20,149 Requests
User Request type Count Duration unknown Total 20,149 1h10m23s copy to 68 8m23s cte 14 20s470ms ddl 5 1s972ms delete 20 30s751ms select 19,995 1h54s update 47 12s433ms Duration by user
Key values
- 1h10m23s (unknown) Main time consuming user
User Request type Count Duration unknown Total 20,149 1h10m23s copy to 68 8m23s cte 14 20s470ms ddl 5 1s972ms delete 20 30s751ms select 19,995 1h54s update 47 12s433ms Queries by host
Key values
- unknown Main host
- 20,149 Requests
- 1h10m23s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 19,858 Requests
- 1h9m33s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2023-05-29 09:51:02 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 19,590 100-500ms duration
Slowest individual queries
Rank Duration Query 1 3m39s COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2023-05-29 09:06:42 ]
2 1m7s COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;[ Date: 2023-05-29 09:03:02 ]
3 1m4s COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;[ Date: 2023-05-29 09:01:52 ]
4 21s477ms COPY public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) TO stdout;[ Date: 2023-05-29 09:08:30 ]
5 21s81ms COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage) TO stdout;[ Date: 2023-05-29 09:07:39 ]
6 17s546ms with data as ( select distinct shl.id as record, 3658, shl.id as ref, 'Sales History' as ref_code, shl.product_id as product_id, shl.invoice_date as invoice_date, shl.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, shl.selling_branch as selling_branch, st.id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from sale_history_line as shl LEFT JOIN stock_warehouse as st ON st.branch_id = shl.selling_branch LEFT JOIN product_product as pp ON pp.id = shl.product_id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id where shl.selling_branch = 45 and shl.sales_obtain != 'direct' and shl.product_id is not null and shl.exception_sale IS NOT TRUE and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and shl.invoice_date >= '2017-05-29 09:29:11' and shl.invoice_date <= '2023-05-29 09:29:11' and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127, 3150) and pt.inventory_vendor_id in (2952) and pp.id in (213570) and pp.id not in (173262, 173641, 203690, 248601, 197227, 248600, 197276, 177378, 177880, 177884, 177882, 173212, 203223, 213290, 177891, 202435, 246006, 211212, 202687, 177894, 177886, 177893, 228248, 179147, 205525, 180400, 239522, 190908, 208958, 206627, 184051, 177878, 177908, 190525, 197274, 177949, 208957, 173230, 180730, 177896, 177743, 210626, 211219, 173229, 184510, 228263, 184439, 190593, 184001, 174022, 181017, 203231, 177853, 177876, 185902, 180735, 211229, 177917, 177924, 192883, 177927, 177926, 239420, 177923, 197267, 179148, 177861, 218905, 190531, 192957, 199642, 185145, 177948, 211201, 179986, 211206, 177890, 211207, 172767, 180822, 180397, 174026, 177885, 174246, 239405, 180879, 206638, 203681, 177900, 172689, 177892, 177872, 177887, 211202, 197240, 177068, 177947, 211220, 177873, 177899, 226991, 174233, 211233, 203674, 177922, 177901, 172796, 219122, 172835) UNION ALL ( select distinct sol.id as record, 3658, so.id as ref, 'Sale Order' as ref_code, sol.product_id as product_id, am.invoice_date as invoice_date, sol.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, so.branch_id as selling_branch, so.warehouse_id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from sale_order_line sol LEFT JOIN product_product as pp ON sol.product_id = pp.id LEFT JOIN product_template as pt ON pp.product_tmpl_id = pt.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id LEFT JOIN sale_order as so ON sol.order_id = so.id LEFT JOIN sale_order_line_invoice_rel as solrel ON solrel.order_line_id = sol.id LEFT JOIN account_move_line as aml ON aml.id = solrel.invoice_line_id LEFT JOIN account_move as am ON am.id = aml.move_id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id where sol.branch_id = 45 and sol.product_id is not null and sol.exception_sale IS NOT TRUE and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and am.invoice_date >= '2017-05-29 09:29:11' and am.invoice_date <= '2023-05-29 09:29:11' and so.state in ('done', 'sale') and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127, 3150) and pt.inventory_vendor_id in (2952) and pp.id in (213570) and pp.id not in (173262, 173641, 203690, 248601, 197227, 248600, 197276, 177378, 177880, 177884, 177882, 173212, 203223, 213290, 177891, 202435, 246006, 211212, 202687, 177894, 177886, 177893, 228248, 179147, 205525, 180400, 239522, 190908, 208958, 206627, 184051, 177878, 177908, 190525, 197274, 177949, 208957, 173230, 180730, 177896, 177743, 210626, 211219, 173229, 184510, 228263, 184439, 190593, 184001, 174022, 181017, 203231, 177853, 177876, 185902, 180735, 211229, 177917, 177924, 192883, 177927, 177926, 239420, 177923, 197267, 179148, 177861, 218905, 190531, 192957, 199642, 185145, 177948, 211201, 179986, 211206, 177890, 211207, 172767, 180822, 180397, 174026, 177885, 174246, 239405, 180879, 206638, 203681, 177900, 172689, 177892, 177872, 177887, 211202, 197240, 177068, 177947, 211220, 177873, 177899, 226991, 174233, 211233, 203674, 177922, 177901, 172796, 219122, 172835)) UNION ALL ( select distinct sol.id as record, 3658, so.id as ref, 'Sale Order' as ref_code, sol.product_id as product_id, so.date_order as invoice_date, sol.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, so.branch_id as selling_branch, so.warehouse_id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from sale_order_line sol LEFT JOIN product_product as pp ON sol.product_id = pp.id LEFT JOIN product_template as pt ON pp.product_tmpl_id = pt.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id LEFT JOIN sale_order as so ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id where sol.branch_id = 45 and sol.product_id is not null and sol.exception_sale IS NOT TRUE and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and so.date_order >= '2017-05-29 09:29:11' and so.date_order <= '2023-05-29 09:29:11' and so.state in ('permanent_order') and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127, 3150) and pt.inventory_vendor_id in (2952) and pp.id in (213570) and pp.id not in (173262, 173641, 203690, 248601, 197227, 248600, 197276, 177378, 177880, 177884, 177882, 173212, 203223, 213290, 177891, 202435, 246006, 211212, 202687, 177894, 177886, 177893, 228248, 179147, 205525, 180400, 239522, 190908, 208958, 206627, 184051, 177878, 177908, 190525, 197274, 177949, 208957, 173230, 180730, 177896, 177743, 210626, 211219, 173229, 184510, 228263, 184439, 190593, 184001, 174022, 181017, 203231, 177853, 177876, 185902, 180735, 211229, 177917, 177924, 192883, 177927, 177926, 239420, 177923, 197267, 179148, 177861, 218905, 190531, 192957, 199642, 185145, 177948, 211201, 179986, 211206, 177890, 211207, 172767, 180822, 180397, 174026, 177885, 174246, 239405, 180879, 206638, 203681, 177900, 172689, 177892, 177872, 177887, 211202, 197240, 177068, 177947, 211220, 177873, 177899, 226991, 174233, 211233, 203674, 177922, 177901, 172796, 219122, 172835)) UNION ALL ( select distinct rol.id as record, 3658, ro.id as ref, 'Repair Orders' as ref_code, rol.product_id as product_id, ro.create_date as invoice_date, rol.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, ro.branch_id as selling_branch, ro.warehouse_id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from repair_order ro LEFT JOIN repair_line as rol ON ro.id = rol.repair_id LEFT JOIN product_product as pp ON rol.product_id = pp.id LEFT JOIN product_template as pt ON pp.product_tmpl_id = pt.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id where ro.state = 'done' and ro.branch_id = 45 and rol.product_id is not null and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and ro.create_date >= '2017-05-29 09:29:11' and ro.create_date <= '2023-05-29 09:29:11' and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127, 3150) and pt.inventory_vendor_id in (2952) and pp.id in (213570) and pp.id not in (173262, 173641, 203690, 248601, 197227, 248600, 197276, 177378, 177880, 177884, 177882, 173212, 203223, 213290, 177891, 202435, 246006, 211212, 202687, 177894, 177886, 177893, 228248, 179147, 205525, 180400, 239522, 190908, 208958, 206627, 184051, 177878, 177908, 190525, 197274, 177949, 208957, 173230, 180730, 177896, 177743, 210626, 211219, 173229, 184510, 228263, 184439, 190593, 184001, 174022, 181017, 203231, 177853, 177876, 185902, 180735, 211229, 177917, 177924, 192883, 177927, 177926, 239420, 177923, 197267, 179148, 177861, 218905, 190531, 192957, 199642, 185145, 177948, 211201, 179986, 211206, 177890, 211207, 172767, 180822, 180397, 174026, 177885, 174246, 239405, 180879, 206638, 203681, 177900, 172689, 177892, 177872, 177887, 211202, 197240, 177068, 177947, 211220, 177873, 177899, 226991, 174233, 211233, 203674, 177922, 177901, 172796, 219122, 172835)) UNION ALL ( select distinct sm.id as record, 3658, mrp.id as ref, 'Manufacturing Orders' as ref_code, sm.product_id as product_id, mrp.create_date as invoice_date, sm.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, mrp.branch_id as selling_branch, sm.warehouse_id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from mrp_production mrp LEFT JOIN stock_move as sm ON sm.raw_material_production_id = mrp.id LEFT JOIN product_product as pp ON sm.product_id = pp.id LEFT JOIN product_template as pt ON pp.product_tmpl_id = pt.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id where mrp.state = 'done' and mrp.branch_id = 45 and sm.product_id is not null and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and mrp.create_date >= '2017-05-29 09:29:11' and mrp.create_date <= '2023-05-29 09:29:11' and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127, 3150) and pt.inventory_vendor_id in (2952) and pp.id in (213570) and pp.id not in (173262, 173641, 203690, 248601, 197227, 248600, 197276, 177378, 177880, 177884, 177882, 173212, 203223, 213290, 177891, 202435, 246006, 211212, 202687, 177894, 177886, 177893, 228248, 179147, 205525, 180400, 239522, 190908, 208958, 206627, 184051, 177878, 177908, 190525, 197274, 177949, 208957, 173230, 180730, 177896, 177743, 210626, 211219, 173229, 184510, 228263, 184439, 190593, 184001, 174022, 181017, 203231, 177853, 177876, 185902, 180735, 211229, 177917, 177924, 192883, 177927, 177926, 239420, 177923, 197267, 179148, 177861, 218905, 190531, 192957, 199642, 185145, 177948, 211201, 179986, 211206, 177890, 211207, 172767, 180822, 180397, 174026, 177885, 174246, 239405, 180879, 206638, 203681, 177900, 172689, 177892, 177872, 177887, 211202, 197240, 177068, 177947, 211220, 177873, 177899, 226991, 174233, 211233, 203674, 177922, 177901, 172796, 219122, 172835))) insert into item_list_line (item_demand_plan_id, product_id, invoice_date, product_uom_qty, inventory_vendor_id, selling_branch, warehouse_id, method, ref_id, ref, create_date, active) ( select 3658, data.product_id as product_id, data.invoice_date as invoice_date, data.product_uom_qty as product_uom_qty, data.inventory_vendor_id as inventory_vendor_id, data.selling_branch as selling_branch, data.warehouse_id as warehouse_id, brpm.method as method, data.ref as ref_id, data.ref_code as ref, now() at time zone 'UTC', True from data LEFT JOIN branch_product_method as brpm ON brpm.product_id = data.product_id and brpm.branch_id = 45);[ Date: 2023-05-29 05:33:13 ]
7 13s10ms COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;[ Date: 2023-05-29 09:08:09 ]
8 12s649ms COPY public.account_move_line (id, move_id, move_name, date, ref, parent_state, journal_id, company_id, company_currency_id, account_id, account_root_id, sequence, name, quantity, price_unit, discount, debit, credit, balance, amount_currency, price_subtotal, price_total, reconciled, blocked, date_maturity, currency_id, partner_id, product_uom_id, product_id, reconcile_model_id, payment_id, statement_line_id, statement_id, tax_line_id, tax_group_id, tax_base_amount, tax_exigible, tax_repartition_line_id, tax_audit, amount_residual, amount_residual_currency, full_reconcile_id, matching_number, analytic_account_id, display_type, is_rounding_line, exclude_from_invoice_tab, create_uid, create_date, write_uid, write_date, expected_pay_date, internal_note, next_action_date, followup_line_id, followup_date, is_anglo_saxon_line, purchase_line_id, branch_id, branch_name, vehicle_id, move_options, sign_product_qty, sign_price_subtotal, new_product_qty, sale_line_id, child_sale_line_id, main_invoice_line_id, core_bank_transaction, is_rtv_line, core_qty, rebate_amount, cost_price, is_visible_in_report, is_labour, can_be_paid, bal_core_bank_id, repair_line_id, inv_back_order_qty, sale_back_order_qty, product_pricelist_item_id) TO stdout;[ Date: 2023-05-29 09:00:22 ]
9 9s109ms COPY public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2023-05-29 09:00:33 ]
10 8s399ms SELECT "account_move_line".id FROM "account_move_line" WHERE (((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line"."parent_state" != 'cancel') OR "account_move_line"."parent_state" IS NULL)) AND (("account_move_line"."parent_state" = 'posted') AND ((((unaccent ("account_move_line"."name"::text) ilike unaccent ('%V-BILL-00773%')) OR (unaccent ("account_move_line"."ref"::text) ilike unaccent ('%V-BILL-00773%'))) OR ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" LEFT JOIN "res_company" AS "account_account__company_id" ON ("account_account"."company_id" = "account_account__company_id"."id") WHERE ((unaccent ("account_account"."code"::text) ilike unaccent ('V-BILL-00773%')) OR (unaccent ("account_account"."name"::text) ilike unaccent ('%V-BILL-00773%'))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1)))))) OR FALSE))) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) ORDER BY "account_move_line"."date" DESC, "account_move_line"."move_name" DESC, "account_move_line"."id", "account_move_line"."id" LIMIT 80;[ Date: 2023-05-29 14:42:18 ]
11 8s5ms DELETE FROM ir_attachment WHERE id IN ( SELECT id FROM ir_attachment WHERE id in (2771992) FOR NO KEY UPDATE SKIP LOCKED);[ Date: 2023-05-29 11:23:36 ]
12 6s224ms DELETE FROM ir_attachment WHERE id IN ( SELECT id FROM ir_attachment WHERE id in (2771886) FOR NO KEY UPDATE SKIP LOCKED);[ Date: 2023-05-29 11:17:02 ]
13 5s240ms COPY public.account_move (id, access_token, message_main_attachment_id, name, date, ref, narration, state, posted_before, move_type, to_check, journal_id, company_id, currency_id, partner_id, commercial_partner_id, is_move_sent, partner_bank_id, payment_reference, payment_id, statement_line_id, amount_untaxed, amount_tax, amount_total, amount_residual, amount_untaxed_signed, amount_tax_signed, amount_total_signed, amount_residual_signed, payment_state, tax_cash_basis_rec_id, tax_cash_basis_move_id, auto_post, reversed_entry_id, fiscal_position_id, invoice_user_id, invoice_date, invoice_date_due, invoice_origin, invoice_payment_term_id, invoice_incoterm_id, qr_code_method, invoice_source_email, invoice_partner_display_name, invoice_cash_rounding_id, secure_sequence_number, inalterable_hash, sequence_prefix, sequence_number, create_uid, create_date, write_uid, write_date, payment_state_before_switch, duplicated_vendor_ref, extract_state, extract_status_code, extract_remote_id, transfer_model_id, tax_closing_end_date, tax_report_control_error, asset_id, asset_remaining_value, asset_depreciated_value, asset_manually_modified, asset_value_change, campaign_id, source_id, medium_id, team_id, partner_shipping_id, stock_move_id, preferred_payment_method_id, website_id, branch_id, branch_name, invoice_action, sign_amount_total, sign_amount_residual, sign_amount_untaxed, invoice_part_id, invoice_product_qty, balance_entry, to_check_negative, non_inventory_entry, direct_order, warranty_invoice, email_send_eod, email_sent, order_type, carrier_id, release_to_pay, release_to_pay_manual, force_release_to_pay, invoice_origin_new, debit_origin_id, paid_by_vc, payment_details, expense_choice, edi_810_id, cash_tendered, change_amount, sequence_generated, open_invoice, edi_split_lock, edi_billed, is_edi_bill, payment_details_compute, edi_done_date) TO stdout;[ Date: 2023-05-29 09:00:09 ]
14 4s660ms COPY public.product_library (id, price_sheet_control_id, inventory_vendor_id, vendor_short_name, part_type_id, part_type_option, default_code, name, description_sale, description, condensed_product_name, manufacturer_product_name, weight, uom_id, standard_price, current_cost, rebate_cost, purchase_cost, list_price, better, best, list_jobber, core_part_no, cores_per_part, core_cost, core_price_part_dmg_1, core_price_part_dmg_2, used_core_description, man_cost_update, call_for_prise, product_update_date, standard_carton_quantity, additional_description_sale, active, volume, is_exception, create_uid, create_date, write_uid, write_date, library_duplicate_check) TO stdout;[ Date: 2023-05-29 09:06:53 ]
15 4s434ms SELECT count(1) FROM "mail_tracking_value" WHERE TRUE;[ Date: 2023-05-29 15:31:56 ]
16 4s65ms SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.template') ORDER BY "ir_model_fields"."name";[ Date: 2023-05-29 11:22:07 ]
17 3s901ms SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.template') ORDER BY "ir_model_fields"."name";[ Date: 2023-05-29 11:23:50 ]
18 3s899ms COPY public.price_sheet (id, price_sheet_control_id, inventory_vendor_id, vendor_short_name, part_type_id, part_type_option, default_code, name, description_sale, description, additional_description_sale, condensed_product_name, manufacturer_product_name, weight, uom_id, standard_price, current_cost, rebate_cost, purchase_cost, list_price, better, best, list_jobber, core_part_no, cores_per_part, core_cost, core_price_part_dmg_1, core_price_part_dmg_2, used_core_description, man_cost_update, call_for_prise, product_update_date, standard_carton_quantity, active, volume, is_exception, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2023-05-29 09:06:46 ]
19 3s634ms COPY public.forecasted_data (id, date, min_product_uom_qty, max_product_uom_qty, item_supply_plan_id, po_qty, 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, default_code, ext_cost, qty_available, qty_reserve, qty_on_order, qty_on_perm_order, qty_mtd_sold, lead_days, mon_1_qty, mon_2_qty, mon_3_qty, mon_4_qty, mon_5_qty, mon_6_qty, mon_7_qty, mon_8_qty, mon_9_qty, mon_10_qty, mon_11_qty, mon_12_qty, seasonal, stocking_flag, freeze_date, warehouse_min_product_uom_qty, is_forcast, modify_qty, req_po_qty, supercede_product_id, superceded, final_branch_id, po_id, unit_ext_cost, is_freeze, qty_in_transist, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, is_new_stock_product, ref_id, ref, product_name, is_stock_flag_product) TO stdout;[ Date: 2023-05-29 09:00:43 ]
20 3s387ms COPY public.stock_move (id, name, sequence, priority, create_date, date, date_deadline, company_id, product_id, description_picking, product_qty, product_uom_qty, product_uom, location_id, location_dest_id, partner_id, picking_id, note, state, price_unit, origin, procure_method, scrapped, group_id, rule_id, propagate_cancel, delay_alert_date, picking_type_id, inventory_id, origin_returned_move_id, restrict_partner_id, warehouse_id, additional, reference, package_level_id, next_serial, next_serial_count, orderpoint_id, create_uid, write_uid, write_date, to_refund, sale_line_id, purchase_line_id, created_purchase_line_id, is_done, created_production_id, production_id, raw_material_production_id, unbuild_id, consume_unbuild_id, operation_id, workorder_id, bom_line_id, byproduct_id, unit_factor, branch_id, weight, move_options, related_core_sale_line_id, related_core_purchase_line_id, sm_line_id, core_qty, bom_action, mrp_core_move, repair_id, repair_line_id, related_core_repair_line_id, related_bom_line_id, mrp_finish_core_move, picking_code, transfer_line_id, src_warehouse_id, dest_warehouse_id, current_warehouse_qty) TO stdout;[ Date: 2023-05-29 09:07:48 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 48m44s 16,870 165ms 347ms 173ms 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 #1
Day Hour Count Duration Avg duration May 29 00 1,677 4m51s 173ms 01 1,069 3m6s 174ms 02 819 2m22s 173ms 03 852 2m27s 173ms 04 699 2m 172ms 05 1,607 4m39s 173ms 06 1,583 4m33s 173ms 07 1,544 4m26s 172ms 08 1,007 2m53s 172ms 09 1,400 4m3s 174ms 10 1,154 3m20s 174ms 11 778 2m15s 173ms 12 1,495 4m17s 172ms 13 831 2m23s 172ms 22 9 1s540ms 171ms 23 346 59s792ms 172ms -
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_frontend.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-be84169/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-05-29 05:32:52 Duration: 347ms
-
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_frontend_lazy.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-755b6ac/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-05-29 05:32:52 Duration: 347ms
-
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_frontend_lazy.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-755b6ac/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-05-29 05:32:52 Duration: 327ms
2 3m39s 1 3m39s 3m39s 3m39s copy public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 29 09 1 3m39s 3m39s -
COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2023-05-29 09:06:42 Duration: 3m39s
3 2m31s 1,029 120ms 390ms 147ms select count(distinct (so.id)) as total_orders from sale_order as so left join sale_order_line as sol on sol.order_id = so.id left join product_warehouse_inventory as pwi on pwi.product_id = sol.product_id left join stock_warehouse as sw on sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= ?::timestamp and so.date_order <= ?::timestamp and sol.product_id = ? and so.state in (...) and so.warehouse_id = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 29 00 76 11s211ms 147ms 01 58 8s30ms 138ms 02 89 13s71ms 146ms 03 105 15s38ms 143ms 04 84 12s658ms 150ms 05 77 11s421ms 148ms 06 80 11s411ms 142ms 07 128 20s408ms 159ms 08 104 15s210ms 146ms 09 78 11s832ms 151ms 22 70 9s886ms 141ms 23 80 11s128ms 139ms -
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-11-29T09:30:04.362896'::timestamp and so.date_order <= '2023-05-29T09:30:04.362896'::timestamp and sol.product_id = 238580 and so.state in ('done', 'sale') and so.warehouse_id = 43;
Date: 2023-05-29 09:34:44 Duration: 390ms
-
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-11-29T07:30:23.641022'::timestamp and so.date_order <= '2023-05-29T07:30:23.641022'::timestamp and sol.product_id = 184219 and so.state in ('done', 'sale') and so.warehouse_id = 35;
Date: 2023-05-29 07:32:12 Duration: 325ms
-
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-11-29T07:30:23.641022'::timestamp and so.date_order <= '2023-05-29T07:30:23.641022'::timestamp and sol.product_id = 194417 and so.state in ('done', 'sale') and so.warehouse_id = 43;
Date: 2023-05-29 07:31:30 Duration: 311ms
4 2m15s 877 120ms 228ms 154ms select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 29 00 24 3s791ms 157ms 01 10 1s529ms 152ms 02 25 3s842ms 153ms 03 24 3s555ms 148ms 04 20 3s143ms 157ms 05 22 3s476ms 158ms 06 29 4s218ms 145ms 07 51 7s285ms 142ms 08 36 5s618ms 156ms 09 42 6s750ms 160ms 10 35 5s639ms 161ms 11 41 6s976ms 170ms 12 112 16s282ms 145ms 13 92 13s630ms 148ms 14 57 9s417ms 165ms 15 43 6s956ms 161ms 16 29 4s601ms 158ms 17 16 2s438ms 152ms 18 24 3s577ms 149ms 19 44 6s760ms 153ms 20 34 5s144ms 151ms 21 18 2s652ms 147ms 22 19 2s944ms 154ms 23 30 4s852ms 161ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-29 11:41:35') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19568]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",19]', '["pointspring_master","mail.channel",248]', '["pointspring_master","mail.channel",285]', '["pointspring_master","res.partner",19568]', '["pointspring_master","ir.needaction",19568]'))) ORDER BY "bus_bus"."id";
Date: 2023-05-29 11:42:25 Duration: 228ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-29 12:29:31') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_982"', '["pointspring_master","calendar.alarm",19520]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",117]', '["pointspring_master","mail.channel",118]', '["pointspring_master","mail.channel",119]', '["pointspring_master","mail.channel",120]', '["pointspring_master","mail.channel",337]', '["pointspring_master","res.partner",19520]', '["pointspring_master","ir.needaction",19520]'))) ORDER BY "bus_bus"."id";
Date: 2023-05-29 12:30:22 Duration: 216ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-29 11:41:35') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_982"', '["pointspring_master","calendar.alarm",19520]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",117]', '["pointspring_master","mail.channel",118]', '["pointspring_master","mail.channel",119]', '["pointspring_master","mail.channel",120]', '["pointspring_master","mail.channel",337]', '["pointspring_master","res.partner",19520]', '["pointspring_master","ir.needaction",19520]'))) ORDER BY "bus_bus"."id";
Date: 2023-05-29 11:42:25 Duration: 214ms
5 1m7s 1 1m7s 1m7s 1m7s 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;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 29 09 1 1m7s 1m7s -
COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;
Date: 2023-05-29 09:03:02 Duration: 1m7s
6 1m4s 1 1m4s 1m4s 1m4s copy public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 29 09 1 1m4s 1m4s -
COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;
Date: 2023-05-29 09:01:52 Duration: 1m4s
7 52s831ms 24 2s168ms 2s249ms 2s201ms select "stock_move".id from "stock_move" where (((unaccent ("stock_move"."origin"::text) ilike unaccent (?)) or (unaccent ("stock_move"."name"::text) ilike unaccent (?))) or ("stock_move"."picking_id" in ( select "stock_picking".id from "stock_picking" where (unaccent ("stock_picking"."name"::text) ilike unaccent (?)) and ("stock_picking"."company_id" in (...))))) and ("stock_move"."company_id" in (...)) order by "stock_move"."date" desc limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 29 11 1 2s249ms 2s249ms 13 15 33s11ms 2s200ms 14 8 17s569ms 2s196ms -
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%05-F/INT/04240%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%05-F/INT/04240%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/04240%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."date" DESC LIMIT 80;
Date: 2023-05-29 11:38:14 Duration: 2s249ms
-
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%05-F/INT/04065%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%05-F/INT/04065%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/04065%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."date" DESC LIMIT 80;
Date: 2023-05-29 13:41:18 Duration: 2s237ms
-
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%05-F/INT/04240%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%05-F/INT/04240%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/04240%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."date" DESC LIMIT 80;
Date: 2023-05-29 13:37:10 Duration: 2s227ms
8 21s477ms 1 21s477ms 21s477ms 21s477ms copy public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 29 09 1 21s477ms 21s477ms -
COPY public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) TO stdout;
Date: 2023-05-29 09:08:30 Duration: 21s477ms
9 21s346ms 11 162ms 8s5ms 1s940ms delete from ir_attachment where id in ( select id from ir_attachment where id in (...) for no key update skip locked);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 29 11 11 21s346ms 1s940ms -
DELETE FROM ir_attachment WHERE id IN ( SELECT id FROM ir_attachment WHERE id in (2771992) FOR NO KEY UPDATE SKIP LOCKED);
Date: 2023-05-29 11:23:36 Duration: 8s5ms
-
DELETE FROM ir_attachment WHERE id IN ( SELECT id FROM ir_attachment WHERE id in (2771886) FOR NO KEY UPDATE SKIP LOCKED);
Date: 2023-05-29 11:17:02 Duration: 6s224ms
-
DELETE FROM ir_attachment WHERE id IN ( SELECT id FROM ir_attachment WHERE id in (2771974) FOR NO KEY UPDATE SKIP LOCKED);
Date: 2023-05-29 11:21:53 Duration: 2s477ms
10 21s81ms 1 21s81ms 21s81ms 21s81ms 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;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 29 09 1 21s81ms 21s81ms -
COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage) TO stdout;
Date: 2023-05-29 09:07:39 Duration: 21s81ms
11 19s779ms 7 1s444ms 4s65ms 2s825ms select "ir_model_fields".id from "ir_model_fields" where ("ir_model_fields"."model" = ?) order by "ir_model_fields"."name";Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 29 10 1 1s444ms 1s444ms 11 6 18s335ms 3s55ms -
SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.template') ORDER BY "ir_model_fields"."name";
Date: 2023-05-29 11:22:07 Duration: 4s65ms
-
SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.template') ORDER BY "ir_model_fields"."name";
Date: 2023-05-29 11:23:50 Duration: 3s901ms
-
SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.template') ORDER BY "ir_model_fields"."name";
Date: 2023-05-29 11:22:07 Duration: 3s7ms
12 17s546ms 1 17s546ms 17s546ms 17s546ms with data as ( select distinct shl.id as record, ?, shl.id as ref, ? as ref_code, shl.product_id as product_id, shl.invoice_date as invoice_date, shl.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, shl.selling_branch as selling_branch, st.id as warehouse_id, pt.method as method, now() at time zone ?, true from sale_history_line as shl left join stock_warehouse as st on st.branch_id = shl.selling_branch left join product_product as pp on pp.id = shl.product_id left join product_template as pt on pt.id = pp.product_tmpl_id left join product_warehouse_inventory as pwi on pwi.product_id = pp.id left join psd_custom_inventory_vendor as inv on inv.id = pt.inventory_vendor_id where shl.selling_branch = ? and shl.sales_obtain != ? and shl.product_id is not null and shl.exception_sale is not true and pt.never_stock = false and pt.discontinued = false and pt.is_core = false and shl.invoice_date >= ? and shl.invoice_date <= ? and pt.inventory_vendor_id not in (...) and pt.inventory_vendor_id in (...) and pp.id in (...) and pp.id not in (...) union all ( select distinct sol.id as record, ?, so.id as ref, ? as ref_code, sol.product_id as product_id, am.invoice_date as invoice_date, sol.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, so.branch_id as selling_branch, so.warehouse_id as warehouse_id, pt.method as method, now() at time zone ?, true from sale_order_line sol left join product_product as pp on sol.product_id = pp.id left join product_template as pt on pp.product_tmpl_id = pt.id left join psd_custom_inventory_vendor as inv on inv.id = pt.inventory_vendor_id left join sale_order as so on sol.order_id = so.id left join sale_order_line_invoice_rel as solrel on solrel.order_line_id = sol.id left join account_move_line as aml on aml.id = solrel.invoice_line_id left join account_move as am on am.id = aml.move_id left join product_warehouse_inventory as pwi on pwi.product_id = pp.id where sol.branch_id = ? and sol.product_id is not null and sol.exception_sale is not true and pt.never_stock = false and pt.discontinued = false and pt.is_core = false and am.invoice_date >= ? and am.invoice_date <= ? and so.state in (...) and pt.inventory_vendor_id not in (...) and pt.inventory_vendor_id in (...) and pp.id in (...) and pp.id not in (...)) union all ( select distinct sol.id as record, ?, so.id as ref, ? as ref_code, sol.product_id as product_id, so.date_order as invoice_date, sol.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, so.branch_id as selling_branch, so.warehouse_id as warehouse_id, pt.method as method, now() at time zone ?, true from sale_order_line sol left join product_product as pp on sol.product_id = pp.id left join product_template as pt on pp.product_tmpl_id = pt.id left join psd_custom_inventory_vendor as inv on inv.id = pt.inventory_vendor_id left join sale_order as so on sol.order_id = so.id left join product_warehouse_inventory as pwi on pwi.product_id = pp.id where sol.branch_id = ? and sol.product_id is not null and sol.exception_sale is not true and pt.never_stock = false and pt.discontinued = false and pt.is_core = false and so.date_order >= ? and so.date_order <= ? and so.state in (...) and pt.inventory_vendor_id not in (...) and pt.inventory_vendor_id in (...) and pp.id in (...) and pp.id not in (...)) union all ( select distinct rol.id as record, ?, ro.id as ref, ? as ref_code, rol.product_id as product_id, ro.create_date as invoice_date, rol.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, ro.branch_id as selling_branch, ro.warehouse_id as warehouse_id, pt.method as method, now() at time zone ?, true from repair_order ro left join repair_line as rol on ro.id = rol.repair_id left join product_product as pp on rol.product_id = pp.id left join product_template as pt on pp.product_tmpl_id = pt.id left join psd_custom_inventory_vendor as inv on inv.id = pt.inventory_vendor_id left join product_warehouse_inventory as pwi on pwi.product_id = pp.id where ro.state = ? and ro.branch_id = ? and rol.product_id is not null and pt.never_stock = false and pt.discontinued = false and pt.is_core = false and ro.create_date >= ? and ro.create_date <= ? and pt.inventory_vendor_id not in (...) and pt.inventory_vendor_id in (...) and pp.id in (...) and pp.id not in (...)) union all ( select distinct sm.id as record, ?, mrp.id as ref, ? as ref_code, sm.product_id as product_id, mrp.create_date as invoice_date, sm.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, mrp.branch_id as selling_branch, sm.warehouse_id as warehouse_id, pt.method as method, now() at time zone ?, true from mrp_production mrp left join stock_move as sm on sm.raw_material_production_id = mrp.id left join product_product as pp on sm.product_id = pp.id left join product_template as pt on pp.product_tmpl_id = pt.id left join psd_custom_inventory_vendor as inv on inv.id = pt.inventory_vendor_id left join product_warehouse_inventory as pwi on pwi.product_id = pp.id where mrp.state = ? and mrp.branch_id = ? and sm.product_id is not null and pt.never_stock = false and pt.discontinued = false and pt.is_core = false and mrp.create_date >= ? and mrp.create_date <= ? and pt.inventory_vendor_id not in (...) and pt.inventory_vendor_id in (...) and pp.id in (...) and pp.id not in (...))) insert into item_list_line (item_demand_plan_id, product_id, invoice_date, product_uom_qty, inventory_vendor_id, selling_branch, warehouse_id, method, ref_id, ref, create_date, active) ( select ?, data.product_id as product_id, data.invoice_date as invoice_date, data.product_uom_qty as product_uom_qty, data.inventory_vendor_id as inventory_vendor_id, data.selling_branch as selling_branch, data.warehouse_id as warehouse_id, brpm.method as method, data.ref as ref_id, data.ref_code as ref, now() at time zone ?, true from data left join branch_product_method as brpm on brpm.product_id = data.product_id and brpm.branch_id = ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 29 05 1 17s546ms 17s546ms -
with data as ( select distinct shl.id as record, 3658, shl.id as ref, 'Sales History' as ref_code, shl.product_id as product_id, shl.invoice_date as invoice_date, shl.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, shl.selling_branch as selling_branch, st.id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from sale_history_line as shl LEFT JOIN stock_warehouse as st ON st.branch_id = shl.selling_branch LEFT JOIN product_product as pp ON pp.id = shl.product_id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id where shl.selling_branch = 45 and shl.sales_obtain != 'direct' and shl.product_id is not null and shl.exception_sale IS NOT TRUE and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and shl.invoice_date >= '2017-05-29 09:29:11' and shl.invoice_date <= '2023-05-29 09:29:11' and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127, 3150) and pt.inventory_vendor_id in (2952) and pp.id in (213570) and pp.id not in (173262, 173641, 203690, 248601, 197227, 248600, 197276, 177378, 177880, 177884, 177882, 173212, 203223, 213290, 177891, 202435, 246006, 211212, 202687, 177894, 177886, 177893, 228248, 179147, 205525, 180400, 239522, 190908, 208958, 206627, 184051, 177878, 177908, 190525, 197274, 177949, 208957, 173230, 180730, 177896, 177743, 210626, 211219, 173229, 184510, 228263, 184439, 190593, 184001, 174022, 181017, 203231, 177853, 177876, 185902, 180735, 211229, 177917, 177924, 192883, 177927, 177926, 239420, 177923, 197267, 179148, 177861, 218905, 190531, 192957, 199642, 185145, 177948, 211201, 179986, 211206, 177890, 211207, 172767, 180822, 180397, 174026, 177885, 174246, 239405, 180879, 206638, 203681, 177900, 172689, 177892, 177872, 177887, 211202, 197240, 177068, 177947, 211220, 177873, 177899, 226991, 174233, 211233, 203674, 177922, 177901, 172796, 219122, 172835) UNION ALL ( select distinct sol.id as record, 3658, so.id as ref, 'Sale Order' as ref_code, sol.product_id as product_id, am.invoice_date as invoice_date, sol.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, so.branch_id as selling_branch, so.warehouse_id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from sale_order_line sol LEFT JOIN product_product as pp ON sol.product_id = pp.id LEFT JOIN product_template as pt ON pp.product_tmpl_id = pt.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id LEFT JOIN sale_order as so ON sol.order_id = so.id LEFT JOIN sale_order_line_invoice_rel as solrel ON solrel.order_line_id = sol.id LEFT JOIN account_move_line as aml ON aml.id = solrel.invoice_line_id LEFT JOIN account_move as am ON am.id = aml.move_id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id where sol.branch_id = 45 and sol.product_id is not null and sol.exception_sale IS NOT TRUE and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and am.invoice_date >= '2017-05-29 09:29:11' and am.invoice_date <= '2023-05-29 09:29:11' and so.state in ('done', 'sale') and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127, 3150) and pt.inventory_vendor_id in (2952) and pp.id in (213570) and pp.id not in (173262, 173641, 203690, 248601, 197227, 248600, 197276, 177378, 177880, 177884, 177882, 173212, 203223, 213290, 177891, 202435, 246006, 211212, 202687, 177894, 177886, 177893, 228248, 179147, 205525, 180400, 239522, 190908, 208958, 206627, 184051, 177878, 177908, 190525, 197274, 177949, 208957, 173230, 180730, 177896, 177743, 210626, 211219, 173229, 184510, 228263, 184439, 190593, 184001, 174022, 181017, 203231, 177853, 177876, 185902, 180735, 211229, 177917, 177924, 192883, 177927, 177926, 239420, 177923, 197267, 179148, 177861, 218905, 190531, 192957, 199642, 185145, 177948, 211201, 179986, 211206, 177890, 211207, 172767, 180822, 180397, 174026, 177885, 174246, 239405, 180879, 206638, 203681, 177900, 172689, 177892, 177872, 177887, 211202, 197240, 177068, 177947, 211220, 177873, 177899, 226991, 174233, 211233, 203674, 177922, 177901, 172796, 219122, 172835)) UNION ALL ( select distinct sol.id as record, 3658, so.id as ref, 'Sale Order' as ref_code, sol.product_id as product_id, so.date_order as invoice_date, sol.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, so.branch_id as selling_branch, so.warehouse_id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from sale_order_line sol LEFT JOIN product_product as pp ON sol.product_id = pp.id LEFT JOIN product_template as pt ON pp.product_tmpl_id = pt.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id LEFT JOIN sale_order as so ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id where sol.branch_id = 45 and sol.product_id is not null and sol.exception_sale IS NOT TRUE and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and so.date_order >= '2017-05-29 09:29:11' and so.date_order <= '2023-05-29 09:29:11' and so.state in ('permanent_order') and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127, 3150) and pt.inventory_vendor_id in (2952) and pp.id in (213570) and pp.id not in (173262, 173641, 203690, 248601, 197227, 248600, 197276, 177378, 177880, 177884, 177882, 173212, 203223, 213290, 177891, 202435, 246006, 211212, 202687, 177894, 177886, 177893, 228248, 179147, 205525, 180400, 239522, 190908, 208958, 206627, 184051, 177878, 177908, 190525, 197274, 177949, 208957, 173230, 180730, 177896, 177743, 210626, 211219, 173229, 184510, 228263, 184439, 190593, 184001, 174022, 181017, 203231, 177853, 177876, 185902, 180735, 211229, 177917, 177924, 192883, 177927, 177926, 239420, 177923, 197267, 179148, 177861, 218905, 190531, 192957, 199642, 185145, 177948, 211201, 179986, 211206, 177890, 211207, 172767, 180822, 180397, 174026, 177885, 174246, 239405, 180879, 206638, 203681, 177900, 172689, 177892, 177872, 177887, 211202, 197240, 177068, 177947, 211220, 177873, 177899, 226991, 174233, 211233, 203674, 177922, 177901, 172796, 219122, 172835)) UNION ALL ( select distinct rol.id as record, 3658, ro.id as ref, 'Repair Orders' as ref_code, rol.product_id as product_id, ro.create_date as invoice_date, rol.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, ro.branch_id as selling_branch, ro.warehouse_id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from repair_order ro LEFT JOIN repair_line as rol ON ro.id = rol.repair_id LEFT JOIN product_product as pp ON rol.product_id = pp.id LEFT JOIN product_template as pt ON pp.product_tmpl_id = pt.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id where ro.state = 'done' and ro.branch_id = 45 and rol.product_id is not null and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and ro.create_date >= '2017-05-29 09:29:11' and ro.create_date <= '2023-05-29 09:29:11' and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127, 3150) and pt.inventory_vendor_id in (2952) and pp.id in (213570) and pp.id not in (173262, 173641, 203690, 248601, 197227, 248600, 197276, 177378, 177880, 177884, 177882, 173212, 203223, 213290, 177891, 202435, 246006, 211212, 202687, 177894, 177886, 177893, 228248, 179147, 205525, 180400, 239522, 190908, 208958, 206627, 184051, 177878, 177908, 190525, 197274, 177949, 208957, 173230, 180730, 177896, 177743, 210626, 211219, 173229, 184510, 228263, 184439, 190593, 184001, 174022, 181017, 203231, 177853, 177876, 185902, 180735, 211229, 177917, 177924, 192883, 177927, 177926, 239420, 177923, 197267, 179148, 177861, 218905, 190531, 192957, 199642, 185145, 177948, 211201, 179986, 211206, 177890, 211207, 172767, 180822, 180397, 174026, 177885, 174246, 239405, 180879, 206638, 203681, 177900, 172689, 177892, 177872, 177887, 211202, 197240, 177068, 177947, 211220, 177873, 177899, 226991, 174233, 211233, 203674, 177922, 177901, 172796, 219122, 172835)) UNION ALL ( select distinct sm.id as record, 3658, mrp.id as ref, 'Manufacturing Orders' as ref_code, sm.product_id as product_id, mrp.create_date as invoice_date, sm.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, mrp.branch_id as selling_branch, sm.warehouse_id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from mrp_production mrp LEFT JOIN stock_move as sm ON sm.raw_material_production_id = mrp.id LEFT JOIN product_product as pp ON sm.product_id = pp.id LEFT JOIN product_template as pt ON pp.product_tmpl_id = pt.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id where mrp.state = 'done' and mrp.branch_id = 45 and sm.product_id is not null and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and mrp.create_date >= '2017-05-29 09:29:11' and mrp.create_date <= '2023-05-29 09:29:11' and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127, 3150) and pt.inventory_vendor_id in (2952) and pp.id in (213570) and pp.id not in (173262, 173641, 203690, 248601, 197227, 248600, 197276, 177378, 177880, 177884, 177882, 173212, 203223, 213290, 177891, 202435, 246006, 211212, 202687, 177894, 177886, 177893, 228248, 179147, 205525, 180400, 239522, 190908, 208958, 206627, 184051, 177878, 177908, 190525, 197274, 177949, 208957, 173230, 180730, 177896, 177743, 210626, 211219, 173229, 184510, 228263, 184439, 190593, 184001, 174022, 181017, 203231, 177853, 177876, 185902, 180735, 211229, 177917, 177924, 192883, 177927, 177926, 239420, 177923, 197267, 179148, 177861, 218905, 190531, 192957, 199642, 185145, 177948, 211201, 179986, 211206, 177890, 211207, 172767, 180822, 180397, 174026, 177885, 174246, 239405, 180879, 206638, 203681, 177900, 172689, 177892, 177872, 177887, 211202, 197240, 177068, 177947, 211220, 177873, 177899, 226991, 174233, 211233, 203674, 177922, 177901, 172796, 219122, 172835))) insert into item_list_line (item_demand_plan_id, product_id, invoice_date, product_uom_qty, inventory_vendor_id, selling_branch, warehouse_id, method, ref_id, ref, create_date, active) ( select 3658, data.product_id as product_id, data.invoice_date as invoice_date, data.product_uom_qty as product_uom_qty, data.inventory_vendor_id as inventory_vendor_id, data.selling_branch as selling_branch, data.warehouse_id as warehouse_id, brpm.method as method, data.ref as ref_id, data.ref_code as ref, now() at time zone 'UTC', True from data LEFT JOIN branch_product_method as brpm ON brpm.product_id = data.product_id and brpm.branch_id = 45);
Date: 2023-05-29 05:33:13 Duration: 17s546ms
13 15s907ms 28 555ms 586ms 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 (((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 #13
Day Hour Count Duration Avg duration May 29 15 13 7s335ms 564ms 18 15 8s572ms 571ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%4707Q%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4707Q%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%4707Q%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-29 18:02:31 Duration: 586ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%4707Q%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4707Q%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%4707Q%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-29 18:02:40 Duration: 584ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%4707Q%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4707Q%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%4707Q%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-29 18:02:36 Duration: 576ms
14 13s10ms 1 13s10ms 13s10ms 13s10ms copy public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 29 09 1 13s10ms 13s10ms -
COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;
Date: 2023-05-29 09:08:09 Duration: 13s10ms
15 12s649ms 1 12s649ms 12s649ms 12s649ms copy public.account_move_line (id, move_id, move_name, date, ref, parent_state, journal_id, company_id, company_currency_id, account_id, account_root_id, sequence, name, quantity, price_unit, discount, debit, credit, balance, amount_currency, price_subtotal, price_total, reconciled, blocked, date_maturity, currency_id, partner_id, product_uom_id, product_id, reconcile_model_id, payment_id, statement_line_id, statement_id, tax_line_id, tax_group_id, tax_base_amount, tax_exigible, tax_repartition_line_id, tax_audit, amount_residual, amount_residual_currency, full_reconcile_id, matching_number, analytic_account_id, display_type, is_rounding_line, exclude_from_invoice_tab, create_uid, create_date, write_uid, write_date, expected_pay_date, internal_note, next_action_date, followup_line_id, followup_date, is_anglo_saxon_line, purchase_line_id, branch_id, branch_name, vehicle_id, move_options, sign_product_qty, sign_price_subtotal, new_product_qty, sale_line_id, child_sale_line_id, main_invoice_line_id, core_bank_transaction, is_rtv_line, core_qty, rebate_amount, cost_price, is_visible_in_report, is_labour, can_be_paid, bal_core_bank_id, repair_line_id, inv_back_order_qty, sale_back_order_qty, product_pricelist_item_id) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 29 09 1 12s649ms 12s649ms -
COPY public.account_move_line (id, move_id, move_name, date, ref, parent_state, journal_id, company_id, company_currency_id, account_id, account_root_id, sequence, name, quantity, price_unit, discount, debit, credit, balance, amount_currency, price_subtotal, price_total, reconciled, blocked, date_maturity, currency_id, partner_id, product_uom_id, product_id, reconcile_model_id, payment_id, statement_line_id, statement_id, tax_line_id, tax_group_id, tax_base_amount, tax_exigible, tax_repartition_line_id, tax_audit, amount_residual, amount_residual_currency, full_reconcile_id, matching_number, analytic_account_id, display_type, is_rounding_line, exclude_from_invoice_tab, create_uid, create_date, write_uid, write_date, expected_pay_date, internal_note, next_action_date, followup_line_id, followup_date, is_anglo_saxon_line, purchase_line_id, branch_id, branch_name, vehicle_id, move_options, sign_product_qty, sign_price_subtotal, new_product_qty, sale_line_id, child_sale_line_id, main_invoice_line_id, core_bank_transaction, is_rtv_line, core_qty, rebate_amount, cost_price, is_visible_in_report, is_labour, can_be_paid, bal_core_bank_id, repair_line_id, inv_back_order_qty, sale_back_order_qty, product_pricelist_item_id) TO stdout;
Date: 2023-05-29 09:00:22 Duration: 12s649ms
16 10s997ms 14 712ms 1s105ms 785ms select distinct ill.product_id from item_list_line as ill left join res_forecast_method as fm on fm.id = ill.method where ill.item_demand_plan_id = ? and ill.method not in (...);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 29 05 14 10s997ms 785ms -
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3658 and ill.method not in (8, 7);
Date: 2023-05-29 05:33:47 Duration: 1s105ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3658 and ill.method not in (8, 7);
Date: 2023-05-29 05:32:52 Duration: 876ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3658 and ill.method not in (8, 7);
Date: 2023-05-29 05:33:17 Duration: 856ms
17 10s653ms 14 725ms 859ms 760ms select count(id) as total_count from item_list_line where item_demand_plan_id = ? and active = true;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 29 05 14 10s653ms 760ms -
select count(id) as total_count from item_list_line where item_demand_plan_id = 3658 and active = True;
Date: 2023-05-29 05:32:50 Duration: 859ms
-
select count(id) as total_count from item_list_line where item_demand_plan_id = 3640 and active = True;
Date: 2023-05-29 05:15:44 Duration: 787ms
-
select count(id) as total_count from item_list_line where item_demand_plan_id = 3658 and active = True;
Date: 2023-05-29 05:34:16 Duration: 778ms
18 9s109ms 1 9s109ms 9s109ms 9s109ms copy public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 29 09 1 9s109ms 9s109ms -
COPY public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2023-05-29 09:00:33 Duration: 9s109ms
19 9s22ms 36 241ms 315ms 250ms 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"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, coalesce("product_template__name"."value", "product_template"."name") desc, "product_template"."id" desc;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 29 03 18 4s495ms 249ms 04 6 1s571ms 261ms 05 6 1s464ms 244ms 06 3 733ms 244ms 14 3 758ms 252ms -
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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2023-05-29 04:53:02 Duration: 315ms
-
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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2023-05-29 03:01:59 Duration: 261ms
-
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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2023-05-29 04:53:03 Duration: 260ms
20 8s399ms 1 8s399ms 8s399ms 8s399ms select "account_move_line".id from "account_move_line" where (((("account_move_line"."display_type" not in (...)) or "account_move_line"."display_type" is null) and (("account_move_line"."parent_state" != ?) or "account_move_line"."parent_state" is null)) and (("account_move_line"."parent_state" = ?) and ((((unaccent ("account_move_line"."name"::text) ilike unaccent (?)) or (unaccent ("account_move_line"."ref"::text) ilike unaccent (?))) or ("account_move_line"."account_id" in ( select "account_account".id from "account_account" left join "res_company" AS "account_account__company_id" on ("account_account"."company_id" = "account_account__company_id"."id") where ((unaccent ("account_account"."code"::text) ilike unaccent (?)) or (unaccent ("account_account"."name"::text) ilike unaccent (?))) and ("account_account"."company_id" is null or ("account_account"."company_id" in (...)))))) or false))) and ("account_move_line"."company_id" is null or ("account_move_line"."company_id" in (...))) order by "account_move_line"."date" desc, "account_move_line"."move_name" desc, "account_move_line"."id", "account_move_line"."id" limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 29 14 1 8s399ms 8s399ms -
SELECT "account_move_line".id FROM "account_move_line" WHERE (((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line"."parent_state" != 'cancel') OR "account_move_line"."parent_state" IS NULL)) AND (("account_move_line"."parent_state" = 'posted') AND ((((unaccent ("account_move_line"."name"::text) ilike unaccent ('%V-BILL-00773%')) OR (unaccent ("account_move_line"."ref"::text) ilike unaccent ('%V-BILL-00773%'))) OR ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" LEFT JOIN "res_company" AS "account_account__company_id" ON ("account_account"."company_id" = "account_account__company_id"."id") WHERE ((unaccent ("account_account"."code"::text) ilike unaccent ('V-BILL-00773%')) OR (unaccent ("account_account"."name"::text) ilike unaccent ('%V-BILL-00773%'))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1)))))) OR FALSE))) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) ORDER BY "account_move_line"."date" DESC, "account_move_line"."move_name" DESC, "account_move_line"."id", "account_move_line"."id" LIMIT 80;
Date: 2023-05-29 14:42:18 Duration: 8s399ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 16,870 48m44s 165ms 347ms 173ms 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 #1
Day Hour Count Duration Avg duration May 29 00 1,677 4m51s 173ms 01 1,069 3m6s 174ms 02 819 2m22s 173ms 03 852 2m27s 173ms 04 699 2m 172ms 05 1,607 4m39s 173ms 06 1,583 4m33s 173ms 07 1,544 4m26s 172ms 08 1,007 2m53s 172ms 09 1,400 4m3s 174ms 10 1,154 3m20s 174ms 11 778 2m15s 173ms 12 1,495 4m17s 172ms 13 831 2m23s 172ms 22 9 1s540ms 171ms 23 346 59s792ms 172ms -
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_frontend.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-be84169/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-05-29 05:32:52 Duration: 347ms
-
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_frontend_lazy.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-755b6ac/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-05-29 05:32:52 Duration: 347ms
-
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_frontend_lazy.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-755b6ac/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-05-29 05:32:52 Duration: 327ms
2 1,029 2m31s 120ms 390ms 147ms select count(distinct (so.id)) as total_orders from sale_order as so left join sale_order_line as sol on sol.order_id = so.id left join product_warehouse_inventory as pwi on pwi.product_id = sol.product_id left join stock_warehouse as sw on sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= ?::timestamp and so.date_order <= ?::timestamp and sol.product_id = ? and so.state in (...) and so.warehouse_id = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 29 00 76 11s211ms 147ms 01 58 8s30ms 138ms 02 89 13s71ms 146ms 03 105 15s38ms 143ms 04 84 12s658ms 150ms 05 77 11s421ms 148ms 06 80 11s411ms 142ms 07 128 20s408ms 159ms 08 104 15s210ms 146ms 09 78 11s832ms 151ms 22 70 9s886ms 141ms 23 80 11s128ms 139ms -
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-11-29T09:30:04.362896'::timestamp and so.date_order <= '2023-05-29T09:30:04.362896'::timestamp and sol.product_id = 238580 and so.state in ('done', 'sale') and so.warehouse_id = 43;
Date: 2023-05-29 09:34:44 Duration: 390ms
-
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-11-29T07:30:23.641022'::timestamp and so.date_order <= '2023-05-29T07:30:23.641022'::timestamp and sol.product_id = 184219 and so.state in ('done', 'sale') and so.warehouse_id = 35;
Date: 2023-05-29 07:32:12 Duration: 325ms
-
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-11-29T07:30:23.641022'::timestamp and so.date_order <= '2023-05-29T07:30:23.641022'::timestamp and sol.product_id = 194417 and so.state in ('done', 'sale') and so.warehouse_id = 43;
Date: 2023-05-29 07:31:30 Duration: 311ms
3 877 2m15s 120ms 228ms 154ms select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 29 00 24 3s791ms 157ms 01 10 1s529ms 152ms 02 25 3s842ms 153ms 03 24 3s555ms 148ms 04 20 3s143ms 157ms 05 22 3s476ms 158ms 06 29 4s218ms 145ms 07 51 7s285ms 142ms 08 36 5s618ms 156ms 09 42 6s750ms 160ms 10 35 5s639ms 161ms 11 41 6s976ms 170ms 12 112 16s282ms 145ms 13 92 13s630ms 148ms 14 57 9s417ms 165ms 15 43 6s956ms 161ms 16 29 4s601ms 158ms 17 16 2s438ms 152ms 18 24 3s577ms 149ms 19 44 6s760ms 153ms 20 34 5s144ms 151ms 21 18 2s652ms 147ms 22 19 2s944ms 154ms 23 30 4s852ms 161ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-29 11:41:35') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19568]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",19]', '["pointspring_master","mail.channel",248]', '["pointspring_master","mail.channel",285]', '["pointspring_master","res.partner",19568]', '["pointspring_master","ir.needaction",19568]'))) ORDER BY "bus_bus"."id";
Date: 2023-05-29 11:42:25 Duration: 228ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-29 12:29:31') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_982"', '["pointspring_master","calendar.alarm",19520]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",117]', '["pointspring_master","mail.channel",118]', '["pointspring_master","mail.channel",119]', '["pointspring_master","mail.channel",120]', '["pointspring_master","mail.channel",337]', '["pointspring_master","res.partner",19520]', '["pointspring_master","ir.needaction",19520]'))) ORDER BY "bus_bus"."id";
Date: 2023-05-29 12:30:22 Duration: 216ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-29 11:41:35') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_982"', '["pointspring_master","calendar.alarm",19520]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",117]', '["pointspring_master","mail.channel",118]', '["pointspring_master","mail.channel",119]', '["pointspring_master","mail.channel",120]', '["pointspring_master","mail.channel",337]', '["pointspring_master","res.partner",19520]', '["pointspring_master","ir.needaction",19520]'))) ORDER BY "bus_bus"."id";
Date: 2023-05-29 11:42:25 Duration: 214ms
4 42 8s280ms 160ms 242ms 197ms select min("product_warehouse_inventory".id) as id, count("product_warehouse_inventory".id) AS "cron_last_stock_flag_update_count", sum("product_warehouse_inventory"."qty_available") AS "qty_available", sum("product_warehouse_inventory"."qty_reserve") AS "qty_reserve", sum("product_warehouse_inventory"."qty_on_order") AS "qty_on_order", sum("product_warehouse_inventory"."qty_on_perm_order") AS "qty_on_perm_order", sum("product_warehouse_inventory"."qty_shipped_not_invoiced") AS "qty_shipped_not_invoiced", sum("product_warehouse_inventory"."qty_in_transist") AS "qty_in_transist", sum("product_warehouse_inventory"."qty_available_last_year") AS "qty_available_last_year", sum("product_warehouse_inventory"."qty_mtd_sold") AS "qty_mtd_sold", sum("product_warehouse_inventory"."qty_ytd_sold") AS "qty_ytd_sold", sum("product_warehouse_inventory"."qty_ytd_transfer_another") AS "qty_ytd_transfer_another", sum("product_warehouse_inventory"."qty_ytd_lost_sales") AS "qty_ytd_lost_sales", sum("product_warehouse_inventory"."qty_last_receive") AS "qty_last_receive", sum("product_warehouse_inventory"."qty_sold_last_year") AS "qty_sold_last_year", sum("product_warehouse_inventory"."qty_ly_transfer_another") AS "qty_ly_transfer_another", sum("product_warehouse_inventory"."mon_1_qty") AS "mon_1_qty", sum("product_warehouse_inventory"."mon_2_qty") AS "mon_2_qty", sum("product_warehouse_inventory"."mon_3_qty") AS "mon_3_qty", sum("product_warehouse_inventory"."mon_4_qty") AS "mon_4_qty", sum("product_warehouse_inventory"."mon_5_qty") AS "mon_5_qty", sum("product_warehouse_inventory"."mon_6_qty") AS "mon_6_qty", sum("product_warehouse_inventory"."mon_7_qty") AS "mon_7_qty", sum("product_warehouse_inventory"."mon_8_qty") AS "mon_8_qty", sum("product_warehouse_inventory"."mon_9_qty") AS "mon_9_qty", sum("product_warehouse_inventory"."mon_10_qty") AS "mon_10_qty", sum("product_warehouse_inventory"."mon_11_qty") AS "mon_11_qty", sum("product_warehouse_inventory"."mon_12_qty") AS "mon_12_qty", sum("product_warehouse_inventory"."unit_cost") AS "unit_cost", sum("product_warehouse_inventory"."loc_check_qty") AS "loc_check_qty", sum("product_warehouse_inventory"."rep_loc_check_qty") AS "rep_loc_check_qty", sum("product_warehouse_inventory"."min_product_uom_qty") AS "min_product_uom_qty", sum("product_warehouse_inventory"."max_product_uom_qty") AS "max_product_uom_qty", sum("product_warehouse_inventory"."last_intra_company_qty") AS "last_intra_company_qty", date_trunc(?, "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) AS "cron_last_stock_flag_update:day" from "product_warehouse_inventory" where (("product_warehouse_inventory"."cron_last_stock_flag_update" >= ?) and ("product_warehouse_inventory"."cron_last_stock_flag_update" < ?)) group by date_trunc(?, "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) order by "cron_last_stock_flag_update:day";Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 29 07 2 325ms 162ms 09 28 5s656ms 202ms 11 10 1s954ms 195ms 12 2 344ms 172ms -
SELECT min("product_warehouse_inventory".id) AS id, count("product_warehouse_inventory".id) AS "cron_last_stock_flag_update_count", sum("product_warehouse_inventory"."qty_available") AS "qty_available", sum("product_warehouse_inventory"."qty_reserve") AS "qty_reserve", sum("product_warehouse_inventory"."qty_on_order") AS "qty_on_order", sum("product_warehouse_inventory"."qty_on_perm_order") AS "qty_on_perm_order", sum("product_warehouse_inventory"."qty_shipped_not_invoiced") AS "qty_shipped_not_invoiced", sum("product_warehouse_inventory"."qty_in_transist") AS "qty_in_transist", sum("product_warehouse_inventory"."qty_available_last_year") AS "qty_available_last_year", sum("product_warehouse_inventory"."qty_mtd_sold") AS "qty_mtd_sold", sum("product_warehouse_inventory"."qty_ytd_sold") AS "qty_ytd_sold", sum("product_warehouse_inventory"."qty_ytd_transfer_another") AS "qty_ytd_transfer_another", sum("product_warehouse_inventory"."qty_ytd_lost_sales") AS "qty_ytd_lost_sales", sum("product_warehouse_inventory"."qty_last_receive") AS "qty_last_receive", sum("product_warehouse_inventory"."qty_sold_last_year") AS "qty_sold_last_year", sum("product_warehouse_inventory"."qty_ly_transfer_another") AS "qty_ly_transfer_another", sum("product_warehouse_inventory"."mon_1_qty") AS "mon_1_qty", sum("product_warehouse_inventory"."mon_2_qty") AS "mon_2_qty", sum("product_warehouse_inventory"."mon_3_qty") AS "mon_3_qty", sum("product_warehouse_inventory"."mon_4_qty") AS "mon_4_qty", sum("product_warehouse_inventory"."mon_5_qty") AS "mon_5_qty", sum("product_warehouse_inventory"."mon_6_qty") AS "mon_6_qty", sum("product_warehouse_inventory"."mon_7_qty") AS "mon_7_qty", sum("product_warehouse_inventory"."mon_8_qty") AS "mon_8_qty", sum("product_warehouse_inventory"."mon_9_qty") AS "mon_9_qty", sum("product_warehouse_inventory"."mon_10_qty") AS "mon_10_qty", sum("product_warehouse_inventory"."mon_11_qty") AS "mon_11_qty", sum("product_warehouse_inventory"."mon_12_qty") AS "mon_12_qty", sum("product_warehouse_inventory"."unit_cost") AS "unit_cost", sum("product_warehouse_inventory"."loc_check_qty") AS "loc_check_qty", sum("product_warehouse_inventory"."rep_loc_check_qty") AS "rep_loc_check_qty", sum("product_warehouse_inventory"."min_product_uom_qty") AS "min_product_uom_qty", sum("product_warehouse_inventory"."max_product_uom_qty") AS "max_product_uom_qty", sum("product_warehouse_inventory"."last_intra_company_qty") AS "last_intra_company_qty", date_trunc('day', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) as "cron_last_stock_flag_update:day" FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."cron_last_stock_flag_update" >= '2023-05-01') AND ("product_warehouse_inventory"."cron_last_stock_flag_update" < '2023-06-01')) GROUP BY date_trunc('day', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) ORDER BY "cron_last_stock_flag_update:day";
Date: 2023-05-29 09:10:37 Duration: 242ms
-
SELECT min("product_warehouse_inventory".id) AS id, count("product_warehouse_inventory".id) AS "cron_last_stock_flag_update_count", sum("product_warehouse_inventory"."qty_available") AS "qty_available", sum("product_warehouse_inventory"."qty_reserve") AS "qty_reserve", sum("product_warehouse_inventory"."qty_on_order") AS "qty_on_order", sum("product_warehouse_inventory"."qty_on_perm_order") AS "qty_on_perm_order", sum("product_warehouse_inventory"."qty_shipped_not_invoiced") AS "qty_shipped_not_invoiced", sum("product_warehouse_inventory"."qty_in_transist") AS "qty_in_transist", sum("product_warehouse_inventory"."qty_available_last_year") AS "qty_available_last_year", sum("product_warehouse_inventory"."qty_mtd_sold") AS "qty_mtd_sold", sum("product_warehouse_inventory"."qty_ytd_sold") AS "qty_ytd_sold", sum("product_warehouse_inventory"."qty_ytd_transfer_another") AS "qty_ytd_transfer_another", sum("product_warehouse_inventory"."qty_ytd_lost_sales") AS "qty_ytd_lost_sales", sum("product_warehouse_inventory"."qty_last_receive") AS "qty_last_receive", sum("product_warehouse_inventory"."qty_sold_last_year") AS "qty_sold_last_year", sum("product_warehouse_inventory"."qty_ly_transfer_another") AS "qty_ly_transfer_another", sum("product_warehouse_inventory"."mon_1_qty") AS "mon_1_qty", sum("product_warehouse_inventory"."mon_2_qty") AS "mon_2_qty", sum("product_warehouse_inventory"."mon_3_qty") AS "mon_3_qty", sum("product_warehouse_inventory"."mon_4_qty") AS "mon_4_qty", sum("product_warehouse_inventory"."mon_5_qty") AS "mon_5_qty", sum("product_warehouse_inventory"."mon_6_qty") AS "mon_6_qty", sum("product_warehouse_inventory"."mon_7_qty") AS "mon_7_qty", sum("product_warehouse_inventory"."mon_8_qty") AS "mon_8_qty", sum("product_warehouse_inventory"."mon_9_qty") AS "mon_9_qty", sum("product_warehouse_inventory"."mon_10_qty") AS "mon_10_qty", sum("product_warehouse_inventory"."mon_11_qty") AS "mon_11_qty", sum("product_warehouse_inventory"."mon_12_qty") AS "mon_12_qty", sum("product_warehouse_inventory"."unit_cost") AS "unit_cost", sum("product_warehouse_inventory"."loc_check_qty") AS "loc_check_qty", sum("product_warehouse_inventory"."rep_loc_check_qty") AS "rep_loc_check_qty", sum("product_warehouse_inventory"."min_product_uom_qty") AS "min_product_uom_qty", sum("product_warehouse_inventory"."max_product_uom_qty") AS "max_product_uom_qty", sum("product_warehouse_inventory"."last_intra_company_qty") AS "last_intra_company_qty", date_trunc('day', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) as "cron_last_stock_flag_update:day" FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."cron_last_stock_flag_update" >= '2023-05-01') AND ("product_warehouse_inventory"."cron_last_stock_flag_update" < '2023-06-01')) GROUP BY date_trunc('day', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) ORDER BY "cron_last_stock_flag_update:day";
Date: 2023-05-29 11:26:51 Duration: 239ms
-
SELECT min("product_warehouse_inventory".id) AS id, count("product_warehouse_inventory".id) AS "cron_last_stock_flag_update_count", sum("product_warehouse_inventory"."qty_available") AS "qty_available", sum("product_warehouse_inventory"."qty_reserve") AS "qty_reserve", sum("product_warehouse_inventory"."qty_on_order") AS "qty_on_order", sum("product_warehouse_inventory"."qty_on_perm_order") AS "qty_on_perm_order", sum("product_warehouse_inventory"."qty_shipped_not_invoiced") AS "qty_shipped_not_invoiced", sum("product_warehouse_inventory"."qty_in_transist") AS "qty_in_transist", sum("product_warehouse_inventory"."qty_available_last_year") AS "qty_available_last_year", sum("product_warehouse_inventory"."qty_mtd_sold") AS "qty_mtd_sold", sum("product_warehouse_inventory"."qty_ytd_sold") AS "qty_ytd_sold", sum("product_warehouse_inventory"."qty_ytd_transfer_another") AS "qty_ytd_transfer_another", sum("product_warehouse_inventory"."qty_ytd_lost_sales") AS "qty_ytd_lost_sales", sum("product_warehouse_inventory"."qty_last_receive") AS "qty_last_receive", sum("product_warehouse_inventory"."qty_sold_last_year") AS "qty_sold_last_year", sum("product_warehouse_inventory"."qty_ly_transfer_another") AS "qty_ly_transfer_another", sum("product_warehouse_inventory"."mon_1_qty") AS "mon_1_qty", sum("product_warehouse_inventory"."mon_2_qty") AS "mon_2_qty", sum("product_warehouse_inventory"."mon_3_qty") AS "mon_3_qty", sum("product_warehouse_inventory"."mon_4_qty") AS "mon_4_qty", sum("product_warehouse_inventory"."mon_5_qty") AS "mon_5_qty", sum("product_warehouse_inventory"."mon_6_qty") AS "mon_6_qty", sum("product_warehouse_inventory"."mon_7_qty") AS "mon_7_qty", sum("product_warehouse_inventory"."mon_8_qty") AS "mon_8_qty", sum("product_warehouse_inventory"."mon_9_qty") AS "mon_9_qty", sum("product_warehouse_inventory"."mon_10_qty") AS "mon_10_qty", sum("product_warehouse_inventory"."mon_11_qty") AS "mon_11_qty", sum("product_warehouse_inventory"."mon_12_qty") AS "mon_12_qty", sum("product_warehouse_inventory"."unit_cost") AS "unit_cost", sum("product_warehouse_inventory"."loc_check_qty") AS "loc_check_qty", sum("product_warehouse_inventory"."rep_loc_check_qty") AS "rep_loc_check_qty", sum("product_warehouse_inventory"."min_product_uom_qty") AS "min_product_uom_qty", sum("product_warehouse_inventory"."max_product_uom_qty") AS "max_product_uom_qty", sum("product_warehouse_inventory"."last_intra_company_qty") AS "last_intra_company_qty", date_trunc('day', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) as "cron_last_stock_flag_update:day" FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."cron_last_stock_flag_update" >= '2023-05-01') AND ("product_warehouse_inventory"."cron_last_stock_flag_update" < '2023-06-01')) GROUP BY date_trunc('day', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) ORDER BY "cron_last_stock_flag_update:day";
Date: 2023-05-29 09:05:09 Duration: 237ms
5 39 7s574ms 162ms 250ms 194ms select min("product_warehouse_inventory".id) as id, count("product_warehouse_inventory".id) AS "stocking_flag_count", sum("product_warehouse_inventory"."qty_available") AS "qty_available", sum("product_warehouse_inventory"."qty_reserve") AS "qty_reserve", sum("product_warehouse_inventory"."qty_on_order") AS "qty_on_order", sum("product_warehouse_inventory"."qty_on_perm_order") AS "qty_on_perm_order", sum("product_warehouse_inventory"."qty_shipped_not_invoiced") AS "qty_shipped_not_invoiced", sum("product_warehouse_inventory"."qty_in_transist") AS "qty_in_transist", sum("product_warehouse_inventory"."qty_available_last_year") AS "qty_available_last_year", sum("product_warehouse_inventory"."qty_mtd_sold") AS "qty_mtd_sold", sum("product_warehouse_inventory"."qty_ytd_sold") AS "qty_ytd_sold", sum("product_warehouse_inventory"."qty_ytd_transfer_another") AS "qty_ytd_transfer_another", sum("product_warehouse_inventory"."qty_ytd_lost_sales") AS "qty_ytd_lost_sales", sum("product_warehouse_inventory"."qty_last_receive") AS "qty_last_receive", sum("product_warehouse_inventory"."qty_sold_last_year") AS "qty_sold_last_year", sum("product_warehouse_inventory"."qty_ly_transfer_another") AS "qty_ly_transfer_another", sum("product_warehouse_inventory"."mon_1_qty") AS "mon_1_qty", sum("product_warehouse_inventory"."mon_2_qty") AS "mon_2_qty", sum("product_warehouse_inventory"."mon_3_qty") AS "mon_3_qty", sum("product_warehouse_inventory"."mon_4_qty") AS "mon_4_qty", sum("product_warehouse_inventory"."mon_5_qty") AS "mon_5_qty", sum("product_warehouse_inventory"."mon_6_qty") AS "mon_6_qty", sum("product_warehouse_inventory"."mon_7_qty") AS "mon_7_qty", sum("product_warehouse_inventory"."mon_8_qty") AS "mon_8_qty", sum("product_warehouse_inventory"."mon_9_qty") AS "mon_9_qty", sum("product_warehouse_inventory"."mon_10_qty") AS "mon_10_qty", sum("product_warehouse_inventory"."mon_11_qty") AS "mon_11_qty", sum("product_warehouse_inventory"."mon_12_qty") AS "mon_12_qty", sum("product_warehouse_inventory"."unit_cost") AS "unit_cost", sum("product_warehouse_inventory"."loc_check_qty") AS "loc_check_qty", sum("product_warehouse_inventory"."rep_loc_check_qty") AS "rep_loc_check_qty", sum("product_warehouse_inventory"."min_product_uom_qty") AS "min_product_uom_qty", sum("product_warehouse_inventory"."max_product_uom_qty") AS "max_product_uom_qty", sum("product_warehouse_inventory"."last_intra_company_qty") AS "last_intra_company_qty", coalesce("product_warehouse_inventory"."stocking_flag", false) AS "stocking_flag" from "product_warehouse_inventory" where ((("product_warehouse_inventory"."cron_last_stock_flag_update" >= ?) and ("product_warehouse_inventory"."cron_last_stock_flag_update" < ?)) and (("product_warehouse_inventory"."cron_last_stock_flag_update" >= ?) and ("product_warehouse_inventory"."cron_last_stock_flag_update" < ?))) group by coalesce("product_warehouse_inventory"."stocking_flag", false) order by "stocking_flag";Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 29 09 29 5s633ms 194ms 11 8 1s596ms 199ms 12 2 345ms 172ms -
SELECT min("product_warehouse_inventory".id) AS id, count("product_warehouse_inventory".id) AS "stocking_flag_count", sum("product_warehouse_inventory"."qty_available") AS "qty_available", sum("product_warehouse_inventory"."qty_reserve") AS "qty_reserve", sum("product_warehouse_inventory"."qty_on_order") AS "qty_on_order", sum("product_warehouse_inventory"."qty_on_perm_order") AS "qty_on_perm_order", sum("product_warehouse_inventory"."qty_shipped_not_invoiced") AS "qty_shipped_not_invoiced", sum("product_warehouse_inventory"."qty_in_transist") AS "qty_in_transist", sum("product_warehouse_inventory"."qty_available_last_year") AS "qty_available_last_year", sum("product_warehouse_inventory"."qty_mtd_sold") AS "qty_mtd_sold", sum("product_warehouse_inventory"."qty_ytd_sold") AS "qty_ytd_sold", sum("product_warehouse_inventory"."qty_ytd_transfer_another") AS "qty_ytd_transfer_another", sum("product_warehouse_inventory"."qty_ytd_lost_sales") AS "qty_ytd_lost_sales", sum("product_warehouse_inventory"."qty_last_receive") AS "qty_last_receive", sum("product_warehouse_inventory"."qty_sold_last_year") AS "qty_sold_last_year", sum("product_warehouse_inventory"."qty_ly_transfer_another") AS "qty_ly_transfer_another", sum("product_warehouse_inventory"."mon_1_qty") AS "mon_1_qty", sum("product_warehouse_inventory"."mon_2_qty") AS "mon_2_qty", sum("product_warehouse_inventory"."mon_3_qty") AS "mon_3_qty", sum("product_warehouse_inventory"."mon_4_qty") AS "mon_4_qty", sum("product_warehouse_inventory"."mon_5_qty") AS "mon_5_qty", sum("product_warehouse_inventory"."mon_6_qty") AS "mon_6_qty", sum("product_warehouse_inventory"."mon_7_qty") AS "mon_7_qty", sum("product_warehouse_inventory"."mon_8_qty") AS "mon_8_qty", sum("product_warehouse_inventory"."mon_9_qty") AS "mon_9_qty", sum("product_warehouse_inventory"."mon_10_qty") AS "mon_10_qty", sum("product_warehouse_inventory"."mon_11_qty") AS "mon_11_qty", sum("product_warehouse_inventory"."mon_12_qty") AS "mon_12_qty", sum("product_warehouse_inventory"."unit_cost") AS "unit_cost", sum("product_warehouse_inventory"."loc_check_qty") AS "loc_check_qty", sum("product_warehouse_inventory"."rep_loc_check_qty") AS "rep_loc_check_qty", sum("product_warehouse_inventory"."min_product_uom_qty") AS "min_product_uom_qty", sum("product_warehouse_inventory"."max_product_uom_qty") AS "max_product_uom_qty", sum("product_warehouse_inventory"."last_intra_company_qty") AS "last_intra_company_qty", coalesce("product_warehouse_inventory"."stocking_flag", false) as "stocking_flag" FROM "product_warehouse_inventory" WHERE ((("product_warehouse_inventory"."cron_last_stock_flag_update" >= '2023-05-27') AND ("product_warehouse_inventory"."cron_last_stock_flag_update" < '2023-05-28')) AND (("product_warehouse_inventory"."cron_last_stock_flag_update" >= '2023-05-01') AND ("product_warehouse_inventory"."cron_last_stock_flag_update" < '2023-06-01'))) GROUP BY coalesce("product_warehouse_inventory"."stocking_flag", false) ORDER BY "stocking_flag";
Date: 2023-05-29 09:06:36 Duration: 250ms
-
SELECT min("product_warehouse_inventory".id) AS id, count("product_warehouse_inventory".id) AS "stocking_flag_count", sum("product_warehouse_inventory"."qty_available") AS "qty_available", sum("product_warehouse_inventory"."qty_reserve") AS "qty_reserve", sum("product_warehouse_inventory"."qty_on_order") AS "qty_on_order", sum("product_warehouse_inventory"."qty_on_perm_order") AS "qty_on_perm_order", sum("product_warehouse_inventory"."qty_shipped_not_invoiced") AS "qty_shipped_not_invoiced", sum("product_warehouse_inventory"."qty_in_transist") AS "qty_in_transist", sum("product_warehouse_inventory"."qty_available_last_year") AS "qty_available_last_year", sum("product_warehouse_inventory"."qty_mtd_sold") AS "qty_mtd_sold", sum("product_warehouse_inventory"."qty_ytd_sold") AS "qty_ytd_sold", sum("product_warehouse_inventory"."qty_ytd_transfer_another") AS "qty_ytd_transfer_another", sum("product_warehouse_inventory"."qty_ytd_lost_sales") AS "qty_ytd_lost_sales", sum("product_warehouse_inventory"."qty_last_receive") AS "qty_last_receive", sum("product_warehouse_inventory"."qty_sold_last_year") AS "qty_sold_last_year", sum("product_warehouse_inventory"."qty_ly_transfer_another") AS "qty_ly_transfer_another", sum("product_warehouse_inventory"."mon_1_qty") AS "mon_1_qty", sum("product_warehouse_inventory"."mon_2_qty") AS "mon_2_qty", sum("product_warehouse_inventory"."mon_3_qty") AS "mon_3_qty", sum("product_warehouse_inventory"."mon_4_qty") AS "mon_4_qty", sum("product_warehouse_inventory"."mon_5_qty") AS "mon_5_qty", sum("product_warehouse_inventory"."mon_6_qty") AS "mon_6_qty", sum("product_warehouse_inventory"."mon_7_qty") AS "mon_7_qty", sum("product_warehouse_inventory"."mon_8_qty") AS "mon_8_qty", sum("product_warehouse_inventory"."mon_9_qty") AS "mon_9_qty", sum("product_warehouse_inventory"."mon_10_qty") AS "mon_10_qty", sum("product_warehouse_inventory"."mon_11_qty") AS "mon_11_qty", sum("product_warehouse_inventory"."mon_12_qty") AS "mon_12_qty", sum("product_warehouse_inventory"."unit_cost") AS "unit_cost", sum("product_warehouse_inventory"."loc_check_qty") AS "loc_check_qty", sum("product_warehouse_inventory"."rep_loc_check_qty") AS "rep_loc_check_qty", sum("product_warehouse_inventory"."min_product_uom_qty") AS "min_product_uom_qty", sum("product_warehouse_inventory"."max_product_uom_qty") AS "max_product_uom_qty", sum("product_warehouse_inventory"."last_intra_company_qty") AS "last_intra_company_qty", coalesce("product_warehouse_inventory"."stocking_flag", false) as "stocking_flag" FROM "product_warehouse_inventory" WHERE ((("product_warehouse_inventory"."cron_last_stock_flag_update" >= '2023-05-27') AND ("product_warehouse_inventory"."cron_last_stock_flag_update" < '2023-05-28')) AND (("product_warehouse_inventory"."cron_last_stock_flag_update" >= '2023-05-01') AND ("product_warehouse_inventory"."cron_last_stock_flag_update" < '2023-06-01'))) GROUP BY coalesce("product_warehouse_inventory"."stocking_flag", false) ORDER BY "stocking_flag";
Date: 2023-05-29 09:05:51 Duration: 243ms
-
SELECT min("product_warehouse_inventory".id) AS id, count("product_warehouse_inventory".id) AS "stocking_flag_count", sum("product_warehouse_inventory"."qty_available") AS "qty_available", sum("product_warehouse_inventory"."qty_reserve") AS "qty_reserve", sum("product_warehouse_inventory"."qty_on_order") AS "qty_on_order", sum("product_warehouse_inventory"."qty_on_perm_order") AS "qty_on_perm_order", sum("product_warehouse_inventory"."qty_shipped_not_invoiced") AS "qty_shipped_not_invoiced", sum("product_warehouse_inventory"."qty_in_transist") AS "qty_in_transist", sum("product_warehouse_inventory"."qty_available_last_year") AS "qty_available_last_year", sum("product_warehouse_inventory"."qty_mtd_sold") AS "qty_mtd_sold", sum("product_warehouse_inventory"."qty_ytd_sold") AS "qty_ytd_sold", sum("product_warehouse_inventory"."qty_ytd_transfer_another") AS "qty_ytd_transfer_another", sum("product_warehouse_inventory"."qty_ytd_lost_sales") AS "qty_ytd_lost_sales", sum("product_warehouse_inventory"."qty_last_receive") AS "qty_last_receive", sum("product_warehouse_inventory"."qty_sold_last_year") AS "qty_sold_last_year", sum("product_warehouse_inventory"."qty_ly_transfer_another") AS "qty_ly_transfer_another", sum("product_warehouse_inventory"."mon_1_qty") AS "mon_1_qty", sum("product_warehouse_inventory"."mon_2_qty") AS "mon_2_qty", sum("product_warehouse_inventory"."mon_3_qty") AS "mon_3_qty", sum("product_warehouse_inventory"."mon_4_qty") AS "mon_4_qty", sum("product_warehouse_inventory"."mon_5_qty") AS "mon_5_qty", sum("product_warehouse_inventory"."mon_6_qty") AS "mon_6_qty", sum("product_warehouse_inventory"."mon_7_qty") AS "mon_7_qty", sum("product_warehouse_inventory"."mon_8_qty") AS "mon_8_qty", sum("product_warehouse_inventory"."mon_9_qty") AS "mon_9_qty", sum("product_warehouse_inventory"."mon_10_qty") AS "mon_10_qty", sum("product_warehouse_inventory"."mon_11_qty") AS "mon_11_qty", sum("product_warehouse_inventory"."mon_12_qty") AS "mon_12_qty", sum("product_warehouse_inventory"."unit_cost") AS "unit_cost", sum("product_warehouse_inventory"."loc_check_qty") AS "loc_check_qty", sum("product_warehouse_inventory"."rep_loc_check_qty") AS "rep_loc_check_qty", sum("product_warehouse_inventory"."min_product_uom_qty") AS "min_product_uom_qty", sum("product_warehouse_inventory"."max_product_uom_qty") AS "max_product_uom_qty", sum("product_warehouse_inventory"."last_intra_company_qty") AS "last_intra_company_qty", coalesce("product_warehouse_inventory"."stocking_flag", false) as "stocking_flag" FROM "product_warehouse_inventory" WHERE ((("product_warehouse_inventory"."cron_last_stock_flag_update" >= '2023-05-28') AND ("product_warehouse_inventory"."cron_last_stock_flag_update" < '2023-05-29')) AND (("product_warehouse_inventory"."cron_last_stock_flag_update" >= '2023-05-01') AND ("product_warehouse_inventory"."cron_last_stock_flag_update" < '2023-06-01'))) GROUP BY coalesce("product_warehouse_inventory"."stocking_flag", false) ORDER BY "stocking_flag";
Date: 2023-05-29 09:05:51 Duration: 241ms
6 36 9s22ms 241ms 315ms 250ms 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"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, coalesce("product_template__name"."value", "product_template"."name") desc, "product_template"."id" desc;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 29 03 18 4s495ms 249ms 04 6 1s571ms 261ms 05 6 1s464ms 244ms 06 3 733ms 244ms 14 3 758ms 252ms -
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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2023-05-29 04:53:02 Duration: 315ms
-
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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2023-05-29 03:01:59 Duration: 261ms
-
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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2023-05-29 04:53:03 Duration: 260ms
7 33 8s264ms 240ms 309ms 250ms 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"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, coalesce("product_template__name"."value", "product_template"."name") asc, "product_template"."id" desc;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 29 03 15 3s732ms 248ms 04 12 3s41ms 253ms 06 3 727ms 242ms 14 3 763ms 254ms -
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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2023-05-29 04:57:19 Duration: 309ms
-
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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2023-05-29 03:00:43 Duration: 276ms
-
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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2023-05-29 04:51:44 Duration: 262ms
8 31 7s74ms 206ms 262ms 228ms select min("product_warehouse_inventory".id) as id, count("product_warehouse_inventory".id) AS "cron_last_stock_flag_update_count", sum("product_warehouse_inventory"."qty_available") AS "qty_available", sum("product_warehouse_inventory"."qty_reserve") AS "qty_reserve", sum("product_warehouse_inventory"."qty_on_order") AS "qty_on_order", sum("product_warehouse_inventory"."qty_on_perm_order") AS "qty_on_perm_order", sum("product_warehouse_inventory"."qty_shipped_not_invoiced") AS "qty_shipped_not_invoiced", sum("product_warehouse_inventory"."qty_in_transist") AS "qty_in_transist", sum("product_warehouse_inventory"."qty_available_last_year") AS "qty_available_last_year", sum("product_warehouse_inventory"."qty_mtd_sold") AS "qty_mtd_sold", sum("product_warehouse_inventory"."qty_ytd_sold") AS "qty_ytd_sold", sum("product_warehouse_inventory"."qty_ytd_transfer_another") AS "qty_ytd_transfer_another", sum("product_warehouse_inventory"."qty_ytd_lost_sales") AS "qty_ytd_lost_sales", sum("product_warehouse_inventory"."qty_last_receive") AS "qty_last_receive", sum("product_warehouse_inventory"."qty_sold_last_year") AS "qty_sold_last_year", sum("product_warehouse_inventory"."qty_ly_transfer_another") AS "qty_ly_transfer_another", sum("product_warehouse_inventory"."mon_1_qty") AS "mon_1_qty", sum("product_warehouse_inventory"."mon_2_qty") AS "mon_2_qty", sum("product_warehouse_inventory"."mon_3_qty") AS "mon_3_qty", sum("product_warehouse_inventory"."mon_4_qty") AS "mon_4_qty", sum("product_warehouse_inventory"."mon_5_qty") AS "mon_5_qty", sum("product_warehouse_inventory"."mon_6_qty") AS "mon_6_qty", sum("product_warehouse_inventory"."mon_7_qty") AS "mon_7_qty", sum("product_warehouse_inventory"."mon_8_qty") AS "mon_8_qty", sum("product_warehouse_inventory"."mon_9_qty") AS "mon_9_qty", sum("product_warehouse_inventory"."mon_10_qty") AS "mon_10_qty", sum("product_warehouse_inventory"."mon_11_qty") AS "mon_11_qty", sum("product_warehouse_inventory"."mon_12_qty") AS "mon_12_qty", sum("product_warehouse_inventory"."unit_cost") AS "unit_cost", sum("product_warehouse_inventory"."loc_check_qty") AS "loc_check_qty", sum("product_warehouse_inventory"."rep_loc_check_qty") AS "rep_loc_check_qty", sum("product_warehouse_inventory"."min_product_uom_qty") AS "min_product_uom_qty", sum("product_warehouse_inventory"."max_product_uom_qty") AS "max_product_uom_qty", sum("product_warehouse_inventory"."last_intra_company_qty") AS "last_intra_company_qty", date_trunc(?, "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) AS "cron_last_stock_flag_update:month" from "product_warehouse_inventory" group by date_trunc(?, "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) order by "cron_last_stock_flag_update:month" limit ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 29 07 2 419ms 209ms 09 15 3s325ms 221ms 11 12 2s908ms 242ms 12 2 421ms 210ms -
SELECT min("product_warehouse_inventory".id) AS id, count("product_warehouse_inventory".id) AS "cron_last_stock_flag_update_count", sum("product_warehouse_inventory"."qty_available") AS "qty_available", sum("product_warehouse_inventory"."qty_reserve") AS "qty_reserve", sum("product_warehouse_inventory"."qty_on_order") AS "qty_on_order", sum("product_warehouse_inventory"."qty_on_perm_order") AS "qty_on_perm_order", sum("product_warehouse_inventory"."qty_shipped_not_invoiced") AS "qty_shipped_not_invoiced", sum("product_warehouse_inventory"."qty_in_transist") AS "qty_in_transist", sum("product_warehouse_inventory"."qty_available_last_year") AS "qty_available_last_year", sum("product_warehouse_inventory"."qty_mtd_sold") AS "qty_mtd_sold", sum("product_warehouse_inventory"."qty_ytd_sold") AS "qty_ytd_sold", sum("product_warehouse_inventory"."qty_ytd_transfer_another") AS "qty_ytd_transfer_another", sum("product_warehouse_inventory"."qty_ytd_lost_sales") AS "qty_ytd_lost_sales", sum("product_warehouse_inventory"."qty_last_receive") AS "qty_last_receive", sum("product_warehouse_inventory"."qty_sold_last_year") AS "qty_sold_last_year", sum("product_warehouse_inventory"."qty_ly_transfer_another") AS "qty_ly_transfer_another", sum("product_warehouse_inventory"."mon_1_qty") AS "mon_1_qty", sum("product_warehouse_inventory"."mon_2_qty") AS "mon_2_qty", sum("product_warehouse_inventory"."mon_3_qty") AS "mon_3_qty", sum("product_warehouse_inventory"."mon_4_qty") AS "mon_4_qty", sum("product_warehouse_inventory"."mon_5_qty") AS "mon_5_qty", sum("product_warehouse_inventory"."mon_6_qty") AS "mon_6_qty", sum("product_warehouse_inventory"."mon_7_qty") AS "mon_7_qty", sum("product_warehouse_inventory"."mon_8_qty") AS "mon_8_qty", sum("product_warehouse_inventory"."mon_9_qty") AS "mon_9_qty", sum("product_warehouse_inventory"."mon_10_qty") AS "mon_10_qty", sum("product_warehouse_inventory"."mon_11_qty") AS "mon_11_qty", sum("product_warehouse_inventory"."mon_12_qty") AS "mon_12_qty", sum("product_warehouse_inventory"."unit_cost") AS "unit_cost", sum("product_warehouse_inventory"."loc_check_qty") AS "loc_check_qty", sum("product_warehouse_inventory"."rep_loc_check_qty") AS "rep_loc_check_qty", sum("product_warehouse_inventory"."min_product_uom_qty") AS "min_product_uom_qty", sum("product_warehouse_inventory"."max_product_uom_qty") AS "max_product_uom_qty", sum("product_warehouse_inventory"."last_intra_company_qty") AS "last_intra_company_qty", date_trunc('month', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) as "cron_last_stock_flag_update:month" FROM "product_warehouse_inventory" GROUP BY date_trunc('month', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) ORDER BY "cron_last_stock_flag_update:month" LIMIT 80;
Date: 2023-05-29 11:09:22 Duration: 262ms
-
SELECT min("product_warehouse_inventory".id) AS id, count("product_warehouse_inventory".id) AS "cron_last_stock_flag_update_count", sum("product_warehouse_inventory"."qty_available") AS "qty_available", sum("product_warehouse_inventory"."qty_reserve") AS "qty_reserve", sum("product_warehouse_inventory"."qty_on_order") AS "qty_on_order", sum("product_warehouse_inventory"."qty_on_perm_order") AS "qty_on_perm_order", sum("product_warehouse_inventory"."qty_shipped_not_invoiced") AS "qty_shipped_not_invoiced", sum("product_warehouse_inventory"."qty_in_transist") AS "qty_in_transist", sum("product_warehouse_inventory"."qty_available_last_year") AS "qty_available_last_year", sum("product_warehouse_inventory"."qty_mtd_sold") AS "qty_mtd_sold", sum("product_warehouse_inventory"."qty_ytd_sold") AS "qty_ytd_sold", sum("product_warehouse_inventory"."qty_ytd_transfer_another") AS "qty_ytd_transfer_another", sum("product_warehouse_inventory"."qty_ytd_lost_sales") AS "qty_ytd_lost_sales", sum("product_warehouse_inventory"."qty_last_receive") AS "qty_last_receive", sum("product_warehouse_inventory"."qty_sold_last_year") AS "qty_sold_last_year", sum("product_warehouse_inventory"."qty_ly_transfer_another") AS "qty_ly_transfer_another", sum("product_warehouse_inventory"."mon_1_qty") AS "mon_1_qty", sum("product_warehouse_inventory"."mon_2_qty") AS "mon_2_qty", sum("product_warehouse_inventory"."mon_3_qty") AS "mon_3_qty", sum("product_warehouse_inventory"."mon_4_qty") AS "mon_4_qty", sum("product_warehouse_inventory"."mon_5_qty") AS "mon_5_qty", sum("product_warehouse_inventory"."mon_6_qty") AS "mon_6_qty", sum("product_warehouse_inventory"."mon_7_qty") AS "mon_7_qty", sum("product_warehouse_inventory"."mon_8_qty") AS "mon_8_qty", sum("product_warehouse_inventory"."mon_9_qty") AS "mon_9_qty", sum("product_warehouse_inventory"."mon_10_qty") AS "mon_10_qty", sum("product_warehouse_inventory"."mon_11_qty") AS "mon_11_qty", sum("product_warehouse_inventory"."mon_12_qty") AS "mon_12_qty", sum("product_warehouse_inventory"."unit_cost") AS "unit_cost", sum("product_warehouse_inventory"."loc_check_qty") AS "loc_check_qty", sum("product_warehouse_inventory"."rep_loc_check_qty") AS "rep_loc_check_qty", sum("product_warehouse_inventory"."min_product_uom_qty") AS "min_product_uom_qty", sum("product_warehouse_inventory"."max_product_uom_qty") AS "max_product_uom_qty", sum("product_warehouse_inventory"."last_intra_company_qty") AS "last_intra_company_qty", date_trunc('month', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) as "cron_last_stock_flag_update:month" FROM "product_warehouse_inventory" GROUP BY date_trunc('month', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) ORDER BY "cron_last_stock_flag_update:month" LIMIT 80;
Date: 2023-05-29 11:09:03 Duration: 261ms
-
SELECT min("product_warehouse_inventory".id) AS id, count("product_warehouse_inventory".id) AS "cron_last_stock_flag_update_count", sum("product_warehouse_inventory"."qty_available") AS "qty_available", sum("product_warehouse_inventory"."qty_reserve") AS "qty_reserve", sum("product_warehouse_inventory"."qty_on_order") AS "qty_on_order", sum("product_warehouse_inventory"."qty_on_perm_order") AS "qty_on_perm_order", sum("product_warehouse_inventory"."qty_shipped_not_invoiced") AS "qty_shipped_not_invoiced", sum("product_warehouse_inventory"."qty_in_transist") AS "qty_in_transist", sum("product_warehouse_inventory"."qty_available_last_year") AS "qty_available_last_year", sum("product_warehouse_inventory"."qty_mtd_sold") AS "qty_mtd_sold", sum("product_warehouse_inventory"."qty_ytd_sold") AS "qty_ytd_sold", sum("product_warehouse_inventory"."qty_ytd_transfer_another") AS "qty_ytd_transfer_another", sum("product_warehouse_inventory"."qty_ytd_lost_sales") AS "qty_ytd_lost_sales", sum("product_warehouse_inventory"."qty_last_receive") AS "qty_last_receive", sum("product_warehouse_inventory"."qty_sold_last_year") AS "qty_sold_last_year", sum("product_warehouse_inventory"."qty_ly_transfer_another") AS "qty_ly_transfer_another", sum("product_warehouse_inventory"."mon_1_qty") AS "mon_1_qty", sum("product_warehouse_inventory"."mon_2_qty") AS "mon_2_qty", sum("product_warehouse_inventory"."mon_3_qty") AS "mon_3_qty", sum("product_warehouse_inventory"."mon_4_qty") AS "mon_4_qty", sum("product_warehouse_inventory"."mon_5_qty") AS "mon_5_qty", sum("product_warehouse_inventory"."mon_6_qty") AS "mon_6_qty", sum("product_warehouse_inventory"."mon_7_qty") AS "mon_7_qty", sum("product_warehouse_inventory"."mon_8_qty") AS "mon_8_qty", sum("product_warehouse_inventory"."mon_9_qty") AS "mon_9_qty", sum("product_warehouse_inventory"."mon_10_qty") AS "mon_10_qty", sum("product_warehouse_inventory"."mon_11_qty") AS "mon_11_qty", sum("product_warehouse_inventory"."mon_12_qty") AS "mon_12_qty", sum("product_warehouse_inventory"."unit_cost") AS "unit_cost", sum("product_warehouse_inventory"."loc_check_qty") AS "loc_check_qty", sum("product_warehouse_inventory"."rep_loc_check_qty") AS "rep_loc_check_qty", sum("product_warehouse_inventory"."min_product_uom_qty") AS "min_product_uom_qty", sum("product_warehouse_inventory"."max_product_uom_qty") AS "max_product_uom_qty", sum("product_warehouse_inventory"."last_intra_company_qty") AS "last_intra_company_qty", date_trunc('month', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) as "cron_last_stock_flag_update:month" FROM "product_warehouse_inventory" GROUP BY date_trunc('month', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) ORDER BY "cron_last_stock_flag_update:month" LIMIT 80;
Date: 2023-05-29 11:09:08 Duration: 258ms
9 28 15s907ms 555ms 586ms 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 (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 29 15 13 7s335ms 564ms 18 15 8s572ms 571ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%4707Q%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4707Q%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%4707Q%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-29 18:02:31 Duration: 586ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%4707Q%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4707Q%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%4707Q%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-29 18:02:40 Duration: 584ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%4707Q%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4707Q%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%4707Q%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-29 18:02:36 Duration: 576ms
10 26 6s326ms 235ms 254ms 243ms select "account_move".id from "account_move" where ((("account_move"."move_type" in (...)) and (("account_move"."non_inventory_entry" = true) or ("account_move"."move_type" in (...)))) and (((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false)) and ("account_move"."company_id" is null or ("account_move"."company_id" in (...))) order by "account_move"."invoice_date_due" limit ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 29 14 1 251ms 251ms 15 25 6s74ms 242ms -
SELECT "account_move".id FROM "account_move" WHERE ((("account_move"."move_type" in ('in_invoice', 'in_refund')) AND (("account_move"."non_inventory_entry" = true) OR ("account_move"."move_type" in ('in_invoice', 'in_refund')))) AND (((((unaccent ("account_move"."name"::text) ilike unaccent ('%G-BILL-02462%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%G-BILL-02462%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%G-BILL-02462%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%G-BILL-02462%'))) OR FALSE)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-05-29 15:29:39 Duration: 254ms
-
SELECT "account_move".id FROM "account_move" WHERE ((("account_move"."move_type" in ('in_invoice', 'in_refund')) AND (("account_move"."non_inventory_entry" = true) OR ("account_move"."move_type" in ('in_invoice', 'in_refund')))) AND (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-BILL-03264%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-BILL-03264%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-BILL-03264%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-BILL-03264%'))) OR FALSE)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-05-29 15:26:06 Duration: 252ms
-
SELECT "account_move".id FROM "account_move" WHERE ((("account_move"."move_type" in ('in_invoice', 'in_refund')) AND (("account_move"."non_inventory_entry" = true) OR ("account_move"."move_type" in ('in_invoice', 'in_refund')))) AND (((((unaccent ("account_move"."name"::text) ilike unaccent ('%G-BILL-04345%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%G-BILL-04345%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%G-BILL-04345%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%G-BILL-04345%'))) OR FALSE)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-05-29 15:24:32 Duration: 251ms
11 26 4s702ms 177ms 204ms 180ms select res_partner.id from "res_partner" where ("res_partner"."active" = true) and (((("res_partner"."partner_share" is null or "res_partner"."partner_share" = false) or ("res_partner"."company_id" in (...))) or "res_partner"."company_id" is null) and (((("res_partner"."type" != ?) or "res_partner"."type" is null) or "res_partner"."type" is null) or ("res_partner"."type" = ?))) and (unaccent (res_partner.email) ilike unaccent (?) or unaccent (res_partner.display_name) ilike unaccent (?) or unaccent (res_partner.ref) ilike unaccent (?) or unaccent (res_partner.vat) ilike unaccent (?)) unaccent (res_partner.display_name);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 29 14 1 178ms 178ms 15 25 4s523ms 180ms -
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%V-BILL-01662%') OR unaccent (res_partner.display_name) ilike unaccent ('%V-BILL-01662%') OR unaccent (res_partner.ref) ilike unaccent ('%V-BILL-01662%') OR unaccent (res_partner.vat) ilike unaccent ('V-BILL-01662')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%V-BILL-01662%') desc, unaccent (res_partner.display_name);
Date: 2023-05-29 15:26:14 Duration: 204ms
-
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%T-BILL-03264%') OR unaccent (res_partner.display_name) ilike unaccent ('%T-BILL-03264%') OR unaccent (res_partner.ref) ilike unaccent ('%T-BILL-03264%') OR unaccent (res_partner.vat) ilike unaccent ('T-BILL-03264')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%T-BILL-03264%') desc, unaccent (res_partner.display_name);
Date: 2023-05-29 15:26:05 Duration: 182ms
-
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 ('%N-BILL-06632%') OR unaccent (res_partner.display_name) ilike unaccent ('%N-BILL-06632%') OR unaccent (res_partner.ref) ilike unaccent ('%N-BILL-06632%') OR unaccent (res_partner.vat) ilike unaccent ('N-BILL-06632')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%N-BILL-06632%') desc, unaccent (res_partner.display_name);
Date: 2023-05-29 15:30:04 Duration: 181ms
12 24 52s831ms 2s168ms 2s249ms 2s201ms select "stock_move".id from "stock_move" where (((unaccent ("stock_move"."origin"::text) ilike unaccent (?)) or (unaccent ("stock_move"."name"::text) ilike unaccent (?))) or ("stock_move"."picking_id" in ( select "stock_picking".id from "stock_picking" where (unaccent ("stock_picking"."name"::text) ilike unaccent (?)) and ("stock_picking"."company_id" in (...))))) and ("stock_move"."company_id" in (...)) order by "stock_move"."date" desc limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 29 11 1 2s249ms 2s249ms 13 15 33s11ms 2s200ms 14 8 17s569ms 2s196ms -
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%05-F/INT/04240%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%05-F/INT/04240%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/04240%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."date" DESC LIMIT 80;
Date: 2023-05-29 11:38:14 Duration: 2s249ms
-
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%05-F/INT/04065%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%05-F/INT/04065%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/04065%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."date" DESC LIMIT 80;
Date: 2023-05-29 13:41:18 Duration: 2s237ms
-
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%05-F/INT/04240%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%05-F/INT/04240%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/04240%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."date" DESC LIMIT 80;
Date: 2023-05-29 13:37:10 Duration: 2s227ms
13 22 3s9ms 126ms 193ms 136ms select count(?) from "product_warehouse_inventory" where (("product_warehouse_inventory"."stocking_flag" is null or "product_warehouse_inventory"."stocking_flag" = false) and ((("product_warehouse_inventory"."cron_last_stock_flag_update" >= ?) and ("product_warehouse_inventory"."cron_last_stock_flag_update" < ?)) and (("product_warehouse_inventory"."cron_last_stock_flag_update" >= ?) and ("product_warehouse_inventory"."cron_last_stock_flag_update" < ?))));Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 29 09 16 2s155ms 134ms 11 6 853ms 142ms -
SELECT count(1) FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."stocking_flag" IS NULL or "product_warehouse_inventory"."stocking_flag" = false) AND ((("product_warehouse_inventory"."cron_last_stock_flag_update" >= '2023-05-27') AND ("product_warehouse_inventory"."cron_last_stock_flag_update" < '2023-05-28')) AND (("product_warehouse_inventory"."cron_last_stock_flag_update" >= '2023-05-01') AND ("product_warehouse_inventory"."cron_last_stock_flag_update" < '2023-06-01'))));
Date: 2023-05-29 11:27:36 Duration: 193ms
-
SELECT count(1) FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."stocking_flag" IS NULL or "product_warehouse_inventory"."stocking_flag" = false) AND ((("product_warehouse_inventory"."cron_last_stock_flag_update" >= '2023-05-27') AND ("product_warehouse_inventory"."cron_last_stock_flag_update" < '2023-05-28')) AND (("product_warehouse_inventory"."cron_last_stock_flag_update" >= '2023-05-01') AND ("product_warehouse_inventory"."cron_last_stock_flag_update" < '2023-06-01'))));
Date: 2023-05-29 09:08:33 Duration: 147ms
-
SELECT count(1) FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."stocking_flag" IS NULL or "product_warehouse_inventory"."stocking_flag" = false) AND ((("product_warehouse_inventory"."cron_last_stock_flag_update" >= '2023-05-27') AND ("product_warehouse_inventory"."cron_last_stock_flag_update" < '2023-05-28')) AND (("product_warehouse_inventory"."cron_last_stock_flag_update" >= '2023-05-01') AND ("product_warehouse_inventory"."cron_last_stock_flag_update" < '2023-06-01'))));
Date: 2023-05-29 09:11:00 Duration: 144ms
14 20 2s615ms 123ms 140ms 130ms select "mail_message".id from "mail_message" where ((((("mail_message"."id" in ( select "mail_message_res_partner_needaction_rel"."mail_message_id" from "mail_message_res_partner_needaction_rel" where ("mail_message_res_partner_needaction_rel"."notification_status" in (...)))) and ("mail_message"."author_id" = ?)) and ("mail_message"."res_id" != ?)) and "mail_message"."model" is not null) and (("mail_message"."message_type" != ?) or "mail_message"."message_type" is null)) order by "mail_message"."id" desc;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 29 05 4 523ms 130ms 09 1 123ms 123ms 10 7 930ms 132ms 11 7 913ms 130ms 13 1 124ms 124ms -
SELECT "mail_message".id FROM "mail_message" WHERE ((((("mail_message"."id" in ( SELECT "mail_message_res_partner_needaction_rel"."mail_message_id" FROM "mail_message_res_partner_needaction_rel" WHERE ("mail_message_res_partner_needaction_rel"."notification_status" in ('bounce', 'exception')))) AND ("mail_message"."author_id" = 3)) AND ("mail_message"."res_id" != 0)) AND "mail_message"."model" IS NOT NULL) AND (("mail_message"."message_type" != 'user_notification') OR "mail_message"."message_type" IS NULL)) ORDER BY "mail_message"."id" DESC;
Date: 2023-05-29 05:10:52 Duration: 140ms
-
SELECT "mail_message".id FROM "mail_message" WHERE ((((("mail_message"."id" in ( SELECT "mail_message_res_partner_needaction_rel"."mail_message_id" FROM "mail_message_res_partner_needaction_rel" WHERE ("mail_message_res_partner_needaction_rel"."notification_status" in ('bounce', 'exception')))) AND ("mail_message"."author_id" = 3)) AND ("mail_message"."res_id" != 0)) AND "mail_message"."model" IS NOT NULL) AND (("mail_message"."message_type" != 'user_notification') OR "mail_message"."message_type" IS NULL)) ORDER BY "mail_message"."id" DESC;
Date: 2023-05-29 11:18:46 Duration: 138ms
-
SELECT "mail_message".id FROM "mail_message" WHERE ((((("mail_message"."id" in ( SELECT "mail_message_res_partner_needaction_rel"."mail_message_id" FROM "mail_message_res_partner_needaction_rel" WHERE ("mail_message_res_partner_needaction_rel"."notification_status" in ('bounce', 'exception')))) AND ("mail_message"."author_id" = 3)) AND ("mail_message"."res_id" != 0)) AND "mail_message"."model" IS NOT NULL) AND (("mail_message"."message_type" != 'user_notification') OR "mail_message"."message_type" IS NULL)) ORDER BY "mail_message"."id" DESC;
Date: 2023-05-29 11:18:12 Duration: 137ms
15 18 3s256ms 177ms 198ms 180ms select "product_template".id from "product_template" where (("product_template"."active" = true) and (("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, "product_template"."list_price" desc, "product_template"."id" desc;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 29 03 6 1s70ms 178ms 04 3 542ms 180ms 08 6 1s75ms 179ms 14 3 567ms 189ms -
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" DESC, "product_template"."id" DESC;
Date: 2023-05-29 14:52:24 Duration: 198ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" DESC, "product_template"."id" DESC;
Date: 2023-05-29 14:52:24 Duration: 184ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" DESC, "product_template"."id" DESC;
Date: 2023-05-29 14:52:24 Duration: 184ms
16 18 3s246ms 176ms 198ms 180ms select "product_template".id from "product_template" where (("product_template"."active" = true) and (("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, "product_template"."list_price" asc, "product_template"."id" desc;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 29 03 3 535ms 178ms 04 3 540ms 180ms 12 3 550ms 183ms 13 3 542ms 180ms 14 3 543ms 181ms 23 3 532ms 177ms -
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" ASC, "product_template"."id" DESC;
Date: 2023-05-29 12:19:34 Duration: 198ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" ASC, "product_template"."id" DESC;
Date: 2023-05-29 13:03:32 Duration: 182ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" ASC, "product_template"."id" DESC;
Date: 2023-05-29 14:52:24 Duration: 182ms
17 16 2s144ms 121ms 149ms 134ms select min("sale_report".id) as id, count("sale_report".id) AS "product_id_count", sum("sale_report"."product_uom_qty") AS "product_uom_qty", "sale_report"."product_id" AS "product_id" from "sale_report" left join "product_product" AS "sale_report__product_id" on ("sale_report"."product_id" = "sale_report__product_id"."id") left join "product_template" AS "sale_report__product_id__product_tmpl_id" on ("sale_report__product_id"."product_tmpl_id" = "sale_report__product_id__product_tmpl_id"."id") left join "ir_translation" AS "sale_report__product_id__product_tmpl_id__name" on ("sale_report__product_id__product_tmpl_id"."id" = "sale_report__product_id__product_tmpl_id__name"."res_id" and "sale_report__product_id__product_tmpl_id__name"."type" = ? and "sale_report__product_id__product_tmpl_id__name"."name" = ? and "sale_report__product_id__product_tmpl_id__name"."lang" = ? and "sale_report__product_id__product_tmpl_id__name"."value" != ?) where ((("sale_report"."state" in (...)) and ("sale_report"."product_id" in (...))) and ("sale_report"."date" >= ?)) and ("sale_report"."company_id" is null or ("sale_report"."company_id" in (...))) group by "sale_report"."product_id", "sale_report__product_id"."default_code", coalesce("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id" order by "sale_report__product_id"."default_code", coalesce("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id";Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 29 05 1 131ms 131ms 09 3 377ms 125ms 11 3 380ms 126ms 13 2 245ms 122ms 18 5 716ms 143ms 19 2 292ms 146ms -
SELECT min("sale_report".id) AS id, count("sale_report".id) AS "product_id_count", sum("sale_report"."product_uom_qty") AS "product_uom_qty", "sale_report"."product_id" as "product_id" FROM "sale_report" LEFT JOIN "product_product" AS "sale_report__product_id" ON ("sale_report"."product_id" = "sale_report__product_id"."id") LEFT JOIN "product_template" AS "sale_report__product_id__product_tmpl_id" ON ("sale_report__product_id"."product_tmpl_id" = "sale_report__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "sale_report__product_id__product_tmpl_id__name" ON ("sale_report__product_id__product_tmpl_id"."id" = "sale_report__product_id__product_tmpl_id__name"."res_id" AND "sale_report__product_id__product_tmpl_id__name"."type" = 'model' AND "sale_report__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "sale_report__product_id__product_tmpl_id__name"."lang" = 'en_US' AND "sale_report__product_id__product_tmpl_id__name"."value" != '') WHERE ((("sale_report"."state" in ('sale', 'done', 'paid')) AND ("sale_report"."product_id" in (237202))) AND ("sale_report"."date" >= '2022-05-29 00:00:00')) AND ("sale_report"."company_id" IS NULL OR ("sale_report"."company_id" in (1))) GROUP BY "sale_report"."product_id", "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id" ORDER BY "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id";
Date: 2023-05-29 18:53:51 Duration: 149ms
-
SELECT min("sale_report".id) AS id, count("sale_report".id) AS "product_id_count", sum("sale_report"."product_uom_qty") AS "product_uom_qty", "sale_report"."product_id" as "product_id" FROM "sale_report" LEFT JOIN "product_product" AS "sale_report__product_id" ON ("sale_report"."product_id" = "sale_report__product_id"."id") LEFT JOIN "product_template" AS "sale_report__product_id__product_tmpl_id" ON ("sale_report__product_id"."product_tmpl_id" = "sale_report__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "sale_report__product_id__product_tmpl_id__name" ON ("sale_report__product_id__product_tmpl_id"."id" = "sale_report__product_id__product_tmpl_id__name"."res_id" AND "sale_report__product_id__product_tmpl_id__name"."type" = 'model' AND "sale_report__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "sale_report__product_id__product_tmpl_id__name"."lang" = 'en_US' AND "sale_report__product_id__product_tmpl_id__name"."value" != '') WHERE ((("sale_report"."state" in ('sale', 'done', 'paid')) AND ("sale_report"."product_id" in (237202))) AND ("sale_report"."date" >= '2022-05-29 00:00:00')) AND ("sale_report"."company_id" IS NULL OR ("sale_report"."company_id" in (1))) GROUP BY "sale_report"."product_id", "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id" ORDER BY "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id";
Date: 2023-05-29 19:23:13 Duration: 147ms
-
SELECT min("sale_report".id) AS id, count("sale_report".id) AS "product_id_count", sum("sale_report"."product_uom_qty") AS "product_uom_qty", "sale_report"."product_id" as "product_id" FROM "sale_report" LEFT JOIN "product_product" AS "sale_report__product_id" ON ("sale_report"."product_id" = "sale_report__product_id"."id") LEFT JOIN "product_template" AS "sale_report__product_id__product_tmpl_id" ON ("sale_report__product_id"."product_tmpl_id" = "sale_report__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "sale_report__product_id__product_tmpl_id__name" ON ("sale_report__product_id__product_tmpl_id"."id" = "sale_report__product_id__product_tmpl_id__name"."res_id" AND "sale_report__product_id__product_tmpl_id__name"."type" = 'model' AND "sale_report__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "sale_report__product_id__product_tmpl_id__name"."lang" = 'en_US' AND "sale_report__product_id__product_tmpl_id__name"."value" != '') WHERE ((("sale_report"."state" in ('sale', 'done', 'paid')) AND ("sale_report"."product_id" in (237202))) AND ("sale_report"."date" >= '2022-05-29 00:00:00')) AND ("sale_report"."company_id" IS NULL OR ("sale_report"."company_id" in (1))) GROUP BY "sale_report"."product_id", "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id" ORDER BY "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id";
Date: 2023-05-29 18:43:35 Duration: 147ms
18 14 10s997ms 712ms 1s105ms 785ms select distinct ill.product_id from item_list_line as ill left join res_forecast_method as fm on fm.id = ill.method where ill.item_demand_plan_id = ? and ill.method not in (...);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 29 05 14 10s997ms 785ms -
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3658 and ill.method not in (8, 7);
Date: 2023-05-29 05:33:47 Duration: 1s105ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3658 and ill.method not in (8, 7);
Date: 2023-05-29 05:32:52 Duration: 876ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3658 and ill.method not in (8, 7);
Date: 2023-05-29 05:33:17 Duration: 856ms
19 14 10s653ms 725ms 859ms 760ms select count(id) as total_count from item_list_line where item_demand_plan_id = ? and active = true;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 29 05 14 10s653ms 760ms -
select count(id) as total_count from item_list_line where item_demand_plan_id = 3658 and active = True;
Date: 2023-05-29 05:32:50 Duration: 859ms
-
select count(id) as total_count from item_list_line where item_demand_plan_id = 3640 and active = True;
Date: 2023-05-29 05:15:44 Duration: 787ms
-
select count(id) as total_count from item_list_line where item_demand_plan_id = 3658 and active = True;
Date: 2023-05-29 05:34:16 Duration: 778ms
20 14 6s992ms 461ms 601ms 499ms select count(id) from item_list_line where item_demand_plan_id = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 29 05 14 6s992ms 499ms -
select count(id) from item_list_line where item_demand_plan_id = 3658;
Date: 2023-05-29 05:32:51 Duration: 601ms
-
select count(id) from item_list_line where item_demand_plan_id = 3658;
Date: 2023-05-29 05:33:39 Duration: 552ms
-
select count(id) from item_list_line where item_demand_plan_id = 3658;
Date: 2023-05-29 05:33:57 Duration: 520ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m39s 3m39s 3m39s 1 3m39s copy public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 29 09 1 3m39s 3m39s -
COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2023-05-29 09:06:42 Duration: 3m39s
2 1m7s 1m7s 1m7s 1 1m7s 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;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 29 09 1 1m7s 1m7s -
COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;
Date: 2023-05-29 09:03:02 Duration: 1m7s
3 1m4s 1m4s 1m4s 1 1m4s copy public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 29 09 1 1m4s 1m4s -
COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;
Date: 2023-05-29 09:01:52 Duration: 1m4s
4 21s477ms 21s477ms 21s477ms 1 21s477ms copy public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 29 09 1 21s477ms 21s477ms -
COPY public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) TO stdout;
Date: 2023-05-29 09:08:30 Duration: 21s477ms
5 21s81ms 21s81ms 21s81ms 1 21s81ms 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;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 29 09 1 21s81ms 21s81ms -
COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage) TO stdout;
Date: 2023-05-29 09:07:39 Duration: 21s81ms
6 17s546ms 17s546ms 17s546ms 1 17s546ms with data as ( select distinct shl.id as record, ?, shl.id as ref, ? as ref_code, shl.product_id as product_id, shl.invoice_date as invoice_date, shl.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, shl.selling_branch as selling_branch, st.id as warehouse_id, pt.method as method, now() at time zone ?, true from sale_history_line as shl left join stock_warehouse as st on st.branch_id = shl.selling_branch left join product_product as pp on pp.id = shl.product_id left join product_template as pt on pt.id = pp.product_tmpl_id left join product_warehouse_inventory as pwi on pwi.product_id = pp.id left join psd_custom_inventory_vendor as inv on inv.id = pt.inventory_vendor_id where shl.selling_branch = ? and shl.sales_obtain != ? and shl.product_id is not null and shl.exception_sale is not true and pt.never_stock = false and pt.discontinued = false and pt.is_core = false and shl.invoice_date >= ? and shl.invoice_date <= ? and pt.inventory_vendor_id not in (...) and pt.inventory_vendor_id in (...) and pp.id in (...) and pp.id not in (...) union all ( select distinct sol.id as record, ?, so.id as ref, ? as ref_code, sol.product_id as product_id, am.invoice_date as invoice_date, sol.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, so.branch_id as selling_branch, so.warehouse_id as warehouse_id, pt.method as method, now() at time zone ?, true from sale_order_line sol left join product_product as pp on sol.product_id = pp.id left join product_template as pt on pp.product_tmpl_id = pt.id left join psd_custom_inventory_vendor as inv on inv.id = pt.inventory_vendor_id left join sale_order as so on sol.order_id = so.id left join sale_order_line_invoice_rel as solrel on solrel.order_line_id = sol.id left join account_move_line as aml on aml.id = solrel.invoice_line_id left join account_move as am on am.id = aml.move_id left join product_warehouse_inventory as pwi on pwi.product_id = pp.id where sol.branch_id = ? and sol.product_id is not null and sol.exception_sale is not true and pt.never_stock = false and pt.discontinued = false and pt.is_core = false and am.invoice_date >= ? and am.invoice_date <= ? and so.state in (...) and pt.inventory_vendor_id not in (...) and pt.inventory_vendor_id in (...) and pp.id in (...) and pp.id not in (...)) union all ( select distinct sol.id as record, ?, so.id as ref, ? as ref_code, sol.product_id as product_id, so.date_order as invoice_date, sol.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, so.branch_id as selling_branch, so.warehouse_id as warehouse_id, pt.method as method, now() at time zone ?, true from sale_order_line sol left join product_product as pp on sol.product_id = pp.id left join product_template as pt on pp.product_tmpl_id = pt.id left join psd_custom_inventory_vendor as inv on inv.id = pt.inventory_vendor_id left join sale_order as so on sol.order_id = so.id left join product_warehouse_inventory as pwi on pwi.product_id = pp.id where sol.branch_id = ? and sol.product_id is not null and sol.exception_sale is not true and pt.never_stock = false and pt.discontinued = false and pt.is_core = false and so.date_order >= ? and so.date_order <= ? and so.state in (...) and pt.inventory_vendor_id not in (...) and pt.inventory_vendor_id in (...) and pp.id in (...) and pp.id not in (...)) union all ( select distinct rol.id as record, ?, ro.id as ref, ? as ref_code, rol.product_id as product_id, ro.create_date as invoice_date, rol.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, ro.branch_id as selling_branch, ro.warehouse_id as warehouse_id, pt.method as method, now() at time zone ?, true from repair_order ro left join repair_line as rol on ro.id = rol.repair_id left join product_product as pp on rol.product_id = pp.id left join product_template as pt on pp.product_tmpl_id = pt.id left join psd_custom_inventory_vendor as inv on inv.id = pt.inventory_vendor_id left join product_warehouse_inventory as pwi on pwi.product_id = pp.id where ro.state = ? and ro.branch_id = ? and rol.product_id is not null and pt.never_stock = false and pt.discontinued = false and pt.is_core = false and ro.create_date >= ? and ro.create_date <= ? and pt.inventory_vendor_id not in (...) and pt.inventory_vendor_id in (...) and pp.id in (...) and pp.id not in (...)) union all ( select distinct sm.id as record, ?, mrp.id as ref, ? as ref_code, sm.product_id as product_id, mrp.create_date as invoice_date, sm.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, mrp.branch_id as selling_branch, sm.warehouse_id as warehouse_id, pt.method as method, now() at time zone ?, true from mrp_production mrp left join stock_move as sm on sm.raw_material_production_id = mrp.id left join product_product as pp on sm.product_id = pp.id left join product_template as pt on pp.product_tmpl_id = pt.id left join psd_custom_inventory_vendor as inv on inv.id = pt.inventory_vendor_id left join product_warehouse_inventory as pwi on pwi.product_id = pp.id where mrp.state = ? and mrp.branch_id = ? and sm.product_id is not null and pt.never_stock = false and pt.discontinued = false and pt.is_core = false and mrp.create_date >= ? and mrp.create_date <= ? and pt.inventory_vendor_id not in (...) and pt.inventory_vendor_id in (...) and pp.id in (...) and pp.id not in (...))) insert into item_list_line (item_demand_plan_id, product_id, invoice_date, product_uom_qty, inventory_vendor_id, selling_branch, warehouse_id, method, ref_id, ref, create_date, active) ( select ?, data.product_id as product_id, data.invoice_date as invoice_date, data.product_uom_qty as product_uom_qty, data.inventory_vendor_id as inventory_vendor_id, data.selling_branch as selling_branch, data.warehouse_id as warehouse_id, brpm.method as method, data.ref as ref_id, data.ref_code as ref, now() at time zone ?, true from data left join branch_product_method as brpm on brpm.product_id = data.product_id and brpm.branch_id = ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 29 05 1 17s546ms 17s546ms -
with data as ( select distinct shl.id as record, 3658, shl.id as ref, 'Sales History' as ref_code, shl.product_id as product_id, shl.invoice_date as invoice_date, shl.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, shl.selling_branch as selling_branch, st.id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from sale_history_line as shl LEFT JOIN stock_warehouse as st ON st.branch_id = shl.selling_branch LEFT JOIN product_product as pp ON pp.id = shl.product_id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id where shl.selling_branch = 45 and shl.sales_obtain != 'direct' and shl.product_id is not null and shl.exception_sale IS NOT TRUE and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and shl.invoice_date >= '2017-05-29 09:29:11' and shl.invoice_date <= '2023-05-29 09:29:11' and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127, 3150) and pt.inventory_vendor_id in (2952) and pp.id in (213570) and pp.id not in (173262, 173641, 203690, 248601, 197227, 248600, 197276, 177378, 177880, 177884, 177882, 173212, 203223, 213290, 177891, 202435, 246006, 211212, 202687, 177894, 177886, 177893, 228248, 179147, 205525, 180400, 239522, 190908, 208958, 206627, 184051, 177878, 177908, 190525, 197274, 177949, 208957, 173230, 180730, 177896, 177743, 210626, 211219, 173229, 184510, 228263, 184439, 190593, 184001, 174022, 181017, 203231, 177853, 177876, 185902, 180735, 211229, 177917, 177924, 192883, 177927, 177926, 239420, 177923, 197267, 179148, 177861, 218905, 190531, 192957, 199642, 185145, 177948, 211201, 179986, 211206, 177890, 211207, 172767, 180822, 180397, 174026, 177885, 174246, 239405, 180879, 206638, 203681, 177900, 172689, 177892, 177872, 177887, 211202, 197240, 177068, 177947, 211220, 177873, 177899, 226991, 174233, 211233, 203674, 177922, 177901, 172796, 219122, 172835) UNION ALL ( select distinct sol.id as record, 3658, so.id as ref, 'Sale Order' as ref_code, sol.product_id as product_id, am.invoice_date as invoice_date, sol.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, so.branch_id as selling_branch, so.warehouse_id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from sale_order_line sol LEFT JOIN product_product as pp ON sol.product_id = pp.id LEFT JOIN product_template as pt ON pp.product_tmpl_id = pt.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id LEFT JOIN sale_order as so ON sol.order_id = so.id LEFT JOIN sale_order_line_invoice_rel as solrel ON solrel.order_line_id = sol.id LEFT JOIN account_move_line as aml ON aml.id = solrel.invoice_line_id LEFT JOIN account_move as am ON am.id = aml.move_id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id where sol.branch_id = 45 and sol.product_id is not null and sol.exception_sale IS NOT TRUE and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and am.invoice_date >= '2017-05-29 09:29:11' and am.invoice_date <= '2023-05-29 09:29:11' and so.state in ('done', 'sale') and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127, 3150) and pt.inventory_vendor_id in (2952) and pp.id in (213570) and pp.id not in (173262, 173641, 203690, 248601, 197227, 248600, 197276, 177378, 177880, 177884, 177882, 173212, 203223, 213290, 177891, 202435, 246006, 211212, 202687, 177894, 177886, 177893, 228248, 179147, 205525, 180400, 239522, 190908, 208958, 206627, 184051, 177878, 177908, 190525, 197274, 177949, 208957, 173230, 180730, 177896, 177743, 210626, 211219, 173229, 184510, 228263, 184439, 190593, 184001, 174022, 181017, 203231, 177853, 177876, 185902, 180735, 211229, 177917, 177924, 192883, 177927, 177926, 239420, 177923, 197267, 179148, 177861, 218905, 190531, 192957, 199642, 185145, 177948, 211201, 179986, 211206, 177890, 211207, 172767, 180822, 180397, 174026, 177885, 174246, 239405, 180879, 206638, 203681, 177900, 172689, 177892, 177872, 177887, 211202, 197240, 177068, 177947, 211220, 177873, 177899, 226991, 174233, 211233, 203674, 177922, 177901, 172796, 219122, 172835)) UNION ALL ( select distinct sol.id as record, 3658, so.id as ref, 'Sale Order' as ref_code, sol.product_id as product_id, so.date_order as invoice_date, sol.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, so.branch_id as selling_branch, so.warehouse_id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from sale_order_line sol LEFT JOIN product_product as pp ON sol.product_id = pp.id LEFT JOIN product_template as pt ON pp.product_tmpl_id = pt.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id LEFT JOIN sale_order as so ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id where sol.branch_id = 45 and sol.product_id is not null and sol.exception_sale IS NOT TRUE and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and so.date_order >= '2017-05-29 09:29:11' and so.date_order <= '2023-05-29 09:29:11' and so.state in ('permanent_order') and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127, 3150) and pt.inventory_vendor_id in (2952) and pp.id in (213570) and pp.id not in (173262, 173641, 203690, 248601, 197227, 248600, 197276, 177378, 177880, 177884, 177882, 173212, 203223, 213290, 177891, 202435, 246006, 211212, 202687, 177894, 177886, 177893, 228248, 179147, 205525, 180400, 239522, 190908, 208958, 206627, 184051, 177878, 177908, 190525, 197274, 177949, 208957, 173230, 180730, 177896, 177743, 210626, 211219, 173229, 184510, 228263, 184439, 190593, 184001, 174022, 181017, 203231, 177853, 177876, 185902, 180735, 211229, 177917, 177924, 192883, 177927, 177926, 239420, 177923, 197267, 179148, 177861, 218905, 190531, 192957, 199642, 185145, 177948, 211201, 179986, 211206, 177890, 211207, 172767, 180822, 180397, 174026, 177885, 174246, 239405, 180879, 206638, 203681, 177900, 172689, 177892, 177872, 177887, 211202, 197240, 177068, 177947, 211220, 177873, 177899, 226991, 174233, 211233, 203674, 177922, 177901, 172796, 219122, 172835)) UNION ALL ( select distinct rol.id as record, 3658, ro.id as ref, 'Repair Orders' as ref_code, rol.product_id as product_id, ro.create_date as invoice_date, rol.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, ro.branch_id as selling_branch, ro.warehouse_id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from repair_order ro LEFT JOIN repair_line as rol ON ro.id = rol.repair_id LEFT JOIN product_product as pp ON rol.product_id = pp.id LEFT JOIN product_template as pt ON pp.product_tmpl_id = pt.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id where ro.state = 'done' and ro.branch_id = 45 and rol.product_id is not null and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and ro.create_date >= '2017-05-29 09:29:11' and ro.create_date <= '2023-05-29 09:29:11' and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127, 3150) and pt.inventory_vendor_id in (2952) and pp.id in (213570) and pp.id not in (173262, 173641, 203690, 248601, 197227, 248600, 197276, 177378, 177880, 177884, 177882, 173212, 203223, 213290, 177891, 202435, 246006, 211212, 202687, 177894, 177886, 177893, 228248, 179147, 205525, 180400, 239522, 190908, 208958, 206627, 184051, 177878, 177908, 190525, 197274, 177949, 208957, 173230, 180730, 177896, 177743, 210626, 211219, 173229, 184510, 228263, 184439, 190593, 184001, 174022, 181017, 203231, 177853, 177876, 185902, 180735, 211229, 177917, 177924, 192883, 177927, 177926, 239420, 177923, 197267, 179148, 177861, 218905, 190531, 192957, 199642, 185145, 177948, 211201, 179986, 211206, 177890, 211207, 172767, 180822, 180397, 174026, 177885, 174246, 239405, 180879, 206638, 203681, 177900, 172689, 177892, 177872, 177887, 211202, 197240, 177068, 177947, 211220, 177873, 177899, 226991, 174233, 211233, 203674, 177922, 177901, 172796, 219122, 172835)) UNION ALL ( select distinct sm.id as record, 3658, mrp.id as ref, 'Manufacturing Orders' as ref_code, sm.product_id as product_id, mrp.create_date as invoice_date, sm.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, mrp.branch_id as selling_branch, sm.warehouse_id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from mrp_production mrp LEFT JOIN stock_move as sm ON sm.raw_material_production_id = mrp.id LEFT JOIN product_product as pp ON sm.product_id = pp.id LEFT JOIN product_template as pt ON pp.product_tmpl_id = pt.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id where mrp.state = 'done' and mrp.branch_id = 45 and sm.product_id is not null and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and mrp.create_date >= '2017-05-29 09:29:11' and mrp.create_date <= '2023-05-29 09:29:11' and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127, 3150) and pt.inventory_vendor_id in (2952) and pp.id in (213570) and pp.id not in (173262, 173641, 203690, 248601, 197227, 248600, 197276, 177378, 177880, 177884, 177882, 173212, 203223, 213290, 177891, 202435, 246006, 211212, 202687, 177894, 177886, 177893, 228248, 179147, 205525, 180400, 239522, 190908, 208958, 206627, 184051, 177878, 177908, 190525, 197274, 177949, 208957, 173230, 180730, 177896, 177743, 210626, 211219, 173229, 184510, 228263, 184439, 190593, 184001, 174022, 181017, 203231, 177853, 177876, 185902, 180735, 211229, 177917, 177924, 192883, 177927, 177926, 239420, 177923, 197267, 179148, 177861, 218905, 190531, 192957, 199642, 185145, 177948, 211201, 179986, 211206, 177890, 211207, 172767, 180822, 180397, 174026, 177885, 174246, 239405, 180879, 206638, 203681, 177900, 172689, 177892, 177872, 177887, 211202, 197240, 177068, 177947, 211220, 177873, 177899, 226991, 174233, 211233, 203674, 177922, 177901, 172796, 219122, 172835))) insert into item_list_line (item_demand_plan_id, product_id, invoice_date, product_uom_qty, inventory_vendor_id, selling_branch, warehouse_id, method, ref_id, ref, create_date, active) ( select 3658, data.product_id as product_id, data.invoice_date as invoice_date, data.product_uom_qty as product_uom_qty, data.inventory_vendor_id as inventory_vendor_id, data.selling_branch as selling_branch, data.warehouse_id as warehouse_id, brpm.method as method, data.ref as ref_id, data.ref_code as ref, now() at time zone 'UTC', True from data LEFT JOIN branch_product_method as brpm ON brpm.product_id = data.product_id and brpm.branch_id = 45);
Date: 2023-05-29 05:33:13 Duration: 17s546ms
7 13s10ms 13s10ms 13s10ms 1 13s10ms copy public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 29 09 1 13s10ms 13s10ms -
COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;
Date: 2023-05-29 09:08:09 Duration: 13s10ms
8 12s649ms 12s649ms 12s649ms 1 12s649ms copy public.account_move_line (id, move_id, move_name, date, ref, parent_state, journal_id, company_id, company_currency_id, account_id, account_root_id, sequence, name, quantity, price_unit, discount, debit, credit, balance, amount_currency, price_subtotal, price_total, reconciled, blocked, date_maturity, currency_id, partner_id, product_uom_id, product_id, reconcile_model_id, payment_id, statement_line_id, statement_id, tax_line_id, tax_group_id, tax_base_amount, tax_exigible, tax_repartition_line_id, tax_audit, amount_residual, amount_residual_currency, full_reconcile_id, matching_number, analytic_account_id, display_type, is_rounding_line, exclude_from_invoice_tab, create_uid, create_date, write_uid, write_date, expected_pay_date, internal_note, next_action_date, followup_line_id, followup_date, is_anglo_saxon_line, purchase_line_id, branch_id, branch_name, vehicle_id, move_options, sign_product_qty, sign_price_subtotal, new_product_qty, sale_line_id, child_sale_line_id, main_invoice_line_id, core_bank_transaction, is_rtv_line, core_qty, rebate_amount, cost_price, is_visible_in_report, is_labour, can_be_paid, bal_core_bank_id, repair_line_id, inv_back_order_qty, sale_back_order_qty, product_pricelist_item_id) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 29 09 1 12s649ms 12s649ms -
COPY public.account_move_line (id, move_id, move_name, date, ref, parent_state, journal_id, company_id, company_currency_id, account_id, account_root_id, sequence, name, quantity, price_unit, discount, debit, credit, balance, amount_currency, price_subtotal, price_total, reconciled, blocked, date_maturity, currency_id, partner_id, product_uom_id, product_id, reconcile_model_id, payment_id, statement_line_id, statement_id, tax_line_id, tax_group_id, tax_base_amount, tax_exigible, tax_repartition_line_id, tax_audit, amount_residual, amount_residual_currency, full_reconcile_id, matching_number, analytic_account_id, display_type, is_rounding_line, exclude_from_invoice_tab, create_uid, create_date, write_uid, write_date, expected_pay_date, internal_note, next_action_date, followup_line_id, followup_date, is_anglo_saxon_line, purchase_line_id, branch_id, branch_name, vehicle_id, move_options, sign_product_qty, sign_price_subtotal, new_product_qty, sale_line_id, child_sale_line_id, main_invoice_line_id, core_bank_transaction, is_rtv_line, core_qty, rebate_amount, cost_price, is_visible_in_report, is_labour, can_be_paid, bal_core_bank_id, repair_line_id, inv_back_order_qty, sale_back_order_qty, product_pricelist_item_id) TO stdout;
Date: 2023-05-29 09:00:22 Duration: 12s649ms
9 9s109ms 9s109ms 9s109ms 1 9s109ms copy public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 29 09 1 9s109ms 9s109ms -
COPY public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2023-05-29 09:00:33 Duration: 9s109ms
10 8s399ms 8s399ms 8s399ms 1 8s399ms select "account_move_line".id from "account_move_line" where (((("account_move_line"."display_type" not in (...)) or "account_move_line"."display_type" is null) and (("account_move_line"."parent_state" != ?) or "account_move_line"."parent_state" is null)) and (("account_move_line"."parent_state" = ?) and ((((unaccent ("account_move_line"."name"::text) ilike unaccent (?)) or (unaccent ("account_move_line"."ref"::text) ilike unaccent (?))) or ("account_move_line"."account_id" in ( select "account_account".id from "account_account" left join "res_company" AS "account_account__company_id" on ("account_account"."company_id" = "account_account__company_id"."id") where ((unaccent ("account_account"."code"::text) ilike unaccent (?)) or (unaccent ("account_account"."name"::text) ilike unaccent (?))) and ("account_account"."company_id" is null or ("account_account"."company_id" in (...)))))) or false))) and ("account_move_line"."company_id" is null or ("account_move_line"."company_id" in (...))) order by "account_move_line"."date" desc, "account_move_line"."move_name" desc, "account_move_line"."id", "account_move_line"."id" limit ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 29 14 1 8s399ms 8s399ms -
SELECT "account_move_line".id FROM "account_move_line" WHERE (((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line"."parent_state" != 'cancel') OR "account_move_line"."parent_state" IS NULL)) AND (("account_move_line"."parent_state" = 'posted') AND ((((unaccent ("account_move_line"."name"::text) ilike unaccent ('%V-BILL-00773%')) OR (unaccent ("account_move_line"."ref"::text) ilike unaccent ('%V-BILL-00773%'))) OR ("account_move_line"."account_id" in ( SELECT "account_account".id FROM "account_account" LEFT JOIN "res_company" AS "account_account__company_id" ON ("account_account"."company_id" = "account_account__company_id"."id") WHERE ((unaccent ("account_account"."code"::text) ilike unaccent ('V-BILL-00773%')) OR (unaccent ("account_account"."name"::text) ilike unaccent ('%V-BILL-00773%'))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in (1)))))) OR FALSE))) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) ORDER BY "account_move_line"."date" DESC, "account_move_line"."move_name" DESC, "account_move_line"."id", "account_move_line"."id" LIMIT 80;
Date: 2023-05-29 14:42:18 Duration: 8s399ms
11 1s444ms 4s65ms 2s825ms 7 19s779ms select "ir_model_fields".id from "ir_model_fields" where ("ir_model_fields"."model" = ?) order by "ir_model_fields"."name";Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 29 10 1 1s444ms 1s444ms 11 6 18s335ms 3s55ms -
SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.template') ORDER BY "ir_model_fields"."name";
Date: 2023-05-29 11:22:07 Duration: 4s65ms
-
SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.template') ORDER BY "ir_model_fields"."name";
Date: 2023-05-29 11:23:50 Duration: 3s901ms
-
SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.template') ORDER BY "ir_model_fields"."name";
Date: 2023-05-29 11:22:07 Duration: 3s7ms
12 2s168ms 2s249ms 2s201ms 24 52s831ms select "stock_move".id from "stock_move" where (((unaccent ("stock_move"."origin"::text) ilike unaccent (?)) or (unaccent ("stock_move"."name"::text) ilike unaccent (?))) or ("stock_move"."picking_id" in ( select "stock_picking".id from "stock_picking" where (unaccent ("stock_picking"."name"::text) ilike unaccent (?)) and ("stock_picking"."company_id" in (...))))) and ("stock_move"."company_id" in (...)) order by "stock_move"."date" desc limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 29 11 1 2s249ms 2s249ms 13 15 33s11ms 2s200ms 14 8 17s569ms 2s196ms -
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%05-F/INT/04240%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%05-F/INT/04240%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/04240%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."date" DESC LIMIT 80;
Date: 2023-05-29 11:38:14 Duration: 2s249ms
-
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%05-F/INT/04065%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%05-F/INT/04065%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/04065%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."date" DESC LIMIT 80;
Date: 2023-05-29 13:41:18 Duration: 2s237ms
-
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%05-F/INT/04240%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%05-F/INT/04240%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/04240%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."date" DESC LIMIT 80;
Date: 2023-05-29 13:37:10 Duration: 2s227ms
13 162ms 8s5ms 1s940ms 11 21s346ms delete from ir_attachment where id in ( select id from ir_attachment where id in (...) for no key update skip locked);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 29 11 11 21s346ms 1s940ms -
DELETE FROM ir_attachment WHERE id IN ( SELECT id FROM ir_attachment WHERE id in (2771992) FOR NO KEY UPDATE SKIP LOCKED);
Date: 2023-05-29 11:23:36 Duration: 8s5ms
-
DELETE FROM ir_attachment WHERE id IN ( SELECT id FROM ir_attachment WHERE id in (2771886) FOR NO KEY UPDATE SKIP LOCKED);
Date: 2023-05-29 11:17:02 Duration: 6s224ms
-
DELETE FROM ir_attachment WHERE id IN ( SELECT id FROM ir_attachment WHERE id in (2771974) FOR NO KEY UPDATE SKIP LOCKED);
Date: 2023-05-29 11:21:53 Duration: 2s477ms
14 712ms 1s105ms 785ms 14 10s997ms select distinct ill.product_id from item_list_line as ill left join res_forecast_method as fm on fm.id = ill.method where ill.item_demand_plan_id = ? and ill.method not in (...);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 29 05 14 10s997ms 785ms -
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3658 and ill.method not in (8, 7);
Date: 2023-05-29 05:33:47 Duration: 1s105ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3658 and ill.method not in (8, 7);
Date: 2023-05-29 05:32:52 Duration: 876ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3658 and ill.method not in (8, 7);
Date: 2023-05-29 05:33:17 Duration: 856ms
15 725ms 859ms 760ms 14 10s653ms select count(id) as total_count from item_list_line where item_demand_plan_id = ? and active = true;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 29 05 14 10s653ms 760ms -
select count(id) as total_count from item_list_line where item_demand_plan_id = 3658 and active = True;
Date: 2023-05-29 05:32:50 Duration: 859ms
-
select count(id) as total_count from item_list_line where item_demand_plan_id = 3640 and active = True;
Date: 2023-05-29 05:15:44 Duration: 787ms
-
select count(id) as total_count from item_list_line where item_demand_plan_id = 3658 and active = True;
Date: 2023-05-29 05:34:16 Duration: 778ms
16 555ms 586ms 568ms 28 15s907ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 29 15 13 7s335ms 564ms 18 15 8s572ms 571ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%4707Q%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4707Q%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%4707Q%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-29 18:02:31 Duration: 586ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%4707Q%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4707Q%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%4707Q%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-29 18:02:40 Duration: 584ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%4707Q%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4707Q%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%4707Q%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-05-29 18:02:36 Duration: 576ms
17 461ms 601ms 499ms 14 6s992ms select count(id) from item_list_line where item_demand_plan_id = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 29 05 14 6s992ms 499ms -
select count(id) from item_list_line where item_demand_plan_id = 3658;
Date: 2023-05-29 05:32:51 Duration: 601ms
-
select count(id) from item_list_line where item_demand_plan_id = 3658;
Date: 2023-05-29 05:33:39 Duration: 552ms
-
select count(id) from item_list_line where item_demand_plan_id = 3658;
Date: 2023-05-29 05:33:57 Duration: 520ms
18 241ms 315ms 250ms 36 9s22ms 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"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, coalesce("product_template__name"."value", "product_template"."name") desc, "product_template"."id" desc;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 29 03 18 4s495ms 249ms 04 6 1s571ms 261ms 05 6 1s464ms 244ms 06 3 733ms 244ms 14 3 758ms 252ms -
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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2023-05-29 04:53:02 Duration: 315ms
-
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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2023-05-29 03:01:59 Duration: 261ms
-
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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2023-05-29 04:53:03 Duration: 260ms
19 240ms 309ms 250ms 33 8s264ms 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"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, coalesce("product_template__name"."value", "product_template"."name") asc, "product_template"."id" desc;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 29 03 15 3s732ms 248ms 04 12 3s41ms 253ms 06 3 727ms 242ms 14 3 763ms 254ms -
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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2023-05-29 04:57:19 Duration: 309ms
-
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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2023-05-29 03:00:43 Duration: 276ms
-
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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2023-05-29 04:51:44 Duration: 262ms
20 235ms 254ms 243ms 26 6s326ms select "account_move".id from "account_move" where ((("account_move"."move_type" in (...)) and (("account_move"."non_inventory_entry" = true) or ("account_move"."move_type" in (...)))) and (((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false)) and ("account_move"."company_id" is null or ("account_move"."company_id" in (...))) order by "account_move"."invoice_date_due" limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 29 14 1 251ms 251ms 15 25 6s74ms 242ms -
SELECT "account_move".id FROM "account_move" WHERE ((("account_move"."move_type" in ('in_invoice', 'in_refund')) AND (("account_move"."non_inventory_entry" = true) OR ("account_move"."move_type" in ('in_invoice', 'in_refund')))) AND (((((unaccent ("account_move"."name"::text) ilike unaccent ('%G-BILL-02462%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%G-BILL-02462%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%G-BILL-02462%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%G-BILL-02462%'))) OR FALSE)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-05-29 15:29:39 Duration: 254ms
-
SELECT "account_move".id FROM "account_move" WHERE ((("account_move"."move_type" in ('in_invoice', 'in_refund')) AND (("account_move"."non_inventory_entry" = true) OR ("account_move"."move_type" in ('in_invoice', 'in_refund')))) AND (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-BILL-03264%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-BILL-03264%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-BILL-03264%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-BILL-03264%'))) OR FALSE)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-05-29 15:26:06 Duration: 252ms
-
SELECT "account_move".id FROM "account_move" WHERE ((("account_move"."move_type" in ('in_invoice', 'in_refund')) AND (("account_move"."non_inventory_entry" = true) OR ("account_move"."move_type" in ('in_invoice', 'in_refund')))) AND (((((unaccent ("account_move"."name"::text) ilike unaccent ('%G-BILL-04345%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%G-BILL-04345%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%G-BILL-04345%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%G-BILL-04345%'))) OR FALSE)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-05-29 15:24:32 Duration: 251ms
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
- 27,989 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 4040 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 3,209 Max number of times the same event was reported
- 4,040 Total events found
Rank Times reported Error 1 3,209 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #1
Day Hour Count May 29 00 325 01 200 02 163 03 165 04 147 05 304 06 290 07 289 08 203 09 264 10 209 11 154 12 268 13 146 14 33 15 1 22 1 23 47 - ERROR: could not serialize access due to concurrent update
Statement: DELETE FROM ir_attachment WHERE id IN ( SELECT id FROM ir_attachment WHERE id in (2764112) FOR NO KEY UPDATE SKIP LOCKED )
Date: 2023-05-29 05:21:50
2 691 ERROR: could not obtain lock on row in relation "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count May 29 00 46 01 45 02 46 03 44 04 46 05 40 06 43 07 59 08 48 09 45 10 13 11 17 12 9 13 9 14 10 15 14 16 10 17 12 18 11 19 8 20 12 21 9 22 49 23 46 - ERROR: could not obtain lock on row in relation "ir_cron"
Statement: SELECT * FROM ir_cron WHERE numbercall != 0 AND active AND nextcall <= (now() at time zone 'UTC') AND id=48 FOR UPDATE NOWAIT
Date: 2023-05-29 05:30:08
3 99 ERROR: current transaction is aborted, commands ignored until end of transaction block
Times Reported Most Frequent Error / Event #3
Day Hour Count May 29 00 11 01 6 02 6 03 12 04 6 05 11 06 5 07 2 08 4 09 9 10 11 11 5 12 7 13 3 23 1 - ERROR: current transaction is aborted, commands ignored until end of transaction block
Statement: SELECT "ir_ui_view".id FROM "ir_ui_view" LEFT JOIN "website" AS "ir_ui_view__website_id" ON ("ir_ui_view"."website_id" = "ir_ui_view__website_id"."id") WHERE (("ir_ui_view"."active" = true) AND (("ir_ui_view"."key" = 'http_routing.http_error') AND (("ir_ui_view"."website_id" in (1)) OR "ir_ui_view"."website_id" IS NULL))) ORDER BY "ir_ui_view__website_id"."id" LIMIT 1
Date: 2023-05-29 05:28:16
4 8 LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #4
Day Hour Count May 29 10 1 11 7 - ERROR: process 2335115 still waiting for AccessShareLock on relation 43699 of database 65946 after 1000.047 ms at character 34
- ERROR: process 2342186 still waiting for AccessShareLock on relation 43699 of database 65946 after 1000.064 ms at character 34
- ERROR: process 2342693 still waiting for AccessShareLock on relation 43699 of database 65946 after 1000.063 ms at character 34
Detail: Process holding the lock: 2335958. Wait queue: 2335115.
Statement: SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.template') ORDER BY "ir_model_fields"."name"Date: 2023-05-29 10:58:31
Detail: Process holding the lock: 2342515. Wait queue: 2342186, 2342693.
Statement: SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'product.template') ORDER BY "ir_model_fields"."name"Date: 2023-05-29 11:17:15
Detail: Process holding the lock: 2342515. Wait queue: 2342186, 2342693.
Statement: SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = 'psd_custom.inventory_vendor') ORDER BY "ir_model_fields"."name"Date: 2023-05-29 11:17:15
5 8 ERROR: could not create unique index "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count May 29 10 2 11 6 - ERROR: could not create unique index "vendor_account_master_unique_acc_no"
Detail: Key (account_number)=(P10394) is duplicated.
Statement: ALTER TABLE "vendor_account_master" ADD CONSTRAINT "vendor_account_master_unique_acc_no" unique (account_number)Date: 2023-05-29 10:58:07
6 5 ERROR: column "..." must appear in the GROUP BY clause or be used in an aggregate function
Times Reported Most Frequent Error / Event #6
Day Hour Count May 29 15 2 18 2 19 1 - ERROR: column "t.id" must appear in the GROUP BY clause or be used in an aggregate function at character 585
- ERROR: column "m.res_id" must appear in the GROUP BY clause or be used in an aggregate function at character 17
- ERROR: column "pw.product_id" must appear in the GROUP BY clause or be used in an aggregate function at character 44
Statement: select count(t.id) from mail_tracking_value t inner join mail_message m on m.id = t.mail_message_id where m.res_id in (select mv.id from account_move mv inner join account_move_purchase_order_rel rel on rel.account_move_id = mv.id inner join purchase_order po on po.id = rel.purchase_order_id inner join res_partner res on res.id = po.partner_id where po.partner_id != mv.partner_id and mv.move_type in ('in_invoice', 'in_refund') and res.type not in ('contact','other') and res.commercial_partner_id != 30496 order by res.name) and m.model= 'account.move'and t.field = 3794 order by t.id desc ;
Date: 2023-05-29 15:40:21
Statement: select distinct(m.res_id) from mail_tracking_value t inner join mail_message m on m.id = t.mail_message_id where m.res_id in (select mv.id from account_move mv inner join account_move_purchase_order_rel rel on rel.account_move_id = mv.id inner join purchase_order po on po.id = rel.purchase_order_id inner join res_partner res on res.id = po.partner_id where po.partner_id != mv.partner_id and mv.move_type in ('in_invoice', 'in_refund') and res.type not in ('contact','other') and res.commercial_partner_id != 30496 order by res.name) and m.model= 'account.move'and t.field = 3794 group by t.id ;
Date: 2023-05-29 15:41:28
Statement: select sum(sm.product_uom_qty) as mtd_sold,pw.product_id ,pw.warehouse_id from product_warehouse_inventory as pw left join stock_move as sm on pw.product_id = sm.product_id and pw.warehouse_id =sm.warehouse_id and pw.company_id = sm.company_id and sm.location_dest_id in (5,15) and sm.state ='done' and date >= (select date_trunc('MONTH',now())::DATE) and date<=(select date_trunc('month', now()) + interval '1 month - 1 day' ::interval+'23hours 59minutes 59seconds'::interval as end_of_month) and pw.product_id = 237202 and pw.warehouse_id = 41 ;
Date: 2023-05-29 18:54:25
7 5 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count May 29 15 5 - ERROR: column m.field_id does not exist at character 149
- ERROR: column m.field does not exist at character 149
- ERROR: column m._res_id does not exist at character 593
Statement: select * from mail_tracking_value t inner join mail_message m on m.id = t.mail_message_id where m.res_id in (633290) and m.model= 'account.move'and m.field_id = 3794 order by t.id desc;
Date: 2023-05-29 15:36:10
Hint: Perhaps you meant to reference the column "t.field".
Statement: select * from mail_tracking_value t inner join mail_message m on m.id = t.mail_message_id where m.res_id in (633290) and m.model= 'account.move'and m.field = 3794 order by t.id desc;Date: 2023-05-29 15:36:35
Hint: Perhaps you meant to reference the column "m.res_id".
Statement: select distinct(m.res_id) from mail_tracking_value t inner join mail_message m on m.id = t.mail_message_id where m.res_id in (select mv.id from account_move mv inner join account_move_purchase_order_rel rel on rel.account_move_id = mv.id inner join purchase_order po on po.id = rel.purchase_order_id inner join res_partner res on res.id = po.partner_id where po.partner_id != mv.partner_id and mv.move_type in ('in_invoice', 'in_refund') and res.type not in ('contact','other') and res.commercial_partner_id != 30496 order by res.name) and m.model= 'account.move'and t.field = 3794 group by m._res_id;Date: 2023-05-29 15:41:46
8 4 LOG: process ... still waiting for RowExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #8
Day Hour Count May 29 11 4 - ERROR: process 2342487 still waiting for RowExclusiveLock on relation 42418 of database 65946 after 1000.046 ms
- ERROR: process 2343234 still waiting for RowExclusiveLock on relation 42418 of database 65946 after 1000.042 ms
- ERROR: process 2343109 still waiting for RowExclusiveLock on relation 42418 of database 65946 after 1000.051 ms
Detail: Process holding the lock: 2342515. Wait queue: 2342487.
Statement: DELETE FROM ir_attachment WHERE id IN ( SELECT id FROM ir_attachment WHERE id in (2771886) FOR NO KEY UPDATE SKIP LOCKED )Date: 2023-05-29 11:16:56
Detail: Process holding the lock: 2342417. Wait queue: 2343234.
Statement: DELETE FROM ir_attachment WHERE id IN ( SELECT id FROM ir_attachment WHERE id in (2771974) FOR NO KEY UPDATE SKIP LOCKED )Date: 2023-05-29 11:21:52
Detail: Process holding the lock: 2342417. Wait queue: 2343109.
Statement: DELETE FROM ir_attachment WHERE id IN ( SELECT id FROM ir_attachment WHERE id in (2771975) FOR NO KEY UPDATE SKIP LOCKED )Date: 2023-05-29 11:21:57
9 3 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count May 29 15 2 18 1 - ERROR: syntax error at or near "select" at character 35
- ERROR: syntax error at or near "l" at character 593
- ERROR: syntax error at or near ")" at character 594
Statement: select mv.id from account_move mv select mv.id from account_move mv inner join account_move_purchase_order_rel rel on rel.account_move_id = mv.id inner join purchase_order po on po.id = rel.purchase_order_id inner join res_partner res on res.id = po.partner_id where po.partner_id != mv.partner_id and mv.move_type in ('in_invoice', 'in_refund') and res.type not in ('contact','other') and res.commercial_partner_id != 30496 order by res.name;
Date: 2023-05-29 15:37:54
Statement: select count(id) from mail_tracking_value t inner join mail_message m on m.id = t.mail_message_id where m.res_id in (select mv.id from account_move mv inner join account_move_purchase_order_rel rel on rel.account_move_id = mv.id inner join purchase_order po on po.id = rel.purchase_order_id inner join res_partner res on res.id = po.partner_id where po.partner_id != mv.partner_id and mv.move_type in ('in_invoice', 'in_refund') and res.type not in ('contact','other') and res.commercial_partner_id != 30496 order by res.name) and m.model= 'account.move'and t.field = 3794 order by t.id desc l ;
Date: 2023-05-29 15:40:05
Statement: select sum(sm.product_uom_qty) as mtd_return,pw.product_id ,pw.warehouse_id from product_warehouse_inventory as pw left join stock_move as sm on pw.product_id = sm.product_id and pw.warehouse_id =sm.warehouse_id and pw.company_id = sm.company_id and sm.location_id in (5,15) and sm.state ='done' and date >= (select date_trunc('MONTH',now())::DATE) and date<=(select date_trunc('month', now()) + interval '1 month - 1 day' ::interval+'23hours 59minutes 59seconds'::interval as end_of_month) where pw.product_id = 237202 and pw.warehouse_id = 41 group BY pw.product_id,pw.warehouse_id) ;
Date: 2023-05-29 18:56:58
10 2 ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
Times Reported Most Frequent Error / Event #10
Day Hour Count May 29 15 2 - ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list at character 608
Statement: select distinct(m.res_id) from mail_tracking_value t inner join mail_message m on m.id = t.mail_message_id where m.res_id in (select mv.id from account_move mv inner join account_move_purchase_order_rel rel on rel.account_move_id = mv.id inner join purchase_order po on po.id = rel.purchase_order_id inner join res_partner res on res.id = po.partner_id where po.partner_id != mv.partner_id and mv.move_type in ('in_invoice', 'in_refund') and res.type not in ('contact','other') and res.commercial_partner_id != 30496 order by res.name) and m.model= 'account.move'and t.field = 3794 group by t.id order by t.id desc ;
Date: 2023-05-29 15:41:11
11 2 ERROR: function "..." does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count May 29 19 2 - ERROR: function "updated_in_transist_v1;" does not exist at character 8
Statement: SELECT 'updated_in_transist_v1;'::pg_catalog.regproc::pg_catalog.oid
Date: 2023-05-29 19:37:53
12 2 ERROR: column reference "..." is ambiguous
Times Reported Most Frequent Error / Event #12
Day Hour Count May 29 15 1 19 1 - ERROR: column reference "id" is ambiguous at character 14
- ERROR: column reference "id" is ambiguous at character 42
Statement: select count(id) from mail_tracking_value t inner join mail_message m on m.id = t.mail_message_id where m.res_id in (select mv.id from account_move mv inner join account_move_purchase_order_rel rel on rel.account_move_id = mv.id inner join purchase_order po on po.id = rel.purchase_order_id inner join res_partner res on res.id = po.partner_id where po.partner_id != mv.partner_id and mv.move_type in ('in_invoice', 'in_refund') and res.type not in ('contact','other') and res.commercial_partner_id != 30496 order by res.name) and m.model= 'account.move'and t.field = 3794 order by t.id desc ;
Date: 2023-05-29 15:40:10
Statement: select sm.product_uom_qty,sm.create_Date,id from product_warehouse_inventory as pw left join stock_move as sm on pw.product_id = sm.product_id and pw.warehouse_id =sm.warehouse_id and pw.company_id = sm.company_id and sm.location_id in (5,15) and sm.state ='done' and date >= (select date_trunc('MONTH',now())::DATE) and date<=(select date_trunc('month', now()) + interval '1 month - 1 day' ::interval+'23hours 59minutes 59seconds'::interval as end_of_month) where pw.product_id = 237202 and pw.warehouse_id = 41 ;
Date: 2023-05-29 19:06:44
13 1 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #13
Day Hour Count May 29 11 1 - ERROR: could not receive data from client: Connection reset by peer
Date: 2023-05-29 11:23:05
14 1 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #14
Day Hour Count May 29 11 1 - ERROR: process 2346839 still waiting for ShareLock on transaction 187908396 after 1000.051 ms
Detail: Process holding the lock: 2342417. Wait queue: 2346839.
Context: while updating tuple (2,4) in relation "ir_module_module"
Statement: UPDATE ir_module_module SET state='installed' WHERE state IN ('to remove', 'to upgrade')Date: 2023-05-29 11:22:20