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. 42.246 1,627.928 ↓ 67.5 1,012 2 / 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. 54.792 600.481 ↓ 67.5 1,012 2 / 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 / 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. 20.434 484.663 ↓ 2.2 1,012 2 / 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. 30.566 417.700 ↓ 2.2 1,012 2 / 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.127 339.788 ↓ 1.3 1,821 2 / 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 / 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.007 0.021 ↑ 1.0 1 1 / 2

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.014 0.014 ↑ 1.0 1 1 / 2

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. 47.346 47.346 ↑ 1.0 1 3,642 / 2

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. 46.529 46.529 ↑ 1.0 1 2,023 / 2

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 / 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 / 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. 47.541 47.541 ↑ 1.0 1 2,023 / 2

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. 264.002 985.201 ↑ 39.0 1 2,023 / 2

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

17. 19.218 19.218 ↓ 0.0 0 2,023 / 2

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. 17.196 17.196 ↓ 0.0 0 2,023 / 2

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. 7.080 7.080 ↓ 0.0 0 2,023 / 2

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. 31.357 31.357 ↓ 0.0 0 2,023 / 2

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. 25.288 25.288 ↓ 0.0 0 2,023 / 2

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. 21.242 21.242 ↓ 0.0 0 2,023 / 2

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. 27.311 27.311 ↓ 0.0 0 2,023 / 2

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. 17.196 17.196 ↓ 0.0 0 2,023 / 2

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. 13.149 13.149 ↓ 0.0 0 2,023 / 2

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. 7.080 7.080 ↓ 0.0 0 2,023 / 2

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. 24.276 24.276 ↓ 0.0 0 2,023 / 2

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. 19.218 19.218 ↓ 0.0 0 2,023 / 2

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. 15.172 15.172 ↓ 0.0 0 2,023 / 2

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. 32.368 32.368 ↓ 0.0 0 2,023 / 2

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. 15.172 15.172 ↓ 0.0 0 2,023 / 2

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. 21.242 21.242 ↓ 0.0 0 2,023 / 2

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. 16.184 16.184 ↓ 0.0 0 2,023 / 2

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. 18.207 18.207 ↓ 0.0 0 2,023 / 2

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. 11.127 11.127 ↓ 0.0 0 2,023 / 2

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. 12.138 12.138 ↓ 0.0 0 2,023 / 2

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. 18.207 18.207 ↓ 0.0 0 2,023 / 2

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. 22.253 22.253 ↓ 0.0 0 2,023 / 2

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. 20.230 20.230 ↓ 0.0 0 2,023 / 2

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. 16.184 16.184 ↓ 0.0 0 2,023 / 2

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. 21.242 21.242 ↓ 0.0 0 2,023 / 2

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. 12.138 12.138 ↓ 0.0 0 2,023 / 2

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. 22.253 22.253 ↓ 0.0 0 2,023 / 2

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. 8.092 8.092 ↓ 0.0 0 2,023 / 2

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. 19.218 19.218 ↓ 0.0 0 2,023 / 2

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. 12.138 12.138 ↓ 0.0 0 2,023 / 2

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. 40.460 40.460 ↓ 0.0 0 2,023 / 2

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. 12.138 12.138 ↓ 0.0 0 2,023 / 2

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. 12.138 12.138 ↓ 0.0 0 2,023 / 2

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. 13.149 13.149 ↓ 0.0 0 2,023 / 2

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. 18.207 18.207 ↓ 0.0 0 2,023 / 2

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. 20.230 20.230 ↓ 0.0 0 2,023 / 2

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. 18.207 18.207 ↓ 0.0 0 2,023 / 2

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. 13.149 13.149 ↓ 0.0 0 2,023 / 2

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. 30.345 30.345 ↓ 0.0 0 2,023 / 2

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