#	exclusive	inclusive	rows x	rows	loops	node
1.	0.000	6,475.584	↑ 1.0	22	1	→ Finalize GroupAggregate (cost=5,184,850.48..5,184,864.56 rows=22 width=14) (actual time=6,475.566..6,475.584 rows=22 loops=1) Group Key: vo_4.id_pays Functions: 633 Options: Inlining true, Optimization true, Expressions true, Deforming true Timing: Generation 216.628 ms, Inlining 326.652 ms, Optimization 17865.536 ms, Emission 10634.604 ms, Total 29043.421 ms"Execution Time: 6,649.581 ms
2.	213.122	6,625.091	↑ 3.5	31	1	→ Gather Merge (cost=5,184,850.48..5,184,863.79 rows=110 width=11) (actual time=6,475.555..6,625.091 rows=31 loops=1) Workers Planned: 5 Workers Launched: 5
3.	0.045	6,411.969	↑ 4.4	5	6 / 6	→ Sort (cost=5,183,850.41..5,183,850.46 rows=22 width=11) (actual time=6,411.968..6,411.969 rows=5 loops=6) Sort Key: vo_4.id_pays Sort Method: quicksort Memory: 25kB Worker 0: Sort Method: quicksort Memory: 25kB Worker 1: Sort Method: quicksort Memory: 25kB Worker 2: Sort Method: quicksort Memory: 25kB Worker 3: Sort Method: quicksort Memory: 25kB Worker 4: Sort Method: quicksort Memory: 25kB
4.	200.030	6,411.924	↑ 4.4	5	6 / 6	→ Partial HashAggregate (cost=5,183,849.70..5,183,849.92 rows=22 width=11) (actual time=6,411.922..6,411.924 rows=5 loops=6) Group Key: vo_4.id_pays
5.	135.266	6,211.894	↑ 2.8	1,531,448	6 / 6	→ Hash Left Join (cost=6,983.35..5,162,344.63 rows=4,301,014 width=3) (actual time=4,884.466..6,211.894 rows=1,531,448 loops=6) Hash Cond: (vo_4.id_dealer = (d.id_dealer)::text)
6.	72.624	6,035.277	↑ 1.2	1,531,004	6 / 6	→ Parallel Append (cost=0.56..5,145,637.36 rows=1,832,784 width=15) (actual time=4,843.009..6,035.277 rows=1,531,004 loops=6)
7.	803.200	805.938	↓ 4.0	152,450	1 / 6	→ Parallel Bitmap Heap Scan on vo_all_partition_cz vo_4 (cost=1,945.69..64,489.13 rows=38,444 width=15) (actual time=4,719.476..4,835.626 rows=152,450 loops=1) Filter: (NOT dead)
8.	2.738	2.738	↑ 1.0	152,450	1 / 6	→ Bitmap Index Scan on vo_all_tmp_partition_cz_dead_dt_dead_idx (cost=0.00..1,907.25 rows=153,776 width=0) (actual time=16.429..16.429 rows=152,450 loops=1) Index Cond: (dead = false)
9.	788.717	790.264	↓ 4.0	78,420	1 / 6	→ Parallel Bitmap Heap Scan on vo_all_partition_hr vo_10 (cost=992.38..33,693.53 rows=19,615 width=16) (actual time=4,678.128..4,741.582 rows=78,420 loops=1) Filter: (NOT dead)
10.	1.546	1.546	↑ 1.0	78,420	1 / 6	→ Bitmap Index Scan on vo_all_tmp_partition_hr_dead_id_dealer_idx (cost=0.00..972.76 rows=78,459 width=0) (actual time=9.279..9.279 rows=78,420 loops=1) Index Cond: (dead = false)
11.	1,083.226	1,083.226	↑ 1.2	360,432	6 / 6	→ Parallel Index Scan using vo_all_tmp_partition_de_dead_id_dealer_idx on vo_all_partition_de vo_5 (cost=0.56..1,297,764.77 rows=440,140 width=13) (actual time=819.019..1,083.226 rows=360,432 loops=6) Index Cond: (dead = false)
12.	943.811	943.811	↓ 4.0	1,096,513	1 / 6	→ Parallel Index Scan using vo_all_tmp_partition_fr_dead_id_dealer_idx on vo_all_partition_fr vo_8 (cost=0.56..619,128.24 rows=272,777 width=11) (actual time=4,864.400..5,662.867 rows=1,096,513 loops=1) Index Cond: (dead = false)
13.	887.421	887.421	↓ 4.1	799,135	1 / 6	→ Parallel Index Scan using vo_all_tmp_partition_it_dead_id_dealer_idx on vo_all_partition_it vo_12 (cost=0.56..453,426.26 rows=192,613 width=14) (actual time=4,779.682..5,324.527 rows=799,135 loops=1) Index Cond: (dead = false)
14.	122.942	122.942	↓ 4.1	1,074,884	1 / 6	→ Parallel Index Scan using vo_all_tmp_partition_es_dead_id_dealer_idx on vo_all_partition_es vo_7 (cost=0.56..621,436.74 rows=264,903 width=12) (actual time=0.034..737.649 rows=1,074,884 loops=1) Index Cond: (dead = false)
15.	93.154	93.154	↓ 4.1	891,632	1 / 6	→ Parallel Index Scan using vo_all_tmp_partition_gb_dead_id_dealer_idx on vo_all_partition_gb vo_9 (cost=0.56..489,376.37 rows=216,040 width=15) (actual time=0.049..558.926 rows=891,632 loops=1) Index Cond: (dead = false)
16.	54.764	54.764	↓ 4.0	507,129	1 / 6	→ Parallel Index Scan using vo_all_tmp_partition_nl_dead_id_dealer_idx on vo_all_partition_nl vo_15 (cost=0.56..297,367.39 rows=126,444 width=15) (actual time=0.060..328.587 rows=507,129 loops=1) Index Cond: (dead = false)
17.	49.533	49.533	↓ 3.9	513,517	1 / 6	→ Parallel Index Scan using vo_all_tmp_partition_pl_dead_id_dealer_idx on vo_all_partition_pl vo_17 (cost=0.56..302,589.47 rows=132,830 width=14) (actual time=0.074..297.198 rows=513,517 loops=1) Index Cond: (dead = false)
18.	15.666	15.666	↓ 3.0	155,942	1 / 6	→ Parallel Index Scan using vo_all_tmp_partition_be_dead_id_dealer_idx on vo_all_partition_be vo_1 (cost=0.43..93,227.97 rows=52,013 width=13) (actual time=0.040..93.997 rows=155,942 loops=1) Index Cond: (dead = false)
19.	23.948	23.948	↓ 3.1	208,829	1 / 6	→ Parallel Index Scan using vo_all_tmp_partition_at_dead_id_dealer_idx on vo_all_partition_at vo (cost=0.43..125,766.39 rows=68,464 width=13) (actual time=0.033..143.690 rows=208,829 loops=1) Index Cond: (dead = false)
20.	20.243	20.243	↓ 3.1	214,104	1 / 6	→ Parallel Index Scan using vo_all_tmp_partition_ro_dead_id_dealer_idx on vo_all_partition_ro vo_19 (cost=0.43..121,578.35 rows=68,725 width=35) (actual time=0.059..121.456 rows=214,104 loops=1) Index Cond: (dead = false)
21.	12.136	12.136	↓ 3.1	160,562	1 / 6	→ Parallel Index Scan using vo_all_tmp_partition_pt_dead_id_dealer_idx on vo_all_partition_pt vo_18 (cost=0.43..92,739.40 rows=51,517 width=13) (actual time=0.053..72.814 rows=160,562 loops=1) Index Cond: (dead = false)
22.	17.267	17.267	↓ 1.0	53,071	3 / 6	→ Parallel Index Scan using vo_all_tmp_partition_se_dead_id_dealer_idx on vo_all_partition_se vo_20 (cost=0.43..89,343.29 rows=50,811 width=15) (actual time=0.030..34.535 rows=53,071 loops=3) Index Cond: (dead = false)
23.	12.128	12.128	↓ 1.6	74,787	2 / 6	→ Parallel Index Scan using vo_all_tmp_partition_ma_dead_id_dealer_idx on vo_all_partition_ma vo_14 (cost=0.43..79,695.83 rows=46,865 width=35) (actual time=0.036..36.385 rows=74,787 loops=2) Index Cond: (dead = false)
24.	9.354	9.354	↓ 2.4	98,627	1 / 6	→ Parallel Index Scan using vo_all_tmp_partition_dk_dead_id_dealer_idx on vo_all_partition_dk vo_6 (cost=0.42..55,721.41 rows=40,966 width=16) (actual time=0.057..56.127 rows=98,627 loops=1) Index Cond: (dead = false)
25.	6.285	6.285	↓ 2.4	64,363	1 / 6	→ Parallel Index Scan using vo_all_tmp_partition_no_dead_id_dealer_idx on vo_all_partition_no vo_16 (cost=0.42..36,136.34 rows=26,906 width=16) (actual time=0.051..37.710 rows=64,363 loops=1) Index Cond: (dead = false)
26.	2.536	2.536	↑ 1.2	16,454	2 / 6	→ Parallel Index Scan using vo_all_tmp_partition_si_dead_id_dealer_idx on vo_all_partition_si vo_21 (cost=0.42..18,484.16 rows=19,158 width=16) (actual time=0.024..7.608 rows=16,454 loops=2) Index Cond: (dead = false)
27.	0.497	0.497	↓ 1.7	6,546	1 / 6	→ Parallel Index Scan using vo_all_tmp_partition_lu_dead_id_dealer_idx on vo_all_partition_lu vo_13 (cost=0.41..3,712.77 rows=3,801 width=16) (actual time=0.028..2.981 rows=6,546 loops=1) Index Cond: (dead = false)
28.	72.768	72.768	↓ 4.9	238,817	1 / 6	→ Parallel Seq Scan on vo_all_partition_ch vo_3 (cost=0.00..95,088.40 rows=48,538 width=13) (actual time=325.709..436.607 rows=238,817 loops=1) Filter: (NOT dead) Rows Removed by Filter: 942,465
29.	74.205	74.205	↓ 5.1	219,894	1 / 6	→ Parallel Seq Scan on vo_all_partition_ie vo_11 (cost=0.00..89,739.86 rows=43,099 width=15) (actual time=343.155..445.232 rows=219,894 loops=1) Filter: (NOT dead) Rows Removed by Filter: 1,061,465
30.	864.566	864.566	↓ 4.0	200,375	1 / 6	→ Parallel Seq Scan on vo_all_partition_bg vo_2 (cost=0.00..55,967.38 rows=49,855 width=35) (actual time=5,102.417..5,187.396 rows=200,375 loops=1) Filter: (NOT dead) Rows Removed by Filter: 497,491
31.	0.954	41.351	↑ 2.3	5,433	6 / 6	→ Hash (cost=6,823.80..6,823.80 rows=12,719 width=12) (actual time=41.350..41.351 rows=5,433 loops=6) Buckets: 16,384 Batches: 1 Memory Usage: 362kB
32.	25.858	40.397	↑ 2.3	5,433	6 / 6	→ Nested Loop Left Join (cost=0.00..6,823.80 rows=12,719 width=12) (actual time=0.068..40.397 rows=5,433 loops=6) Join Filter: ((n.id_network)::text = ANY ((d.ids_network)::text[])) Rows Removed by Join Filter: 255,010
33.	3.699	3.699	↑ 1.0	5,420	6 / 6	→ Seq Scan on dealer d (cost=0.00..318.20 rows=5,420 width=41) (actual time=0.036..3.699 rows=5,420 loops=6)
34.	10.813	10.840	↑ 1.0	48	32,520 / 6	→ Materialize (cost=0.00..1.72 rows=48 width=4) (actual time=0.000..0.002 rows=48 loops=32,520)
35.	0.027	0.027	↑ 1.0	48	6 / 6	→ Seq Scan on network n (cost=0.00..1.48 rows=48 width=4) (actual time=0.023..0.027 rows=48 loops=6)

"Finalize GroupAggregate  (cost=5184850.48..5184864.56 rows=22 width=14) (actual time=6475.566..6475.584 rows=22 loops=1)"
"  Group Key: vo_4.id_pays"
"  ->  Gather Merge  (cost=5184850.48..5184863.79 rows=110 width=11) (actual time=6475.555..6625.091 rows=31 loops=1)"
"        Workers Planned: 5"
"        Workers Launched: 5"
"        ->  Sort  (cost=5183850.41..5183850.46 rows=22 width=11) (actual time=6411.968..6411.969 rows=5 loops=6)"
"              Sort Key: vo_4.id_pays"
"              Sort Method: quicksort  Memory: 25kB"
"              Worker 0:  Sort Method: quicksort  Memory: 25kB"
"              Worker 1:  Sort Method: quicksort  Memory: 25kB"
"              Worker 2:  Sort Method: quicksort  Memory: 25kB"
"              Worker 3:  Sort Method: quicksort  Memory: 25kB"
"              Worker 4:  Sort Method: quicksort  Memory: 25kB"
"              ->  Partial HashAggregate  (cost=5183849.70..5183849.92 rows=22 width=11) (actual time=6411.922..6411.924 rows=5 loops=6)"
"                    Group Key: vo_4.id_pays"
"                    ->  Hash Left Join  (cost=6983.35..5162344.63 rows=4301014 width=3) (actual time=4884.466..6211.894 rows=1531448 loops=6)"
"                          Hash Cond: (vo_4.id_dealer = (d.id_dealer)::text)"
"                          ->  Parallel Append  (cost=0.56..5145637.36 rows=1832784 width=15) (actual time=4843.009..6035.277 rows=1531004 loops=6)"
"                                ->  Parallel Bitmap Heap Scan on vo_all_partition_cz vo_4  (cost=1945.69..64489.13 rows=38444 width=15) (actual time=4719.476..4835.626 rows=152450 loops=1)"
"                                      Filter: (NOT dead)"
"                                      ->  Bitmap Index Scan on vo_all_tmp_partition_cz_dead_dt_dead_idx  (cost=0.00..1907.25 rows=153776 width=0) (actual time=16.429..16.429 rows=152450 loops=1)"
"                                            Index Cond: (dead = false)"
"                                ->  Parallel Bitmap Heap Scan on vo_all_partition_hr vo_10  (cost=992.38..33693.53 rows=19615 width=16) (actual time=4678.128..4741.582 rows=78420 loops=1)"
"                                      Filter: (NOT dead)"
"                                      ->  Bitmap Index Scan on vo_all_tmp_partition_hr_dead_id_dealer_idx  (cost=0.00..972.76 rows=78459 width=0) (actual time=9.279..9.279 rows=78420 loops=1)"
"                                            Index Cond: (dead = false)"
"                                ->  Parallel Index Scan using vo_all_tmp_partition_de_dead_id_dealer_idx on vo_all_partition_de vo_5  (cost=0.56..1297764.77 rows=440140 width=13) (actual time=819.019..1083.226 rows=360432 loops=6)"
"                                      Index Cond: (dead = false)"
"                                ->  Parallel Index Scan using vo_all_tmp_partition_fr_dead_id_dealer_idx on vo_all_partition_fr vo_8  (cost=0.56..619128.24 rows=272777 width=11) (actual time=4864.400..5662.867 rows=1096513 loops=1)"
"                                      Index Cond: (dead = false)"
"                                ->  Parallel Index Scan using vo_all_tmp_partition_it_dead_id_dealer_idx on vo_all_partition_it vo_12  (cost=0.56..453426.26 rows=192613 width=14) (actual time=4779.682..5324.527 rows=799135 loops=1)"
"                                      Index Cond: (dead = false)"
"                                ->  Parallel Index Scan using vo_all_tmp_partition_es_dead_id_dealer_idx on vo_all_partition_es vo_7  (cost=0.56..621436.74 rows=264903 width=12) (actual time=0.034..737.649 rows=1074884 loops=1)"
"                                      Index Cond: (dead = false)"
"                                ->  Parallel Index Scan using vo_all_tmp_partition_gb_dead_id_dealer_idx on vo_all_partition_gb vo_9  (cost=0.56..489376.37 rows=216040 width=15) (actual time=0.049..558.926 rows=891632 loops=1)"
"                                      Index Cond: (dead = false)"
"                                ->  Parallel Index Scan using vo_all_tmp_partition_nl_dead_id_dealer_idx on vo_all_partition_nl vo_15  (cost=0.56..297367.39 rows=126444 width=15) (actual time=0.060..328.587 rows=507129 loops=1)"
"                                      Index Cond: (dead = false)"
"                                ->  Parallel Index Scan using vo_all_tmp_partition_pl_dead_id_dealer_idx on vo_all_partition_pl vo_17  (cost=0.56..302589.47 rows=132830 width=14) (actual time=0.074..297.198 rows=513517 loops=1)"
"                                      Index Cond: (dead = false)"
"                                ->  Parallel Index Scan using vo_all_tmp_partition_be_dead_id_dealer_idx on vo_all_partition_be vo_1  (cost=0.43..93227.97 rows=52013 width=13) (actual time=0.040..93.997 rows=155942 loops=1)"
"                                      Index Cond: (dead = false)"
"                                ->  Parallel Index Scan using vo_all_tmp_partition_at_dead_id_dealer_idx on vo_all_partition_at vo  (cost=0.43..125766.39 rows=68464 width=13) (actual time=0.033..143.690 rows=208829 loops=1)"
"                                      Index Cond: (dead = false)"
"                                ->  Parallel Index Scan using vo_all_tmp_partition_ro_dead_id_dealer_idx on vo_all_partition_ro vo_19  (cost=0.43..121578.35 rows=68725 width=35) (actual time=0.059..121.456 rows=214104 loops=1)"
"                                      Index Cond: (dead = false)"
"                                ->  Parallel Index Scan using vo_all_tmp_partition_pt_dead_id_dealer_idx on vo_all_partition_pt vo_18  (cost=0.43..92739.40 rows=51517 width=13) (actual time=0.053..72.814 rows=160562 loops=1)"
"                                      Index Cond: (dead = false)"
"                                ->  Parallel Index Scan using vo_all_tmp_partition_se_dead_id_dealer_idx on vo_all_partition_se vo_20  (cost=0.43..89343.29 rows=50811 width=15) (actual time=0.030..34.535 rows=53071 loops=3)"
"                                      Index Cond: (dead = false)"
"                                ->  Parallel Index Scan using vo_all_tmp_partition_ma_dead_id_dealer_idx on vo_all_partition_ma vo_14  (cost=0.43..79695.83 rows=46865 width=35) (actual time=0.036..36.385 rows=74787 loops=2)"
"                                      Index Cond: (dead = false)"
"                                ->  Parallel Index Scan using vo_all_tmp_partition_dk_dead_id_dealer_idx on vo_all_partition_dk vo_6  (cost=0.42..55721.41 rows=40966 width=16) (actual time=0.057..56.127 rows=98627 loops=1)"
"                                      Index Cond: (dead = false)"
"                                ->  Parallel Index Scan using vo_all_tmp_partition_no_dead_id_dealer_idx on vo_all_partition_no vo_16  (cost=0.42..36136.34 rows=26906 width=16) (actual time=0.051..37.710 rows=64363 loops=1)"
"                                      Index Cond: (dead = false)"
"                                ->  Parallel Index Scan using vo_all_tmp_partition_si_dead_id_dealer_idx on vo_all_partition_si vo_21  (cost=0.42..18484.16 rows=19158 width=16) (actual time=0.024..7.608 rows=16454 loops=2)"
"                                      Index Cond: (dead = false)"
"                                ->  Parallel Index Scan using vo_all_tmp_partition_lu_dead_id_dealer_idx on vo_all_partition_lu vo_13  (cost=0.41..3712.77 rows=3801 width=16) (actual time=0.028..2.981 rows=6546 loops=1)"
"                                      Index Cond: (dead = false)"
"                                ->  Parallel Seq Scan on vo_all_partition_ch vo_3  (cost=0.00..95088.40 rows=48538 width=13) (actual time=325.709..436.607 rows=238817 loops=1)"
"                                      Filter: (NOT dead)"
"                                      Rows Removed by Filter: 942465"
"                                ->  Parallel Seq Scan on vo_all_partition_ie vo_11  (cost=0.00..89739.86 rows=43099 width=15) (actual time=343.155..445.232 rows=219894 loops=1)"
"                                      Filter: (NOT dead)"
"                                      Rows Removed by Filter: 1061465"
"                                ->  Parallel Seq Scan on vo_all_partition_bg vo_2  (cost=0.00..55967.38 rows=49855 width=35) (actual time=5102.417..5187.396 rows=200375 loops=1)"
"                                      Filter: (NOT dead)"
"                                      Rows Removed by Filter: 497491"
"                          ->  Hash  (cost=6823.80..6823.80 rows=12719 width=12) (actual time=41.350..41.351 rows=5433 loops=6)"
"                                Buckets: 16384  Batches: 1  Memory Usage: 362kB"
"                                ->  Nested Loop Left Join  (cost=0.00..6823.80 rows=12719 width=12) (actual time=0.068..40.397 rows=5433 loops=6)"
"                                      Join Filter: ((n.id_network)::text = ANY ((d.ids_network)::text[]))"
"                                      Rows Removed by Join Filter: 255010"
"                                      ->  Seq Scan on dealer d  (cost=0.00..318.20 rows=5420 width=41) (actual time=0.036..3.699 rows=5420 loops=6)"
"                                      ->  Materialize  (cost=0.00..1.72 rows=48 width=4) (actual time=0.000..0.002 rows=48 loops=32520)"
"                                            ->  Seq Scan on network n  (cost=0.00..1.48 rows=48 width=4) (actual time=0.023..0.027 rows=48 loops=6)"
"Planning Time: 2.405 ms"
"JIT:"
"  Functions: 633"
"  Options: Inlining true, Optimization true, Expressions true, Deforming true"
"  Timing: Generation 216.628 ms, Inlining 326.652 ms, Optimization 17865.536 ms, Emission 10634.604 ms, Total 29043.421 ms"
"Execution Time: 6649.581 ms"

Per node type stats

node type	count	sum of times	% of query
Bitmap Index Scan	2	4.285 ms	0.1 %
Finalize GroupAggregate	1	0.000 ms	0.0 %
Gather Merge	1	213.122 ms	3.3 %
Hash	1	0.954 ms	0.0 %
Hash Left Join	1	135.266 ms	2.1 %
Materialize	1	10.813 ms	0.2 %
Nested Loop Left Join	1	25.858 ms	0.4 %
Parallel Append	1	72.624 ms	1.1 %
Parallel Bitmap Heap Scan	2	1,591.917 ms	24.6 %
Parallel Index Scan	17	3,354.913 ms	51.8 %
Parallel Seq Scan	3	1,011.539 ms	15.6 %
Partial HashAggregate	1	200.030 ms	3.1 %
Seq Scan	2	3.726 ms	0.1 %
Sort	1	0.045 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
dealer	1	3.699 ms	0.1 %
Seq Scan	1	3.699 ms	100.0 %
network	1	0.027 ms	0.0 %
Seq Scan	1	0.027 ms	100.0 %
vo_all_partition_at	1	23.948 ms	0.4 %
Parallel Index Scan	1	23.948 ms	100.0 %
vo_all_partition_be	1	15.666 ms	0.2 %
Parallel Index Scan	1	15.666 ms	100.0 %
vo_all_partition_bg	1	864.566 ms	13.4 %
Parallel Seq Scan	1	864.566 ms	100.0 %
vo_all_partition_ch	1	72.768 ms	1.1 %
Parallel Seq Scan	1	72.768 ms	100.0 %
vo_all_partition_cz	1	803.200 ms	12.4 %
Parallel Bitmap Heap Scan	1	803.200 ms	100.0 %
vo_all_partition_de	1	1,083.226 ms	16.7 %
Parallel Index Scan	1	1,083.226 ms	100.0 %
vo_all_partition_dk	1	9.354 ms	0.1 %
Parallel Index Scan	1	9.354 ms	100.0 %
vo_all_partition_es	1	122.942 ms	1.9 %
Parallel Index Scan	1	122.942 ms	100.0 %
vo_all_partition_fr	1	943.811 ms	14.6 %
Parallel Index Scan	1	943.811 ms	100.0 %
vo_all_partition_gb	1	93.154 ms	1.4 %
Parallel Index Scan	1	93.154 ms	100.0 %
vo_all_partition_hr	1	788.717 ms	12.2 %
Parallel Bitmap Heap Scan	1	788.717 ms	100.0 %
vo_all_partition_ie	1	74.205 ms	1.1 %
Parallel Seq Scan	1	74.205 ms	100.0 %
vo_all_partition_it	1	887.421 ms	13.7 %
Parallel Index Scan	1	887.421 ms	100.0 %
vo_all_partition_lu	1	0.497 ms	0.0 %
Parallel Index Scan	1	0.497 ms	100.0 %
vo_all_partition_ma	1	12.128 ms	0.2 %
Parallel Index Scan	1	12.128 ms	100.0 %
vo_all_partition_nl	1	54.764 ms	0.8 %
Parallel Index Scan	1	54.764 ms	100.0 %
vo_all_partition_no	1	6.285 ms	0.1 %
Parallel Index Scan	1	6.285 ms	100.0 %
vo_all_partition_pl	1	49.533 ms	0.8 %
Parallel Index Scan	1	49.533 ms	100.0 %
vo_all_partition_pt	1	12.136 ms	0.2 %
Parallel Index Scan	1	12.136 ms	100.0 %
vo_all_partition_ro	1	20.243 ms	0.3 %
Parallel Index Scan	1	20.243 ms	100.0 %
vo_all_partition_se	1	17.267 ms	0.3 %
Parallel Index Scan	1	17.267 ms	100.0 %
vo_all_partition_si	1	2.536 ms	0.0 %
Parallel Index Scan	1	2.536 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sMWV

Color mode:

Visible columns:

Per node type stats

Per table stats