explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JLE9

Settings
# exclusive inclusive rows x rows loops node
1. 6,422.377 8,050.305 ↓ 77.8 2,023 1

Gather (cost=1,003.60..6,982.33 rows=26 width=263) (actual time=23.924..8,050.305 rows=2,023 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 1,026.473 1,627.928 ↓ 67.5 1,012 2

Nested Loop Left Join (cost=3.60..5,979.73 rows=15 width=263) (actual time=5.214..1,627.928 rows=1,012 loops=2)

3. 102.286 600.481 ↓ 67.5 1,012 2

Nested Loop Left Join (cost=3.48..5,787.98 rows=15 width=263) (actual time=5.101..600.481 rows=1,012 loops=2)

4. 13.352 498.148 ↓ 67.5 1,012 2

Hash Join (cost=3.19..5,782.85 rows=15 width=255) (actual time=5.074..498.148 rows=1,012 loops=2)

  • Hash Cond: (government_list_body.government_list_bodytype_id = government_list_bodytype.government_list_bodytype_id)
5. 66.917 484.663 ↓ 2.2 1,012 2

Nested Loop (cost=1.81..5,775.74 rows=464 width=263) (actual time=0.195..484.663 rows=1,012 loops=2)

6. 77.886 417.700 ↓ 2.2 1,012 2

Nested Loop (cost=1.38..4,064.60 rows=464 width=90) (actual time=0.148..417.700 rows=1,012 loops=2)

7. 85.106 339.788 ↓ 1.3 1,821 2

Hash Join (cost=1.10..3,329.16 rows=1,448 width=90) (actual time=0.083..339.788 rows=1,821 loops=2)

  • Hash Cond: (az.zags_list_azkind_id = zags_list_azkind.zags_list_azkind_id)
8. 254.640 254.640 ↑ 1.2 8,672 2

Parallel Seq Scan on zags_az az (cost=0.00..3,212.92 rows=10,138 width=98) (actual time=0.029..254.640 rows=8,672 loops=2)

  • Filter: ((close_date IS NULL) AND ((removed IS NULL) OR ((removed)::text = 'N'::text)) AND ((az_source)::text <> 'OTHER_COUNTRY'::text))
  • Rows Removed by Filter: 5066
9. 0.014 0.042 ↑ 1.0 1 1

Hash (cost=1.09..1.09 rows=1 width=8) (actual time=0.041..0.042 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
10. 0.028 0.028 ↑ 1.0 1 1

Seq Scan on zags_list_azkind (cost=0.00..1.09 rows=1 width=8) (actual time=0.023..0.028 rows=1 loops=1)

  • Filter: ((code)::text = 'DEATH'::text)
  • Rows Removed by Filter: 6
11. 0.026 0.026 ↑ 1.0 1 3,642

Index Scan using zags_az_ecp_pkey on zags_az_ecp (cost=0.29..0.51 rows=1 width=8) (actual time=0.026..0.026 rows=1 loops=3,642)

  • Index Cond: (zags_az_ecp_id = az.zags_az_id)
  • Filter: signed
  • Rows Removed by Filter: 0
12. 0.046 0.046 ↑ 1.0 1 2,023

Index Scan using government_list_body_pkey on government_list_body (cost=0.42..3.69 rows=1 width=181) (actual time=0.046..0.046 rows=1 loops=2,023)

  • Index Cond: (government_list_body_id = az.az_first_gov_list_body_id)
  • Filter: (removed IS NULL)
13. 0.020 0.133 ↑ 1.0 1 2

Hash (cost=1.38..1.38 rows=1 width=8) (actual time=0.132..0.133 rows=1 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
14. 0.113 0.113 ↑ 1.0 1 2

Seq Scan on government_list_bodytype (cost=0.00..1.38 rows=1 width=8) (actual time=0.104..0.113 rows=1 loops=2)

  • Filter: ((code)::text = 'ЗАГС'::text)
  • Rows Removed by Filter: 29
15. 0.047 0.047 ↑ 1.0 1 2,023

Index Scan using ix_zags_az_death_4 on zags_az_death (cost=0.28..0.33 rows=1 width=16) (actual time=0.031..0.047 rows=1 loops=2,023)

  • Index Cond: (zags_az_id = az.zags_az_id)
16. 0.261 0.974 ↑ 39.0 1 2,023

Append (cost=0.12..12.39 rows=39 width=8) (actual time=0.531..0.974 rows=1 loops=2,023)

17. 0.019 0.019 ↓ 0.0 0 2,023

Index Only Scan using natur_person_pkey on natur_person death_natur_person (cost=0.12..0.14 rows=1 width=8) (actual time=0.019..0.019 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 0
18. 0.017 0.017 ↓ 0.0 0 2,023

Index Only Scan using natur_person_a_pkey on natur_person_a death_natur_person_1 (cost=0.28..0.31 rows=1 width=8) (actual time=0.017..0.017 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 22
19. 0.007 0.007 ↓ 0.0 0 2,023

Index Only Scan using natur_person_ani_pkey on natur_person_ani death_natur_person_2 (cost=0.28..0.30 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 23
20. 0.031 0.031 ↓ 0.0 0 2,023

Index Only Scan using natur_person_b_pkey on natur_person_b death_natur_person_3 (cost=0.28..0.32 rows=1 width=8) (actual time=0.031..0.031 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 62
21. 0.025 0.025 ↓ 0.0 0 2,023

Index Only Scan using natur_person_before_a_pkey on natur_person_before_a death_natur_person_4 (cost=0.42..1.54 rows=1 width=8) (actual time=0.025..0.025 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 1
22. 0.021 0.021 ↓ 0.0 0 2,023

Index Only Scan using natur_person_bj_pkey on natur_person_bj death_natur_person_5 (cost=0.28..0.32 rows=1 width=8) (actual time=0.021..0.021 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 38
23. 0.027 0.027 ↓ 0.0 0 2,023

Index Only Scan using natur_person_ch_pkey on natur_person_ch death_natur_person_6 (cost=0.28..0.30 rows=1 width=8) (actual time=0.027..0.027 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 36
24. 0.017 0.017 ↓ 0.0 0 2,023

Index Only Scan using natur_person_d_pkey on natur_person_d death_natur_person_7 (cost=0.28..0.31 rows=1 width=8) (actual time=0.017..0.017 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 52
25. 0.013 0.013 ↓ 0.0 0 2,023

Index Only Scan using natur_person_e_pkey on natur_person_e death_natur_person_8 (cost=0.28..0.31 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 44
26. 0.007 0.007 ↓ 0.0 0 2,023

Index Only Scan using natur_person_f_pkey on natur_person_f death_natur_person_9 (cost=0.28..0.35 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 39
27. 0.024 0.024 ↓ 0.0 0 2,023

Index Only Scan using natur_person_ga_pkey on natur_person_ga death_natur_person_10 (cost=0.27..0.30 rows=1 width=8) (actual time=0.024..0.024 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 8
28. 0.019 0.019 ↓ 0.0 0 2,023

Index Only Scan using natur_person_gak_pkey on natur_person_gak death_natur_person_11 (cost=0.14..0.16 rows=1 width=8) (actual time=0.019..0.019 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 16
29. 0.015 0.015 ↓ 0.0 0 2,023

Index Only Scan using natur_person_gam_pkey on natur_person_gam death_natur_person_12 (cost=0.15..0.17 rows=1 width=8) (actual time=0.015..0.015 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 13
30. 0.032 0.032 ↓ 0.0 0 2,023

Index Only Scan using natur_person_gb_pkey on natur_person_gb death_natur_person_13 (cost=0.28..0.31 rows=1 width=8) (actual time=0.032..0.032 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 67
31. 0.015 0.015 ↓ 0.0 0 2,023

Index Only Scan using natur_person_h_pkey on natur_person_h death_natur_person_14 (cost=0.14..0.16 rows=1 width=8) (actual time=0.015..0.015 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 17
32. 0.021 0.021 ↓ 0.0 0 2,023

Index Only Scan using natur_person_han_pkey on natur_person_han death_natur_person_15 (cost=0.28..0.30 rows=1 width=8) (actual time=0.021..0.021 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 39
33. 0.016 0.016 ↓ 0.0 0 2,023

Index Only Scan using natur_person_i_pkey on natur_person_i death_natur_person_16 (cost=0.28..0.36 rows=1 width=8) (actual time=0.016..0.016 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 36
34. 0.018 0.018 ↓ 0.0 0 2,023

Index Only Scan using natur_person_ka_pkey on natur_person_ka death_natur_person_17 (cost=0.28..0.30 rows=1 width=8) (actual time=0.018..0.018 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 44
35. 0.011 0.011 ↓ 0.0 0 2,023

Index Only Scan using natur_person_kb_pkey on natur_person_kb death_natur_person_18 (cost=0.28..0.32 rows=1 width=8) (actual time=0.010..0.011 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 93
36. 0.012 0.012 ↓ 0.0 0 2,023

Index Only Scan using natur_person_kot_pkey on natur_person_kot death_natur_person_19 (cost=0.28..0.31 rows=1 width=8) (actual time=0.012..0.012 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 40
37. 0.018 0.018 ↓ 0.0 0 2,023

Index Only Scan using natur_person_ll_pkey on natur_person_ll death_natur_person_20 (cost=0.28..0.31 rows=1 width=8) (actual time=0.018..0.018 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 75
38. 0.022 0.022 ↓ 0.0 0 2,023

Index Only Scan using natur_person_ma_pkey on natur_person_ma death_natur_person_21 (cost=0.28..0.31 rows=1 width=8) (actual time=0.022..0.022 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 43
39. 0.020 0.020 ↓ 0.0 0 2,023

Index Only Scan using natur_person_mb_pkey on natur_person_mb death_natur_person_22 (cost=0.28..0.30 rows=1 width=8) (actual time=0.020..0.020 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 27
40. 0.016 0.016 ↓ 0.0 0 2,023

Index Only Scan using natur_person_mk_pkey on natur_person_mk death_natur_person_23 (cost=0.28..0.31 rows=1 width=8) (actual time=0.016..0.016 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 29
41. 0.021 0.021 ↓ 0.0 0 2,023

Index Only Scan using natur_person_n_pkey on natur_person_n death_natur_person_24 (cost=0.28..0.30 rows=1 width=8) (actual time=0.016..0.021 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 46
42. 0.012 0.012 ↓ 0.0 0 2,023

Index Only Scan using natur_person_o_pkey on natur_person_o death_natur_person_25 (cost=0.28..0.34 rows=1 width=8) (actual time=0.012..0.012 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 59
43. 0.022 0.022 ↓ 0.0 0 2,023

Index Only Scan using natur_person_pj_pkey on natur_person_pj death_natur_person_26 (cost=0.28..0.32 rows=1 width=8) (actual time=0.022..0.022 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 78
44. 0.008 0.008 ↓ 0.0 0 2,023

Index Only Scan using natur_person_r_pkey on natur_person_r death_natur_person_27 (cost=0.28..0.31 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 35
45. 0.019 0.019 ↓ 0.0 0 2,023

Index Only Scan using natur_person_sa_pkey on natur_person_sa death_natur_person_28 (cost=0.14..0.17 rows=1 width=8) (actual time=0.019..0.019 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 23
46. 0.012 0.012 ↓ 0.0 0 2,023

Index Only Scan using natur_person_sal_pkey on natur_person_sal death_natur_person_29 (cost=0.15..0.17 rows=1 width=8) (actual time=0.012..0.012 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 27
47. 0.040 0.040 ↓ 0.0 0 2,023

Index Only Scan using natur_person_sb_pkey on natur_person_sb death_natur_person_30 (cost=0.28..0.31 rows=1 width=8) (actual time=0.040..0.040 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 25
48. 0.012 0.012 ↓ 0.0 0 2,023

Index Only Scan using natur_person_sche_pkey on natur_person_sche death_natur_person_31 (cost=0.28..0.30 rows=1 width=8) (actual time=0.012..0.012 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 16
49. 0.012 0.012 ↓ 0.0 0 2,023

Index Only Scan using natur_person_sh_pkey on natur_person_sh death_natur_person_32 (cost=0.14..0.16 rows=1 width=8) (actual time=0.012..0.012 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 8
50. 0.013 0.013 ↓ 0.0 0 2,023

Index Only Scan using natur_person_shao_pkey on natur_person_shao death_natur_person_33 (cost=0.28..0.33 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 56
51. 0.018 0.018 ↓ 0.0 0 2,023

Index Only Scan using natur_person_sp_pkey on natur_person_sp death_natur_person_34 (cost=0.28..0.30 rows=1 width=8) (actual time=0.018..0.018 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 9
52. 0.020 0.020 ↓ 0.0 0 2,023

Index Only Scan using natur_person_t_pkey on natur_person_t death_natur_person_35 (cost=0.28..0.35 rows=1 width=8) (actual time=0.020..0.020 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 40
53. 0.018 0.018 ↓ 0.0 0 2,023

Index Only Scan using natur_person_v_pkey on natur_person_v death_natur_person_36 (cost=0.28..0.31 rows=1 width=8) (actual time=0.018..0.018 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 19
54. 0.013 0.013 ↓ 0.0 0 2,023

Index Only Scan using natur_person_ya_pkey on natur_person_ya death_natur_person_37 (cost=0.27..0.30 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 22
55. 0.030 0.030 ↓ 0.0 0 2,023

Index Only Scan using natur_person_z_pkey on natur_person_z death_natur_person_38 (cost=0.28..0.30 rows=1 width=8) (actual time=0.030..0.030 rows=0 loops=2,023)

  • Index Cond: (natur_person_id = zags_az_death.death_natur_person_id)
  • Heap Fetches: 38
Planning time : 179.942 ms
Execution time : 8,084.580 ms