explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b8Zf

Settings
# exclusive inclusive rows x rows loops node
1. 0.055 1.753 ↑ 14.7 3 1

Sort (cost=1,019.03..1,019.14 rows=44 width=366) (actual time=1.753..1.753 rows=3 loops=1)

  • Sort Key: bov.danais, bov.copaip, bov.nunati
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=196
2. 0.023 1.698 ↑ 14.7 3 1

HashAggregate (cost=1,017.39..1,017.83 rows=44 width=366) (actual time=1.697..1.698 rows=3 loops=1)

  • Group Key: bov.copaip, bov.nunati, bov.nobovi, bov.sexbov, ip.copach, ip.cheipg, bov.indite, (CASE WHEN ((bo.cofgmu IS NOT NULL) AND (bo.cofgmu = '2'::bpchar)) THEN 'O'::text ELSE 'N'::text END), bov.danais, bov.ponais, bov.toupoi, bof_dern.dafige, bof_avant_dern.dafige, bof_mere.ravela, bov.conais, (CASE WHEN (bovige_anim.nunati IS NOT NULL) THEN bovige_anim.copape ELSE bov.copapi END), (CASE WHEN (bovige_anim.nunati IS NOT NULL) THEN bovige_anim.nupere ELSE bov.nupeip END), (CASE WHEN (bovige_anim.nunati IS NOT NULL) THEN bov_pere1.nobovi ELSE bov_pere2.nobovi END), boa.nocomp, bop120.poagty, bop210.poagty
  • Buffers: shared hit=190
3. 0.002 1.675 ↑ 14.7 3 1

Append (cost=12.05..1,015.08 rows=44 width=366) (actual time=0.866..1.675 rows=3 loops=1)

  • Buffers: shared hit=190
4. 0.010 1.509 ↑ 13.3 3 1

Nested Loop Left Join (cost=12.05..904.87 rows=40 width=213) (actual time=0.865..1.509 rows=3 loops=1)

  • Buffers: shared hit=168
5. 0.004 1.487 ↑ 13.3 3 1

Nested Loop Left Join (cost=11.48..792.67 rows=40 width=160) (actual time=0.847..1.487 rows=3 loops=1)

  • Buffers: shared hit=168
6. 0.006 1.429 ↑ 13.3 3 1

Nested Loop Left Join (cost=10.92..534.49 rows=40 width=140) (actual time=0.821..1.429 rows=3 loops=1)

  • Buffers: shared hit=154
7. 0.007 1.390 ↑ 13.3 3 1

Nested Loop Left Join (cost=10.35..422.39 rows=40 width=158) (actual time=0.799..1.390 rows=3 loops=1)

  • Buffers: shared hit=144
8. 0.005 1.245 ↑ 3.3 3 1

Nested Loop Left Join (cost=9.78..357.44 rows=10 width=136) (actual time=0.737..1.245 rows=3 loops=1)

  • Buffers: shared hit=130
9. 0.006 1.186 ↑ 3.3 3 1

Nested Loop Left Join (cost=9.21..329.34 rows=10 width=150) (actual time=0.710..1.186 rows=3 loops=1)

  • Buffers: shared hit=115
10. 0.008 1.117 ↑ 3.3 3 1

Nested Loop Left Join (cost=8.65..301.32 rows=10 width=139) (actual time=0.673..1.117 rows=3 loops=1)

  • Buffers: shared hit=100
11. 0.010 0.956 ↑ 3.3 3 1

Nested Loop Left Join (cost=8.08..278.05 rows=10 width=130) (actual time=0.606..0.956 rows=3 loops=1)

  • Buffers: shared hit=85
12. 0.007 0.748 ↑ 3.3 3 1

Nested Loop Left Join (cost=7.51..250.15 rows=10 width=144) (actual time=0.445..0.748 rows=3 loops=1)

  • Buffers: shared hit=70
13. 0.004 0.615 ↑ 3.3 3 1

Nested Loop Left Join (cost=6.95..222.15 rows=10 width=97) (actual time=0.380..0.615 rows=3 loops=1)

  • Buffers: shared hit=55
14. 0.004 0.605 ↑ 3.3 3 1

Nested Loop Left Join (cost=6.52..195.50 rows=10 width=119) (actual time=0.373..0.605 rows=3 loops=1)

  • Buffers: shared hit=55
15. 0.005 0.511 ↑ 3.3 3 1

Nested Loop Left Join (cost=6.09..168.55 rows=10 width=95) (actual time=0.313..0.511 rows=3 loops=1)

  • Buffers: shared hit=46
16. 0.005 0.500 ↑ 3.3 3 1

Nested Loop Left Join (cost=5.52..140.50 rows=10 width=101) (actual time=0.306..0.500 rows=3 loops=1)

  • Buffers: shared hit=46
17. 0.003 0.276 ↑ 3.3 3 1

Nested Loop Left Join (cost=1.69..101.62 rows=10 width=79) (actual time=0.181..0.276 rows=3 loops=1)

  • Buffers: shared hit=31
18. 0.012 0.231 ↑ 3.3 3 1

Nested Loop Left Join (cost=1.13..58.46 rows=10 width=77) (actual time=0.161..0.231 rows=3 loops=1)

  • Buffers: shared hit=19
19. 0.117 0.117 ↑ 3.3 3 1

Index Scan using bovide_fk3 on bovide bov (cost=0.57..15.30 rows=10 width=75) (actual time=0.101..0.117 rows=3 loops=1)

  • Index Cond: ((numeip = '5694030194 '::bpchar) AND (copami = 'FR'::bpchar))
  • Filter: (((indite IS NULL) OR (indite <> 'O'::bpchar)) AND (cosu = '0'::bpchar))
  • Buffers: shared hit=7
20. 0.102 0.102 ↓ 0.0 0 3

Index Scan using bopoat_pk on bopoat bop120 (cost=0.56..4.28 rows=4 width=20) (actual time=0.034..0.034 rows=0 loops=3)

  • Index Cond: ((copaip = bov.copaip) AND (nunati = bov.nunati) AND (copoat = '04'::bpchar))
  • Filter: ((cosu = '0'::bpchar) AND (cosu = bov.cosu))
  • Buffers: shared hit=12
21. 0.042 0.042 ↓ 0.0 0 3

Index Scan using bopoat_pk on bopoat bop210 (cost=0.56..4.28 rows=4 width=20) (actual time=0.014..0.014 rows=0 loops=3)

  • Index Cond: ((copaip = bov.copaip) AND (nunati = bov.nunati) AND (copoat = '07'::bpchar))
  • Filter: ((cosu = '0'::bpchar) AND (cosu = bov.cosu))
  • Buffers: shared hit=12
22. 0.006 0.219 ↓ 0.0 0 3

GroupAggregate (cost=3.83..3.87 rows=1 width=26) (actual time=0.073..0.073 rows=0 loops=3)

  • Group Key: sipder.copaip, sipder.nunati, sipder.cosu, sipder.dasort
  • Filter: (max(sipder.daench) < CURRENT_DATE)
  • Buffers: shared hit=15
23. 0.021 0.213 ↓ 0.0 0 3

Sort (cost=3.83..3.84 rows=1 width=26) (actual time=0.071..0.071 rows=0 loops=3)

  • Sort Key: sipder.dasort
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=15
24. 0.192 0.192 ↓ 0.0 0 3

Index Scan using ipgmou_pkey on ipgmou sipder (cost=0.57..3.82 rows=1 width=26) (actual time=0.064..0.064 rows=0 loops=3)

  • Index Cond: ((copaip = bov.copaip) AND (nunati = bov.nunati))
  • Filter: ((bov.cosu = cosu) AND ((dasort IS NULL) OR (dasort > CURRENT_DATE)))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=15
25. 0.006 0.006 ↓ 0.0 0 3

Index Scan using ipgmou_pkey on ipgmou ip (cost=0.57..2.80 rows=1 width=38) (actual time=0.002..0.002 rows=0 loops=3)

  • Index Cond: ((copaip = sipder.copaip) AND (nunati = sipder.nunati) AND (daench = (max(sipder.daench))))
  • Filter: (cosu = sipder.cosu)
26. 0.003 0.090 ↓ 0.0 0 3

GroupAggregate (cost=0.43..2.68 rows=1 width=24) (actual time=0.030..0.030 rows=0 loops=3)

  • Group Key: sboap.copaip, sboap.nunati, sboap.tyapco, sboap.cosu
  • Buffers: shared hit=9
27. 0.087 0.087 ↓ 0.0 0 3

Index Scan using boapco_pk on boapco sboap (cost=0.43..2.65 rows=1 width=24) (actual time=0.029..0.029 rows=0 loops=3)

  • Index Cond: ((copaip = bov.copaip) AND (nunati = bov.nunati) AND (tyapco = 'A'::bpchar))
  • Filter: (cosu = bov.cosu)
  • Buffers: shared hit=9
28. 0.006 0.006 ↓ 0.0 0 3

Index Scan using boapco_pk on boapco boa (cost=0.43..2.66 rows=1 width=26) (actual time=0.002..0.002 rows=0 loops=3)

  • Index Cond: ((copaip = sboap.copaip) AND (nunati = sboap.nunati) AND (daapco = (max(sboap.daapco))) AND (tyapco = sboap.tyapco))
  • Filter: (sboap.cosu = cosu)
29. 0.126 0.126 ↑ 1.0 1 3

Index Scan using bovige_pk on bovige bovige_anim (cost=0.56..2.79 rows=1 width=50) (actual time=0.042..0.042 rows=1 loops=3)

  • Index Cond: ((copaip = bov.copaip) AND (nunati = bov.nunati))
  • Filter: ((cosu = '0'::bpchar) AND (bov.cosu = cosu))
  • Buffers: shared hit=15
30. 0.198 0.198 ↑ 1.0 1 3

Index Scan using bofige_pkey on bofige bo (cost=0.57..2.79 rows=1 width=22) (actual time=0.066..0.066 rows=1 loops=3)

  • Index Cond: ((copaip = bovige_anim.copame) AND (nunati = bovige_anim.numere) AND (dafige = bov.danais))
  • Buffers: shared hit=15
31. 0.153 0.153 ↑ 1.0 1 3

Index Scan using bovide_pkey on bovide bov_pere1 (cost=0.57..2.32 rows=1 width=29) (actual time=0.051..0.051 rows=1 loops=3)

  • Index Cond: ((copaip = bovige_anim.copape) AND (nunati = bovige_anim.nupere))
  • Filter: ((cosu = '0'::bpchar) AND (cosu = bovige_anim.cosu))
  • Buffers: shared hit=15
32. 0.063 0.063 ↑ 1.0 1 3

Index Scan using bovide_pkey on bovide bov_pere2 (cost=0.57..2.79 rows=1 width=29) (actual time=0.021..0.021 rows=1 loops=3)

  • Index Cond: ((copaip = bov.copapi) AND (nunati = bov.nupeip))
  • Filter: ((cosu = '0'::bpchar) AND (bov.cosu = cosu))
  • Buffers: shared hit=15
33. 0.054 0.054 ↑ 1.0 1 3

Index Scan using bofige_pkey on bofige bof_mere (cost=0.57..2.80 rows=1 width=24) (actual time=0.018..0.018 rows=1 loops=3)

  • Index Cond: ((copaip = bov.copami) AND (copaip = 'FR'::bpchar) AND (nunati = bov.numeip) AND (nunati = '5694030194 '::bpchar) AND (dafige = bov.danais))
  • Filter: ((cosu = '0'::bpchar) AND (bov.cosu = cosu))
  • Buffers: shared hit=15
34. 0.009 0.138 ↑ 4.0 1 3

GroupAggregate (cost=0.57..6.41 rows=4 width=22) (actual time=0.046..0.046 rows=1 loops=3)

  • Group Key: sfgder.copaip, sfgder.nunati, sfgder.cosu
  • Buffers: shared hit=14
35. 0.129 0.129 ↑ 2.0 2 3

Index Scan using bofige_pkey on bofige sfgder (cost=0.57..6.33 rows=4 width=22) (actual time=0.042..0.043 rows=2 loops=3)

  • Index Cond: ((copaip = bov.copaip) AND (nunati = bov.nunati))
  • Filter: (bov.cosu = cosu)
  • Buffers: shared hit=14
36. 0.033 0.033 ↑ 1.0 1 3

Index Scan using bofige_pkey on bofige bof_dern (cost=0.57..2.79 rows=1 width=22) (actual time=0.011..0.011 rows=1 loops=3)

  • Index Cond: ((copaip = sfgder.copaip) AND (nunati = sfgder.nunati) AND (dafige = (max(sfgder.dafige))))
  • Filter: (cosu = sfgder.cosu)
  • Buffers: shared hit=10
37. 0.006 0.054 ↓ 0.0 0 3

GroupAggregate (cost=0.57..6.43 rows=1 width=22) (actual time=0.018..0.018 rows=0 loops=3)

  • Group Key: sfgavder.copaip, sfgavder.nunati, sfgavder.cosu
  • Filter: (max(sfgavder.dafige) < bof_dern.dafige)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=14
38. 0.048 0.048 ↑ 2.0 2 3

Index Scan using bofige_pkey on bofige sfgavder (cost=0.57..6.33 rows=4 width=22) (actual time=0.015..0.016 rows=2 loops=3)

  • Index Cond: ((copaip = bov.copaip) AND (nunati = bov.nunati))
  • Filter: (bov.cosu = cosu)
  • Buffers: shared hit=14
39. 0.012 0.012 ↓ 0.0 0 3

Index Scan using bofige_pkey on bofige bof_avant_dern (cost=0.57..2.79 rows=1 width=22) (actual time=0.004..0.004 rows=0 loops=3)

  • Index Cond: ((copaip = sfgavder.copaip) AND (nunati = sfgavder.nunati) AND (dafige = (max(sfgavder.dafige))))
  • Filter: (cosu = sfgavder.cosu)
40. 0.001 0.164 ↓ 0.0 0 1

Nested Loop Left Join (cost=12.05..109.55 rows=4 width=213) (actual time=0.164..0.164 rows=0 loops=1)

  • Buffers: shared hit=22
41. 0.000 0.163 ↓ 0.0 0 1

Nested Loop Left Join (cost=11.48..98.33 rows=4 width=150) (actual time=0.163..0.163 rows=0 loops=1)

  • Buffers: shared hit=22
42. 0.000 0.163 ↓ 0.0 0 1

Nested Loop Left Join (cost=10.92..72.51 rows=4 width=130) (actual time=0.163..0.163 rows=0 loops=1)

  • Buffers: shared hit=22
43. 0.000 0.163 ↓ 0.0 0 1

Nested Loop Left Join (cost=10.35..61.30 rows=4 width=148) (actual time=0.163..0.163 rows=0 loops=1)

  • Buffers: shared hit=22
44. 0.001 0.163 ↓ 0.0 0 1

Nested Loop Left Join (cost=9.78..54.81 rows=1 width=126) (actual time=0.163..0.163 rows=0 loops=1)

  • Buffers: shared hit=22
45. 0.000 0.162 ↓ 0.0 0 1

Nested Loop Left Join (cost=9.21..52.32 rows=1 width=140) (actual time=0.162..0.162 rows=0 loops=1)

  • Buffers: shared hit=22
46. 0.000 0.162 ↓ 0.0 0 1

Nested Loop Left Join (cost=8.65..49.78 rows=1 width=129) (actual time=0.162..0.162 rows=0 loops=1)

  • Buffers: shared hit=22
47. 0.000 0.162 ↓ 0.0 0 1

Nested Loop Left Join (cost=8.08..46.98 rows=1 width=117) (actual time=0.162..0.162 rows=0 loops=1)

  • Join Filter: ((bovige_anim_1.copame = bo_1.copaip) AND (bovige_anim_1.numere = bo_1.nunati))
  • Buffers: shared hit=22
48. 0.000 0.162 ↓ 0.0 0 1

Nested Loop Left Join (cost=7.51..44.50 rows=1 width=131) (actual time=0.162..0.162 rows=0 loops=1)

  • Buffers: shared hit=22
49. 0.001 0.162 ↓ 0.0 0 1

Nested Loop Left Join (cost=7.08..41.83 rows=1 width=153) (actual time=0.162..0.162 rows=0 loops=1)

  • Buffers: shared hit=22
50. 0.000 0.161 ↓ 0.0 0 1

Nested Loop Left Join (cost=6.66..39.14 rows=1 width=129) (actual time=0.161..0.161 rows=0 loops=1)

  • Buffers: shared hit=22
51. 0.000 0.161 ↓ 0.0 0 1

Nested Loop Left Join (cost=6.09..36.33 rows=1 width=135) (actual time=0.161..0.161 rows=0 loops=1)

  • Buffers: shared hit=22
52. 0.000 0.161 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.25..32.44 rows=1 width=113) (actual time=0.161..0.161 rows=0 loops=1)

  • Buffers: shared hit=22
53. 0.001 0.161 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.69..28.91 rows=1 width=111) (actual time=0.160..0.161 rows=0 loops=1)

  • Buffers: shared hit=22
54. 0.003 0.160 ↓ 0.0 0 1

Nested Loop (cost=1.13..25.38 rows=1 width=109) (actual time=0.160..0.160 rows=0 loops=1)

  • Buffers: shared hit=22
55. 0.061 0.061 ↑ 2.3 3 1

Index Scan using bovige_fk1 on bovige bovige_anim_1 (cost=0.56..5.83 rows=7 width=50) (actual time=0.059..0.061 rows=3 loops=1)

  • Index Cond: ((copame = 'FR'::bpchar) AND (numere = '5694030194 '::bpchar))
  • Filter: (cosu = '0'::bpchar)
  • Buffers: shared hit=7
56. 0.096 0.096 ↓ 0.0 0 3

Index Scan using bovide_pkey on bovide bov_1 (cost=0.57..2.79 rows=1 width=75) (actual time=0.032..0.032 rows=0 loops=3)

  • Index Cond: ((copaip = bovige_anim_1.copaip) AND (nunati = bovige_anim_1.nunati))
  • Filter: ((cosu = '0'::bpchar) AND (indite = 'O'::bpchar))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=15
57. 0.000 0.000 ↓ 0.0 0

Index Scan using bopoat_pk on bopoat bop120_1 (cost=0.56..3.49 rows=4 width=20) (never executed)

  • Index Cond: ((copaip = bov_1.copaip) AND (nunati = bov_1.nunati) AND (copoat = '04'::bpchar))
  • Filter: ((cosu = '0'::bpchar) AND (cosu = bov_1.cosu))
58. 0.000 0.000 ↓ 0.0 0

Index Scan using bopoat_pk on bopoat bop210_1 (cost=0.56..3.49 rows=4 width=20) (never executed)

  • Index Cond: ((copaip = bov_1.copaip) AND (nunati = bov_1.nunati) AND (copoat = '07'::bpchar))
  • Filter: ((cosu = '0'::bpchar) AND (cosu = bov_1.cosu))
59. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=3.83..3.87 rows=1 width=26) (never executed)

  • Group Key: sipder_1.copaip, sipder_1.nunati, sipder_1.cosu, sipder_1.dasort
  • Filter: (max(sipder_1.daench) < CURRENT_DATE)
60. 0.000 0.000 ↓ 0.0 0

Sort (cost=3.83..3.84 rows=1 width=26) (never executed)

  • Sort Key: sipder_1.dasort
61. 0.000 0.000 ↓ 0.0 0

Index Scan using ipgmou_pkey on ipgmou sipder_1 (cost=0.57..3.82 rows=1 width=26) (never executed)

  • Index Cond: ((copaip = bov_1.copaip) AND (nunati = bov_1.nunati))
  • Filter: ((bov_1.cosu = cosu) AND ((dasort IS NULL) OR (dasort > CURRENT_DATE)))
62. 0.000 0.000 ↓ 0.0 0

Index Scan using ipgmou_pkey on ipgmou ip_1 (cost=0.57..2.80 rows=1 width=38) (never executed)

  • Index Cond: ((copaip = sipder_1.copaip) AND (nunati = sipder_1.nunati) AND (daench = (max(sipder_1.daench))))
  • Filter: (cosu = sipder_1.cosu)
63. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=0.43..2.68 rows=1 width=24) (never executed)

  • Group Key: sboap_1.copaip, sboap_1.nunati, sboap_1.tyapco, sboap_1.cosu
64. 0.000 0.000 ↓ 0.0 0

Index Scan using boapco_pk on boapco sboap_1 (cost=0.43..2.65 rows=1 width=24) (never executed)

  • Index Cond: ((copaip = bov_1.copaip) AND (nunati = bov_1.nunati) AND (tyapco = 'A'::bpchar))
  • Filter: (cosu = bov_1.cosu)
65. 0.000 0.000 ↓ 0.0 0

Index Scan using boapco_pk on boapco boa_1 (cost=0.43..2.66 rows=1 width=26) (never executed)

  • Index Cond: ((copaip = sboap_1.copaip) AND (nunati = sboap_1.nunati) AND (daapco = (max(sboap_1.daapco))) AND (tyapco = sboap_1.tyapco))
  • Filter: (sboap_1.cosu = cosu)
66. 0.000 0.000 ↓ 0.0 0

Index Scan using bofige_pkey on bofige bo_1 (cost=0.57..2.47 rows=1 width=22) (never executed)

  • Index Cond: ((copaip = 'FR'::bpchar) AND (nunati = '5694030194 '::bpchar) AND (dafige = bov_1.danais))
67. 0.000 0.000 ↓ 0.0 0

Index Scan using bovide_pkey on bovide bov_pere1_1 (cost=0.57..2.79 rows=1 width=29) (never executed)

  • Index Cond: ((copaip = bovige_anim_1.copape) AND (nunati = bovige_anim_1.nupere))
  • Filter: ((cosu = '0'::bpchar) AND (cosu = bovige_anim_1.cosu))
68. 0.000 0.000 ↓ 0.0 0

Index Scan using bovide_pkey on bovide bov_pere2_1 (cost=0.57..2.53 rows=1 width=29) (never executed)

  • Index Cond: ((copaip = bov_1.copapi) AND (nunati = bov_1.nupeip))
  • Filter: ((cosu = '0'::bpchar) AND (bov_1.cosu = cosu))
69. 0.000 0.000 ↓ 0.0 0

Index Scan using bofige_pkey on bofige bof_mere_1 (cost=0.57..2.48 rows=1 width=24) (never executed)

  • Index Cond: ((copaip = bov_1.copami) AND (nunati = bov_1.numeip) AND (dafige = bov_1.danais))
  • Filter: ((cosu = '0'::bpchar) AND (bov_1.cosu = cosu))
70. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=0.57..6.41 rows=4 width=22) (never executed)

  • Group Key: sfgder_1.copaip, sfgder_1.nunati, sfgder_1.cosu
71. 0.000 0.000 ↓ 0.0 0

Index Scan using bofige_pkey on bofige sfgder_1 (cost=0.57..6.33 rows=4 width=22) (never executed)

  • Index Cond: ((copaip = bov_1.copaip) AND (nunati = bov_1.nunati))
  • Filter: (bov_1.cosu = cosu)