# | 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)
|
2. | 0.000 | 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)
|
3. | 0.270 | 38,471.814 | ↑ 4.4 | 5 | 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)
|
4. | 1,200.180 | 38,471.544 | ↑ 4.4 | 5 | 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)
|
5. | 811.596 | 37,271.364 | ↑ 2.8 | 1,531,448 | 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)
|
6. | 435.743 | 36,211.662 | ↑ 1.2 | 1,531,004 | 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. | 4,819.197 | 4,835.626 | ↓ 4.0 | 152,450 | 1 |
→
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)
|
8. | 16.429 | 16.429 | ↑ 1.0 | 152,450 | 1 |
→
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)
|
9. | 4,732.303 | 4,741.582 | ↓ 4.0 | 78,420 | 1 |
→
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)
|
10. | 9.279 | 9.279 | ↑ 1.0 | 78,420 | 1 |
→
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)
|
11. | 6,499.356 | 6,499.356 | ↑ 1.2 | 360,432 | 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)
|
12. | 5,662.867 | 5,662.867 | ↓ 4.0 | 1,096,513 | 1 |
→
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)
|
13. | 5,324.527 | 5,324.527 | ↓ 4.1 | 799,135 | 1 |
→
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)
|
14. | 737.649 | 737.649 | ↓ 4.1 | 1,074,884 | 1 |
→
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)
|
15. | 558.926 | 558.926 | ↓ 4.1 | 891,632 | 1 |
→
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)
|
16. | 328.587 | 328.587 | ↓ 4.0 | 507,129 | 1 |
→
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)
|
17. | 297.198 | 297.198 | ↓ 3.9 | 513,517 | 1 |
→
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)
|
18. | 93.997 | 93.997 | ↓ 3.0 | 155,942 | 1 |
→
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)
|
19. | 143.690 | 143.690 | ↓ 3.1 | 208,829 | 1 |
→
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)
|
20. | 121.456 | 121.456 | ↓ 3.1 | 214,104 | 1 |
→
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)
|
21. | 72.814 | 72.814 | ↓ 3.1 | 160,562 | 1 |
→
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)
|
22. | 103.605 | 103.605 | ↓ 1.0 | 53,071 | 3 |
→
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)
|
23. | 72.770 | 72.770 | ↓ 1.6 | 74,787 | 2 |
→
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)
|
24. | 56.127 | 56.127 | ↓ 2.4 | 98,627 | 1 |
→
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)
|
25. | 37.710 | 37.710 | ↓ 2.4 | 64,363 | 1 |
→
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)
|
26. | 15.216 | 15.216 | ↑ 1.2 | 16,454 | 2 |
→
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)
|
27. | 2.981 | 2.981 | ↓ 1.7 | 6,546 | 1 |
→
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)
|
28. | 436.607 | 436.607 | ↓ 4.9 | 238,817 | 1 |
→
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)
|
29. | 445.232 | 445.232 | ↓ 5.1 | 219,894 | 1 |
→
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)
|
30. | 5,187.396 | 5,187.396 | ↓ 4.0 | 200,375 | 1 |
→
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)
|
31. | 5.724 | 248.106 | ↑ 2.3 | 5,433 | 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)
|
32. | 155.148 | 242.382 | ↑ 2.3 | 5,433 | 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)
|
33. | 22.194 | 22.194 | ↑ 1.0 | 5,420 | 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. | 64.878 | 65.040 | ↑ 1.0 | 48 | 32,520 |
→
Materialize (cost=0.00..1.72 rows=48 width=4) (actual time=0.000..0.002 rows=48 loops=32,520) |
35. | 0.162 | 0.162 | ↑ 1.0 | 48 | 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) |
Planning time | : | 2.405 ms |
---|