explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fnKU

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

GroupAggregate (cost=19,896,762.52..19,916,475.48 rows=492,824 width=164) (actual rows= loops=)

  • Group Key: mh.kurum_hesap_kodu_id, pc.parent_hesap_kodu, pc.parent_hesap_adi, pc.en_alt_seviye_mi
2. 0.000 0.000 ↓ 0.0

Sort (cost=19,896,762.52..19,897,994.58 rows=492,824 width=84) (actual rows= loops=)

  • Sort Key: mh.kurum_hesap_kodu_id, pc.parent_hesap_kodu, pc.parent_hesap_adi, pc.en_alt_seviye_mi
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=468,427.36..19,833,319.25 rows=492,824 width=84) (actual rows= loops=)

  • Hash Cond: (mh.kurum_hesap_kodu_id = pc.child_id)
4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on muhasebe_hareketleri mh (cost=305,015.21..19,039,649.27 rows=15,633,240 width=32) (actual rows= loops=)

  • Recheck Cond: (kurum_hesap_plani_id = 254)
  • Filter: ((fis_tarihi >= '2018-01-01 00:00:00'::timestamp without time zone) AND (fis_tarihi <= '2018-12-31 23:59:59.999'::timestamp without time zone) AND ((islem_tipi)::text <> 'Tüm Hesaplar Kapanış'::text))
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mh_kurumhesapplaniid_idx (cost=0.00..301,106.90 rows=15,911,778 width=0) (actual rows= loops=)

  • Index Cond: (kurum_hesap_plani_id = 254)
6. 0.000 0.000 ↓ 0.0

Hash (cost=162,169.42..162,169.42 rows=99,418 width=76) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on parent_child pc (cost=3,167.05..162,169.42 rows=99,418 width=76) (actual rows= loops=)

  • Recheck Cond: (kurum_hesap_plani_id = 254)
8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on parentchild_kurum_hesap_plani_id_idx (cost=0.00..3,142.20 rows=99,418 width=0) (actual rows= loops=)

  • Index Cond: (kurum_hesap_plani_id = 254)