explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gVzj

Settings
# exclusive inclusive rows x rows loops node
1. 181.086 2,643.916 ↓ 1.2 744,030 1

Hash Left Join (cost=21,793.04..119,627.18 rows=596,528 width=614) (actual time=254.612..2,643.916 rows=744,030 loops=1)

  • Output: gr.grup_kod, gr.grup_tanim, s.sinif_kod, s.sinif_tanim, ma.malzeme_tanim, ma.malzeme_id, m.malzeme_durum, ma.eski_birim, c.ambar_cikis_dt, ct.ambar_cikis_tur, cn.ambar_cikis_neden, c.ambar_cikis_no, a.ambar_kod, a.ambar_ad, aa.ambar_kod, aa.ambar_ad, ax.ad, a.yerlesim_kod, c.sevk_yerlesim_kod, cd.cikis_miktar, cd.cikis_kiymet, cd.alacak_hesap, cd.borc_hesap, p.proje_no, p.proje_adi, cd.insert_dttm
  • Hash Cond: ((c.proje_no)::text = (p.proje_no)::text)
  • Buffers: shared hit=22057, temp read=4736 written=4734
2. 235.709 2,462.450 ↓ 1.2 744,030 1

Hash Join (cost=21,758.24..117,353.40 rows=596,528 width=572) (actual time=254.222..2,462.450 rows=744,030 loops=1)

  • Output: cd.cikis_miktar, cd.cikis_kiymet, cd.alacak_hesap, cd.borc_hesap, cd.insert_dttm, c.ambar_cikis_dt, c.ambar_cikis_no, c.sevk_yerlesim_kod, c.proje_no, ma.malzeme_tanim, ma.malzeme_id, ma.eski_birim, m.malzeme_durum, a.ambar_kod, a.ambar_ad, a.yerlesim_kod, aa.ambar_kod, aa.ambar_ad, gr.grup_kod, gr.grup_tanim, s.sinif_kod, s.sinif_tanim, ax.ad, cn.ambar_cikis_neden, ct.ambar_cikis_tur
  • Hash Cond: (c.t_cikis_tur_id = ct.t_ambar_cikis_tur_id)
  • Buffers: shared hit=22044, temp read=4736 written=4734
3. 160.197 2,226.731 ↓ 1.2 744,030 1

Hash Left Join (cost=21,757.17..109,150.08 rows=596,528 width=456) (actual time=254.198..2,226.731 rows=744,030 loops=1)

  • Output: cd.cikis_miktar, cd.cikis_kiymet, cd.alacak_hesap, cd.borc_hesap, cd.insert_dttm, c.ambar_cikis_dt, c.ambar_cikis_no, c.sevk_yerlesim_kod, c.t_cikis_tur_id, c.proje_no, ma.malzeme_tanim, ma.malzeme_id, ma.eski_birim, m.malzeme_durum, a.ambar_kod, a.ambar_ad, a.yerlesim_kod, aa.ambar_kod, aa.ambar_ad, gr.grup_kod, gr.grup_tanim, s.sinif_kod, s.sinif_tanim, ax.ad, cn.ambar_cikis_neden
  • Hash Cond: (c.t_cikis_neden_id = cn.t_ambar_cikis_neden_id)
  • Buffers: shared hit=22043, temp read=4736 written=4734
4. 223.644 2,066.525 ↓ 1.2 744,030 1

Hash Left Join (cost=21,756.06..106,911.97 rows=596,528 width=340) (actual time=254.179..2,066.525 rows=744,030 loops=1)

  • Output: cd.cikis_miktar, cd.cikis_kiymet, cd.alacak_hesap, cd.borc_hesap, cd.insert_dttm, c.ambar_cikis_dt, c.ambar_cikis_no, c.sevk_yerlesim_kod, c.t_cikis_neden_id, c.t_cikis_tur_id, c.proje_no, ma.malzeme_tanim, ma.malzeme_id, ma.eski_birim, m.malzeme_durum, a.ambar_kod, a.ambar_ad, a.yerlesim_kod, aa.ambar_kod, aa.ambar_ad, gr.grup_kod, gr.grup_tanim, s.sinif_kod, s.sinif_tanim, ax.ad
  • Hash Cond: (c.unite_id = ax.personel_unite_id)
  • Buffers: shared hit=22042, temp read=4736 written=4734
5. 156.420 1,837.035 ↓ 1.2 744,030 1

Hash Left Join (cost=20,176.22..97,143.79 rows=596,528 width=310) (actual time=248.273..1,837.035 rows=744,030 loops=1)

  • Output: cd.cikis_miktar, cd.cikis_kiymet, cd.alacak_hesap, cd.borc_hesap, cd.insert_dttm, c.ambar_cikis_dt, c.ambar_cikis_no, c.sevk_yerlesim_kod, c.unite_id, c.t_cikis_neden_id, c.t_cikis_tur_id, c.proje_no, ma.malzeme_tanim, ma.malzeme_id, ma.eski_birim, m.malzeme_durum, a.ambar_kod, a.ambar_ad, a.yerlesim_kod, aa.ambar_kod, aa.ambar_ad, gr.grup_kod, gr.grup_tanim, s.sinif_kod, s.sinif_tanim
  • Hash Cond: (c.sevk_ambar_id = aa.ambar_id)
  • Buffers: shared hit=20687, temp read=4736 written=4734
6. 225.784 1,680.552 ↓ 1.2 744,030 1

Hash Left Join (cost=20,169.30..94,643.19 rows=596,528 width=287) (actual time=248.198..1,680.552 rows=744,030 loops=1)

  • Output: cd.cikis_miktar, cd.cikis_kiymet, cd.alacak_hesap, cd.borc_hesap, cd.insert_dttm, c.ambar_cikis_dt, c.ambar_cikis_no, c.sevk_yerlesim_kod, c.sevk_ambar_id, c.unite_id, c.t_cikis_neden_id, c.t_cikis_tur_id, c.proje_no, ma.malzeme_tanim, ma.malzeme_id, ma.eski_birim, m.malzeme_durum, a.ambar_kod, a.ambar_ad, a.yerlesim_kod, gr.grup_kod, gr.grup_tanim, s.sinif_kod, s.sinif_tanim
  • Hash Cond: (c.cikis_yapan_ambar_id = a.ambar_id)
  • Buffers: shared hit=20684, temp read=4736 written=4734
7. 333.521 1,454.693 ↓ 1.2 744,030 1

Hash Join (cost=20,162.39..86,434.01 rows=596,528 width=260) (actual time=248.109..1,454.693 rows=744,030 loops=1)

  • Output: cd.cikis_miktar, cd.cikis_kiymet, cd.alacak_hesap, cd.borc_hesap, cd.insert_dttm, c.ambar_cikis_dt, c.ambar_cikis_no, c.sevk_yerlesim_kod, c.cikis_yapan_ambar_id, c.sevk_ambar_id, c.unite_id, c.t_cikis_neden_id, c.t_cikis_tur_id, c.proje_no, ma.malzeme_tanim, ma.malzeme_id, ma.eski_birim, m.malzeme_durum, gr.grup_kod, gr.grup_tanim, s.sinif_kod, s.sinif_tanim
  • Hash Cond: (cd.ambar_cikis_id = c.ambar_cikis_id)
  • Buffers: shared hit=20681, temp read=4736 written=4734
8. 483.866 1,028.960 ↓ 1.2 744,030 1

Hash Join (cost=12,662.43..70,731.80 rows=596,528 width=230) (actual time=155.158..1,028.960 rows=744,030 loops=1)

  • Output: cd.cikis_miktar, cd.cikis_kiymet, cd.alacak_hesap, cd.borc_hesap, cd.insert_dttm, cd.ambar_cikis_id, ma.malzeme_tanim, ma.malzeme_id, ma.eski_birim, m.malzeme_durum, gr.grup_kod, gr.grup_tanim, s.sinif_kod, s.sinif_tanim
  • Hash Cond: (cd.malzeme_id = ma.malzeme_id)
  • Buffers: shared hit=17150, temp read=4736 written=4734
9. 302.695 390.394 ↓ 1.2 745,641 1

Hash Join (cost=1.09..29,766.19 rows=596,528 width=92) (actual time=0.042..390.394 rows=745,641 loops=1)

  • Output: cd.cikis_miktar, cd.cikis_kiymet, cd.alacak_hesap, cd.borc_hesap, cd.insert_dttm, cd.ambar_cikis_id, cd.malzeme_id, m.malzeme_durum
  • Hash Cond: (cd.t_malzeme_durum_id = m.t_malzeme_durum_id)
  • Buffers: shared hit=13548
10. 87.690 87.690 ↑ 1.0 745,660 1

Seq Scan on stok.stk_ambar_cikis_detay cd (cost=0.00..21,003.60 rows=745,660 width=64) (actual time=0.009..87.690 rows=745,660 loops=1)

  • Output: cd.ambar_cikis_detay_id, cd.ambar_cikis_id, cd.cikis_miktar, cd.cikis_kiymet, cd.active_flag, cd.version_no, cd.insert_user_id, cd.insert_dttm, cd.version_user_id, cd.version_dttm, cd.seri_nos, cd.birim_fiyat, cd.borc_hesap, cd.alacak_hesap, cd.malzeme_id, cd.t_malzeme_durum_id, cd.proje_no, cd.t_malzeme_gereklilik_id
  • Buffers: shared hit=13547
11. 0.002 0.009 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=34) (actual time=0.009..0.009 rows=4 loops=1)

  • Output: m.malzeme_durum, m.t_malzeme_durum_id
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
12. 0.007 0.007 ↑ 1.0 4 1

Seq Scan on stok.t_malzeme_durum m (cost=0.00..1.04 rows=4 width=34) (actual time=0.005..0.007 rows=4 loops=1)

  • Output: m.malzeme_durum, m.t_malzeme_durum_id
  • Buffers: shared hit=1
13. 54.534 154.700 ↑ 1.0 127,931 1

Hash (cost=8,438.20..8,438.20 rows=127,931 width=142) (actual time=154.700..154.700 rows=127,931 loops=1)

  • Output: ma.malzeme_tanim, ma.malzeme_id, ma.eski_birim, gr.grup_kod, gr.grup_tanim, s.sinif_kod, s.sinif_tanim
  • Buckets: 131072 Batches: 2 Memory Usage: 12183kB
  • Buffers: shared hit=3602, temp written=1294
14. 33.961 100.166 ↑ 1.0 127,931 1

Hash Join (cost=64.79..8,438.20 rows=127,931 width=142) (actual time=0.701..100.166 rows=127,931 loops=1)

  • Output: ma.malzeme_tanim, ma.malzeme_id, ma.eski_birim, gr.grup_kod, gr.grup_tanim, s.sinif_kod, s.sinif_tanim
  • Hash Cond: (ma.sinif_id = s.sinif_id)
  • Buffers: shared hit=3602
15. 46.402 65.575 ↑ 1.0 127,931 1

Hash Join (cost=3.82..6,618.18 rows=127,931 width=122) (actual time=0.057..65.575 rows=127,931 loops=1)

  • Output: ma.malzeme_tanim, ma.malzeme_id, ma.eski_birim, ma.sinif_id, gr.grup_kod, gr.grup_tanim
  • Hash Cond: (ma.grup_id = gr.grup_id)
  • Buffers: shared hit=3578
16. 19.136 19.136 ↑ 1.0 127,931 1

Seq Scan on stok.stk_malzeme ma (cost=0.00..4,855.31 rows=127,931 width=93) (actual time=0.007..19.136 rows=127,931 loops=1)

  • Output: ma.malzeme_id, ma.grup_id, ma.sinif_id, ma.ozellik_ids, ma.ozellik_deger_ids, ma.malzeme_tanim, ma.active_flag, ma.version_no, ma.insert_user_id, ma.insert_dttm, ma.version_user_id, ma.version_dttm, ma.eski_birim, ma.t_birim_id, ma.max_stok, ma.min_stok
  • Buffers: shared hit=3576
17. 0.017 0.037 ↑ 1.0 81 1

Hash (cost=2.81..2.81 rows=81 width=37) (actual time=0.037..0.037 rows=81 loops=1)

  • Output: gr.grup_kod, gr.grup_tanim, gr.grup_id
  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
  • Buffers: shared hit=2
18. 0.020 0.020 ↑ 1.0 81 1

Seq Scan on stok.mkd_grup gr (cost=0.00..2.81 rows=81 width=37) (actual time=0.006..0.020 rows=81 loops=1)

  • Output: gr.grup_kod, gr.grup_tanim, gr.grup_id
  • Buffers: shared hit=2
19. 0.331 0.630 ↑ 1.0 1,643 1

Hash (cost=40.43..40.43 rows=1,643 width=28) (actual time=0.630..0.630 rows=1,643 loops=1)

  • Output: s.sinif_kod, s.sinif_tanim, s.sinif_id
  • Buckets: 2048 Batches: 1 Memory Usage: 116kB
  • Buffers: shared hit=24
20. 0.299 0.299 ↑ 1.0 1,643 1

Seq Scan on stok.mkd_sinif s (cost=0.00..40.43 rows=1,643 width=28) (actual time=0.007..0.299 rows=1,643 loops=1)

  • Output: s.sinif_kod, s.sinif_tanim, s.sinif_id
  • Buffers: shared hit=24
21. 41.469 92.212 ↑ 1.0 176,398 1

Hash (cost=5,294.98..5,294.98 rows=176,398 width=38) (actual time=92.212..92.212 rows=176,398 loops=1)

  • Output: c.ambar_cikis_dt, c.ambar_cikis_no, c.sevk_yerlesim_kod, c.ambar_cikis_id, c.cikis_yapan_ambar_id, c.sevk_ambar_id, c.unite_id, c.t_cikis_neden_id, c.t_cikis_tur_id, c.proje_no
  • Buckets: 262144 Batches: 1 Memory Usage: 13448kB
  • Buffers: shared hit=3531
22. 50.743 50.743 ↑ 1.0 176,398 1

Seq Scan on stok.stk_ambar_cikis c (cost=0.00..5,294.98 rows=176,398 width=38) (actual time=0.006..50.743 rows=176,398 loops=1)

  • Output: c.ambar_cikis_dt, c.ambar_cikis_no, c.sevk_yerlesim_kod, c.ambar_cikis_id, c.cikis_yapan_ambar_id, c.sevk_ambar_id, c.unite_id, c.t_cikis_neden_id, c.t_cikis_tur_id, c.proje_no
  • Buffers: shared hit=3531
23. 0.034 0.075 ↑ 1.0 174 1

Hash (cost=4.74..4.74 rows=174 width=35) (actual time=0.075..0.075 rows=174 loops=1)

  • Output: a.ambar_kod, a.ambar_ad, a.yerlesim_kod, a.ambar_id
  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
  • Buffers: shared hit=3
24. 0.041 0.041 ↑ 1.0 174 1

Seq Scan on stok.stk_ambar a (cost=0.00..4.74 rows=174 width=35) (actual time=0.007..0.041 rows=174 loops=1)

  • Output: a.ambar_kod, a.ambar_ad, a.yerlesim_kod, a.ambar_id
  • Buffers: shared hit=3
25. 0.039 0.063 ↑ 1.0 174 1

Hash (cost=4.74..4.74 rows=174 width=31) (actual time=0.063..0.063 rows=174 loops=1)

  • Output: aa.ambar_kod, aa.ambar_ad, aa.ambar_id
  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
  • Buffers: shared hit=3
26. 0.024 0.024 ↑ 1.0 174 1

Seq Scan on stok.stk_ambar aa (cost=0.00..4.74 rows=174 width=31) (actual time=0.003..0.024 rows=174 loops=1)

  • Output: aa.ambar_kod, aa.ambar_ad, aa.ambar_id
  • Buffers: shared hit=3
27. 2.143 5.846 ↑ 1.0 9,993 1

Hash (cost=1,454.93..1,454.93 rows=9,993 width=38) (actual time=5.846..5.846 rows=9,993 loops=1)

  • Output: ax.ad, ax.personel_unite_id
  • Buckets: 16384 Batches: 1 Memory Usage: 829kB
  • Buffers: shared hit=1355
28. 3.703 3.703 ↑ 1.0 9,993 1

Seq Scan on genel.t_gen_personel_unite ax (cost=0.00..1,454.93 rows=9,993 width=38) (actual time=0.006..3.703 rows=9,993 loops=1)

  • Output: ax.ad, ax.personel_unite_id
  • Buffers: shared hit=1355
29. 0.003 0.009 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=122) (actual time=0.009..0.009 rows=5 loops=1)

  • Output: cn.ambar_cikis_neden, cn.t_ambar_cikis_neden_id
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
30. 0.006 0.006 ↑ 1.0 5 1

Seq Scan on stok.t_stk_ambar_cikis_neden cn (cost=0.00..1.05 rows=5 width=122) (actual time=0.005..0.006 rows=5 loops=1)

  • Output: cn.ambar_cikis_neden, cn.t_ambar_cikis_neden_id
  • Buffers: shared hit=1
31. 0.003 0.010 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=122) (actual time=0.010..0.010 rows=3 loops=1)

  • Output: ct.ambar_cikis_tur, ct.t_ambar_cikis_tur_id
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
32. 0.007 0.007 ↑ 1.0 3 1

Seq Scan on stok.t_stk_ambar_cikis_tur ct (cost=0.00..1.03 rows=3 width=122) (actual time=0.005..0.007 rows=3 loops=1)

  • Output: ct.ambar_cikis_tur, ct.t_ambar_cikis_tur_id
  • Buffers: shared hit=1
33. 0.212 0.380 ↑ 1.0 969 1

Hash (cost=22.69..22.69 rows=969 width=48) (actual time=0.380..0.380 rows=969 loops=1)

  • Output: p.proje_no, p.proje_adi
  • Buckets: 1024 Batches: 1 Memory Usage: 85kB
  • Buffers: shared hit=13
34. 0.168 0.168 ↑ 1.0 969 1

Seq Scan on stok.yatirim_proje p (cost=0.00..22.69 rows=969 width=48) (actual time=0.006..0.168 rows=969 loops=1)

  • Output: p.proje_no, p.proje_adi
  • Buffers: shared hit=13
Planning time : 2.206 ms
Execution time : 2,691.994 ms