explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SvTv

Settings
# exclusive inclusive rows x rows loops node
1. 5,327.209 5,333.869 ↓ 13.0 13 1

Nested Loop (cost=1,035.65..2,057.9 rows=1 width=32) (actual time=8.195..5,333.869 rows=13 loops=1)

  • Buffers: shared hit=289550
2. 0.027 5.386 ↓ 13.0 13 1

Nested Loop (cost=1,011.48..2,026.24 rows=1 width=8) (actual time=4.336..5.386 rows=13 loops=1)

  • Buffers: shared hit=464
3. 0.023 5.138 ↓ 13.0 13 1

Nested Loop (cost=1,011.19..2,019.81 rows=1 width=12) (actual time=4.318..5.138 rows=13 loops=1)

  • Buffers: shared hit=425
4. 0.044 4.439 ↑ 5.8 13 1

Nested Loop (cost=1,010.76..1,806.06 rows=75 width=20) (actual time=4.24..4.439 rows=13 loops=1)

  • Buffers: shared hit=347
5. 0.008 4.265 ↑ 5.8 13 1

Nested Loop (cost=1,010.47..1,225.29 rows=75 width=20) (actual time=4.235..4.265 rows=13 loops=1)

  • Buffers: shared hit=321
6. 0.058 0.058 ↑ 1.0 1 1

Index Only Scan using all_jednostki_org_pkey on all_jednostki_org all_jednostki_org (cost=0.14..8.16 rows=1 width=4) (actual time=0.056..0.058 rows=1 loops=1)

  • Index Cond: (all_jednostki_org.id_jedn_org = 10)
  • Buffers: shared hit=2
7. 0.872 4.199 ↑ 5.8 13 1

Hash Join (cost=1,010.32..1,216.38 rows=75 width=20) (actual time=4.177..4.199 rows=13 loops=1)

  • Buffers: shared hit=319
8. 1.652 1.652 ↑ 1.0 7,783 1

Seq Scan on ho_dane_noworodka ho_dane_noworodka (cost=0..176.83 rows=7,783 width=4) (actual time=0.023..1.652 rows=7,783 loops=1)

  • Buffers: shared hit=99
9. 0.017 1.675 ↑ 5.8 13 1

Hash (cost=1,009.39..1,009.39 rows=75 width=20) (actual time=1.675..1.675 rows=13 loops=1)

  • Buffers: shared hit=217
10. 0.007 1.658 ↑ 5.8 13 1

Nested Loop (cost=0.84..1,009.39 rows=75 width=20) (actual time=0.174..1.658 rows=13 loops=1)

  • Buffers: shared hit=217
11. 1.404 1.404 ↑ 5.8 13 1

Index Scan using ho_pobyty_id_zd_out_key on ho_pobyty ho_pobyty (cost=0.42..391.19 rows=76 width=20) (actual time=0.141..1.404 rows=13 loops=1)

  • Index Cond: (ho_pobyty.id_zd_out = 1)
  • Filter: (ho_pobyty.id_jedn_org = 10)
  • Buffers: shared hit=165
12. 0.247 0.247 ↑ 1.0 1 13

Index Scan using ho_hospit_pkey on ho_hospit ho_hospit (cost=0.42..8.12 rows=1 width=14) (actual time=0.018..0.019 rows=1 loops=13)

  • Index Cond: (ho_hospit.id_hospit = ho_pobyty.id_hospit)
  • Filter: (ho_hospit.chemioterapia = 0)
  • Buffers: shared hit=52
13. 0.130 0.130 ↓ 0.0 0 13

Index Scan using ho_pob_jgp_id_pobytu_index on ho_pob_jgp ho_pob_jgp (cost=0.29..7.73 rows=1 width=4) (actual time=0.01..0.01 rows=0 loops=13)

  • Index Cond: (ho_pobyty.id_pobytu = ho_pob_jgp.id_pobytu)
  • Filter: (ho_pob_jgp.aktywny = 1)
  • Buffers: shared hit=26
14. 0.676 0.676 ↑ 1.0 1 13

Index Scan using all_personal_id_app_nad_key on all_personal all_personal (cost=0.43..2.84 rows=1 width=8) (actual time=0.041..0.052 rows=1 loops=13)

  • Index Cond: (all_personal.id_app_nad = ho_hospit.id_hospit)
  • Filter: (((all_personal.pow_tbl)::text = 'ho_hospit'::text) AND (ho_hospit.id_personal = all_personal.id_personal))
  • Buffers: shared hit=78
15. 0.221 0.221 ↑ 1.0 1 13

Index Scan using ho_sale_pobytu_id_pobytu_index on ho_sale_pobytu ho_sale_pobytu (cost=0.29..6.41 rows=1 width=12) (actual time=0.015..0.017 rows=1 loops=13)

  • Index Cond: (ho_pobyty.id_pobytu = ho_sale_pobytu.id_pobytu)
  • Filter: (ho_sale_pobytu.aktywny <> 0)
  • Buffers: shared hit=39
16. 0.091 1.274 ↑ 1.0 1 13

Bitmap Heap Scan on numeracje_konteksty numeracje_konteksty (cost=24.17..31.4 rows=1 width=4) (actual time=0.097..0.098 rows=1 loops=13)

  • Filter: (((numeracje_konteksty.usuniety = 0) OR (numeracje_konteksty.usuniety IS NULL)) AND (numeracje_konteksty.numeracja_id <> 0))
  • Buffers: shared hit=91
17. 0.039 1.183 ↓ 0.0 0 13

BitmapAnd (cost=24.17..24.17 rows=2 width=0) (actual time=0.091..0.091 rows=0 loops=13)

  • Buffers: shared hit=78
18. 0.195 0.195 ↓ 3.1 69 13

Bitmap Index Scan on numeracje_konteksty_kontekst_index (cost=0..4.45 rows=22 width=0) (actual time=0.015..0.015 rows=69 loops=13)

  • Index Cond: (numeracje_konteksty.kontekst = 10)
  • Buffers: shared hit=26
19. 0.949 0.949 ↑ 1.0 958 13

Bitmap Index Scan on numeracje_konteksty_kontekst2_index (cost=0..19.47 rows=958 width=0) (actual time=0.073..0.073 rows=958 loops=13)

  • Index Cond: (numeracje_konteksty.kontekst2 = 0)
  • Buffers: shared hit=52