explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xRH3

Settings
# exclusive inclusive rows x rows loops node
1. 11,615.105 146,473.553 ↑ 28.2 17,465 1

GroupAggregate (cost=19,896,762.52..19,916,475.48 rows=492,824 width=164) (actual time=104,423.275..146,473.553 rows=17,465 loops=1)

  • Group Key: mh.kurum_hesap_kodu_id, pc.parent_hesap_kodu, pc.parent_hesap_adi, pc.en_alt_seviye_mi
2. 92,988.946 134,858.448 ↓ 108.8 53,609,740 1

Sort (cost=19,896,762.52..19,897,994.58 rows=492,824 width=84) (actual time=103,223.482..134,858.448 rows=53,609,740 loops=1)

  • Sort Key: mh.kurum_hesap_kodu_id, pc.parent_hesap_kodu, pc.parent_hesap_adi, pc.en_alt_seviye_mi
  • Sort Method: external merge Disk: 4931616kB
3. 8,281.028 41,869.502 ↓ 108.8 53,609,740 1

Hash Join (cost=468,427.36..19,833,319.25 rows=492,824 width=84) (actual time=3,270.617..41,869.502 rows=53,609,740 loops=1)

  • Hash Cond: (mh.kurum_hesap_kodu_id = pc.child_id)
4. 30,385.380 33,515.329 ↓ 1.0 15,858,551 1

Bitmap Heap Scan on muhasebe_hareketleri mh (cost=305,015.21..19,039,649.27 rows=15,633,240 width=32) (actual time=3,197.174..33,515.329 rows=15,858,551 loops=1)

  • Recheck Cond: (kurum_hesap_plani_id = 254)
  • Rows Removed by Index Recheck: 9477252
  • 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))
  • Heap Blocks: exact=105273 lossy=3062308
5. 3,129.949 3,129.949 ↑ 1.0 15,858,842 1

Bitmap Index Scan on mh_kurumhesapplaniid_idx (cost=0.00..301,106.90 rows=15,911,778 width=0) (actual time=3,129.949..3,129.949 rows=15,858,842 loops=1)

  • Index Cond: (kurum_hesap_plani_id = 254)
6. 23.116 73.145 ↑ 1.0 98,651 1

Hash (cost=162,169.42..162,169.42 rows=99,418 width=76) (actual time=73.145..73.145 rows=98,651 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 11841kB
7. 41.864 50.029 ↑ 1.0 98,651 1

Bitmap Heap Scan on parent_child pc (cost=3,167.05..162,169.42 rows=99,418 width=76) (actual time=8.722..50.029 rows=98,651 loops=1)

  • Recheck Cond: (kurum_hesap_plani_id = 254)
  • Heap Blocks: exact=4122
8. 8.165 8.165 ↑ 1.0 98,651 1

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

  • Index Cond: (kurum_hesap_plani_id = 254)