explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LwTX

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=94.99..95.04 rows=1 width=421) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Unique (cost=94.99..124.82 rows=628 width=421) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=94.99..96.56 rows=628 width=421) (actual rows= loops=)

  • Sort Key: f.segediktatoszam, (count(1) OVER (?)), ib.id, lo.id, f.iktatoszam, i.irattari_jel, p.teljes_nev, f.targy, (to_char(f.datum, 'YYYY-MM-DD'::text)), (to_char(ib.datum, 'YYYY-MM-DD'::text)), it.nev, (to_char(sj.datum, 'YYYY-MM-DD'::text)), (to_char(lj.datum, 'YYYY-MM-DD'::text)), (to_char(ib.felulvizsgalat_datum, 'YYYY-MM-DD'::text)), ib.terem, ib.sor, ib.polc, ib.oszlop
4. 0.000 0.000 ↓ 0.0

WindowAgg (cost=5.77..65.80 rows=628 width=421) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5.77..50.10 rows=628 width=293) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.25..14.46 rows=2 width=277) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.98..13.92 rows=1 width=281) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.98..12.89 rows=1 width=237) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.71..12.43 rows=1 width=219) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..9.64 rows=1 width=211) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..9.39 rows=1 width=128) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on m_irattaribejegyzesek ib (cost=0.00..1.09 rows=1 width=128) (actual rows= loops=)

  • Filter: ((irattar_id = 1) AND (is_aktivalva = 0) AND (is_kesz = 0))
13. 0.000 0.000 ↓ 0.0

Index Scan using pk_m_link_objects_id on m_link_objects lo (cost=0.28..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = ib.link_object_id)
14. 0.000 0.000 ↓ 0.0

Index Scan using pk_foszamok_id on foszamok f (cost=0.15..0.24 rows=1 width=95) (actual rows= loops=)

  • Index Cond: (id = lo.foszam_id)
  • Filter: (iktatokonyv_id = ANY ('{27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48}'::integer[]))
15. 0.000 0.000 ↓ 0.0

Index Scan using pk_irattaritetelek_id on irattaritetelek i (cost=0.29..2.78 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (f.irattaritetel_id = id)
16. 0.000 0.000 ↓ 0.0

Index Scan using pk_partnerek_id on partnerek p (cost=0.27..0.45 rows=1 width=26) (actual rows= loops=)

  • Index Cond: (f.partner_id = id)
17. 0.000 0.000 ↓ 0.0

Seq Scan on irattarak it (cost=0.00..1.01 rows=1 width=52) (actual rows= loops=)

  • Filter: (id = 1)
18. 0.000 0.000 ↓ 0.0

Index Scan using ixf_alszamok_foszam_id on alszamok asz (cost=0.28..0.53 rows=2 width=8) (actual rows= loops=)

  • Index Cond: (foszam_id = f.id)
19. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=4.52..17.74 rows=8 width=20) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=4.37..16.06 rows=8 width=16) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on m_sellev sl (cost=4.21..14.37 rows=8 width=8) (actual rows= loops=)

  • Recheck Cond: (irattaribejegyzes_id = ib.id)
22. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ixf_m_sellev_irattaribejegyzes_id (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: (irattaribejegyzes_id = ib.id)
23. 0.000 0.000 ↓ 0.0

Index Scan using pk_sellev_jegyzokonyvek_id on sellev_jegyzokonyvek sj (cost=0.15..0.20 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (sl.jegyzokonyv_id = id)
  • Filter: (is_selejtezesi = 1)
24. 0.000 0.000 ↓ 0.0

Index Scan using pk_sellev_jegyzokonyvek_id on sellev_jegyzokonyvek lj (cost=0.15..0.20 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (sl.jegyzokonyv_id = id)
  • Filter: (is_selejtezesi = 0)