explain.depesz.com

PostgreSQL's explain analyze made readable

Result: INEF

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 6,771.598 ↑ 1.0 22 1

Finalize GroupAggregate (cost=5,184,850.48..5,184,864.56 rows=22 width=14) (actual time=6,771.580..6,771.598 rows=22 loops=1)

  • Group Key: vo_4.id_pays
  • Functions: 633
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 230.580 ms, Inlining 349.175 ms, Optimization 18710.773 ms, Emission 10564.114 ms, Total 29854.641 ms"Execution Time: 7,035.903 ms
2. 287.894 6,995.525 ↑ 3.5 31 1

Gather Merge (cost=5,184,850.48..5,184,863.79 rows=110 width=11) (actual time=6,771.571..6,995.525 rows=31 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
3. 0.052 6,707.631 ↑ 4.4 5 6 / 6

Sort (cost=5,183,850.41..5,183,850.46 rows=22 width=11) (actual time=6,707.631..6,707.631 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. 201.884 6,707.579 ↑ 4.4 5 6 / 6

Partial HashAggregate (cost=5,183,849.70..5,183,849.92 rows=22 width=11) (actual time=6,707.578..6,707.579 rows=5 loops=6)

  • Group Key: vo_4.id_pays
5. 140.619 6,505.695 ↑ 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=5,021.048..6,505.695 rows=1,531,448 loops=6)

  • Hash Cond: (vo_4.id_dealer = (d.id_dealer)::text)
6. 72.004 6,321.866 ↑ 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,977.729..6,321.866 rows=1,531,004 loops=6)

7. 883.330 886.219 ↓ 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=5,177.639..5,317.316 rows=152,450 loops=1)

  • Filter: (NOT dead)
8. 2.889 2.889 ↑ 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=17.335..17.335 rows=152,450 loops=1)

  • Index Cond: (dead = false)
9. 815.573 817.493 ↓ 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,827.709..4,904.959 rows=78,420 loops=1)

  • Filter: (NOT dead)
10. 1.920 1.920 ↑ 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=11.521..11.521 rows=78,420 loops=1)

  • Index Cond: (dead = false)
11. 1,118.710 1,118.710 ↑ 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=816.379..1,118.710 rows=360,432 loops=6)

  • Index Cond: (dead = false)
12. 954.155 954.155 ↓ 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,879.071..5,724.931 rows=1,096,513 loops=1)

  • Index Cond: (dead = false)
13. 915.815 915.815 ↓ 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,906.034..5,494.890 rows=799,135 loops=1)

  • Index Cond: (dead = false)
14. 134.073 134.073 ↓ 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.065..804.437 rows=1,074,884 loops=1)

  • Index Cond: (dead = false)
15. 104.013 104.013 ↓ 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.053..624.079 rows=891,632 loops=1)

  • Index Cond: (dead = false)
16. 74.314 74.314 ↓ 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.048..445.884 rows=507,129 loops=1)

  • Index Cond: (dead = false)
17. 59.078 59.078 ↓ 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.063..354.468 rows=513,517 loops=1)

  • Index Cond: (dead = false)
18. 19.722 19.722 ↓ 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.043..118.334 rows=155,942 loops=1)

  • Index Cond: (dead = false)
19. 31.017 31.017 ↓ 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.042..186.102 rows=208,829 loops=1)

  • Index Cond: (dead = false)
20. 25.704 25.704 ↓ 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.071..154.227 rows=214,104 loops=1)

  • Index Cond: (dead = false)
21. 18.114 18.114 ↓ 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.040..108.684 rows=160,562 loops=1)

  • Index Cond: (dead = false)
22. 24.503 24.503 ↓ 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.041..49.005 rows=53,071 loops=3)

  • Index Cond: (dead = false)
23. 16.791 16.791 ↓ 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.069..50.374 rows=74,787 loops=2)

  • Index Cond: (dead = false)
24. 7.985 7.985 ↓ 1.2 49,314 2 / 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.031..23.954 rows=49,314 loops=2)

  • Index Cond: (dead = false)
25. 4.969 4.969 ↓ 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.025..29.813 rows=64,363 loops=1)

  • Index Cond: (dead = false)
26. 2.559 2.559 ↓ 1.7 32,907 1 / 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.019..15.354 rows=32,907 loops=1)

  • Index Cond: (dead = false)
27. 0.553 0.553 ↓ 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.027..3.320 rows=6,546 loops=1)

  • Index Cond: (dead = false)
28. 80.381 80.381 ↓ 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=348.176..482.284 rows=238,817 loops=1)

  • Filter: (NOT dead)
  • Rows Removed by Filter: 942,465
29. 76.325 76.325 ↓ 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=353.337..457.948 rows=219,894 loops=1)

  • Filter: (NOT dead)
  • Rows Removed by Filter: 1,061,465
30. 877.369 877.369 ↓ 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,177.824..5,264.211 rows=200,375 loops=1)

  • Filter: (NOT dead)
  • Rows Removed by Filter: 497,491
31. 1.107 43.210 ↑ 2.3 5,433 6 / 6

Hash (cost=6,823.80..6,823.80 rows=12,719 width=12) (actual time=43.210..43.210 rows=5,433 loops=6)

  • Buckets: 16,384 Batches: 1 Memory Usage: 362kB
32. 27.021 42.103 ↑ 2.3 5,433 6 / 6

Nested Loop Left Join (cost=0.00..6,823.80 rows=12,719 width=12) (actual time=0.070..42.103 rows=5,433 loops=6)

  • Join Filter: ((n.id_network)::text = ANY ((d.ids_network)::text[]))
  • Rows Removed by Join Filter: 255,010
33. 4.242 4.242 ↑ 1.0 5,420 6 / 6

Seq Scan on dealer d (cost=0.00..318.20 rows=5,420 width=41) (actual time=0.037..4.242 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.024..0.027 rows=48 loops=6)