pgBadger :: pgBadger

Global information

Generated on Tue Apr 7 13:53:14 2026
Log file: /logs/postgresql-2026-04-07.log
Parsed 919,226 log entries in 25s
Log start from 2026-04-07 10:21:28 to 2026-04-07 13:52:49

Global Stats

653 Number of unique normalized queries
34,895 Number of queries
9h42m53s Total query duration
2026-04-07 10:21:30 First query
2026-04-07 13:52:49 Last query
16 queries/s at 2026-04-07 12:58:31 Query peak

9h42m53s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
9h42m53s Execute total duration

16,702 Number of events
16 Number of unique normalized events
14,692 Max number of times the same event was reported
0 Number of cancellation

115 Total number of automatic vacuums
338 Total number of automatic analyzes

412 Number temporary file
282.25 MiB Max size of temporary file
23.92 MiB Average size of temporary file

127,820 Total number of sessions
102 sessions at 2026-04-07 13:22:09 Session peak
18d18h2m11s Total duration of sessions
12s675ms Average duration of sessions
0 Average queries per session
273ms Average queries duration per session

127,983 Total number of connections
173 connections/s at 2026-04-07 13:32:34 Connection peak
3 Total number of databases

SQL Traffic

Key values

16 queries/s Query Peak
2026-04-07 12:58:31 Date

SELECT Traffic

Key values

0 queries/s Query Peak
Date

INSERT/UPDATE/DELETE Traffic

Key values

16 queries/s Query Peak
2026-04-07 12:58:31 Date

Queries duration

Key values

9h42m53s 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)
Apr 07	10	6,503	200ms	1m15s	1s3ms	3m48s	4m19s	4m39s
	11	8,356	200ms	35s533ms	919ms	3m7s	3m29s	4m5s
	12	10,222	200ms	1m17s	1s62ms	4m52s	5m29s	5m57s
	13	9,814	200ms	3m28s	1s9ms	4m59s	5m44s	6m36s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Apr 07	10	6,463	955ms	3m10s	3m37s	4m10s
	11	8,332	909ms	2m31s	3m3s	3m32s
	12	10,117	1s36ms	3m44s	4m39s	5m30s
	13	9,576	974ms	3m56s	4m59s	5m26s

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Apr 07	10	7	0	31	9s207ms	203ms	28s514ms	31s684ms
	11	0	0	21	4s719ms	0ms	0ms	26s114ms
	12	21	3	79	3s645ms	466ms	14s747ms	29s498ms
	13	63	3	153	2s61ms	1s551ms	22s611ms	34s965ms

Day	Hour	Bind	Bind/Prepare	Percentage of prepare
Apr 07	10	0	0.00	0.00%
	11	0	0.00	0.00%
	12	1	1.00	0.00%
	13	3	3.00	0.00%

Day	Hour	Count	Average / Second
Apr 07	10	27,120	7.53/s
	11	40,337	11.20/s
	12	34,026	9.45/s
	13	26,500	7.36/s

Day	Hour	Count	Average Duration
Apr 07	10	26,963	3s484ms
	11	40,338	5s817ms
	12	34,021	7s808ms
	13	26,498	38s715ms

↑ Back to the top of the General Activity table

Established Connections

Key values

173 connections Connection Peak
2026-04-07 13:32:34 Date

Connections per database

Key values

odoo_position Main Database
127,983 connections Total

Chart
Table

Database	User	Count
account_move_line		1
	odoo	1
odoo		588
	odoo	578
	presalio_user	10
odoo_position		126,587
	odoo	126,587
postgres		807
	odoo	807

Connections per user

Key values

odoo Main User
127,983 connections Total

Chart
Table

User	Count
odoo	127,973
presalio_user	10

Connections per host

Key values

172.20.0.2 Main host with 127951 connections
127,982 Total connections

Chart
Table

Host	Count
105.96.24.217	8
172.20.0.1	16
172.20.0.2	127,951
41.110.184.190	2
[local]	5

Simultaneous sessions

Key values

102 sessions Session Peak
2026-04-07 13:22:09 Date

Histogram of session times

Key values

126,864 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	126,864	99.25%
500ms-1s	464	0.36%
1s-30s	73	0.06%
30s-1m	2	0.00%
1m-10m	17	0.01%
10m-30m	58	0.05%
30m-1h	260	0.20%
1h-8h	82	0.06%
> 8h	0	0.00%

Sessions per database

Key values

odoo_position Main Database
127,820 sessions Total

Chart
Table

Database	User	Count	Total Duration
odoo	432	18d12h29m27s	1h1m44s
odoo_position	126,582	2h34m18s	73ms
postgres	806	2h58m25s	13s282ms

Sessions per user

Key values

odoo Main User
127,820 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
odoo	127,810	18d17h57m48s
presalio_user	10	4m23s

Sessions per host

Key values

172.20.0.2 Main Host
127,820 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
105.96.24.217	8	4m22s	32s865ms
172.20.0.1	7	6h45m32s	57m56s
172.20.0.2	127,802	18d11h12m12s	12s484ms
41.110.184.190	2	388ms	194ms
[local]	1	3s262ms	3s262ms

Sessions per application

Key values

unknown Main Host
127,820 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
unknown	127,820	18d18h2m11s	12s675ms

Checkpoints Buffers

Key values

7,864 buffers Checkpoint Peak
2026-04-07 11:00:58 Date
269.952 seconds Highest write time
0.845 seconds Sync time

Checkpoints Wal files

Key values

65 files Wal files usage Peak
2026-04-07 13:10:58 Date

Checkpoints distance

Key values

2,092.80 Mo Distance Peak
2026-04-07 13:05:58 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Apr 07	10	34,492	1,618.54s	0.587s	1,619.292s
	11	67,878	3,238.237s	0.958s	3,239.585s
	12	55,802	3,238.13s	1.105s	3,239.61s
	13	54,329	2,967.662s	1.55s	2,969.594s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Apr 07	10	96	7,904	0.009s	0.006s
	11	215	15,710	0.011s	0.012s
	12	210	15,658	0.013s	0.012s
	13	266	14,554	0.163s	0.011s

Day	Hour	Avg time (sec)
Apr 07	10	0s
	11	0s
	12	0s
	13	0s

Day	Hour	Mean distance	Mean estimate
Apr 07	10	284,566.00 kB	320,685.00 kB
	11	285,555.20 kB	327,409.80 kB
	12	279,047.75 kB	337,589.33 kB
	13	408,918.18 kB	776,152.82 kB

↑ Back to the top of the Checkpoint Activity table

Size of temporary files

Key values

550.23 MiB Temp Files size Peak
2026-04-07 13:10:34 Date

Number of temporary files

Key values

6 per second Temp Files Peak
2026-04-07 12:11:35 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Apr 07	10	91	2.72 GiB	30.60 MiB
	11	105	2.46 GiB	23.96 MiB
	12	118	2.16 GiB	18.79 MiB
	13	98	2.28 GiB	23.86 MiB

↑ Back to the top of the Temporary Files Activity table

Queries generating the most temporary files (N)

Rank	Count	Total size	Min size	Max size	Avg size	Query
1	5	292.37 MiB	57.02 MiB	60.69 MiB	58.47 MiB	select "account_move".id from "account_move" where ("account_move"."type" = ?) and true order by "account_move"."date" desc, "account_move"."name" desc, "account_move"."id" desc limit ?; SELECT "account_move".id FROM "account_move" WHERE ("account_move"."type" = 'out_invoice') AND TRUE ORDER BY "account_move"."date" DESC, "account_move"."name" DESC, "account_move"."id" DESC limit 80; Date: 2026-04-07 10:44:51 Duration: 8s260ms SELECT "account_move".id FROM "account_move" WHERE ("account_move"."type" = 'out_invoice') AND TRUE ORDER BY "account_move"."date" DESC, "account_move"."name" DESC, "account_move"."id" DESC limit 80; Date: 2026-04-07 10:44:51 Duration: 0ms
2	4	61.40 MiB	11.28 MiB	22.30 MiB	15.35 MiB	select min("sale_report".id) as id, count("sale_report".id) AS "__count", sum("sale_report"."price_subtotal") AS "price_subtotal", date_trunc(?, "sale_report"."date"::timestamp) AS "date:month", date_trunc(?, "sale_report"."date"::timestamp) AS "date:day" from "sale_report" where (("sale_report"."date" >= ?) and ("sale_report"."date" < ?)) and true group by date_trunc(?, "sale_report"."date"::timestamp), date_trunc(?, "sale_report"."date"::timestamp) order by "date:month", "date:day"; SELECT min("sale_report".id) AS id, count("sale_report".id) AS "__count", sum("sale_report"."price_subtotal") AS "price_subtotal", date_trunc('month', "sale_report"."date"::timestamp) as "date:month", date_trunc('day', "sale_report"."date"::timestamp) as "date:day" FROM "sale_report" WHERE (("sale_report"."date" >= '2026-04-01 00:00:00') AND ("sale_report"."date" < '2026-05-01 00:00:00')) AND TRUE GROUP BY date_trunc('month', "sale_report"."date"::timestamp), date_trunc('day', "sale_report"."date"::timestamp) ORDER BY "date:month", "date:day"; Date: 2026-04-07 13:03:11 Duration: 0ms
3	4	41.65 MiB	10.28 MiB	10.55 MiB	10.41 MiB	select "planning_planning".id from "planning_planning" left join planning_planning_company_rel on (planning_planning.id = planning_planning_company_rel.planning_id) left join planning_planning_warehouse_rel on (planning_planning.id = planning_planning_warehouse_rel.planning_id) where ("planning_planning"."workflow_type" = ?) and ((planning_planning.company_id in (...) or planning_planning_company_rel.company_id in (...)) and (planning_planning_warehouse_rel.warehouse_id in (...))) order by "planning_planning"."state" desc, "planning_planning"."date_end" desc limit ?; SELECT "planning_planning".id FROM "planning_planning" LEFT JOIN planning_planning_company_rel ON (planning_planning.id = planning_planning_company_rel.planning_id) LEFT JOIN planning_planning_warehouse_rel ON (planning_planning.id = planning_planning_warehouse_rel.planning_id) WHERE ("planning_planning"."workflow_type" = 'presale') AND ((planning_planning.company_id IN (1, 3) OR planning_planning_company_rel.company_id IN (0)) AND (planning_planning_warehouse_rel.warehouse_id in (1, 93, 10, 6, 107, 14, 157, 2, 131, 121, 132, 46, 48, 44, 34, 55, 160, 168, 49, 28, 153, 57, 135, 150, 54, 75, 118, 22, 68, 81, 52, 83, 126, 103, 151, 80, 56, 98, 35, 87, 43, 29, 53, 37, 63, 147, 128, 50, 117, 19, 33, 77, 60, 70, 149, 92, 134, 152, 158, 166, 113, 84, 32, 163, 127, 159, 110, 139, 119, 164, 85, 26, 104, 99, 136, 154, 61, 38, 36, 18, 165, 27, 40, 162, 39, 94, 62, 16, 42, 76, 141, 73, 58, 90, 17, 145, 112, 100, 155, 24, 74, 114, 79, 130, 133, 142, 25, 15, 45, 148, 95, 21, 51, 120, 137, 47, 96, 23, 116, 111, 66, 105, 109, 106, 91, 129, 115, 101, 138, 41, 156, 71, 97, 146, 20, 69, 64))) ORDER BY "planning_planning"."state" DESC, "planning_planning"."date_end" DESC limit 80; Date: 2026-04-07 13:27:11 Duration: 1s541ms SELECT "planning_planning".id FROM "planning_planning" LEFT JOIN planning_planning_company_rel ON (planning_planning.id = planning_planning_company_rel.planning_id) LEFT JOIN planning_planning_warehouse_rel ON (planning_planning.id = planning_planning_warehouse_rel.planning_id) WHERE ("planning_planning"."workflow_type" = 'presale') AND ((planning_planning.company_id IN (1, 3) OR planning_planning_company_rel.company_id IN (0)) AND (planning_planning_warehouse_rel.warehouse_id in (1, 93, 10, 6, 107, 14, 157, 2, 131, 121, 132, 46, 48, 44, 34, 55, 160, 168, 49, 28, 153, 57, 135, 150, 54, 75, 118, 22, 68, 81, 52, 83, 126, 103, 151, 80, 56, 98, 35, 87, 43, 29, 53, 37, 63, 147, 128, 50, 117, 19, 33, 77, 60, 70, 149, 92, 134, 152, 158, 166, 113, 84, 32, 163, 127, 159, 110, 139, 119, 164, 85, 26, 104, 99, 136, 154, 61, 38, 36, 18, 165, 27, 40, 162, 39, 94, 62, 16, 42, 76, 141, 73, 58, 90, 17, 145, 112, 100, 155, 24, 74, 114, 79, 130, 133, 142, 25, 15, 45, 148, 95, 21, 51, 120, 137, 47, 96, 23, 116, 111, 66, 105, 109, 106, 91, 129, 115, 101, 138, 41, 156, 71, 97, 146, 20, 69, 64))) ORDER BY "planning_planning"."state" DESC, "planning_planning"."date_end" DESC limit 80; Date: 2026-04-07 13:27:16 Duration: 1s418ms SELECT "planning_planning".id FROM "planning_planning" LEFT JOIN planning_planning_company_rel ON (planning_planning.id = planning_planning_company_rel.planning_id) LEFT JOIN planning_planning_warehouse_rel ON (planning_planning.id = planning_planning_warehouse_rel.planning_id) WHERE ("planning_planning"."workflow_type" = 'presale') AND ((planning_planning.company_id IN (1, 3, 4) OR planning_planning_company_rel.company_id IN (0)) AND (planning_planning_warehouse_rel.warehouse_id in (1, 93, 10, 6, 107, 14, 157, 46, 44, 75, 80, 87, 29, 53, 128, 117, 19, 33, 77, 70, 134, 84, 32, 39, 17, 133, 142, 45, 95, 51, 137, 105, 106, 101, 20))) ORDER BY "planning_planning"."state" DESC, "planning_planning"."date_end" DESC limit 80; Date: 2026-04-07 12:16:30 Duration: 1s273ms
4	4	57.12 MiB	13.35 MiB	14.83 MiB	14.28 MiB	select "ir_model_data".id from "ir_model_data" order by "ir_model_data"."module", "ir_model_data"."model", "ir_model_data"."name" limit ?; SELECT "ir_model_data".id FROM "ir_model_data" ORDER BY "ir_model_data"."module", "ir_model_data"."model", "ir_model_data"."name" limit 80; Date: 2026-04-07 11:10:05 Duration: 1s52ms SELECT "ir_model_data".id FROM "ir_model_data" ORDER BY "ir_model_data"."module", "ir_model_data"."model", "ir_model_data"."name" limit 80; Date: 2026-04-07 11:10:05 Duration: 0ms
5	3	39.10 MiB	7.79 MiB	19.24 MiB	13.03 MiB	select min("sale_report".id) as id, count("sale_report".id) AS "__count", sum("sale_report"."price_subtotal") AS "price_subtotal" from "sale_report" where (("sale_report"."date" >= ?) and ("sale_report"."date" < ?)) and true; SELECT min("sale_report".id) AS id, count("sale_report".id) AS "__count", sum("sale_report"."price_subtotal") AS "price_subtotal" FROM "sale_report" WHERE (("sale_report"."date" >= '2026-04-01 00:00:00') AND ("sale_report"."date" < '2026-05-01 00:00:00')) AND TRUE; Date: 2026-04-07 13:03:09 Duration: 0ms
6	29	801.46 MiB	20.55 MiB	46.55 MiB	27.64 MiB	select min("sale_report".id) as id, count("sale_report".id) AS "__count", sum("sale_report"."price_subtotal") AS "price_subtotal", "sale_report"."planning_template_id" AS "planning_template_id" from "sale_report" left join "planning_template" AS "sale_report__planning_template_id" on ("sale_report"."planning_template_id" = "sale_report__planning_template_id"."id") where (((((("sale_report"."planning_template_id" = ?) or ("sale_report"."planning_template_id" = ?)) or ("sale_report"."planning_template_id" = ?)) or ("sale_report"."planning_template_id" = ?)) or ("sale_report"."planning_template_id" = ?)) or ("sale_report"."planning_template_id" = ?)) and true and ((sale_report.company_id in (...)) and (sale_report.brand_id is null or sale_report.brand_id in (...)) and (sale_report.warehouse_id in (...))) group by "sale_report"."planning_template_id", "sale_report__planning_template_id"."id" order by "sale_report__planning_template_id"."id"; SELECT min("sale_report".id) AS id, count("sale_report".id) AS "__count", sum("sale_report"."price_subtotal") AS "price_subtotal", "sale_report"."planning_template_id" as "planning_template_id" FROM "sale_report" LEFT JOIN "planning_template" as "sale_report__planning_template_id" ON ("sale_report"."planning_template_id" = "sale_report__planning_template_id"."id") WHERE (((((("sale_report"."planning_template_id" = 98) OR ("sale_report"."planning_template_id" = 115)) OR ("sale_report"."planning_template_id" = 113)) OR ("sale_report"."planning_template_id" = 605)) OR ("sale_report"."planning_template_id" = 607)) OR ("sale_report"."planning_template_id" = 608)) AND TRUE AND ((sale_report.company_id IN (1)) AND (sale_report.brand_id IS NULL OR sale_report.brand_id in (1)) AND (sale_report.warehouse_id in (10))) GROUP BY "sale_report"."planning_template_id", "sale_report__planning_template_id"."id" ORDER BY "sale_report__planning_template_id"."id"; Date: 2026-04-07 12:11:35 Duration: 0ms
7	257	4.50 GiB	10.17 MiB	49.17 MiB	17.93 MiB	select min("stock_valuation_layer".id) as id, count("stock_valuation_layer".id) AS "product_id_count", sum("stock_valuation_layer"."value") AS "value", sum("stock_valuation_layer"."quantity") AS "quantity", "stock_valuation_layer"."product_id" AS "product_id" from "product_product" AS "stock_valuation_layer__product_id" left join "product_template" AS "stock_valuation_layer__product_id__product_tmpl_id" on ("stock_valuation_layer__product_id"."product_tmpl_id" = "stock_valuation_layer__product_id__product_tmpl_id"."id"), "stock_valuation_layer" where ("stock_valuation_layer"."product_id" = "stock_valuation_layer__product_id"."id") and ((("stock_valuation_layer__product_id"."active" = true) and ("stock_valuation_layer"."product_id" in (...))) and ("stock_valuation_layer"."company_id" = ?)) group by "stock_valuation_layer"."product_id", "stock_valuation_layer__product_id"."default_code", "stock_valuation_layer__product_id__product_tmpl_id"."name", "stock_valuation_layer__product_id"."id" order by "stock_valuation_layer__product_id"."default_code", "stock_valuation_layer__product_id__product_tmpl_id"."name", "stock_valuation_layer__product_id"."id"; SELECT min("stock_valuation_layer".id) AS id, count("stock_valuation_layer".id) AS "product_id_count", sum("stock_valuation_layer"."value") AS "value", sum("stock_valuation_layer"."quantity") AS "quantity", "stock_valuation_layer"."product_id" as "product_id" FROM "product_product" as "stock_valuation_layer__product_id" LEFT JOIN "product_template" as "stock_valuation_layer__product_id__product_tmpl_id" ON ("stock_valuation_layer__product_id"."product_tmpl_id" = "stock_valuation_layer__product_id__product_tmpl_id"."id"), "stock_valuation_layer" WHERE ("stock_valuation_layer"."product_id" = "stock_valuation_layer__product_id"."id") AND ((("stock_valuation_layer__product_id"."active" = true) AND ("stock_valuation_layer"."product_id" in (900, 141, 137, 130, 11))) AND ("stock_valuation_layer"."company_id" = 1)) GROUP BY "stock_valuation_layer"."product_id", "stock_valuation_layer__product_id"."default_code", "stock_valuation_layer__product_id__product_tmpl_id"."name", "stock_valuation_layer__product_id"."id" ORDER BY "stock_valuation_layer__product_id"."default_code", "stock_valuation_layer__product_id__product_tmpl_id"."name", "stock_valuation_layer__product_id"."id"; Date: 2026-04-07 12:10:34 Duration: 0ms
8	25	698.69 MiB	26.78 MiB	29.47 MiB	27.95 MiB	select min("sale_report".id) as id, count("sale_report".id) AS "__count", sum("sale_report"."price_subtotal") AS "price_subtotal" from "sale_report" where (((((("sale_report"."planning_template_id" = ?) or ("sale_report"."planning_template_id" = ?)) or ("sale_report"."planning_template_id" = ?)) or ("sale_report"."planning_template_id" = ?)) or ("sale_report"."planning_template_id" = ?)) or ("sale_report"."planning_template_id" = ?)) and true and ((sale_report.company_id in (...)) and (sale_report.brand_id is null or sale_report.brand_id in (...)) and (sale_report.warehouse_id in (...))); SELECT min("sale_report".id) AS id, count("sale_report".id) AS "__count", sum("sale_report"."price_subtotal") AS "price_subtotal" FROM "sale_report" WHERE (((((("sale_report"."planning_template_id" = 98) OR ("sale_report"."planning_template_id" = 115)) OR ("sale_report"."planning_template_id" = 113)) OR ("sale_report"."planning_template_id" = 605)) OR ("sale_report"."planning_template_id" = 607)) OR ("sale_report"."planning_template_id" = 608)) AND TRUE AND ((sale_report.company_id IN (1)) AND (sale_report.brand_id IS NULL OR sale_report.brand_id in (1)) AND (sale_report.warehouse_id in (10))); Date: 2026-04-07 12:11:19 Duration: 0ms Database: odoo User: odoo
9	20	411.62 MiB	11.45 MiB	61.21 MiB	20.58 MiB	select min("stock_valuation_layer".id) as id, count("stock_valuation_layer".id) AS "product_id_count", sum("stock_valuation_layer"."value") AS "value", sum("stock_valuation_layer"."quantity") AS "quantity", "stock_valuation_layer"."product_id" AS "product_id" from "product_product" AS "stock_valuation_layer__product_id" left join "product_template" AS "stock_valuation_layer__product_id__product_tmpl_id" on ("stock_valuation_layer__product_id"."product_tmpl_id" = "stock_valuation_layer__product_id__product_tmpl_id"."id") left join "ir_translation" AS "stock_valuation_layer__product_id__product_tmpl_id__name" on ("stock_valuation_layer__product_id__product_tmpl_id"."id" = "stock_valuation_layer__product_id__product_tmpl_id__name"."res_id" and "stock_valuation_layer__product_id__product_tmpl_id__name"."type" = ? and "stock_valuation_layer__product_id__product_tmpl_id__name"."name" = ? and "stock_valuation_layer__product_id__product_tmpl_id__name"."lang" = ? and "stock_valuation_layer__product_id__product_tmpl_id__name"."value" != ?), "stock_valuation_layer" where ("stock_valuation_layer"."product_id" = "stock_valuation_layer__product_id"."id") and ((("stock_valuation_layer__product_id"."active" = true) and ("stock_valuation_layer"."product_id" in (...))) and ("stock_valuation_layer"."company_id" = ?)) group by "stock_valuation_layer"."product_id", "stock_valuation_layer__product_id"."default_code", coalesce("stock_valuation_layer__product_id__product_tmpl_id__name"."value", "stock_valuation_layer__product_id__product_tmpl_id"."name"), "stock_valuation_layer__product_id"."id" order by "stock_valuation_layer__product_id"."default_code", coalesce("stock_valuation_layer__product_id__product_tmpl_id__name"."value", "stock_valuation_layer__product_id__product_tmpl_id"."name"), "stock_valuation_layer__product_id"."id"; SELECT min("stock_valuation_layer".id) AS id, count("stock_valuation_layer".id) AS "product_id_count", sum("stock_valuation_layer"."value") AS "value", sum("stock_valuation_layer"."quantity") AS "quantity", "stock_valuation_layer"."product_id" as "product_id" FROM "product_product" as "stock_valuation_layer__product_id" LEFT JOIN "product_template" as "stock_valuation_layer__product_id__product_tmpl_id" ON ("stock_valuation_layer__product_id"."product_tmpl_id" = "stock_valuation_layer__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" as "stock_valuation_layer__product_id__product_tmpl_id__name" ON ("stock_valuation_layer__product_id__product_tmpl_id"."id" = "stock_valuation_layer__product_id__product_tmpl_id__name"."res_id" AND "stock_valuation_layer__product_id__product_tmpl_id__name"."type" = 'model' AND "stock_valuation_layer__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "stock_valuation_layer__product_id__product_tmpl_id__name"."lang" = 'fr_FR' AND "stock_valuation_layer__product_id__product_tmpl_id__name"."value" != ''), "stock_valuation_layer" WHERE ("stock_valuation_layer"."product_id" = "stock_valuation_layer__product_id"."id") AND ((("stock_valuation_layer__product_id"."active" = true) AND ("stock_valuation_layer"."product_id" in (784, 790, 332, 587, 629, 120, 12))) AND ("stock_valuation_layer"."company_id" = 3)) GROUP BY "stock_valuation_layer"."product_id", "stock_valuation_layer__product_id"."default_code", COALESCE("stock_valuation_layer__product_id__product_tmpl_id__name"."value", "stock_valuation_layer__product_id__product_tmpl_id"."name"), "stock_valuation_layer__product_id"."id" ORDER BY "stock_valuation_layer__product_id"."default_code", COALESCE("stock_valuation_layer__product_id__product_tmpl_id__name"."value", "stock_valuation_layer__product_id__product_tmpl_id"."name"), "stock_valuation_layer__product_id"."id"; Date: 2026-04-07 12:12:27 Duration: 0ms
10	2	58.78 MiB	17.23 MiB	41.55 MiB	29.39 MiB	select min("sale_report".id) as id, count("sale_report".id) AS "__count", sum("sale_report"."price_subtotal") AS "price_subtotal", date_trunc(?, "sale_report"."date"::timestamp) AS "date:month" from "sale_report" where (("sale_report"."date" >= ?) and ("sale_report"."date" < ?)) and true group by date_trunc(?, "sale_report"."date"::timestamp) order by "date:month"; SELECT min("sale_report".id) AS id, count("sale_report".id) AS "__count", sum("sale_report"."price_subtotal") AS "price_subtotal", date_trunc('month', "sale_report"."date"::timestamp) as "date:month" FROM "sale_report" WHERE (("sale_report"."date" >= '2026-04-01 00:00:00') AND ("sale_report"."date" < '2026-05-01 00:00:00')) AND TRUE GROUP BY date_trunc('month', "sale_report"."date"::timestamp) ORDER BY "date:month"; Date: 2026-04-07 13:03:11 Duration: 0ms
11	2	81.41 MiB	20.70 MiB	60.70 MiB	40.70 MiB	select rp.id as id_pos, rp.ref as code_pos, rp.name as nom_pos, rp.rc as rc, rp.art as art, rp.nis as nis, rp.vat as nif, sw.name as depot, typ.value as type_pv, rp.active as status_pos, rpc.value as cluster_pos, ppi.name as liste_prix, prcr.name as region, prcs.name as zone, rcst.name as wilaya, rp.city as commune, rp.street as adresse, rp.phone as telephone, concat(rp.partner_latitude, ?, rp.partner_longitude) as coordonnees_gps, concat(?, dr.name, ?) as route, ? as jour_visite, drp.sequence as sequence_visite, case when exists ( select ? from ir_attachment ia where ia.res_model = ? and ia.res_field = ? and ia.res_id = rp.id) then ? else ? end as disponibilite_photo, rp.state as etat_census, max(mm.write_date) as date_derniere_modification, ( select sub_mm.body from mail_message sub_mm where sub_mm.model = ? and sub_mm.res_id = rp.id order by sub_mm.write_date desc limit ?) as derniere_modification, count(mm.id) as nombre_modifications, ( select ai.name as number from account_move ai where ai.partner_id = rp.id and ai.invoice_payment_state in (...) order by ai.write_date desc limit ?) as derniere_vente from res_partner rp left join planning_template_event drp on rp.id = drp.partner_id left join planning_template dr on dr.id = drp.planning_template_id left join stock_warehouse sw on rp.warehouse_id = sw.id left join model_custom_attribute_value typ on rp.partner_custom_attribute_2 = typ.id left join model_custom_attribute_value rpc on rp.partner_custom_attribute_1 = rpc.id left join res_country_state rcst on rp.state_id = rcst.id left join res_country_region prcr on rp.region_id = prcr.id left join res_country_sector prcs on rp.sector_id = prcs.id left join res_partner_pricelist pl on rp.id = pl.partner_id left join product_pricelist ppi on pl.pricelist_id = ppi.id left join mail_message mm on mm.model = ? and mm.res_id = rp.id where --rp.customer_rank = ?* sw.id not in (...) group by rp.id, rp.ref, rp.name, sw.name, typ.value, rp.active, rpc.value, ppi.name, prcr.name, prcs.name, rcst.name, rp.city, rp.street, rp.phone, rp.partner_latitude, rp.partner_longitude, dr.name, drp.sequence, disponibilite_photo, rp.state, rp.write_date ; SELECT rp.id AS ID_POS, rp.ref AS CODE_POS, rp.name AS NOM_POS, rp.rc AS rc, rp.art AS art, rp.nis as nis, rp.vat as nif, sw.name AS DEPOT, typ.value AS type_pv, rp.active AS STATUS_POS, rpc.value AS CLUSTER_POS, ppi.name AS LISTE_PRIX, prcr.name AS REGION, prcs.name AS ZONE, rcst.name AS WILAYA, rp.city AS COMMUNE, rp.street AS ADRESSE, rp.phone AS TELEPHONE, CONCAT(rp.partner_latitude, ',', rp.partner_longitude) AS COORDONNEES_GPS, CONCAT('[', dr.name, ']') AS ROUTE, 'Tous les jours sauf vendredi' AS JOUR_VISITE, drp.sequence AS SEQUENCE_VISITE, CASE WHEN EXISTS ( SELECT 1 FROM ir_attachment ia WHERE ia.res_model = 'res.partner' AND ia.res_field = 'image_1920' AND ia.res_id = rp.id) THEN 'OUI' ELSE 'NON' END AS DISPONIBILITE_PHOTO, rp.state AS ETAT_CENSUS, MAX(mm.write_date) AS Date_derniere_modification, ( SELECT sub_mm.body FROM mail_message sub_mm WHERE sub_mm.model = 'res.partner' AND sub_mm.res_id = rp.id ORDER BY sub_mm.write_date DESC LIMIT 1) AS Derniere_Modification, COUNT(mm.id) AS nombre_modifications, ( SELECT ai.name as number FROM account_move ai WHERE ai.partner_id = rp.id AND ai.invoice_payment_state IN ('not_paid', 'paid') ORDER BY ai.write_date DESC LIMIT 1) AS derniere_vente FROM res_partner rp LEFT JOIN planning_template_event drp ON rp.id = drp.partner_id LEFT JOIN planning_template dr ON dr.id = drp.planning_template_id LEFT JOIN stock_warehouse sw ON rp.warehouse_id = sw.id LEFT JOIN model_custom_attribute_value typ ON rp.partner_custom_attribute_2 = typ.id LEFT JOIN model_custom_attribute_value rpc ON rp.partner_custom_attribute_1 = rpc.id LEFT JOIN res_country_state rcst ON rp.state_id = rcst.id LEFT JOIN res_country_region prcr ON rp.region_id = prcr.id LEFT JOIN res_country_sector prcs ON rp.sector_id = prcs.id LEFT JOIN res_partner_pricelist pl ON rp.id = pl.partner_id LEFT JOIN product_pricelist ppi ON pl.pricelist_id = ppi.id LEFT JOIN mail_message mm ON mm.model = 'res.partner' AND mm.res_id = rp.id WHERE --rp.customer_rank = 1* sw.id not in (170, 172, 180, 182) GROUP BY rp.id, rp.ref, rp.name, sw.name, typ.value, rp.active, rpc.value, ppi.name, prcr.name, prcs.name, rcst.name, rp.city, rp.street, rp.phone, rp.partner_latitude, rp.partner_longitude, dr.name, drp.sequence, DISPONIBILITE_PHOTO, rp.state, rp.write_date; Date: 2026-04-07 13:38:29 Duration: 0ms Database: odoo User: presalio_user
12	2	550.23 MiB	267.98 MiB	282.25 MiB	275.11 MiB	select min("account_report".id) as id, count("account_report".id) AS "__count", sum("account_report"."price_subtotal") AS "price_subtotal" from "account_report" where ((((("account_report"."state" not in (...)) or "account_report"."state" is null) and (("account_report"."type" = ?) or ("account_report"."type" = ?))) and ("account_report"."invoice_date" >= ?)) and ("account_report"."partner_custom_attribute_1" in (...))) and ((account_report.company_id in (...)) and (account_report.warehouse_id in (...))); SELECT min("account_report".id) AS id, count("account_report".id) AS "__count", sum("account_report"."price_subtotal") AS "price_subtotal" FROM "account_report" WHERE ((((("account_report"."state" not in ('draft', 'cancel')) OR "account_report"."state" IS NULL) AND (("account_report"."type" = 'out_invoice') OR ("account_report"."type" = 'out_refund'))) AND ("account_report"."invoice_date" >= '2025-01-01')) AND ("account_report"."partner_custom_attribute_1" in (73, 83, 91, 93))) AND ((account_report.company_id IN (1, 3)) AND (account_report.warehouse_id in (1, 93, 10, 6, 107, 14, 157, 2, 131, 121, 132, 46, 48, 44, 34, 55, 160, 49, 28, 153, 57, 135, 150, 54, 75, 118, 22, 68, 81, 52, 83, 126, 103, 151, 80, 56, 98, 35, 87, 43, 29, 53, 37, 63, 147, 128, 50, 117, 19, 33, 77, 60, 70, 149, 92, 134, 152, 158, 166, 113, 84, 32, 163, 127, 159, 110, 139, 119, 164, 85, 26, 104, 99, 136, 154, 61, 38, 36, 18, 165, 27, 40, 162, 39, 94, 62, 16, 42, 76, 141, 73, 58, 90, 17, 145, 112, 100, 155, 24, 74, 114, 79, 130, 133, 142, 25, 15, 45, 148, 95, 21, 51, 120, 137, 47, 96, 23, 116, 111, 66, 105, 109, 106, 91, 129, 115, 101, 138, 41, 156, 71, 97, 146, 20, 69, 64, 178))); Date: 2026-04-07 13:10:34 Duration: 0ms
13	12	88.44 MiB	5.04 MiB	12.63 MiB	7.37 MiB	select "planning_planning".id from "planning_planning" left join planning_planning_company_rel on (planning_planning.id = planning_planning_company_rel.planning_id) left join planning_planning_warehouse_rel on (planning_planning.id = planning_planning_warehouse_rel.planning_id) where ? = ? and ((planning_planning.company_id in (...) or planning_planning_company_rel.company_id in (...)) and (planning_planning.brand_id is null or planning_planning.brand_id in (...)) and (planning_planning_warehouse_rel.warehouse_id in (...))) order by "planning_planning"."state" desc, "planning_planning"."date_end" desc limit ?; SELECT "planning_planning".id FROM "planning_planning" LEFT JOIN planning_planning_company_rel ON (planning_planning.id = planning_planning_company_rel.planning_id) LEFT JOIN planning_planning_warehouse_rel ON (planning_planning.id = planning_planning_warehouse_rel.planning_id) WHERE 1 = 1 AND ((planning_planning.company_id IN (1) OR planning_planning_company_rel.company_id IN (0)) AND (planning_planning.brand_id IS NULL OR planning_planning.brand_id in (1)) AND (planning_planning_warehouse_rel.warehouse_id in (1, 93, 10, 6, 107, 14, 157, 178))) ORDER BY "planning_planning"."state" DESC, "planning_planning"."date_end" DESC limit 8; Date: 2026-04-07 12:40:57 Duration: 1s267ms SELECT "planning_planning".id FROM "planning_planning" LEFT JOIN planning_planning_company_rel ON (planning_planning.id = planning_planning_company_rel.planning_id) LEFT JOIN planning_planning_warehouse_rel ON (planning_planning.id = planning_planning_warehouse_rel.planning_id) WHERE 1 = 1 AND ((planning_planning.company_id IN (1) OR planning_planning_company_rel.company_id IN (0)) AND (planning_planning.brand_id IS NULL OR planning_planning.brand_id in (1)) AND (planning_planning_warehouse_rel.warehouse_id in (1, 93, 10, 6, 107, 14, 157, 178))) ORDER BY "planning_planning"."state" DESC, "planning_planning"."date_end" DESC limit 8; Date: 2026-04-07 12:30:44 Duration: 1s149ms SELECT "planning_planning".id FROM "planning_planning" LEFT JOIN planning_planning_company_rel ON (planning_planning.id = planning_planning_company_rel.planning_id) LEFT JOIN planning_planning_warehouse_rel ON (planning_planning.id = planning_planning_warehouse_rel.planning_id) WHERE 1 = 1 AND ((planning_planning.company_id IN (1) OR planning_planning_company_rel.company_id IN (0)) AND (planning_planning.brand_id IS NULL OR planning_planning.brand_id in (1)) AND (planning_planning_warehouse_rel.warehouse_id in (1, 93, 10, 6, 107, 14, 157, 178))) ORDER BY "planning_planning"."state" DESC, "planning_planning"."date_end" DESC limit 8; Date: 2026-04-07 12:40:59 Duration: 1s98ms
14	10	504.61 MiB	21.30 MiB	85.23 MiB	50.46 MiB	select min("stock_move_line".id) as id, count("stock_move_line".id) AS "product_id_count", "stock_move_line"."product_id" AS "product_id" from "stock_move_line" left join "product_product" AS "stock_move_line__product_id" on ("stock_move_line"."product_id" = "stock_move_line__product_id"."id") left join "product_template" AS "stock_move_line__product_id__product_tmpl_id" on ("stock_move_line__product_id"."product_tmpl_id" = "stock_move_line__product_id__product_tmpl_id"."id") left join "ir_translation" AS "stock_move_line__product_id__product_tmpl_id__name" on ("stock_move_line__product_id__product_tmpl_id"."id" = "stock_move_line__product_id__product_tmpl_id__name"."res_id" and "stock_move_line__product_id__product_tmpl_id__name"."type" = ? and "stock_move_line__product_id__product_tmpl_id__name"."name" = ? and "stock_move_line__product_id__product_tmpl_id__name"."lang" = ? and "stock_move_line__product_id__product_tmpl_id__name"."value" != ?) where ("stock_move_line"."state" = ?) and ((stock_move_line.company_id in (...)) and (stock_move_line.warehouse_id is null or stock_move_line.warehouse_id in (...)) and (stock_move_line.brand_id is null or stock_move_line.brand_id in (...))) group by "stock_move_line"."product_id", "stock_move_line__product_id"."default_code", coalesce("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" order by "stock_move_line__product_id"."default_code", coalesce("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" limit ? offset ?; SELECT min("stock_move_line".id) AS id, count("stock_move_line".id) AS "product_id_count", "stock_move_line"."product_id" as "product_id" FROM "stock_move_line" LEFT JOIN "product_product" as "stock_move_line__product_id" ON ("stock_move_line"."product_id" = "stock_move_line__product_id"."id") LEFT JOIN "product_template" as "stock_move_line__product_id__product_tmpl_id" ON ("stock_move_line__product_id"."product_tmpl_id" = "stock_move_line__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" as "stock_move_line__product_id__product_tmpl_id__name" ON ("stock_move_line__product_id__product_tmpl_id"."id" = "stock_move_line__product_id__product_tmpl_id__name"."res_id" AND "stock_move_line__product_id__product_tmpl_id__name"."type" = 'model' AND "stock_move_line__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "stock_move_line__product_id__product_tmpl_id__name"."lang" = 'fr_FR' AND "stock_move_line__product_id__product_tmpl_id__name"."value" != '') WHERE ("stock_move_line"."state" = 'done') AND ((stock_move_line.company_id IN (3)) AND (stock_move_line.warehouse_id IS NULL OR stock_move_line.warehouse_id IN (16, 133)) AND (stock_move_line.brand_id IS NULL OR stock_move_line.brand_id IN (1))) GROUP BY "stock_move_line"."product_id", "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" ORDER BY "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" LIMIT 100000 OFFSET 80; Date: 2026-04-07 11:54:46 Duration: 0ms
15	10	916.41 MiB	86.70 MiB	96.91 MiB	91.64 MiB	select min("account_payment".id) as id, count("account_payment".id) AS "journal_id_count", sum("account_payment"."amount") AS "amount", "account_payment"."journal_id" AS "journal_id" from "account_payment" left join "account_journal" AS "account_payment__journal_id" on ("account_payment"."journal_id" = "account_payment__journal_id"."id") where ("account_payment"."partner_type" = ?) group by "account_payment"."journal_id", "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code" order by "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code"; SELECT min("account_payment".id) AS id, count("account_payment".id) AS "journal_id_count", sum("account_payment"."amount") AS "amount", "account_payment"."journal_id" as "journal_id" FROM "account_payment" LEFT JOIN "account_journal" as "account_payment__journal_id" ON ("account_payment"."journal_id" = "account_payment__journal_id"."id") WHERE ("account_payment"."partner_type" = 'customer') GROUP BY "account_payment"."journal_id", "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code" ORDER BY "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code"; Date: 2026-04-07 10:45:42 Duration: 0ms
16	10	542.19 MiB	22.97 MiB	87.66 MiB	54.22 MiB	select min("stock_move_line".id) as id, count("stock_move_line".id) AS "product_id_count", sum("stock_move_line"."qty_done") AS "qty_done", "stock_move_line"."product_id" AS "product_id" from "stock_move_line" left join "product_product" AS "stock_move_line__product_id" on ("stock_move_line"."product_id" = "stock_move_line__product_id"."id") left join "product_template" AS "stock_move_line__product_id__product_tmpl_id" on ("stock_move_line__product_id"."product_tmpl_id" = "stock_move_line__product_id__product_tmpl_id"."id") left join "ir_translation" AS "stock_move_line__product_id__product_tmpl_id__name" on ("stock_move_line__product_id__product_tmpl_id"."id" = "stock_move_line__product_id__product_tmpl_id__name"."res_id" and "stock_move_line__product_id__product_tmpl_id__name"."type" = ? and "stock_move_line__product_id__product_tmpl_id__name"."name" = ? and "stock_move_line__product_id__product_tmpl_id__name"."lang" = ? and "stock_move_line__product_id__product_tmpl_id__name"."value" != ?) where ("stock_move_line"."state" = ?) and ((stock_move_line.company_id in (...)) and (stock_move_line.warehouse_id is null or stock_move_line.warehouse_id in (...)) and (stock_move_line.brand_id is null or stock_move_line.brand_id in (...))) group by "stock_move_line"."product_id", "stock_move_line__product_id"."default_code", coalesce("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" order by "stock_move_line__product_id"."default_code", coalesce("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" limit ?; SELECT min("stock_move_line".id) AS id, count("stock_move_line".id) AS "product_id_count", sum("stock_move_line"."qty_done") AS "qty_done", "stock_move_line"."product_id" as "product_id" FROM "stock_move_line" LEFT JOIN "product_product" as "stock_move_line__product_id" ON ("stock_move_line"."product_id" = "stock_move_line__product_id"."id") LEFT JOIN "product_template" as "stock_move_line__product_id__product_tmpl_id" ON ("stock_move_line__product_id"."product_tmpl_id" = "stock_move_line__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" as "stock_move_line__product_id__product_tmpl_id__name" ON ("stock_move_line__product_id__product_tmpl_id"."id" = "stock_move_line__product_id__product_tmpl_id__name"."res_id" AND "stock_move_line__product_id__product_tmpl_id__name"."type" = 'model' AND "stock_move_line__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "stock_move_line__product_id__product_tmpl_id__name"."lang" = 'fr_FR' AND "stock_move_line__product_id__product_tmpl_id__name"."value" != '') WHERE ("stock_move_line"."state" = 'done') AND ((stock_move_line.company_id IN (3)) AND (stock_move_line.warehouse_id IS NULL OR stock_move_line.warehouse_id IN (16, 133)) AND (stock_move_line.brand_id IS NULL OR stock_move_line.brand_id IN (1))) GROUP BY "stock_move_line"."product_id", "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" ORDER BY "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" LIMIT 80; Date: 2026-04-07 11:54:42 Duration: 0ms
17	1	23.91 MiB	23.91 MiB	23.91 MiB	23.91 MiB	select min("account_report".id) as id, count("account_report".id) AS "__count", sum("account_report"."price_subtotal") AS "price_subtotal" from "account_report" where (((("account_report"."state" not in (...)) or "account_report"."state" is null) and (("account_report"."type" = ?) or ("account_report"."type" = ?))) and (("account_report"."invoice_date" >= ?) and ("account_report"."invoice_date" < ?))) and ((account_report.company_id in (...)) and (account_report.brand_id is null or account_report.brand_id in (...)) and (account_report.warehouse_id in (...))); SELECT min("account_report".id) AS id, count("account_report".id) AS "__count", sum("account_report"."price_subtotal") AS "price_subtotal" FROM "account_report" WHERE (((("account_report"."state" not in ('draft', 'cancel')) OR "account_report"."state" IS NULL) AND (("account_report"."type" = 'out_invoice') OR ("account_report"."type" = 'out_refund'))) AND (("account_report"."invoice_date" >= '2026-03-01') AND ("account_report"."invoice_date" < '2026-04-01'))) AND ((account_report.company_id IN (1, 3)) AND (account_report.brand_id IS NULL OR account_report.brand_id in (1)) AND (account_report.warehouse_id in (10, 14, 48, 44, 135, 80, 29, 53, 163, 27, 45, 106, 138, 20))); Date: 2026-04-07 10:29:20 Duration: 0ms
18	1	31.36 MiB	31.36 MiB	31.36 MiB	31.36 MiB	select min("account_payment".id) as id, count("account_payment".id) AS "journal_id_count", sum("account_payment"."amount") AS "amount", "account_payment"."journal_id" AS "journal_id" from "account_payment" left join "account_journal" AS "account_payment__journal_id" on ("account_payment"."journal_id" = "account_payment__journal_id"."id") where (("account_payment"."partner_type" = ?) and ("account_payment"."warehouse_id" in (...))) group by "account_payment"."journal_id", "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code" order by "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code"; SELECT min("account_payment".id) AS id, count("account_payment".id) AS "journal_id_count", sum("account_payment"."amount") AS "amount", "account_payment"."journal_id" as "journal_id" FROM "account_payment" LEFT JOIN "account_journal" as "account_payment__journal_id" ON ("account_payment"."journal_id" = "account_payment__journal_id"."id") WHERE (("account_payment"."partner_type" = 'customer') AND ("account_payment"."warehouse_id" in (6))) GROUP BY "account_payment"."journal_id", "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code" ORDER BY "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code"; Date: 2026-04-07 10:46:27 Duration: 0ms
19	1	24.73 MiB	24.73 MiB	24.73 MiB	24.73 MiB	select min("account_report".id) as id, count("account_report".id) AS "__count", sum("account_report"."price_subtotal") AS "price_subtotal", date_trunc(?, "account_report"."invoice_date"::timestamp) AS "invoice_date" from "account_report" where (((("account_report"."state" not in (...)) or "account_report"."state" is null) and (("account_report"."type" = ?) or ("account_report"."type" = ?))) and (("account_report"."invoice_date" >= ?) and ("account_report"."invoice_date" < ?))) and ((account_report.company_id in (...)) and (account_report.brand_id is null or account_report.brand_id in (...)) and (account_report.warehouse_id in (...))) group by date_trunc(?, "account_report"."invoice_date"::timestamp) order by "invoice_date"; SELECT min("account_report".id) AS id, count("account_report".id) AS "__count", sum("account_report"."price_subtotal") AS "price_subtotal", date_trunc('month', "account_report"."invoice_date"::timestamp) as "invoice_date" FROM "account_report" WHERE (((("account_report"."state" not in ('draft', 'cancel')) OR "account_report"."state" IS NULL) AND (("account_report"."type" = 'out_invoice') OR ("account_report"."type" = 'out_refund'))) AND (("account_report"."invoice_date" >= '2026-03-01') AND ("account_report"."invoice_date" < '2026-04-01'))) AND ((account_report.company_id IN (1, 3)) AND (account_report.brand_id IS NULL OR account_report.brand_id in (1)) AND (account_report.warehouse_id in (10, 14, 48, 44, 135, 80, 29, 53, 163, 27, 45, 106, 138, 20))) GROUP BY date_trunc('month', "account_report"."invoice_date"::timestamp) ORDER BY "invoice_date"; Date: 2026-04-07 10:29:23 Duration: 0ms
20	1	23.90 MiB	23.90 MiB	23.90 MiB	23.90 MiB	select min("account_report".id) as id, count("account_report".id) AS "__count", sum("account_report"."price_subtotal") AS "price_subtotal", "account_report"."warehouse_id" AS "warehouse_id" from "account_report" left join "stock_warehouse" AS "account_report__warehouse_id" on ("account_report"."warehouse_id" = "account_report__warehouse_id"."id") where ((("account_report"."invoice_date" >= ?) and ("account_report"."invoice_date" < ?)) and (((("account_report"."state" not in (...)) or "account_report"."state" is null) and (("account_report"."type" = ?) or ("account_report"."type" = ?))) and (("account_report"."invoice_date" >= ?) and ("account_report"."invoice_date" < ?)))) and ((account_report.company_id in (...)) and (account_report.brand_id is null or account_report.brand_id in (...)) and (account_report.warehouse_id in (...))) group by "account_report"."warehouse_id", "account_report__warehouse_id"."sequence", "account_report__warehouse_id"."name" order by "account_report__warehouse_id"."sequence" asc, "account_report__warehouse_id"."name" asc; SELECT min("account_report".id) AS id, count("account_report".id) AS "__count", sum("account_report"."price_subtotal") AS "price_subtotal", "account_report"."warehouse_id" as "warehouse_id" FROM "account_report" LEFT JOIN "stock_warehouse" as "account_report__warehouse_id" ON ("account_report"."warehouse_id" = "account_report__warehouse_id"."id") WHERE ((("account_report"."invoice_date" >= '2026-03-01') AND ("account_report"."invoice_date" < '2026-04-01')) AND (((("account_report"."state" not in ('draft', 'cancel')) OR "account_report"."state" IS NULL) AND (("account_report"."type" = 'out_invoice') OR ("account_report"."type" = 'out_refund'))) AND (("account_report"."invoice_date" >= '2026-03-01') AND ("account_report"."invoice_date" < '2026-04-01')))) AND ((account_report.company_id IN (1, 3)) AND (account_report.brand_id IS NULL OR account_report.brand_id in (1)) AND (account_report.warehouse_id in (10, 14, 48, 44, 135, 80, 29, 53, 163, 27, 45, 106, 138, 20))) GROUP BY "account_report"."warehouse_id", "account_report__warehouse_id"."sequence", "account_report__warehouse_id"."name" ORDER BY "account_report__warehouse_id"."sequence" ASC, "account_report__warehouse_id"."name" ASC; Date: 2026-04-07 10:29:28 Duration: 0ms

Queries generating the largest temporary files

Rank	Size	Query
1	282.25 MiB	SELECT min("account_report".id) AS id, count("account_report".id) AS "__count", sum("account_report"."price_subtotal") AS "price_subtotal" FROM "account_report" WHERE ((((("account_report"."state" not in ('draft', 'cancel')) OR "account_report"."state" IS NULL) AND (("account_report"."type" = 'out_invoice') OR ("account_report"."type" = 'out_refund'))) AND ("account_report"."invoice_date" >= '2025-01-01')) AND ("account_report"."partner_custom_attribute_1" in (73, 83, 91, 93))) AND ((account_report.company_id IN (1, 3)) AND (account_report.warehouse_id in (1, 93, 10, 6, 107, 14, 157, 2, 131, 121, 132, 46, 48, 44, 34, 55, 160, 49, 28, 153, 57, 135, 150, 54, 75, 118, 22, 68, 81, 52, 83, 126, 103, 151, 80, 56, 98, 35, 87, 43, 29, 53, 37, 63, 147, 128, 50, 117, 19, 33, 77, 60, 70, 149, 92, 134, 152, 158, 166, 113, 84, 32, 163, 127, 159, 110, 139, 119, 164, 85, 26, 104, 99, 136, 154, 61, 38, 36, 18, 165, 27, 40, 162, 39, 94, 62, 16, 42, 76, 141, 73, 58, 90, 17, 145, 112, 100, 155, 24, 74, 114, 79, 130, 133, 142, 25, 15, 45, 148, 95, 21, 51, 120, 137, 47, 96, 23, 116, 111, 66, 105, 109, 106, 91, 129, 115, 101, 138, 41, 156, 71, 97, 146, 20, 69, 64, 178))); [ Date: 2026-04-07 13:10:34 ]
2	267.98 MiB	SELECT min("account_report".id) AS id, count("account_report".id) AS "__count", sum("account_report"."price_subtotal") AS "price_subtotal" FROM "account_report" WHERE ((((("account_report"."state" not in ('draft', 'cancel')) OR "account_report"."state" IS NULL) AND (("account_report"."type" = 'out_invoice') OR ("account_report"."type" = 'out_refund'))) AND ("account_report"."invoice_date" >= '2025-01-01')) AND ("account_report"."partner_custom_attribute_1" in (73, 83, 91, 93))) AND ((account_report.company_id IN (1, 3)) AND (account_report.warehouse_id in (1, 93, 10, 6, 107, 14, 157, 2, 131, 121, 132, 46, 48, 44, 34, 55, 160, 49, 28, 153, 57, 135, 150, 54, 75, 118, 22, 68, 81, 52, 83, 126, 103, 151, 80, 56, 98, 35, 87, 43, 29, 53, 37, 63, 147, 128, 50, 117, 19, 33, 77, 60, 70, 149, 92, 134, 152, 158, 166, 113, 84, 32, 163, 127, 159, 110, 139, 119, 164, 85, 26, 104, 99, 136, 154, 61, 38, 36, 18, 165, 27, 40, 162, 39, 94, 62, 16, 42, 76, 141, 73, 58, 90, 17, 145, 112, 100, 155, 24, 74, 114, 79, 130, 133, 142, 25, 15, 45, 148, 95, 21, 51, 120, 137, 47, 96, 23, 116, 111, 66, 105, 109, 106, 91, 129, 115, 101, 138, 41, 156, 71, 97, 146, 20, 69, 64, 178))); [ Date: 2026-04-07 13:10:34 ]
3	96.91 MiB	SELECT min("account_payment".id) AS id, count("account_payment".id) AS "journal_id_count", sum("account_payment"."amount") AS "amount", "account_payment"."journal_id" as "journal_id" FROM "account_payment" LEFT JOIN "account_journal" as "account_payment__journal_id" ON ("account_payment"."journal_id" = "account_payment__journal_id"."id") WHERE ("account_payment"."partner_type" = 'customer') GROUP BY "account_payment"."journal_id", "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code" ORDER BY "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code"; [ Date: 2026-04-07 10:45:59 ]
4	96.58 MiB	SELECT min("account_payment".id) AS id, count("account_payment".id) AS "journal_id_count", sum("account_payment"."amount") AS "amount", "account_payment"."journal_id" as "journal_id" FROM "account_payment" LEFT JOIN "account_journal" as "account_payment__journal_id" ON ("account_payment"."journal_id" = "account_payment__journal_id"."id") WHERE ("account_payment"."partner_type" = 'customer') GROUP BY "account_payment"."journal_id", "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code" ORDER BY "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code"; [ Date: 2026-04-07 10:45:59 ]
5	96.45 MiB	SELECT min("account_payment".id) AS id, count("account_payment".id) AS "journal_id_count", sum("account_payment"."amount") AS "amount", "account_payment"."journal_id" as "journal_id" FROM "account_payment" LEFT JOIN "account_journal" as "account_payment__journal_id" ON ("account_payment"."journal_id" = "account_payment__journal_id"."id") WHERE ("account_payment"."partner_type" = 'customer') GROUP BY "account_payment"."journal_id", "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code" ORDER BY "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code"; [ Date: 2026-04-07 10:45:42 ]
6	92.80 MiB	SELECT min("account_payment".id) AS id, count("account_payment".id) AS "journal_id_count", sum("account_payment"."amount") AS "amount", "account_payment"."journal_id" as "journal_id" FROM "account_payment" LEFT JOIN "account_journal" as "account_payment__journal_id" ON ("account_payment"."journal_id" = "account_payment__journal_id"."id") WHERE ("account_payment"."partner_type" = 'customer') GROUP BY "account_payment"."journal_id", "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code" ORDER BY "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code"; [ Date: 2026-04-07 10:45:41 ]
7	91.18 MiB	SELECT min("account_payment".id) AS id, count("account_payment".id) AS "journal_id_count", sum("account_payment"."amount") AS "amount", "account_payment"."journal_id" as "journal_id" FROM "account_payment" LEFT JOIN "account_journal" as "account_payment__journal_id" ON ("account_payment"."journal_id" = "account_payment__journal_id"."id") WHERE ("account_payment"."partner_type" = 'customer') GROUP BY "account_payment"."journal_id", "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code" ORDER BY "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code"; [ Date: 2026-04-07 10:45:58 ]
8	90.92 MiB	SELECT min("account_payment".id) AS id, count("account_payment".id) AS "journal_id_count", sum("account_payment"."amount") AS "amount", "account_payment"."journal_id" as "journal_id" FROM "account_payment" LEFT JOIN "account_journal" as "account_payment__journal_id" ON ("account_payment"."journal_id" = "account_payment__journal_id"."id") WHERE ("account_payment"."partner_type" = 'customer') GROUP BY "account_payment"."journal_id", "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code" ORDER BY "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code"; [ Date: 2026-04-07 10:45:41 ]
9	89.16 MiB	SELECT min("account_payment".id) AS id, count("account_payment".id) AS "journal_id_count", sum("account_payment"."amount") AS "amount", "account_payment"."journal_id" as "journal_id" FROM "account_payment" LEFT JOIN "account_journal" as "account_payment__journal_id" ON ("account_payment"."journal_id" = "account_payment__journal_id"."id") WHERE ("account_payment"."partner_type" = 'customer') GROUP BY "account_payment"."journal_id", "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code" ORDER BY "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code"; [ Date: 2026-04-07 10:45:41 ]
10	88.87 MiB	SELECT min("account_payment".id) AS id, count("account_payment".id) AS "journal_id_count", sum("account_payment"."amount") AS "amount", "account_payment"."journal_id" as "journal_id" FROM "account_payment" LEFT JOIN "account_journal" as "account_payment__journal_id" ON ("account_payment"."journal_id" = "account_payment__journal_id"."id") WHERE ("account_payment"."partner_type" = 'customer') GROUP BY "account_payment"."journal_id", "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code" ORDER BY "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code"; [ Date: 2026-04-07 10:45:41 ]
11	87.66 MiB	SELECT min("stock_move_line".id) AS id, count("stock_move_line".id) AS "product_id_count", sum("stock_move_line"."qty_done") AS "qty_done", "stock_move_line"."product_id" as "product_id" FROM "stock_move_line" LEFT JOIN "product_product" as "stock_move_line__product_id" ON ("stock_move_line"."product_id" = "stock_move_line__product_id"."id") LEFT JOIN "product_template" as "stock_move_line__product_id__product_tmpl_id" ON ("stock_move_line__product_id"."product_tmpl_id" = "stock_move_line__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" as "stock_move_line__product_id__product_tmpl_id__name" ON ("stock_move_line__product_id__product_tmpl_id"."id" = "stock_move_line__product_id__product_tmpl_id__name"."res_id" AND "stock_move_line__product_id__product_tmpl_id__name"."type" = 'model' AND "stock_move_line__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "stock_move_line__product_id__product_tmpl_id__name"."lang" = 'fr_FR' AND "stock_move_line__product_id__product_tmpl_id__name"."value" != '') WHERE ("stock_move_line"."state" = 'done') AND ((stock_move_line.company_id IN (1)) AND (stock_move_line.warehouse_id IS NULL OR stock_move_line.warehouse_id IN (10, 107)) AND (stock_move_line.brand_id IS NULL OR stock_move_line.brand_id IN (1))) GROUP BY "stock_move_line"."product_id", "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" ORDER BY "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" LIMIT 80; [ Date: 2026-04-07 11:50:37 ]
12	86.84 MiB	SELECT min("account_payment".id) AS id, count("account_payment".id) AS "journal_id_count", sum("account_payment"."amount") AS "amount", "account_payment"."journal_id" as "journal_id" FROM "account_payment" LEFT JOIN "account_journal" as "account_payment__journal_id" ON ("account_payment"."journal_id" = "account_payment__journal_id"."id") WHERE ("account_payment"."partner_type" = 'customer') GROUP BY "account_payment"."journal_id", "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code" ORDER BY "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code"; [ Date: 2026-04-07 10:45:59 ]
13	86.70 MiB	SELECT min("account_payment".id) AS id, count("account_payment".id) AS "journal_id_count", sum("account_payment"."amount") AS "amount", "account_payment"."journal_id" as "journal_id" FROM "account_payment" LEFT JOIN "account_journal" as "account_payment__journal_id" ON ("account_payment"."journal_id" = "account_payment__journal_id"."id") WHERE ("account_payment"."partner_type" = 'customer') GROUP BY "account_payment"."journal_id", "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code" ORDER BY "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code"; [ Date: 2026-04-07 10:45:59 ]
14	85.23 MiB	SELECT min("stock_move_line".id) AS id, count("stock_move_line".id) AS "product_id_count", "stock_move_line"."product_id" as "product_id" FROM "stock_move_line" LEFT JOIN "product_product" as "stock_move_line__product_id" ON ("stock_move_line"."product_id" = "stock_move_line__product_id"."id") LEFT JOIN "product_template" as "stock_move_line__product_id__product_tmpl_id" ON ("stock_move_line__product_id"."product_tmpl_id" = "stock_move_line__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" as "stock_move_line__product_id__product_tmpl_id__name" ON ("stock_move_line__product_id__product_tmpl_id"."id" = "stock_move_line__product_id__product_tmpl_id__name"."res_id" AND "stock_move_line__product_id__product_tmpl_id__name"."type" = 'model' AND "stock_move_line__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "stock_move_line__product_id__product_tmpl_id__name"."lang" = 'fr_FR' AND "stock_move_line__product_id__product_tmpl_id__name"."value" != '') WHERE ("stock_move_line"."state" = 'done') AND ((stock_move_line.company_id IN (1)) AND (stock_move_line.warehouse_id IS NULL OR stock_move_line.warehouse_id IN (10, 107)) AND (stock_move_line.brand_id IS NULL OR stock_move_line.brand_id IN (1))) GROUP BY "stock_move_line"."product_id", "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" ORDER BY "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" LIMIT 100000 OFFSET 80; [ Date: 2026-04-07 11:50:43 ]
15	83.22 MiB	SELECT min("stock_move_line".id) AS id, count("stock_move_line".id) AS "product_id_count", sum("stock_move_line"."qty_done") AS "qty_done", "stock_move_line"."product_id" as "product_id" FROM "stock_move_line" LEFT JOIN "product_product" as "stock_move_line__product_id" ON ("stock_move_line"."product_id" = "stock_move_line__product_id"."id") LEFT JOIN "product_template" as "stock_move_line__product_id__product_tmpl_id" ON ("stock_move_line__product_id"."product_tmpl_id" = "stock_move_line__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" as "stock_move_line__product_id__product_tmpl_id__name" ON ("stock_move_line__product_id__product_tmpl_id"."id" = "stock_move_line__product_id__product_tmpl_id__name"."res_id" AND "stock_move_line__product_id__product_tmpl_id__name"."type" = 'model' AND "stock_move_line__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "stock_move_line__product_id__product_tmpl_id__name"."lang" = 'fr_FR' AND "stock_move_line__product_id__product_tmpl_id__name"."value" != '') WHERE ("stock_move_line"."state" = 'done') AND ((stock_move_line.company_id IN (1)) AND (stock_move_line.warehouse_id IS NULL OR stock_move_line.warehouse_id IN (10, 107)) AND (stock_move_line.brand_id IS NULL OR stock_move_line.brand_id IN (1))) GROUP BY "stock_move_line"."product_id", "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" ORDER BY "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" LIMIT 80; [ Date: 2026-04-07 11:50:37 ]
16	81.84 MiB	SELECT min("stock_move_line".id) AS id, count("stock_move_line".id) AS "product_id_count", sum("stock_move_line"."qty_done") AS "qty_done", "stock_move_line"."product_id" as "product_id" FROM "stock_move_line" LEFT JOIN "product_product" as "stock_move_line__product_id" ON ("stock_move_line"."product_id" = "stock_move_line__product_id"."id") LEFT JOIN "product_template" as "stock_move_line__product_id__product_tmpl_id" ON ("stock_move_line__product_id"."product_tmpl_id" = "stock_move_line__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" as "stock_move_line__product_id__product_tmpl_id__name" ON ("stock_move_line__product_id__product_tmpl_id"."id" = "stock_move_line__product_id__product_tmpl_id__name"."res_id" AND "stock_move_line__product_id__product_tmpl_id__name"."type" = 'model' AND "stock_move_line__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "stock_move_line__product_id__product_tmpl_id__name"."lang" = 'fr_FR' AND "stock_move_line__product_id__product_tmpl_id__name"."value" != '') WHERE ("stock_move_line"."state" = 'done') AND ((stock_move_line.company_id IN (1)) AND (stock_move_line.warehouse_id IS NULL OR stock_move_line.warehouse_id IN (10, 107)) AND (stock_move_line.brand_id IS NULL OR stock_move_line.brand_id IN (1))) GROUP BY "stock_move_line"."product_id", "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" ORDER BY "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" LIMIT 80; [ Date: 2026-04-07 11:50:37 ]
17	80.43 MiB	SELECT min("stock_move_line".id) AS id, count("stock_move_line".id) AS "product_id_count", sum("stock_move_line"."qty_done") AS "qty_done", "stock_move_line"."product_id" as "product_id" FROM "stock_move_line" LEFT JOIN "product_product" as "stock_move_line__product_id" ON ("stock_move_line"."product_id" = "stock_move_line__product_id"."id") LEFT JOIN "product_template" as "stock_move_line__product_id__product_tmpl_id" ON ("stock_move_line__product_id"."product_tmpl_id" = "stock_move_line__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" as "stock_move_line__product_id__product_tmpl_id__name" ON ("stock_move_line__product_id__product_tmpl_id"."id" = "stock_move_line__product_id__product_tmpl_id__name"."res_id" AND "stock_move_line__product_id__product_tmpl_id__name"."type" = 'model' AND "stock_move_line__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "stock_move_line__product_id__product_tmpl_id__name"."lang" = 'fr_FR' AND "stock_move_line__product_id__product_tmpl_id__name"."value" != '') WHERE ("stock_move_line"."state" = 'done') AND ((stock_move_line.company_id IN (1)) AND (stock_move_line.warehouse_id IS NULL OR stock_move_line.warehouse_id IN (10, 107)) AND (stock_move_line.brand_id IS NULL OR stock_move_line.brand_id IN (1))) GROUP BY "stock_move_line"."product_id", "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" ORDER BY "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" LIMIT 80; [ Date: 2026-04-07 11:50:37 ]
18	79.91 MiB	SELECT min("stock_move_line".id) AS id, count("stock_move_line".id) AS "product_id_count", "stock_move_line"."product_id" as "product_id" FROM "stock_move_line" LEFT JOIN "product_product" as "stock_move_line__product_id" ON ("stock_move_line"."product_id" = "stock_move_line__product_id"."id") LEFT JOIN "product_template" as "stock_move_line__product_id__product_tmpl_id" ON ("stock_move_line__product_id"."product_tmpl_id" = "stock_move_line__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" as "stock_move_line__product_id__product_tmpl_id__name" ON ("stock_move_line__product_id__product_tmpl_id"."id" = "stock_move_line__product_id__product_tmpl_id__name"."res_id" AND "stock_move_line__product_id__product_tmpl_id__name"."type" = 'model' AND "stock_move_line__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "stock_move_line__product_id__product_tmpl_id__name"."lang" = 'fr_FR' AND "stock_move_line__product_id__product_tmpl_id__name"."value" != '') WHERE ("stock_move_line"."state" = 'done') AND ((stock_move_line.company_id IN (1)) AND (stock_move_line.warehouse_id IS NULL OR stock_move_line.warehouse_id IN (10, 107)) AND (stock_move_line.brand_id IS NULL OR stock_move_line.brand_id IN (1))) GROUP BY "stock_move_line"."product_id", "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" ORDER BY "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" LIMIT 100000 OFFSET 80; [ Date: 2026-04-07 11:50:42 ]
19	77.58 MiB	SELECT min("stock_move_line".id) AS id, count("stock_move_line".id) AS "product_id_count", sum("stock_move_line"."qty_done") AS "qty_done", "stock_move_line"."product_id" as "product_id" FROM "stock_move_line" LEFT JOIN "product_product" as "stock_move_line__product_id" ON ("stock_move_line"."product_id" = "stock_move_line__product_id"."id") LEFT JOIN "product_template" as "stock_move_line__product_id__product_tmpl_id" ON ("stock_move_line__product_id"."product_tmpl_id" = "stock_move_line__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" as "stock_move_line__product_id__product_tmpl_id__name" ON ("stock_move_line__product_id__product_tmpl_id"."id" = "stock_move_line__product_id__product_tmpl_id__name"."res_id" AND "stock_move_line__product_id__product_tmpl_id__name"."type" = 'model' AND "stock_move_line__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "stock_move_line__product_id__product_tmpl_id__name"."lang" = 'fr_FR' AND "stock_move_line__product_id__product_tmpl_id__name"."value" != '') WHERE ("stock_move_line"."state" = 'done') AND ((stock_move_line.company_id IN (1)) AND (stock_move_line.warehouse_id IS NULL OR stock_move_line.warehouse_id IN (10, 107)) AND (stock_move_line.brand_id IS NULL OR stock_move_line.brand_id IN (1))) GROUP BY "stock_move_line"."product_id", "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" ORDER BY "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" LIMIT 80; [ Date: 2026-04-07 11:50:37 ]
20	74.22 MiB	SELECT min("stock_move_line".id) AS id, count("stock_move_line".id) AS "product_id_count", "stock_move_line"."product_id" as "product_id" FROM "stock_move_line" LEFT JOIN "product_product" as "stock_move_line__product_id" ON ("stock_move_line"."product_id" = "stock_move_line__product_id"."id") LEFT JOIN "product_template" as "stock_move_line__product_id__product_tmpl_id" ON ("stock_move_line__product_id"."product_tmpl_id" = "stock_move_line__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" as "stock_move_line__product_id__product_tmpl_id__name" ON ("stock_move_line__product_id__product_tmpl_id"."id" = "stock_move_line__product_id__product_tmpl_id__name"."res_id" AND "stock_move_line__product_id__product_tmpl_id__name"."type" = 'model' AND "stock_move_line__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "stock_move_line__product_id__product_tmpl_id__name"."lang" = 'fr_FR' AND "stock_move_line__product_id__product_tmpl_id__name"."value" != '') WHERE ("stock_move_line"."state" = 'done') AND ((stock_move_line.company_id IN (1)) AND (stock_move_line.warehouse_id IS NULL OR stock_move_line.warehouse_id IN (10, 107)) AND (stock_move_line.brand_id IS NULL OR stock_move_line.brand_id IN (1))) GROUP BY "stock_move_line"."product_id", "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" ORDER BY "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" LIMIT 100000 OFFSET 80; [ Date: 2026-04-07 11:50:42 ]

Vacuums / Analyzes Distribution

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date
0 sec Highest CPU-cost analyze
Table
Database
Date

Analyzes per table

Key values

public.res_users_activity (111) Main table analyzed (database odoo)
338 analyzes Total

Chart
Table

Table	Number of analyzes
odoo.public.res_users_activity	111
odoo.public.bus_presence	59
odoo.public.ir_cron	23
odoo.public.ir_sequence_date_range	15
odoo.public.bus_bus	11
odoo.public.sig_edi_document	11
odoo.public.stock_invoice_onshipping	11
odoo.public.mass_reconcile_advanced_partner	10
odoo.public.mass_reconcile_advanced_partner_res_partner_rel	10
odoo.public.initial_balance_line_wizard	9
odoo.public.product_promotion_stock_choose_wizard	7
odoo.public.mail_compose_message	5
odoo.public.mail_channel_partner	4
odoo.public.product_promo_st_choose_wizard_offer_choices	4
odoo.public.product_promo_stock_choose_promo_offer_avail_rel	3
odoo.public.stock_immediate_transfer	2
odoo.public.res_partner_balance	2
odoo.public.res_users_fcm_token	2
odoo.public.product_promotion_choose_wizard	2
odoo.public.planning_availability_survey_line	2
odoo.public.product_promotion_choose_wizard_offer_choices	2
odoo.public.initial_balance_wizard	2
odoo.public.stock_picking_transfer_rel	2
odoo.public.inventory_report_wizard_warehouse_rel	1
odoo.public.account_journal_account_partner_balance_wizard_rel	1
odoo.public.audit_issue	1
odoo.public.product_promo_choose_promo_offer_avail_rel	1
odoo.public.stock_return_picking	1
odoo.public.res_users_log	1
odoo.public.stock_return_picking_line	1
odoo.public.planning_warehouse_location	1
odoo.public.product_product	1
odoo.public.res_users	1
odoo.public.availability_survey_product_selector_linear	1
odoo.public.planning_planning	1
odoo.public.res_partner	1
odoo.public.stock_picking_cancel_wizard	1
odoo.public.inventory_report_wizard_location_rel	1
odoo.public.res_partner_company_rel	1
odoo.public.product_warehouse_cost	1
odoo.public.account_move_reversal	1
odoo.public.modify_partner_rel	1
odoo.public.inventory_report_wizard	1
odoo.public.change_password_user	1
odoo.public.planning_template_event_filter_wizard	1
odoo.public.close_bank_statement_wizard	1
odoo.public.res_partner_pricelist	1
odoo.public.wizard_modify_partner	1
odoo.public.inventory_report_wizard_product_rel	1
odoo.public.res_users_product_limit	1
odoo.public.affect_loading_request_wizard	1
odoo.public.stock_picking_auto_validate_wizard	1
Total	338

Vacuums per table

Key values

public.res_users_activity (50) Main table vacuumed on database odoo
115 vacuums Total

Chart
Table

Table	Number of vacuums	Index scans
odoo.public.res_users_activity	50	34
odoo.public.bus_presence	25	0
odoo.public.bus_bus	5	3
odoo.public.mass_reconcile_advanced_partner_res_partner_rel	5	2
odoo.public.mass_reconcile_advanced_partner	5	2
odoo.public.mail_compose_message	5	2
odoo.public.stock_invoice_onshipping	4	2
odoo.public.initial_balance_line_wizard	4	2
odoo.public.inventory_report_wizard_product_rel	1	0
odoo.public.product_promo_st_choose_wizard_offer_choices	1	1
odoo.public.stock_immediate_transfer	1	1
odoo.pg_catalog.pg_statistic	1	1
odoo.public.product_promotion_stock_choose_wizard	1	1
odoo.public.stock_picking_transfer_rel	1	1
odoo.public.res_partner_balance	1	1
odoo.public.stock_return_picking_line	1	1
odoo.public.res_users_log	1	1
odoo.public.product_promo_stock_choose_promo_offer_avail_rel	1	1
odoo.public.ir_sequence_date_range	1	0
odoo.public.planning_template_brand_rel	1	1
Total	115	57

Tuples removed per table

Key values

public.bus_bus (34731) Main table with removed tuples on database odoo
121452 tuples Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
odoo.public.bus_bus	5	3	34731	0
odoo.public.res_users_activity	50	34	32085	0
odoo.public.bus_presence	25	0	18580	0
odoo.public.initial_balance_line_wizard	4	2	7098	0
odoo.public.res_partner_balance	1	1	6066	0
odoo.public.stock_invoice_onshipping	4	2	5865	0
odoo.public.mass_reconcile_advanced_partner_res_partner_rel	5	2	5585	0
odoo.public.mass_reconcile_advanced_partner	5	2	5585	0
odoo.public.mail_compose_message	5	2	1369	0
odoo.public.ir_sequence_date_range	1	0	1025	0
odoo.public.planning_template_brand_rel	1	1	876	0
odoo.pg_catalog.pg_statistic	1	1	738	0
odoo.public.product_promotion_stock_choose_wizard	1	1	580	26
odoo.public.product_promo_st_choose_wizard_offer_choices	1	1	380	0
odoo.public.res_users_log	1	1	374	0
odoo.public.stock_picking_transfer_rel	1	1	268	0
odoo.public.stock_return_picking_line	1	1	127	0
odoo.public.stock_immediate_transfer	1	1	94	0
odoo.public.product_promo_stock_choose_promo_offer_avail_rel	1	1	26	0
odoo.public.inventory_report_wizard_product_rel	1	0	0	0
Total	115	57	121,452	26

Pages removed per table

Key values

public.product_promotion_stock_choose_wizard (26) Main table with removed pages on database odoo
26 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
odoo.public.product_promotion_stock_choose_wizard	1	1	580	26
odoo.public.bus_bus	5	3	34731	0
odoo.public.mass_reconcile_advanced_partner_res_partner_rel	5	2	5585	0
odoo.public.inventory_report_wizard_product_rel	1	0	0	0
odoo.public.product_promo_st_choose_wizard_offer_choices	1	1	380	0
odoo.public.stock_immediate_transfer	1	1	94	0
odoo.pg_catalog.pg_statistic	1	1	738	0
odoo.public.mass_reconcile_advanced_partner	5	2	5585	0
odoo.public.stock_picking_transfer_rel	1	1	268	0
odoo.public.mail_compose_message	5	2	1369	0
odoo.public.res_partner_balance	1	1	6066	0
odoo.public.stock_return_picking_line	1	1	127	0
odoo.public.res_users_log	1	1	374	0
odoo.public.product_promo_stock_choose_promo_offer_avail_rel	1	1	26	0
odoo.public.res_users_activity	50	34	32085	0
odoo.public.ir_sequence_date_range	1	0	1025	0
odoo.public.planning_template_brand_rel	1	1	876	0
odoo.public.stock_invoice_onshipping	4	2	5865	0
odoo.public.bus_presence	25	0	18580	0
odoo.public.initial_balance_line_wizard	4	2	7098	0
Total	115	57	121,452	26

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Apr 07	10	36	83
	11	38	92
	12	25	88
	13	16	75

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

ShareLock Main Lock Type
17 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
RowExclusiveLock		5	2m39s	31s858ms
	relation	5	2m39s	31s858ms
ShareLock		12	1m17s	6s473ms
	transaction	12	1m17s	6s473ms
	Total	17	3m56s	13s939ms

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	1	1m15s	1m15s	1m15s	1m15s	insert into "ir_attachment" ("id", "create_uid", "create_date", "write_uid", "write_date", "_ruid", "checksum", "company_id", "db_datas", "file_size", "index_content", "mimetype", "name", "public", "res_field", "res_id", "res_model", "store_fname", "temporary", "type") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), ?, ?, ?, null, ?, ?, ?, ?, true, ?, ?, ?, ?, false, ?) returning id; INSERT INTO "ir_attachment" ("id", "create_uid", "create_date", "write_uid", "write_date", "_ruid", "checksum", "company_id", "db_datas", "file_size", "index_content", "mimetype", "name", "public", "res_field", "res_id", "res_model", "store_fname", "temporary", "type") VALUES (nextval('ir_attachment_id_seq'), 6071, (now() at time zone 'UTC'), 6071, (now() at time zone 'UTC'), '5f96db2d-02bb-404f-b001-0e999faee61e', 'cc8f700618e8e12617f4c4344883b9278f6bdef9', 3, NULL, 164415, 'image', 'image/jpeg', 'image_1920', true, 'image_1920', 7683467, 'survey.user_input_line.image', 'cc/cc8f700618e8e12617f4c4344883b9278f6bdef9', false, 'binary') RETURNING id; Date: 2026-04-07 10:57:39 INSERT INTO "ir_attachment" ("id", "create_uid", "create_date", "write_uid", "write_date", "_ruid", "checksum", "company_id", "db_datas", "file_size", "index_content", "mimetype", "name", "public", "res_field", "res_id", "res_model", "store_fname", "temporary", "type") VALUES (nextval('ir_attachment_id_seq'), 6071, (now() at time zone 'UTC'), 6071, (now() at time zone 'UTC'), '5f96db2d-02bb-404f-b001-0e999faee61e', 'cc8f700618e8e12617f4c4344883b9278f6bdef9', 3, NULL, 164415, 'image', 'image/jpeg', 'image_1920', true, 'image_1920', 7683467, 'survey.user_input_line.image', 'cc/cc8f700618e8e12617f4c4344883b9278f6bdef9', false, 'binary') RETURNING id; Date: 2026-04-07 10:57:39
2	6	48s103ms	9s517ms	9s936ms	8s17ms	update "stock_quant" set "write_uid" = ?, "reserved_quantity" = ?.?, "write_date" = (now() at time zone ?) where id in (...); UPDATE "stock_quant" SET "write_uid" = 1, "reserved_quantity" = 2167.0, "write_date" = (now() at time zone 'UTC') WHERE id IN (38846940); Date: 2026-04-07 12:31:38 UPDATE "stock_quant" SET "write_uid" = 1, "reserved_quantity" = 295.0, "write_date" = (now() at time zone 'UTC') WHERE id IN (39533379); Date: 2026-04-07 13:26:58
3	1	33s736ms	33s736ms	33s736ms	33s736ms	delete from calendar_event where id in (...); DELETE FROM calendar_event WHERE id IN (52942473); Date: 2026-04-07 13:23:05 DELETE FROM calendar_event WHERE id IN (52938257); Date: 2026-04-07 12:33:05 DELETE FROM calendar_event WHERE id IN (52941887); Date: 2026-04-07 13:01:25
4	1	32s268ms	32s268ms	32s268ms	32s268ms	update "account_move" set "amount_residual" = ?, "amount_residual_signed" = ?, "is_partially_or_fully_reconciled" = true, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...); UPDATE "account_move" SET "amount_residual" = '1.81', "amount_residual_signed" = '1.81', "is_partially_or_fully_reconciled" = true, "write_uid" = 356, "write_date" = (now() at time zone 'UTC') WHERE id IN (63464029); Date: 2026-04-07 13:23:05 UPDATE "account_move" SET "amount_residual" = '1.81', "amount_residual_signed" = '1.81', "is_partially_or_fully_reconciled" = true, "write_uid" = 356, "write_date" = (now() at time zone 'UTC') WHERE id IN (63464029); Date: 2026-04-07 13:23:05
5	1	17s885ms	17s885ms	17s885ms	17s885ms	update "calendar_event" set "visited_fail" = false, "visited_success" = false, "visited" = false, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...); UPDATE "calendar_event" SET "visited_fail" = false, "visited_success" = false, "visited" = false, "write_uid" = 3467, "write_date" = (now() at time zone 'UTC') WHERE id IN (52942473); Date: 2026-04-07 13:24:04
6	1	13s990ms	13s990ms	13s990ms	13s990ms	insert into "account_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "auto_post", "brand_id", "currency_id", "date", "event_id", "invoice_date", "invoice_incoterm_id", "invoice_sent", "invoice_user_id", "journal_id", "name", "partner_id", "planning_id", "ref", "state", "team_id", "temp_codification", "to_check", "type") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), false, ?, ?, ?, ?, null, null, false, ?, ?, ?, ?, ?, ?, ?, null, false, false, ?) returning id; INSERT INTO "account_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "auto_post", "brand_id", "currency_id", "date", "event_id", "invoice_date", "invoice_incoterm_id", "invoice_sent", "invoice_user_id", "journal_id", "name", "partner_id", "planning_id", "ref", "state", "team_id", "temp_codification", "to_check", "type") VALUES (nextval('account_move_id_seq'), 988, (now() at time zone 'UTC'), 988, (now() at time zone 'UTC'), false, 1, 114, '2026-04-07', 52496117, NULL, NULL, false, 3026, 971, '/', 24186, 954997, '0417820260328083230', 'draft', NULL, false, false, 'entry') RETURNING id; Date: 2026-04-07 13:23:05 INSERT INTO "account_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "auto_post", "brand_id", "currency_id", "date", "event_id", "invoice_date", "invoice_incoterm_id", "invoice_sent", "invoice_user_id", "journal_id", "name", "partner_id", "planning_id", "ref", "state", "team_id", "temp_codification", "to_check", "type") VALUES (nextval('account_move_id_seq'), 988, (now() at time zone 'UTC'), 988, (now() at time zone 'UTC'), false, 1, 114, '2026-04-07', 52496117, NULL, NULL, false, 3026, 971, '/', 24186, 954997, '0417820260328083230', 'draft', NULL, false, false, 'entry') RETURNING id; Date: 2026-04-07 13:23:05
7	2	6s988ms	3s494ms	3s494ms	3s494ms	insert into bank_statement_vendor_move_line_rel (bank_statement_id, move_line_id) values (?, ?), (?, ?) on conflict do nothing; INSERT INTO bank_statement_vendor_move_line_rel (bank_statement_id, move_line_id) VALUES (267671, 169663663), (267671, 169663315) ON CONFLICT DO NOTHING; Date: 2026-04-07 13:49:18
8	1	3s825ms	3s825ms	3s825ms	3s825ms	insert into "account_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "auto_post", "currency_id", "date", "invoice_date", "invoice_incoterm_id", "invoice_sent", "invoice_user_id", "journal_id", "name", "partner_id", "ref", "state", "team_id", "temp_codification", "to_check", "type") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), false, ?, ?, null, null, false, ?, ?, ?, ?, null, ?, null, true, false, ?) returning id; INSERT INTO "account_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "auto_post", "currency_id", "date", "invoice_date", "invoice_incoterm_id", "invoice_sent", "invoice_user_id", "journal_id", "name", "partner_id", "ref", "state", "team_id", "temp_codification", "to_check", "type") VALUES (nextval('account_move_id_seq'), 1, (now() at time zone 'UTC'), 1, (now() at time zone 'UTC'), false, 114, '2025-10-26', NULL, NULL, false, 4319, 969, '0431920251026122349', 150215, NULL, 'draft', NULL, true, false, 'entry') RETURNING id; Date: 2026-04-07 13:23:05 INSERT INTO "account_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "auto_post", "currency_id", "date", "invoice_date", "invoice_incoterm_id", "invoice_sent", "invoice_user_id", "journal_id", "name", "partner_id", "ref", "state", "team_id", "temp_codification", "to_check", "type") VALUES (nextval('account_move_id_seq'), 1, (now() at time zone 'UTC'), 1, (now() at time zone 'UTC'), false, 114, '2025-10-26', NULL, NULL, false, 4319, 969, '0431920251026122349', 150215, NULL, 'draft', NULL, true, false, 'entry') RETURNING id; Date: 2026-04-07 13:23:05
9	2	3s677ms	1s247ms	2s429ms	1s838ms	update "stock_picking" set "write_uid" = ?, "partner_longitude" = ?, "write_date" = (now() at time zone ?) where id in (...); UPDATE "stock_picking" SET "write_uid" = 2114, "partner_longitude" = '-0.56807', "write_date" = (now() at time zone 'UTC') WHERE id IN (9382105); Date: 2026-04-07 12:34:45
10	1	1s26ms	1s26ms	1s26ms	1s26ms	insert into "calendar_event" ("id", "create_uid", "create_date", "write_uid", "write_date", "_ruid", "active", "address", "allday", "count", "currency_id", "date", "day", "duration", "end_type", "event_tz", "in_template", "interval", "month_by", "name", "partner_customer_id", "planning_id", "privacy", "sequence", "show_as", "start", "state", "stop", "user_id", "validation_state") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), ?, true, ?, false, ?, ?, ?, ?, ?.?, ?, ?, false, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) returning id; INSERT INTO "calendar_event" ("id", "create_uid", "create_date", "write_uid", "write_date", "_ruid", "active", "address", "allday", "count", "currency_id", "date", "day", "duration", "end_type", "event_tz", "in_template", "interval", "month_by", "name", "partner_customer_id", "planning_id", "privacy", "sequence", "show_as", "start", "state", "stop", "user_id", "validation_state") VALUES (nextval('calendar_event_id_seq'), 372, (now() at time zone 'UTC'), 372, (now() at time zone 'UTC'), 'e1c41965-c677-4b16-9632-bb3af69fb85b', true, 'MOHRA NEDJM-EDDINE Wilaya de SÃ©tif SÃ©tif 19 190000 AlgÃ©rie', false, 1, 114, '2026-04-07 12:19:21', 'tuesday', 0.0, 'count', 'Africa/Algiers', false, 1, 'date', 'PL/PS/19/2601412/MOHRA NEDJM-EDDINE/tuesday2026-04-07 12:19:21', 55177, 967061, 'public', 12, 'busy', '2026-04-07 12:19:21', 'draft', '2026-04-07 12:19:21', 372, 'to_validate') RETURNING id; Date: 2026-04-07 12:19:27

Queries that waited the most

Rank	Wait time	Query
1	1m15s	INSERT INTO "ir_attachment" ("id", "create_uid", "create_date", "write_uid", "write_date", "_ruid", "checksum", "company_id", "db_datas", "file_size", "index_content", "mimetype", "name", "public", "res_field", "res_id", "res_model", "store_fname", "temporary", "type") VALUES (nextval('ir_attachment_id_seq'), 6071, (now() at time zone 'UTC'), 6071, (now() at time zone 'UTC'), '5f96db2d-02bb-404f-b001-0e999faee61e', 'cc8f700618e8e12617f4c4344883b9278f6bdef9', 3, NULL, 164415, 'image', 'image/jpeg', 'image_1920', true, 'image_1920', 7683467, 'survey.user_input_line.image', 'cc/cc8f700618e8e12617f4c4344883b9278f6bdef9', false, 'binary') RETURNING id; [ Date: 2026-04-07 10:57:39 ]
2	33s736ms	DELETE FROM calendar_event WHERE id IN (52942473); [ Date: 2026-04-07 13:23:05 ]
3	32s268ms	UPDATE "account_move" SET "amount_residual" = '1.81', "amount_residual_signed" = '1.81', "is_partially_or_fully_reconciled" = true, "write_uid" = 356, "write_date" = (now() at time zone 'UTC') WHERE id IN (63464029); [ Date: 2026-04-07 13:23:05 ]
4	17s885ms	UPDATE "calendar_event" SET "visited_fail" = false, "visited_success" = false, "visited" = false, "write_uid" = 3467, "write_date" = (now() at time zone 'UTC') WHERE id IN (52942473); [ Date: 2026-04-07 13:24:04 ]
5	13s990ms	INSERT INTO "account_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "auto_post", "brand_id", "currency_id", "date", "event_id", "invoice_date", "invoice_incoterm_id", "invoice_sent", "invoice_user_id", "journal_id", "name", "partner_id", "planning_id", "ref", "state", "team_id", "temp_codification", "to_check", "type") VALUES (nextval('account_move_id_seq'), 988, (now() at time zone 'UTC'), 988, (now() at time zone 'UTC'), false, 1, 114, '2026-04-07', 52496117, NULL, NULL, false, 3026, 971, '/', 24186, 954997, '0417820260328083230', 'draft', NULL, false, false, 'entry') RETURNING id; [ Date: 2026-04-07 13:23:05 ]
6	9s936ms	UPDATE "stock_quant" SET "write_uid" = 1, "reserved_quantity" = 6294.0, "write_date" = (now() at time zone 'UTC') WHERE id IN (37407791); [ Date: 2026-04-07 13:48:51 ]
7	9s837ms	UPDATE "stock_quant" SET "write_uid" = 745, "reserved_quantity" = 4810.0, "write_date" = (now() at time zone 'UTC') WHERE id IN (37407789); [ Date: 2026-04-07 13:43:13 ]
8	9s783ms	UPDATE "stock_quant" SET "write_uid" = 1, "reserved_quantity" = 4920.0, "write_date" = (now() at time zone 'UTC') WHERE id IN (38285259); [ Date: 2026-04-07 13:42:35 ]
9	9s517ms	UPDATE "stock_quant" SET "write_uid" = 1, "reserved_quantity" = 295.0, "write_date" = (now() at time zone 'UTC') WHERE id IN (39533379); [ Date: 2026-04-07 13:26:58 ]
10	6s898ms	UPDATE "stock_quant" SET "write_uid" = 1, "reserved_quantity" = 2167.0, "write_date" = (now() at time zone 'UTC') WHERE id IN (38846940); [ Date: 2026-04-07 12:31:38 ]
11	3s825ms	INSERT INTO "account_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "auto_post", "currency_id", "date", "invoice_date", "invoice_incoterm_id", "invoice_sent", "invoice_user_id", "journal_id", "name", "partner_id", "ref", "state", "team_id", "temp_codification", "to_check", "type") VALUES (nextval('account_move_id_seq'), 1, (now() at time zone 'UTC'), 1, (now() at time zone 'UTC'), false, 114, '2025-10-26', NULL, NULL, false, 4319, 969, '0431920251026122349', 150215, NULL, 'draft', NULL, true, false, 'entry') RETURNING id; [ Date: 2026-04-07 13:23:05 ]
12	3s494ms	INSERT INTO bank_statement_vendor_move_line_rel (bank_statement_id, move_line_id) VALUES (267671, 169663663), (267671, 169663315) ON CONFLICT DO NOTHING; [ Date: 2026-04-07 13:49:18 ]
13	3s494ms	INSERT INTO bank_statement_vendor_move_line_rel (bank_statement_id, move_line_id) VALUES (267671, 169663663), (267671, 169663315) ON CONFLICT DO NOTHING; [ Date: 2026-04-07 13:49:18 ]
14	2s429ms	UPDATE "stock_picking" SET "write_uid" = 2114, "partner_longitude" = '-0.56961', "write_date" = (now() at time zone 'UTC') WHERE id IN (9382017); [ Date: 2026-04-07 12:34:48 ]
15	2s130ms	UPDATE "stock_quant" SET "write_uid" = 1, "reserved_quantity" = 3000.0, "write_date" = (now() at time zone 'UTC') WHERE id IN (37797919); [ Date: 2026-04-07 13:17:53 ]
16	1s247ms	UPDATE "stock_picking" SET "write_uid" = 2114, "partner_longitude" = '-0.56807', "write_date" = (now() at time zone 'UTC') WHERE id IN (9382105); [ Date: 2026-04-07 12:34:45 ]
17	1s26ms	INSERT INTO "calendar_event" ("id", "create_uid", "create_date", "write_uid", "write_date", "_ruid", "active", "address", "allday", "count", "currency_id", "date", "day", "duration", "end_type", "event_tz", "in_template", "interval", "month_by", "name", "partner_customer_id", "planning_id", "privacy", "sequence", "show_as", "start", "state", "stop", "user_id", "validation_state") VALUES (nextval('calendar_event_id_seq'), 372, (now() at time zone 'UTC'), 372, (now() at time zone 'UTC'), 'e1c41965-c677-4b16-9632-bb3af69fb85b', true, 'MOHRA NEDJM-EDDINE Wilaya de SÃ©tif SÃ©tif 19 190000 AlgÃ©rie', false, 1, 114, '2026-04-07 12:19:21', 'tuesday', 0.0, 'count', 'Africa/Algiers', false, 1, 'date', 'PL/PS/19/2601412/MOHRA NEDJM-EDDINE/tuesday2026-04-07 12:19:21', 55177, 967061, 'public', 12, 'busy', '2026-04-07 12:19:21', 'draft', '2026-04-07 12:19:21', 372, 'to_validate') RETURNING id; [ Date: 2026-04-07 12:19:27 ]

Queries by type

Key values

34,488 Total read queries
388 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	34,488	98.83%
INSERT	91	0.26%
UPDATE	6	0.02%
DELETE	284	0.81%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	7	0.02%
DDL	0	0.00%
TCL	0	0.00%
CURSOR	0	0.00%
OTHERS	19	0.05%

Queries by database

Key values

unknown Main database
34,582 Requests
9h34m (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
odoo	Total	305	8m50s
	CREATE	1	49s63ms
	DELETE	3	1s371ms
	SELECT	301	7m59s
odoo_position	Total	8	2s409ms
	COMMIT	6	1s945ms
	SELECT	2	463ms
unknown	Total	34,582	9h34m
	COMMIT	5	1s492ms
	CTE	7	3s116ms
	DELETE	281	17m
	INSERT	91	3m33s
	SELECT	34,185	9h11m30s
	UPDATE	6	40s158ms
	others	7	1m10s

Queries by user

Key values

unknown Main user
69,164 Requests

Queries Chart
Table

User	Request type	Count	Duration
odoo	Total	620	16m12s
	COMMIT	12	3s890ms
	CREATE	2	1m38s
	DELETE	6	2s743ms
	SELECT	600	14m27s
presalio_user	Total	6	1m32s
	SELECT	6	1m32s
unknown	Total	69,164	19h8m
	COMMIT	10	2s985ms
	CTE	14	6s232ms
	DELETE	562	34m1s
	INSERT	182	7m7s
	SELECT	68,370	18h23m1s
	UPDATE	12	1m20s
	others	14	2m20s

Duration by user

Key values

19h8m (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
odoo	Total	620	16m12s
	COMMIT	12	3s890ms
	CREATE	2	1m38s
	DELETE	6	2s743ms
	SELECT	600	14m27s
presalio_user	Total	6	1m32s
	SELECT	6	1m32s
unknown	Total	69,164	19h8m
	COMMIT	10	2s985ms
	CTE	14	6s232ms
	DELETE	562	34m1s
	INSERT	182	7m7s
	SELECT	68,370	18h23m1s
	UPDATE	12	1m20s
	others	14	2m20s

Queries by host

Key values

unknown Main host
69,790 Requests
19h25m46s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	69,790	19h25m46s
	COMMIT	22	6s876ms
	CREATE	2	1m38s
	CTE	14	6s232ms
	DELETE	568	34m3s
	INSERT	182	7m7s
	SELECT	68,976	18h39m2s
	UPDATE	12	1m20s
	others	14	2m20s

Queries by application

Key values

unknown Main application
34,895 Requests
9h42m53s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	34,895	9h42m53s
	COMMIT	11	3s438ms
	CREATE	1	49s63ms
	CTE	7	3s116ms
	DELETE	284	17m1s
	INSERT	91	3m33s
	SELECT	34,488	9h19m31s
	UPDATE	6	40s158ms
	others	7	1m10s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-04-07 12:03:51 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

24,166 100-500ms duration

Chart
Table

Range	Count	Percentage
0-1ms	0	0.00%
1-5ms	0	0.00%
5-10ms	0	0.00%
10-25ms	0	0.00%
25-50ms	0	0.00%
50-100ms	0	0.00%
100-500ms	24,166	69.25%
500-1000ms	6,197	17.76%
1000-10000ms	3,869	11.09%
> 10000ms	663	1.90%

Slowest individual queries

Rank	Duration	Query
1	3m28s	SELECT rp.id AS ID_POS, rp.ref AS CODE_POS, rp.name AS NOM_POS, rp.rc AS rc, rp.art AS art, rp.nis as nis, rp.vat as nif, sw.name AS DEPOT, typ.value AS type_pv, rp.active AS STATUS_POS, rpc.value AS CLUSTER_POS, ppi.name AS LISTE_PRIX, prcr.name AS REGION, prcs.name AS ZONE, rcst.name AS WILAYA, rp.city AS COMMUNE, rp.street AS ADRESSE, rp.phone AS TELEPHONE, CONCAT(rp.partner_latitude, ',', rp.partner_longitude) AS COORDONNEES_GPS, CONCAT('[', dr.name, ']') AS ROUTE, 'Tous les jours sauf vendredi' AS JOUR_VISITE, drp.sequence AS SEQUENCE_VISITE, CASE WHEN EXISTS ( SELECT 1 FROM ir_attachment ia WHERE ia.res_model = 'res.partner' AND ia.res_field = 'image_1920' AND ia.res_id = rp.id) THEN 'OUI' ELSE 'NON' END AS DISPONIBILITE_PHOTO, rp.state AS ETAT_CENSUS, MAX(mm.write_date) AS Date_derniere_modification, ( SELECT sub_mm.body FROM mail_message sub_mm WHERE sub_mm.model = 'res.partner' AND sub_mm.res_id = rp.id ORDER BY sub_mm.write_date DESC LIMIT 1) AS Derniere_Modification, COUNT(mm.id) AS nombre_modifications, ( SELECT ai.name as number FROM account_move ai WHERE ai.partner_id = rp.id AND ai.invoice_payment_state IN ('not_paid', 'paid') ORDER BY ai.write_date DESC LIMIT 1) AS derniere_vente FROM res_partner rp LEFT JOIN planning_template_event drp ON rp.id = drp.partner_id LEFT JOIN planning_template dr ON dr.id = drp.planning_template_id LEFT JOIN stock_warehouse sw ON rp.warehouse_id = sw.id LEFT JOIN model_custom_attribute_value typ ON rp.partner_custom_attribute_2 = typ.id LEFT JOIN model_custom_attribute_value rpc ON rp.partner_custom_attribute_1 = rpc.id LEFT JOIN res_country_state rcst ON rp.state_id = rcst.id LEFT JOIN res_country_region prcr ON rp.region_id = prcr.id LEFT JOIN res_country_sector prcs ON rp.sector_id = prcs.id LEFT JOIN res_partner_pricelist pl ON rp.id = pl.partner_id LEFT JOIN product_pricelist ppi ON pl.pricelist_id = ppi.id LEFT JOIN mail_message mm ON mm.model = 'res.partner' AND mm.res_id = rp.id WHERE --rp.customer_rank = 1* sw.id not in (170, 172, 180, 182) GROUP BY rp.id, rp.ref, rp.name, sw.name, typ.value, rp.active, rpc.value, ppi.name, prcr.name, prcs.name, rcst.name, rp.city, rp.street, rp.phone, rp.partner_latitude, rp.partner_longitude, dr.name, drp.sequence, DISPONIBILITE_PHOTO, rp.state, rp.write_date; [ Date: 2026-04-07 13:41:51 ]
2	1m18s	SELECT "account_move".id FROM "account_move" WHERE (("account_move"."type" = 'out_invoice') AND ((((("account_move"."name"::text ilike '%LE GRAND TOP SHOP%') OR ("account_move"."invoice_origin"::text ilike '%LE GRAND TOP SHOP%')) OR ("account_move"."ref"::text ilike '%LE GRAND TOP SHOP%')) OR ("account_move"."invoice_payment_ref"::text ilike '%LE GRAND TOP SHOP%')) OR ("account_move"."partner_id" in (165007)))) AND TRUE AND ((account_move.company_id IN (1, 3)) AND (account_move.brand_id IS NULL OR account_move.brand_id in (1)) AND (account_move.warehouse_id IS NULL OR account_move.warehouse_id in (1, 93, 10, 6, 107, 14, 2, 46, 48, 44, 34, 55, 49, 28, 57, 54, 75, 118, 22, 68, 81, 52, 83, 103, 80, 56, 98, 35, 87, 43, 29, 53, 37, 63, 50, 117, 19, 33, 77, 60, 70, 92, 113, 84, 32, 110, 119, 85, 26, 104, 99, 61, 38, 36, 18, 27, 40, 39, 94, 62, 16, 42, 76, 73, 58, 90, 17, 112, 100, 24, 74, 114, 79, 25, 15, 45, 95, 21, 51, 120, 47, 96, 23, 116, 111, 66, 105, 109, 106, 91, 115, 101, 41, 71, 97, 20, 69, 64))) ORDER BY "account_move"."date" DESC limit 80; [ Date: 2026-04-07 13:50:19 ]
3	1m17s	SELECT "account_move".id FROM "account_move" WHERE (("account_move"."type" = 'out_invoice') AND ((((("account_move"."name"::text ilike '%0005320260406124626%') OR ("account_move"."invoice_origin"::text ilike '%0005320260406124626%')) OR ("account_move"."ref"::text ilike '%0005320260406124626%')) OR ("account_move"."invoice_payment_ref"::text ilike '%0005320260406124626%')) OR FALSE)) AND TRUE ORDER BY "account_move"."date" DESC limit 80; [ Date: 2026-04-07 12:45:12 ]
4	1m15s	INSERT INTO "ir_attachment" ("id", "create_uid", "create_date", "write_uid", "write_date", "_ruid", "checksum", "company_id", "db_datas", "file_size", "index_content", "mimetype", "name", "public", "res_field", "res_id", "res_model", "store_fname", "temporary", "type") VALUES (nextval('ir_attachment_id_seq'), 6071, (now() at time zone 'UTC'), 6071, (now() at time zone 'UTC'), '5f96db2d-02bb-404f-b001-0e999faee61e', 'cc8f700618e8e12617f4c4344883b9278f6bdef9', 3, NULL, 164415, 'image', 'image/jpeg', 'image_1920', true, 'image_1920', 7683467, 'survey.user_input_line.image', 'cc/cc8f700618e8e12617f4c4344883b9278f6bdef9', false, 'binary') RETURNING id; [ Date: 2026-04-07 10:57:39 ]
5	1m13s	SELECT min("account_report".id) AS id, count("account_report".id) AS "__count", sum("account_report"."price_subtotal") AS "price_subtotal" FROM "account_report" WHERE ((((("account_report"."state" not in ('draft', 'cancel')) OR "account_report"."state" IS NULL) AND (("account_report"."type" = 'out_invoice') OR ("account_report"."type" = 'out_refund'))) AND ("account_report"."invoice_date" >= '2025-01-01')) AND ("account_report"."partner_custom_attribute_1" in (73, 83, 91, 93))) AND ((account_report.company_id IN (1, 3)) AND (account_report.warehouse_id in (1, 93, 10, 6, 107, 14, 157, 2, 131, 121, 132, 46, 48, 44, 34, 55, 160, 49, 28, 153, 57, 135, 150, 54, 75, 118, 22, 68, 81, 52, 83, 126, 103, 151, 80, 56, 98, 35, 87, 43, 29, 53, 37, 63, 147, 128, 50, 117, 19, 33, 77, 60, 70, 149, 92, 134, 152, 158, 166, 113, 84, 32, 163, 127, 159, 110, 139, 119, 164, 85, 26, 104, 99, 136, 154, 61, 38, 36, 18, 165, 27, 40, 162, 39, 94, 62, 16, 42, 76, 141, 73, 58, 90, 17, 145, 112, 100, 155, 24, 74, 114, 79, 130, 133, 142, 25, 15, 45, 148, 95, 21, 51, 120, 137, 47, 96, 23, 116, 111, 66, 105, 109, 106, 91, 129, 115, 101, 138, 41, 156, 71, 97, 146, 20, 69, 64, 178))); [ Date: 2026-04-07 13:10:34 ]
6	1m12s	SELECT "account_move".id FROM "account_move" WHERE (("account_move"."type" = 'out_invoice') AND ((((("account_move"."name"::text ilike '%le grand top shop%') OR ("account_move"."invoice_origin"::text ilike '%le grand top shop%')) OR ("account_move"."ref"::text ilike '%le grand top shop%')) OR ("account_move"."invoice_payment_ref"::text ilike '%le grand top shop%')) OR ("account_move"."partner_id" in (165007)))) AND TRUE AND ((account_move.company_id IN (1, 3)) AND (account_move.brand_id IS NULL OR account_move.brand_id in (1)) AND (account_move.warehouse_id IS NULL OR account_move.warehouse_id in (1, 93, 10, 6, 107, 14, 2, 46, 48, 44, 34, 55, 49, 28, 57, 54, 75, 118, 22, 68, 81, 52, 83, 103, 80, 56, 98, 35, 87, 43, 29, 53, 37, 63, 50, 117, 19, 33, 77, 60, 70, 92, 113, 84, 32, 110, 119, 85, 26, 104, 99, 61, 38, 36, 18, 27, 40, 39, 94, 62, 16, 42, 76, 73, 58, 90, 17, 112, 100, 24, 74, 114, 79, 25, 15, 45, 95, 21, 51, 120, 47, 96, 23, 116, 111, 66, 105, 109, 106, 91, 115, 101, 41, 71, 97, 20, 69, 64))) ORDER BY "account_move"."date" DESC limit 80; [ Date: 2026-04-07 13:48:37 ]
7	1m2s	SELECT "account_move".id FROM "account_move" WHERE (("account_move"."type" = 'out_invoice') AND ((((("account_move"."name"::text ilike '%eurl unodis%') OR ("account_move"."invoice_origin"::text ilike '%eurl unodis%')) OR ("account_move"."ref"::text ilike '%eurl unodis%')) OR ("account_move"."invoice_payment_ref"::text ilike '%eurl unodis%')) OR ("account_move"."partner_id" in (138402, 147608, 162297, 162299, 162307, 162311, 162315, 162331, 163697, 163705, 163713)))) AND TRUE AND ((account_move.company_id IN (1, 3)) AND (account_move.warehouse_id IS NULL OR account_move.warehouse_id in (1, 93, 10, 6, 107, 14, 157, 117, 19, 33, 17, 133, 105))) ORDER BY "account_move"."date" DESC limit 80; [ Date: 2026-04-07 12:00:17 ]
8	59s344ms	SELECT "account_move".id FROM "account_move" WHERE (("account_move"."type" = 'out_invoice') AND ((((("account_move"."name"::text ilike '%0123320260406110304%') OR ("account_move"."invoice_origin"::text ilike '%0123320260406110304%')) OR ("account_move"."ref"::text ilike '%0123320260406110304%')) OR ("account_move"."invoice_payment_ref"::text ilike '%0123320260406110304%')) OR FALSE)) AND TRUE ORDER BY "account_move"."date" DESC limit 80; [ Date: 2026-04-07 13:14:48 ]
9	57s413ms	SELECT account_move_line.partner_id, act.type, SUM(account_move_line.amount_residual) FROM "account_move_line" LEFT JOIN account_account a ON (account_move_line.account_id = a.id) LEFT JOIN account_account_type act ON (a.user_type_id = act.id) WHERE act.type IN ('receivable', 'payable') AND account_move_line.partner_id IN (107163, 137027, 8514, 13605, 120910, 520, 5569, 155013, 98556, 5505, 158949, 7046, 90316, 7389, 7390, 6487, 938, 159233, 39623, 97548, 116638, 103097, 3925, 162195, 126253, 1554, 14439, 113319, 6906, 1075, 101208, 758, 8034, 133352, 98386, 554, 97309, 14765, 10529, 123962, 1691, 124387, 2299, 92722, 946, 34114, 120857, 147907, 7936, 140449, 113410, 103446, 6641, 6242, 142107, 929, 121770, 6983, 143301, 2038, 932, 1373, 2392, 529, 11568, 35252, 167035, 940, 137630, 129414, 145508, 4481, 100548, 7347, 10623, 75362, 10399, 14003, 2300, 4519, 6770, 126836, 9403, 123784, 7057, 103126, 125840, 136774, 34704, 10578, 16432, 127354, 5487, 137474, 141972, 97949, 5602, 6245, 6647, 111486, 8050, 3373, 123319, 97867, 98186, 5626, 102445, 125559, 136887, 33944, 97283, 15872, 119241, 6238, 125675, 111246, 13012, 7289, 157981, 133946, 97304, 96683, 6986, 125155, 125849, 120905, 161603, 5486, 125154, 2765, 93798, 99648, 157759, 2568, 135733, 101171, 122410, 10576, 107043, 16419, 5619, 2734, 125351, 121964, 97553, 104263, 146910, 104451, 108692, 90105, 117465, 133239, 219, 7287, 10389, 97077, 107389, 142450, 119214, 133936, 149613, 2524, 1653, 137164, 125689, 3940, 1319, 158101, 23320, 117530, 5520, 141169, 94874, 98424, 34173, 1982, 134256, 121055, 116412, 7408, 10601, 7418, 146065, 96564, 127146, 3393, 12991, 122216, 158667, 120836, 112282, 1403, 118721, 4473, 7001, 145197, 138928, 5527, 120837, 2791, 33916, 137618, 120818, 123870, 97955, 155853, 159083, 121411, 6989, 95831, 162211, 40228, 98398, 121065, 104377, 7025, 135450, 89490, 32582, 1231, 118785, 4204, 30177, 90699, 931, 12464, 1549, 134229, 132757, 34174, 6763, 90534, 119058, 93802, 103098, 116382, 559, 98518, 3417, 3483, 7310, 2338, 93790, 14283, 123574, 132860, 101266, 92994, 118669, 120854, 405, 107650, 107144, 5528, 7415, 121025, 118930, 156171, 146664, 133943, 1877, 379, 320, 12826, 91301, 135488, 118314, 39667, 1365, 6764, 6589, 94237, 9531, 7000, 31609, 4949, 18521, 1359, 555, 139679, 9802, 1144, 107279, 120911, 4482, 7400, 99321, 34061, 98276, 94627, 6232, 3950, 1987, 123607, 93881, 40821, 30175, 123854, 12905, 9532, 543, 124666, 100193, 135394, 94879, 167565, 163979, 5890, 519, 1250, 120912, 102719, 34076, 927, 107151, 936, 147980, 6980, 6747, 95071, 149899, 12257, 125667, 1561, 39410, 120965, 95949, 8083, 135455, 7385, 6943, 96460, 5563, 123671, 7403, 129285, 109163, 116557, 13816, 147987, 6256, 102478, 126611, 119573, 14668, 4523, 3374, 5573, 91619, 133934, 14421, 94681, 98267, 2005, 558, 124669, 107367, 120852, 148219, 5618, 145968, 128194, 109113, 16421, 16428, 662, 126248, 11560, 104507, 97552, 162373, 112907, 8504, 40265, 16199, 5042, 6497, 136783, 10374, 158289, 147629, 122748, 4049, 141677, 98483, 126160, 7382, 32894, 2591, 1665, 5529, 130079, 2326, 147243, 2250, 119377, 156737, 150339, 154763, 9411, 121970, 6996, 90739, 148002, 10586, 165045, 158531, 32159, 1257, 103513, 167153, 133305, 152467, 90635, 7637, 256, 17149, 935, 97250, 131796, 5517, 96149, 15316, 5961, 117364, 100479, 118581, 111969, 133251, 5887, 148087, 6748, 97058, 7686, 135589, 9410, 120906, 129726, 98296, 98339, 139481, 113280, 6767, 2808, 16151, 118477, 121305, 7061, 7055, 123279, 132646, 123873, 146232, 135731, 123681, 92378, 1317, 149469, 541, 1563, 154005, 40264, 660, 163133, 5081, 123578, 15753, 107884, 135667, 90536, 5008, 151711, 2270, 6267, 2077, 1565, 2018, 133672, 36718, 130624, 95091, 91867, 1255, 95616, 135612, 102549, 155573, 92581, 3243, 14289, 127611, 3813, 525, 2310, 126585, 132374, 162189, 123617, 148419, 147977, 107023, 137101, 98541, 7286, 35227, 115921, 1367, 129128, 16442, 118720, 1684, 7022, 135604, 123610, 148297, 2584, 9968, 91977, 89022, 104446, 89021, 107460, 137067, 156747, 44860, 796, 15115, 98193, 8489, 135112, 10439, 29130, 283, 179, 16429, 6616, 90577, 137374, 138294, 2079, 140242, 124955, 129429, 126823, 136775, 1261, 104008, 143247, 974, 5894, 166923, 91436, 108460, 168083, 537, 6985, 866, 16193, 145522, 94009, 9774, 6604, 9067, 33917, 142585, 16507, 126861, 118109, 140022, 92210, 156455, 125157, 158241, 123010, 143182, 118240, 953, 94328, 90636, 119740, 3163, 143249, 121208, 126187, 120840, 96611, 23316, 112399, 4477, 119299, 140283, 158045, 148044, 124308, 124699, 147989, 772, 140592, 139981, 149467, 98340, 121303, 44873, 98391, 162599, 6904, 118777, 120841, 33975, 152989, 10631, 127610, 96497, 145305, 31309, 8758, 31625, 130412, 1663, 139977, 32848, 95824, 100440, 20361, 11930, 107403, 93787, 140260, 14847, 167973, 89010, 130844, 14251, 118826, 90539, 121060, 141374, 136875, 17296, 6494, 123834, 7007, 29102, 795, 118729, 135471, 116499, 108946, 131326, 132760, 137951, 120959, 157087, 116562, 132425, 140843, 7317, 104174, 96215, 75051, 111412, 100864, 107161, 131071, 10493, 31043, 1953, 44856, 14687, 6296, 112976, 9378, 7328, 141038, 92222, 34064, 1413, 8098, 5502, 15056, 19368, 140255, 5523, 6743, 5884, 6746, 9400, 11563, 138191, 5964, 10369, 128161, 9402, 8268, 988, 14127, 92727, 96214, 8095, 39466, 4630, 132728, 112283, 143006, 98124, 7410, 90537, 8079, 14141, 145609, 6997, 155897, 116993, 7316, 137225, 96935, 135519, 16433, 130451, 120860, 6269, 5515, 96601, 124688, 100510, 5762, 138275, 150849, 158975, 118454, 7219, 97831, 13142, 7353, 96125, 7223, 4067, 7404, 40920, 123320, 120887, 108002, 32668, 118841, 17297, 5962, 93912, 10521, 156511, 40923, 98719, 16444, 1256, 5526, 90538, 167109, 16627, 98018, 13350, 13862, 13023, 95678, 9412, 7050, 44859, 32032, 7063, 98142, 108442, 516, 98455, 142875, 137992, 882, 118734, 126249, 1304, 137018, 39929, 918, 96143, 9068, 10384, 97215, 127777, 127616, 138268, 161747, 115236, 752, 95092, 9538, 7391, 2283, 6636, 12979, 44839, 102968, 7327, 124957, 7635, 9024, 136778, 39244, 2328, 5596, 2305, 128259, 134010, 8078, 127233, 119585, 125837, 136776, 119244, 107369, 140346, 146265, 136905, 116408, 118956, 102479, 153005, 157, 116465, 142554, 9096, 143319, 1327, 3839, 7311, 127778, 11316, 12397, 146347, 2031, 103093, 147972, 162223, 9065, 140277, 1972, 146296, 11043, 140148, 123773, 6752, 123772) AND coalesce(account_move_line.reconciled) IS NOT TRUE AND (((("account_move_line"."parent_state" = 'posted') AND ("account_move_line"."company_id" in (1))) AND (("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)) GROUP BY account_move_line.partner_id, act.type; [ Date: 2026-04-07 13:51:26 ]
10	53s724ms	SELECT "account_move".id FROM "account_move" WHERE (("account_move"."type" = 'out_invoice') AND ((((("account_move"."name"::text ilike '%unodis%') OR ("account_move"."invoice_origin"::text ilike '%unodis%')) OR ("account_move"."ref"::text ilike '%unodis%')) OR ("account_move"."invoice_payment_ref"::text ilike '%unodis%')) OR ("account_move"."partner_id" in (91527, 138402, 147608, 162297, 162299, 162307, 162311, 162315, 162331, 163697, 163705, 163713)))) AND TRUE AND ((account_move.company_id IN (1, 3)) AND (account_move.brand_id IS NULL OR account_move.brand_id in (1)) AND (account_move.warehouse_id IS NULL OR account_move.warehouse_id in (1, 93, 10, 6, 107, 14, 2, 46, 48, 44, 34, 55, 49, 28, 57, 54, 75, 118, 22, 68, 81, 52, 83, 103, 80, 56, 98, 35, 87, 43, 29, 53, 37, 63, 50, 117, 19, 33, 77, 60, 70, 92, 113, 84, 32, 110, 119, 85, 26, 104, 99, 61, 38, 36, 18, 27, 40, 39, 94, 62, 16, 42, 76, 73, 58, 90, 17, 112, 100, 24, 74, 114, 79, 25, 15, 45, 95, 21, 51, 120, 47, 96, 23, 116, 111, 66, 105, 109, 106, 91, 115, 101, 41, 71, 97, 20, 69, 64))) ORDER BY "account_move"."date" DESC limit 80; [ Date: 2026-04-07 12:19:18 ]
11	52s913ms	SELECT "account_move".id FROM "account_move" WHERE (("account_move"."type" = 'out_invoice') AND ((((("account_move"."name"::text ilike '%unodis%') OR ("account_move"."invoice_origin"::text ilike '%unodis%')) OR ("account_move"."ref"::text ilike '%unodis%')) OR ("account_move"."invoice_payment_ref"::text ilike '%unodis%')) OR ("account_move"."partner_id" in (91527, 138402, 147608, 162297, 162299, 162307, 162311, 162315, 162331, 163697, 163705, 163713)))) AND TRUE AND ((account_move.company_id IN (1, 3)) AND (account_move.warehouse_id IS NULL OR account_move.warehouse_id in (1, 93, 10, 6, 107, 14, 157, 117, 19, 33, 17, 133, 105))) ORDER BY "account_move"."date" DESC limit 80; [ Date: 2026-04-07 12:12:48 ]
12	50s548ms	SELECT account_move_line.partner_id, act.type, SUM(account_move_line.amount_residual) FROM "account_move_line" LEFT JOIN account_account a ON (account_move_line.account_id = a.id) LEFT JOIN account_account_type act ON (a.user_type_id = act.id) WHERE act.type IN ('receivable', 'payable') AND account_move_line.partner_id IN (107163, 137027, 8514, 13605, 120910, 520, 5569, 155013, 98556, 5505, 158949, 7046, 90316, 7389, 7390, 6487, 938, 159233, 39623, 97548, 116638, 103097, 3925, 162195, 126253, 1554, 14439, 113319, 6906, 1075, 101208, 758, 8034, 133352, 98386, 554, 97309, 14765, 10529, 123962, 1691, 124387, 2299, 92722, 946, 34114, 120857, 147907, 7936, 140449, 113410, 103446, 6641, 6242, 142107, 929, 121770, 6983, 143301, 2038, 932, 1373, 2392, 529, 11568, 35252, 167035, 940, 137630, 129414, 145508, 4481, 100548, 7347, 10623, 75362, 10399, 14003, 2300, 4519, 6770, 126836, 9403, 123784, 7057, 103126, 125840, 136774, 34704, 10578, 16432, 127354, 5487, 137474, 141972, 97949, 5602, 6245, 6647, 111486, 8050, 3373, 123319, 97867, 98186, 5626, 102445, 125559, 136887, 33944, 97283, 15872, 119241, 6238, 125675, 111246, 13012, 7289, 157981, 133946, 97304, 96683, 6986, 125155, 125849, 120905, 161603, 5486, 125154, 2765, 93798, 99648, 157759, 2568, 135733, 101171, 122410, 10576, 107043, 16419, 5619, 2734, 125351, 121964, 97553, 104263, 146910, 104451, 108692, 90105, 117465, 133239, 219, 7287, 10389, 97077, 107389, 142450, 119214, 133936, 149613, 2524, 1653, 137164, 125689, 3940, 1319, 158101, 23320, 117530, 5520, 141169, 94874, 98424, 34173, 1982, 134256, 121055, 116412, 7408, 10601, 7418, 146065, 96564, 127146, 3393, 12991, 122216, 158667, 120836, 112282, 1403, 118721, 4473, 7001, 145197, 138928, 5527, 120837, 2791, 33916, 137618, 120818, 123870, 97955, 155853, 159083, 121411, 6989, 95831, 162211, 40228, 98398, 121065, 104377, 7025, 135450, 89490, 32582, 1231, 118785, 4204, 30177, 90699, 931, 12464, 1549, 134229, 132757, 34174, 6763, 90534, 119058, 93802, 103098, 116382, 559, 98518, 3417, 3483, 7310, 2338, 93790, 14283, 123574, 132860, 101266, 92994, 118669, 120854, 405, 107650, 107144, 5528, 7415, 121025, 118930, 156171, 146664, 133943, 1877, 379, 320, 12826, 91301, 135488, 118314, 39667, 1365, 6764, 6589, 94237, 9531, 7000, 31609, 4949, 18521, 1359, 555, 139679, 9802, 1144, 107279, 120911, 4482, 7400, 99321, 34061, 98276, 94627, 6232, 3950, 1987, 123607, 93881, 40821, 30175, 123854, 12905, 9532, 543, 124666, 100193, 135394, 94879, 167565, 163979, 5890, 519, 1250, 120912, 102719, 34076, 927, 107151, 936, 147980, 6980, 6747, 95071, 149899, 12257, 125667, 1561, 39410, 120965, 95949, 8083, 135455, 7385, 6943, 96460, 5563, 123671, 7403, 129285, 109163, 116557, 13816, 147987, 6256, 102478, 126611, 119573, 14668, 4523, 3374, 5573, 91619, 133934, 14421, 94681, 98267, 2005, 558, 124669, 107367, 120852, 148219, 5618, 145968, 128194, 109113, 16421, 16428, 662, 126248, 11560, 104507, 97552, 162373, 112907, 8504, 40265, 16199, 5042, 6497, 136783, 10374, 158289, 147629, 122748, 4049, 141677, 98483, 126160, 7382, 32894, 2591, 1665, 5529, 130079, 2326, 147243, 2250, 119377, 156737, 150339, 154763, 9411, 121970, 6996, 90739, 148002, 10586, 165045, 158531, 32159, 1257, 103513, 167153, 133305, 152467, 90635, 7637, 256, 17149, 935, 97250, 131796, 5517, 96149, 15316, 5961, 117364, 100479, 118581, 111969, 133251, 5887, 148087, 6748, 97058, 7686, 135589, 9410, 120906, 129726, 98296, 98339, 139481, 113280, 6767, 2808, 16151, 118477, 121305, 7061, 7055, 123279, 132646, 123873, 146232, 135731, 123681, 92378, 1317, 149469, 541, 1563, 154005, 40264, 660, 163133, 5081, 123578, 15753, 107884, 135667, 90536, 5008, 151711, 2270, 6267, 2077, 1565, 2018, 133672, 36718, 130624, 95091, 91867, 1255, 95616, 135612, 102549, 155573, 92581, 3243, 14289, 127611, 3813, 525, 2310, 126585, 132374, 162189, 123617, 148419, 147977, 107023, 137101, 98541, 7286, 35227, 115921, 1367, 129128, 16442, 118720, 1684, 7022, 135604, 123610, 148297, 2584, 9968, 91977, 89022, 104446, 89021, 107460, 137067, 156747, 44860, 796, 15115, 98193, 8489, 135112, 10439, 29130, 283, 179, 16429, 6616, 90577, 137374, 138294, 2079, 140242, 124955, 129429, 126823, 136775, 1261, 104008, 143247, 974, 5894, 166923, 91436, 108460, 168083, 537, 6985, 866, 16193, 145522, 94009, 9774, 6604, 9067, 33917, 142585, 16507, 126861, 118109, 140022, 92210, 156455, 125157, 158241, 123010, 143182, 118240, 953, 94328, 90636, 119740, 3163, 143249, 121208, 126187, 120840, 96611, 23316, 112399, 4477, 119299, 140283, 158045, 148044, 124308, 124699, 147989, 772, 140592, 139981, 149467, 98340, 121303, 44873, 98391, 162599, 6904, 118777, 120841, 33975, 152989, 10631, 127610, 96497, 145305, 31309, 8758, 31625, 130412, 1663, 139977, 32848, 95824, 100440, 20361, 11930, 107403, 93787, 140260, 14847, 167973, 89010, 130844, 14251, 118826, 90539, 121060, 141374, 136875, 17296, 6494, 123834, 7007, 29102, 795, 118729, 135471, 116499, 108946, 131326, 132760, 137951, 120959, 157087, 116562, 132425, 140843, 7317, 104174, 96215, 75051, 111412, 100864, 107161, 131071, 10493, 31043, 1953, 44856, 14687, 6296, 112976, 9378, 7328, 141038, 92222, 34064, 1413, 8098, 5502, 15056, 19368, 140255, 5523, 6743, 5884, 6746, 9400, 11563, 138191, 5964, 10369, 128161, 9402, 8268, 988, 14127, 92727, 96214, 8095, 39466, 4630, 132728, 112283, 143006, 98124, 7410, 90537, 8079, 14141, 145609, 6997, 155897, 116993, 7316, 137225, 96935, 135519, 16433, 130451, 120860, 6269, 5515, 96601, 124688, 100510, 5762, 138275, 150849, 158975, 118454, 7219, 97831, 13142, 7353, 96125, 7223, 4067, 7404, 40920, 123320, 120887, 108002, 32668, 118841, 17297, 5962, 93912, 10521, 156511, 40923, 98719, 16444, 1256, 5526, 90538, 167109, 16627, 98018, 13350, 13862, 13023, 95678, 9412, 7050, 44859, 32032, 7063, 98142, 108442, 516, 98455, 142875, 137992, 882, 118734, 126249, 1304, 137018, 39929, 918, 96143, 9068, 10384, 97215, 127777, 127616, 138268, 161747, 115236, 752, 95092, 9538, 7391, 2283, 6636, 12979, 44839, 102968, 7327, 124957, 7635, 9024, 136778, 39244, 2328, 5596, 2305, 128259, 134010, 8078, 127233, 119585, 125837, 136776, 119244, 107369, 140346, 146265, 136905, 116408, 118956, 102479, 153005, 157, 116465, 142554, 9096, 143319, 1327, 3839, 7311, 127778, 11316, 12397, 146347, 2031, 103093, 147972, 162223, 9065, 140277, 1972, 146296, 11043, 140148, 123773, 6752, 123772) AND coalesce(account_move_line.reconciled) IS NOT TRUE AND (((("account_move_line"."parent_state" = 'posted') AND ("account_move_line"."company_id" in (1))) AND (("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)) GROUP BY account_move_line.partner_id, act.type; [ Date: 2026-04-07 12:29:59 ]
13	50s23ms	SELECT account_move_line.partner_id, act.type, SUM(account_move_line.amount_residual) FROM "account_move_line" LEFT JOIN account_account a ON (account_move_line.account_id = a.id) LEFT JOIN account_account_type act ON (a.user_type_id = act.id) WHERE act.type IN ('receivable', 'payable') AND account_move_line.partner_id IN (107163, 137027, 8514, 13605, 120910, 520, 5569, 155013, 98556, 5505, 158949, 7046, 90316, 7389, 7390, 6487, 938, 159233, 39623, 97548, 116638, 103097, 3925, 162195, 126253, 1554, 14439, 113319, 6906, 1075, 101208, 758, 8034, 133352, 98386, 554, 97309, 14765, 10529, 123962, 1691, 124387, 2299, 92722, 946, 34114, 120857, 147907, 7936, 140449, 113410, 103446, 6641, 6242, 142107, 929, 121770, 6983, 143301, 2038, 932, 1373, 2392, 529, 11568, 35252, 167035, 940, 137630, 129414, 145508, 4481, 100548, 7347, 10623, 75362, 10399, 14003, 2300, 4519, 6770, 126836, 9403, 123784, 7057, 103126, 125840, 136774, 34704, 10578, 16432, 127354, 5487, 137474, 141972, 97949, 5602, 6245, 6647, 111486, 8050, 3373, 123319, 97867, 98186, 5626, 102445, 125559, 136887, 33944, 97283, 15872, 119241, 6238, 125675, 111246, 13012, 7289, 157981, 133946, 97304, 96683, 6986, 125155, 125849, 120905, 161603, 5486, 125154, 2765, 93798, 99648, 157759, 2568, 135733, 101171, 122410, 10576, 107043, 16419, 5619, 2734, 125351, 121964, 97553, 104263, 146910, 104451, 108692, 90105, 117465, 133239, 219, 7287, 10389, 97077, 107389, 142450, 119214, 133936, 149613, 2524, 1653, 137164, 125689, 3940, 1319, 158101, 23320, 117530, 5520, 141169, 94874, 98424, 34173, 1982, 134256, 121055, 116412, 7408, 10601, 7418, 146065, 96564, 127146, 3393, 12991, 122216, 158667, 120836, 112282, 1403, 118721, 4473, 7001, 145197, 138928, 5527, 120837, 2791, 33916, 137618, 120818, 123870, 97955, 155853, 159083, 121411, 6989, 95831, 162211, 40228, 98398, 121065, 104377, 7025, 135450, 89490, 32582, 1231, 118785, 4204, 30177, 90699, 931, 12464, 1549, 134229, 132757, 34174, 6763, 90534, 119058, 93802, 103098, 116382, 559, 98518, 3417, 3483, 7310, 2338, 93790, 14283, 123574, 132860, 101266, 92994, 118669, 120854, 405, 107650, 107144, 5528, 7415, 121025, 118930, 156171, 146664, 133943, 1877, 379, 320, 12826, 91301, 135488, 118314, 39667, 1365, 6764, 6589, 94237, 9531, 7000, 31609, 4949, 18521, 1359, 555, 139679, 9802, 1144, 107279, 120911, 4482, 7400, 99321, 34061, 98276, 94627, 6232, 3950, 1987, 123607, 93881, 40821, 30175, 123854, 12905, 9532, 543, 124666, 100193, 135394, 94879, 167565, 163979, 5890, 519, 1250, 120912, 102719, 34076, 927, 107151, 936, 147980, 6980, 6747, 95071, 149899, 12257, 125667, 1561, 39410, 120965, 95949, 8083, 135455, 7385, 6943, 96460, 5563, 123671, 7403, 129285, 109163, 116557, 13816, 147987, 6256, 102478, 126611, 119573, 14668, 4523, 3374, 5573, 91619, 133934, 14421, 94681, 98267, 2005, 558, 124669, 107367, 120852, 148219, 5618, 145968, 128194, 109113, 16421, 16428, 662, 126248, 11560, 104507, 97552, 162373, 112907, 8504, 40265, 16199, 5042, 6497, 136783, 10374, 158289, 147629, 122748, 4049, 141677, 98483, 126160, 7382, 32894, 2591, 1665, 5529, 130079, 2326, 147243, 2250, 119377, 156737, 150339, 154763, 9411, 121970, 6996, 90739, 148002, 10586, 165045, 158531, 32159, 1257, 103513, 167153, 133305, 152467, 90635, 7637, 256, 17149, 935, 97250, 131796, 5517, 96149, 15316, 5961, 117364, 100479, 118581, 111969, 133251, 5887, 148087, 6748, 97058, 7686, 135589, 9410, 120906, 129726, 98296, 98339, 139481, 113280, 6767, 2808, 16151, 118477, 121305, 7061, 7055, 123279, 132646, 123873, 146232, 135731, 123681, 92378, 1317, 149469, 541, 1563, 154005, 40264, 660, 163133, 5081, 123578, 15753, 107884, 135667, 90536, 5008, 151711, 2270, 6267, 2077, 1565, 2018, 133672, 36718, 130624, 95091, 91867, 1255, 95616, 135612, 102549, 155573, 92581, 3243, 14289, 127611, 3813, 525, 2310, 126585, 132374, 162189, 123617, 148419, 147977, 107023, 137101, 98541, 7286, 35227, 115921, 1367, 129128, 16442, 118720, 1684, 7022, 135604, 123610, 148297, 2584, 9968, 91977, 89022, 104446, 89021, 107460, 137067, 156747, 44860, 796, 15115, 98193, 8489, 135112, 10439, 29130, 283, 179, 16429, 6616, 90577, 137374, 138294, 2079, 140242, 124955, 129429, 126823, 136775, 1261, 104008, 143247, 974, 5894, 166923, 91436, 108460, 168083, 537, 6985, 866, 16193, 145522, 94009, 9774, 6604, 9067, 33917, 142585, 16507, 126861, 118109, 140022, 92210, 156455, 125157, 158241, 123010, 143182, 118240, 953, 94328, 90636, 119740, 3163, 143249, 121208, 126187, 120840, 96611, 23316, 112399, 4477, 119299, 140283, 158045, 148044, 124308, 124699, 147989, 772, 140592, 139981, 149467, 98340, 121303, 44873, 98391, 162599, 6904, 118777, 120841, 33975, 152989, 10631, 127610, 96497, 145305, 31309, 8758, 31625, 130412, 1663, 139977, 32848, 95824, 100440, 20361, 11930, 107403, 93787, 140260, 14847, 167973, 89010, 130844, 14251, 118826, 90539, 121060, 141374, 136875, 17296, 6494, 123834, 7007, 29102, 795, 118729, 135471, 116499, 108946, 131326, 132760, 137951, 120959, 157087, 116562, 132425, 140843, 7317, 104174, 96215, 75051, 111412, 100864, 107161, 131071, 10493, 31043, 1953, 44856, 14687, 6296, 112976, 9378, 7328, 141038, 92222, 34064, 1413, 8098, 5502, 15056, 19368, 140255, 5523, 6743, 5884, 6746, 9400, 11563, 138191, 5964, 10369, 128161, 9402, 8268, 988, 14127, 92727, 96214, 8095, 39466, 4630, 132728, 112283, 143006, 98124, 7410, 90537, 8079, 14141, 145609, 6997, 155897, 116993, 7316, 137225, 96935, 135519, 16433, 130451, 120860, 6269, 5515, 96601, 124688, 100510, 5762, 138275, 150849, 158975, 118454, 7219, 97831, 13142, 7353, 96125, 7223, 4067, 7404, 40920, 123320, 120887, 108002, 32668, 118841, 17297, 5962, 93912, 10521, 156511, 40923, 98719, 16444, 1256, 5526, 90538, 167109, 16627, 98018, 13350, 13862, 13023, 95678, 9412, 7050, 44859, 32032, 7063, 98142, 108442, 516, 98455, 142875, 137992, 882, 118734, 126249, 1304, 137018, 39929, 918, 96143, 9068, 10384, 97215, 127777, 127616, 138268, 161747, 115236, 752, 95092, 9538, 7391, 2283, 6636, 12979, 44839, 102968, 7327, 124957, 7635, 9024, 136778, 39244, 2328, 5596, 2305, 128259, 134010, 8078, 127233, 119585, 125837, 136776, 119244, 107369, 140346, 146265, 136905, 116408, 118956, 102479, 153005, 157, 116465, 142554, 9096, 143319, 1327, 3839, 7311, 127778, 11316, 12397, 146347, 2031, 103093, 147972, 162223, 9065, 140277, 1972, 146296, 11043, 140148, 123773, 6752, 123772) AND coalesce(account_move_line.reconciled) IS NOT TRUE AND (((("account_move_line"."parent_state" = 'posted') AND ("account_move_line"."company_id" in (1))) AND (("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)) GROUP BY account_move_line.partner_id, act.type; [ Date: 2026-04-07 12:08:23 ]
14	49s678ms	SELECT account_move_line.partner_id, act.type, SUM(account_move_line.amount_residual) FROM "account_move_line" LEFT JOIN account_account a ON (account_move_line.account_id = a.id) LEFT JOIN account_account_type act ON (a.user_type_id = act.id) WHERE act.type IN ('receivable', 'payable') AND account_move_line.partner_id IN (146232, 752, 135450, 6589, 140346, 559, 127233, 123610, 90538, 126160, 136778, 121060, 147980, 525, 4049, 7025, 116408, 97955, 97548, 129414, 8083, 118841, 146065, 120840, 135612, 554, 147972, 100864, 131326, 130412, 141374, 126861, 125689, 7061, 1261, 134010, 34076, 96143, 90739, 137018, 90577, 145609, 33917, 558, 10586, 1317, 16199, 12991, 125840, 7686, 9532, 7389, 9068, 1413, 92378, 121770, 7219, 7328, 147243, 3839, 123870, 123671, 5529, 11043, 137164, 2038, 1565, 147629, 4473, 9065, 102479, 140242, 145305, 124308, 7635, 6497, 5887, 123784, 137374, 132646, 123617, 123279, 90539, 137225, 138191, 98424, 145522, 537, 98193, 99321, 140283, 529, 772, 116382, 116638, 119585, 94328, 44856, 128259, 141038, 123320, 5569, 5563, 405, 2524, 14251, 6770, 6641, 10623, 1554, 32848, 988, 90316, 953, 118669, 1327, 9024, 3483, 5573, 146265, 126253, 6269, 104507, 146296, 33916, 11560, 96460, 141972, 5523, 44839, 974, 10521, 34173, 14003, 379, 1075, 935, 31609, 108946, 44859, 2808, 3940, 9411, 3925, 5081, 5961, 256, 93798, 6238, 33975, 1144, 12979, 7050, 107161, 108002, 2299, 2250, 130844, 2283, 120905, 13142, 516, 219, 795, 95949, 95678, 6232, 95831, 5964, 4204, 5517, 97831, 6616, 12397, 5894, 32582, 7055, 14847, 543, 14687, 1257, 10529, 6986, 18521, 16507, 40923, 6996, 1563, 9400, 1691, 11563, 16193, 660, 931, 662, 12464, 3373, 5042, 6636, 1403, 20361, 1319, 6989, 7057, 102549, 16432, 142107, 1255, 10576, 7637, 16419, 5618, 9402, 9403, 15115, 7289, 5884, 927, 10399, 7410, 7403, 2392, 10369, 7310, 6743, 14668, 36718, 4477, 14421, 936, 5626, 16421, 5528, 1304, 5502, 39667, 9802, 1972, 1359, 6764, 5008, 946, 1367, 2791, 1373, 8050, 3163, 6997, 116499, 3417, 179, 929, 13816, 14127, 7311, 1684, 9067, 1561, 15872, 4630, 89010, 940, 123607, 97949, 2338, 157, 520, 866, 882, 1365, 2018, 2031, 2079, 2310, 2326, 2328, 2568, 2591, 3374, 3813, 4949, 5487, 5526, 5515, 5596, 5602, 5962, 6242, 6245, 6267, 6487, 6494, 6747, 6748, 6746, 6752, 6763, 6906, 6980, 6985, 7022, 7007, 7001, 7063, 7223, 7287, 7317, 7316, 7385, 7936, 8079, 8078, 8095, 8489, 8514, 9378, 9412, 9538, 9531, 9774, 10384, 10374, 10439, 10493, 10578, 10631, 12905, 14141, 14289, 15056, 15316, 15753, 16429, 16433, 16428, 16444, 16442, 19368, 4523, 7286, 23316, 23320, 283, 6904, 5486, 5520, 13605, 29102, 1987, 320, 1653, 1665, 2077, 5619, 8034, 30175, 30177, 16627, 7353, 1549, 32159, 14765, 5527, 32668, 32894, 1877, 11316, 6296, 2005, 4481, 9096, 14439, 34064, 13862, 34061, 1250, 34114, 34174, 14283, 6767, 35252, 8758, 31625, 7408, 2270, 5762, 39244, 39410, 39929, 758, 40265, 40264, 2300, 10601, 5890, 6604, 9968, 44860, 2305, 11930, 12257, 4519, 98398, 13023, 2734, 6983, 35227, 17297, 34704, 29130, 7000, 7347, 7390, 7404, 1982, 932, 7418, 3243, 8504, 11568, 125155, 96125, 40920, 6647, 10389, 13350, 31043, 16151, 8268, 8098, 1231, 2584, 1663, 6256, 13012, 6943, 1953, 519, 7391, 2765, 124666, 100479, 91436, 4482, 541, 4067, 555, 3393, 918, 938, 115921, 17149, 111412, 120910, 120912, 39466, 9410, 100440, 133943, 796, 1256, 3950, 5505, 7046, 7327, 7400, 7382, 7415, 12826, 17296, 75051, 31309, 32032, 33944, 39623, 40228, 40821, 44873, 75362, 90537, 91301, 98276, 104263, 107144, 107650, 111246, 113280, 118930, 124669, 127354, 132425, 136783, 137027, 89021, 89022, 137618, 89490, 90105, 90534, 90536, 90636, 90635, 90699, 145508, 91619, 91867, 148002, 91977, 92210, 92222, 92581, 92727, 92722, 92994, 93790, 93787, 93802, 93881, 93912, 94009, 94237, 94627, 94681, 94874, 94879, 95071, 95091, 95092, 95616, 95824, 96149, 96215, 96214, 96497, 96564, 96611, 96601, 96683, 96935, 97058, 97077, 97215, 97250, 97283, 97304, 97309, 97553, 97552, 97867, 98018, 98124, 98142, 98186, 98267, 98296, 98340, 98339, 98391, 98386, 98455, 98483, 98518, 98541, 98556, 98719, 99648, 100193, 100510, 100548, 101171, 101208, 101266, 102445, 102478, 102719, 102968, 103093, 103097, 103098, 103126, 103446, 103513, 104008, 104174, 104377, 104446, 104451, 107023, 107043, 107151, 107163, 107279, 107367, 107369, 107389, 107403, 107460, 107884, 108442, 108460, 108692, 109113, 109163, 111486, 111969, 112282, 112283, 112399, 112907, 112976, 113319, 113410, 115236, 116412, 116465, 116562, 116557, 116993, 117364, 117465, 117530, 118109, 118240, 118314, 118454, 118477, 118581, 118721, 118720, 118729, 118734, 118777, 118785, 118826, 118956, 119058, 119214, 119241, 119244, 119299, 119377, 119573, 119740, 120818, 120841, 120836, 120837, 120854, 120860, 120857, 120852, 120887, 120906, 120911, 120959, 120965, 121025, 121055, 121065, 121208, 121303, 121305, 121411, 121964, 121970, 122216, 122410, 122748, 123010, 123319, 123574, 123578, 123681, 123772, 123773, 123834, 123854, 123873, 123962, 124387, 124699, 124688, 124957, 124955, 125154, 125157, 125351, 125559, 125667, 125675, 125849, 125837, 126187, 126249, 126248, 126585, 126611, 126823, 126836, 127146, 127611, 127610, 127616, 127777, 127778, 128161, 128194, 129128, 129285, 129429, 129726, 130079, 130451, 130624, 131071, 131796, 132374, 132728, 132757, 132760, 132860, 133239, 133251, 133305, 133352, 133672, 133934, 133936, 133946, 134229, 134256, 135112, 135394, 135455, 135471, 135488, 135519, 135589, 135604, 135667, 135733, 135731, 136774, 136775, 136776, 136875, 136887, 136905, 137067, 137101, 137474, 137630, 137951, 137992, 138268, 138275, 138294, 138928, 139481, 139679, 139981, 139977, 140022, 140148, 140260, 140255, 140277, 140449, 140592, 140843, 141169, 141677, 142450, 142554, 142585, 142875, 143006, 143182, 143249, 143247, 143301, 143319, 145197, 145968, 146347, 146664, 146910, 148044, 147907, 147977, 147987, 147989, 148087, 148219, 148297, 148419, 149467, 149469, 149613, 149899, 150339, 150849, 151711, 152467, 152989, 153005, 154005, 154763, 155013, 155573, 155853, 155897, 156171, 156455, 156511, 156737, 156747, 157087, 157759, 157981, 158045, 158101, 158241, 158289, 158531, 158667, 158949, 158975, 159083, 159233, 161603, 161747, 162189, 162195, 162211, 162223, 162373, 162599, 163133, 163979, 165045, 166923, 167035, 167109, 167153, 167565, 167973, 168083) AND coalesce(account_move_line.reconciled) IS NOT TRUE AND (((("account_move_line"."parent_state" = 'posted') AND ("account_move_line"."company_id" in (1))) AND (("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)) GROUP BY account_move_line.partner_id, act.type; [ Date: 2026-04-07 12:45:17 ]
15	49s569ms	SELECT DISTINCT "user_input_id" FROM "survey_user_input_line" WHERE "id" > 0; [ Date: 2026-04-07 10:37:48 ]
16	49s63ms	create index account_move_tax_cash_basis_rec_id_index on account_move (tax_cash_basis_rec_id); [ Date: 2026-04-07 13:23:05 - Database: odoo - User: odoo ]
17	48s476ms	SELECT DISTINCT "user_input_id" FROM "survey_user_input_line" WHERE "id" > 0; [ Date: 2026-04-07 10:38:42 ]
18	47s433ms	SELECT account_move_line.partner_id, act.type, SUM(account_move_line.amount_residual) FROM "account_move_line" LEFT JOIN account_account a ON (account_move_line.account_id = a.id) LEFT JOIN account_account_type act ON (a.user_type_id = act.id) WHERE act.type IN ('receivable', 'payable') AND account_move_line.partner_id IN (37178, 23778, 73133, 46797, 82180, 47592, 119262, 67855, 24153, 112596, 93192, 67936, 46548, 67931, 41284, 145192, 71464, 137069, 142159, 30311, 22611, 55140, 62849, 41480, 67802, 92927, 107443, 68024, 122564, 54881, 121031, 58351, 121340, 68106, 68324, 70705, 73759, 78916, 103628, 88653, 50051, 28419, 72572, 78362, 93162, 24151, 31513, 134078, 99553, 93016, 30192, 41843, 59961, 23461, 56854, 31799, 68542, 23638, 34810, 35733, 55177, 31880, 36862, 73775, 57567, 92903, 96433, 31690, 68164, 76513, 42023, 23766, 29398, 79851, 22623, 23563, 67866, 118482, 24388, 99582, 40214, 22576, 27291, 27285, 27556, 28303, 29391, 30165, 30161, 30372, 30576, 31059, 31366, 31363, 31445, 31684, 31892, 33133, 34615, 34930, 34965, 35016, 34996, 37999, 41771, 38589, 23048, 39290, 40471, 67941, 42132, 43974, 45064, 45174, 45520, 31950, 48210, 31762, 30658, 90864, 53024, 41715, 27558, 54616, 45341, 22766, 32170, 47918, 55348, 40053, 55605, 45035, 45736, 56876, 27360, 59057, 31952, 63606, 63682, 64417, 64558, 24071, 98305, 65257, 41306, 65438, 65939, 72637, 67907, 67731, 67796, 67862, 67938, 67915, 67916, 67939, 67982, 68048, 68192, 68270, 72629, 42278, 63073, 28509, 43921, 45735, 45021, 46318, 38321, 76084, 110759, 72564, 72555, 72576, 72634, 72616, 72621, 72653, 29405, 72663, 72825, 56194, 123197, 73520, 73980, 74037, 32258, 39312, 39382, 39901, 42111, 62966, 67820, 68147, 68202, 68201, 70703, 73199, 76214, 76220, 76610, 76998, 79702, 81444, 114991, 85103, 85842, 93013, 90852, 90891, 91050, 91101, 92302, 92881, 92918, 92925, 92954, 92980, 92979, 93003, 93015, 93043, 93165, 93168, 93193, 94307, 94825, 95171, 96933, 97048, 98537, 98610, 99574, 99717, 100336, 102208, 104291, 106867, 107248, 108210, 111644, 116250, 117809, 118647, 120935, 120941, 121002, 121018, 121023, 121103, 121099, 121323, 122485, 127374, 129489, 129512, 135517, 139553, 141181, 143289, 144132) AND coalesce(account_move_line.reconciled) IS NOT TRUE AND (((("account_move_line"."parent_state" = 'posted') AND ("account_move_line"."company_id" in (1, 3))) AND (("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)) GROUP BY account_move_line.partner_id, act.type; [ Date: 2026-04-07 12:49:51 ]
19	43s56ms	SELECT account_move_line.partner_id, act.type, SUM(account_move_line.amount_residual) FROM "account_move_line" LEFT JOIN account_account a ON (account_move_line.account_id = a.id) LEFT JOIN account_account_type act ON (a.user_type_id = act.id) WHERE act.type IN ('receivable', 'payable') AND account_move_line.partner_id IN (92137, 39602, 90957, 3471, 35165, 39338, 2151, 12698, 786, 3968, 44891, 1000, 74952, 2453, 2680, 115034, 190, 972, 11565, 102219, 829, 29354, 1050, 4561, 17321, 39272, 16171, 2196, 1136, 15801, 99278, 95435, 646, 145019, 971, 101119, 12295, 7919, 6467, 5001, 71853, 31735, 147597, 1894, 14762, 132550, 35309, 798, 7578, 1942, 12440, 360, 14957, 16423, 2152, 104194, 119408, 355, 157389, 145303, 2155, 115851, 1450, 139470, 1184, 18568, 139811, 787, 91240, 1448, 7552, 133152, 7688, 10996, 145621, 9069, 5033, 2153, 101017) AND coalesce(account_move_line.reconciled) IS NOT TRUE AND (((("account_move_line"."parent_state" = 'posted') AND ("account_move_line"."company_id" in (1))) AND (("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)) GROUP BY account_move_line.partner_id, act.type; [ Date: 2026-04-07 12:17:42 ]
20	43s51ms	SELECT account_move_line.partner_id, act.type, SUM(account_move_line.amount_residual) FROM "account_move_line" LEFT JOIN account_account a ON (account_move_line.account_id = a.id) LEFT JOIN account_account_type act ON (a.user_type_id = act.id) WHERE act.type IN ('receivable', 'payable') AND account_move_line.partner_id IN (13078, 145891, 14063, 30351, 13274, 15368, 13347, 29023, 30632, 14621, 140511, 14230, 133202, 15415, 6633, 14697, 1078, 2609, 13244, 12783, 12791, 13083, 13291, 14215, 14885, 15202, 15388, 41453, 29261, 15109, 16216, 2258, 15855, 35029, 15107, 22522, 12816, 2967, 14921, 18519, 29611, 30641, 90076, 97980, 98437, 104385, 108596, 112340, 121192, 122787, 122951, 125739, 127849, 129985, 158339) AND coalesce(account_move_line.reconciled) IS NOT TRUE AND (((("account_move_line"."parent_state" = 'posted') AND ("account_move_line"."company_id" in (1))) AND (("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)) GROUP BY account_move_line.partner_id, act.type; [ Date: 2026-04-07 13:50:09 ]

Time consuming queries


[ User: odoo - Total duration: 4m19s - Times executed: 49 ]
[ User: odoo - Total duration: 11s815ms - Times executed: 38 ]
Date: 2026-04-07 10:46:09
Duration: 30s979ms
[ User: odoo - Total duration: 13s201ms - Times executed: 34 ]
[ User: odoo - Total duration: 5s765ms - Times executed: 7 ]
Date: 2026-04-07 12:15:23
Duration: 4s116ms
[ User: odoo - Total duration: 10s212ms - Times executed: 13 ]
Date: 2026-04-07 12:20:38
Duration: 15s277ms
Date: 2026-04-07 13:49:57
Duration: 22s607ms
[ User: odoo - Total duration: 8s838ms - Times executed: 10 ]
Date: 2026-04-07 11:54:14
Duration: 35s533ms
[ User: odoo - Total duration: 14s201ms - Times executed: 7 ]
Date: 2026-04-07 13:50:19
Duration: 1m18s
Date: 2026-04-07 13:50:14
Duration: 12s204ms
Date: 2026-04-07 13:41:51
Duration: 3m28s
Date: 2026-04-07 13:15:17
Duration: 2s847ms
Date: 2026-04-07 10:28:51
Duration: 1s613ms
Date: 2026-04-07 13:19:18
Duration: 9s133ms
Date: 2026-04-07 13:47:09
Duration: 5s628ms
Date: 2026-04-07 12:00:17
Duration: 1m2s

Most frequent queries (N)


[ User: odoo - Total duration: 11s815ms - Times executed: 38 ]
[ User: odoo - Total duration: 4m19s - Times executed: 49 ]
[ User: odoo - Total duration: 13s201ms - Times executed: 34 ]
Date: 2026-04-07 12:15:23
Duration: 4s116ms
[ User: odoo - Total duration: 5s765ms - Times executed: 7 ]
[ User: odoo - Total duration: 8s838ms - Times executed: 10 ]
[ User: odoo - Total duration: 7s442ms - Times executed: 11 ]
Date: 2026-04-07 13:15:17
Duration: 2s847ms
[ User: odoo - Total duration: 3s525ms - Times executed: 10 ]
Date: 2026-04-07 10:28:51
Duration: 1s613ms
[ User: odoo - Total duration: 10s212ms - Times executed: 13 ]
Date: 2026-04-07 12:38:18
Duration: 1s51ms
Date: 2026-04-07 11:41:23
Duration: 3s879ms
[ User: odoo - Total duration: 2s852ms - Times executed: 8 ]
[ User: odoo - Total duration: 634ms - Times executed: 1 ]
[ User: odoo - Total duration: 1s371ms - Times executed: 3 ]
Date: 2026-04-07 12:39:25
Duration: 394ms
Date: 2026-04-07 10:34:08
Duration: 555ms
Date: 2026-04-07 13:27:39
Duration: 1s64ms
[ User: odoo - Total duration: 1s955ms - Times executed: 7 ]

Normalized slowest queries (N)


Date: 2026-04-07 13:41:51
Duration: 3m28s
Date: 2026-04-07 12:00:17
Duration: 1m2s
Date: 2026-04-07 10:46:09
Duration: 30s979ms
Date: 2026-04-07 11:54:14
Duration: 35s533ms
Date: 2026-04-07 13:49:57
Duration: 22s607ms
Date: 2026-04-07 13:50:19
Duration: 1m18s
Date: 2026-04-07 12:20:38
Duration: 15s277ms
Date: 2026-04-07 13:19:18
Duration: 9s133ms
Date: 2026-04-07 13:50:14
Duration: 12s204ms
[ User: odoo - Total duration: 4m19s - Times executed: 49 ]
[ User: odoo - Total duration: 14s201ms - Times executed: 7 ]
Date: 2026-04-07 13:47:09
Duration: 5s628ms
[ User: odoo - Total duration: 10s212ms - Times executed: 13 ]
[ User: odoo - Total duration: 8s838ms - Times executed: 10 ]
[ User: odoo - Total duration: 5s765ms - Times executed: 7 ]
Date: 2026-04-07 12:15:23
Duration: 4s116ms
Date: 2026-04-07 10:28:51
Duration: 1s613ms
Date: 2026-04-07 13:15:17
Duration: 2s847ms
[ User: odoo - Total duration: 13s201ms - Times executed: 34 ]
[ User: odoo - Total duration: 634ms - Times executed: 1 ]

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

Log levels

Key values

469,463 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	51	0.01%
DETAIL	15,909	3.39%
ERROR	16,689	3.55%
FATAL	13	0.00%
HINT	1	0.00%
LOG	419,682	89.40%
STATEMENT	17,118	3.65%

Events distribution

Key values

0 PANIC entries
13 FATAL entries
16689 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

14,692 Max number of times the same event was reported
16,702 Total events found

Rank

Times reported

Error

1

14,692

Details

ERROR: insert or update on table "..." violates foreign key constraint "..."

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Apr 07	10	2,625
	11	4,104
	12	4,276
	13	3,687

ERROR: insert or update on table "account_tax_sale_order_line_rel" violates foreign key constraint "account_tax_sale_order_line_rel_sale_order_line_id_fkey"
ERROR: insert or update on table "stock_picking" violates foreign key constraint "stock_picking_sale_id_fkey"
ERROR: insert or update on table "account_tax_stock_move_rel" violates foreign key constraint "account_tax_stock_move_rel_stock_move_id_fkey"

2

844

Details

ERROR: update or delete on table "..." violates foreign key constraint "..." on table "..."

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Apr 07	10	154
	11	240
	12	240
	13	210

ERROR: update or delete on table "product_promotion" violates foreign key constraint "product_promotion_offer_promotion_id_fkey" on table "product_promotion_offer"

3

566

Details

ERROR: could not obtain lock on row in relation "..."

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Apr 07	10	105
	11	140
	12	170
	13	151

ERROR: could not obtain lock on row in relation "ir_cron"
ERROR: could not obtain lock on row in relation "planning_planning"
ERROR: could not obtain lock on row in relation "stock_quant"

4

352

Details

ERROR: duplicate key value violates unique constraint "..."

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Apr 07	10	17
	11	179
	12	59
	13	97

ERROR: duplicate key value violates unique constraint "res_partner_pref_visit_days__ruid_uniq"
ERROR: duplicate key value violates unique constraint "account_payment__ruid_uniq"
ERROR: duplicate key value violates unique constraint "sale_order__ruid_uniq"

5

190

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Apr 07	10	22
	11	51
	12	54
	13	63

ERROR: could not serialize access due to concurrent update

6

22

Details

ERROR: invalid input syntax for type date: ...

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Apr 07	10	2
	11	9
	12	7
	13	4

ERROR: invalid input syntax for type date: "" at character 481

7

12

Details

LOG: process ... still waiting for ShareLock on transaction ... after ... ms

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Apr 07	12	4
	13	8

ERROR: process 664227 still waiting for ShareLock on transaction 1151714199 after 1000.098 ms
ERROR: process 666545 still waiting for ShareLock on transaction 1151718538 after 1000.060 ms
ERROR: process 661118 still waiting for ShareLock on transaction 1151718538 after 1000.064 ms

8

12

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Apr 07	10	12

FATAL: the database system is starting up

9

5

Details

LOG: process ... still waiting for RowExclusiveLock on relation ... of database ... after ... ms

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Apr 07	10	1
	13	4

ERROR: process 55 still waiting for RowExclusiveLock on relation 16857 of database 16384 after 1001.396 ms at character 13
ERROR: process 660835 still waiting for RowExclusiveLock on relation 25516 of database 16384 after 1000.059 ms
ERROR: process 660843 still waiting for RowExclusiveLock on relation 25516 of database 16384 after 1000.047 ms at character 8

10

1

Details

ERROR: missing FROM-clause entry for table "..."

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Apr 07	13	1

ERROR: missing FROM-clause entry for table "cp" at character 8

11

1

Details

ERROR: payload string too long

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Apr 07	13	1

ERROR: payload string too long

12

1

Details

ERROR: canceling statement due to user request

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Apr 07	13	1

ERROR: canceling statement due to user request

13

1

Details

ERROR: syntax error at or near "..."

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Apr 07	13	1

ERROR: syntax error at or near ";" at character 85

14

1

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Apr 07	12	1

FATAL: database "account_move_line" does not exist

15

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Apr 07	10	1

ERROR: database system was shut down at 2026-04-07 10:21:10 UTC

16

1

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Apr 07	12	1

ERROR: deadlock detected

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

Queries generating the most temporary files (N)

Queries generating the largest temporary files

Vacuums

Vacuums / Analyzes Distribution

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

Autovacuum Activity

Locks

Locks by types

Key values

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database

Key values

Queries by user

Key values

Duration by user

Key values

Queries by host

Key values