explain.depesz.com

PostgreSQL's explain analyze made readable

Result: A6fU

Settings
# exclusive inclusive rows x rows loops node
1. 0.140 301.039 ↑ 1.0 20 1

Subquery Scan on z (cost=207,791.63..210,235.03 rows=20 width=1,508) (actual time=280.586..301.039 rows=20 loops=1)

2. 0.015 299.259 ↑ 1.0 20 1

Limit (cost=207,791.63..208,374.48 rows=20 width=568) (actual time=279.892..299.259 rows=20 loops=1)

3. 0.115 299.244 ↑ 59.5 40 1

Result (cost=207,208.78..276,626.22 rows=2,382 width=568) (actual time=258.514..299.244 rows=40 loops=1)

4. 4.736 256.529 ↑ 59.5 40 1

Sort (cost=207,208.78..207,214.74 rows=2,382 width=504) (actual time=256.504..256.529 rows=40 loops=1)

  • Sort Key: k1.kullanici_ad, t.tesis_ad, y.baglanti_anlasma_dt
  • Sort Method: top-N heapsort Memory: 41kB
5. 1.696 251.793 ↑ 1.1 2,155 1

Nested Loop Left Join (cost=0.71..207,133.49 rows=2,382 width=504) (actual time=5.249..251.793 rows=2,155 loops=1)

6. 0.827 250.097 ↑ 1.1 2,155 1

Nested Loop (cost=0.56..206,673.16 rows=2,382 width=462) (actual time=5.248..250.097 rows=2,155 loops=1)

7. 2.967 242.802 ↑ 1.1 2,156 1

Nested Loop (cost=0.28..205,622.92 rows=2,382 width=412) (actual time=5.237..242.802 rows=2,156 loops=1)

8. 198.731 233.963 ↑ 1.0 2,936 1

Seq Scan on skys_baglanti_anlasma y (cost=0.00..204,223.50 rows=3,047 width=386) (actual time=5.217..233.963 rows=2,936 loops=1)

  • Filter: ((active_flag = 1) AND (t_gecerlilik_durum_id = 1))
  • Rows Removed by Filter: 2312
9.          

SubPlan (for Seq Scan)

10. 5.872 5.872 ↑ 1.0 1 2,936

Index Scan using ba_id_idx on skys_tesis_sozlesme skys_tesis_sozlesme_2 (cost=0.28..8.30 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=2,936)

  • Index Cond: (baglanti_anlasma_id = y.baglanti_anlasma_id)
11. 2.936 2.936 ↑ 1.0 1 2,936

Index Scan using ba_id_idx on skys_tesis_sozlesme skys_tesis_sozlesme_3 (cost=0.28..8.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=2,936)

  • Index Cond: (baglanti_anlasma_id = y.baglanti_anlasma_id)
12. 8.808 14.680 ↓ 0.0 0 2,936

Seq Scan on skys_geri_odeme_hareket g (cost=8.30..25.05 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=2,936)

  • Filter: (tesis_sozlesme_id = $16)
  • Rows Removed by Filter: 9
13.          

Initplan (for Seq Scan)

14. 5.872 5.872 ↑ 1.0 1 2,936

Index Scan using ba_id_idx on skys_tesis_sozlesme skys_tesis_sozlesme_4 (cost=0.28..8.30 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=2,936)

  • Index Cond: (baglanti_anlasma_id = y.baglanti_anlasma_id)
15. 8.808 11.744 ↓ 0.0 0 2,936

Seq Scan on skys_geri_odeme_hareket g_1 (cost=8.30..25.05 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=2,936)

  • Filter: (tesis_sozlesme_id = $18)
  • Rows Removed by Filter: 9
16.          

Initplan (for Seq Scan)

17. 2.936 2.936 ↑ 1.0 1 2,936

Index Scan using ba_id_idx on skys_tesis_sozlesme skys_tesis_sozlesme_5 (cost=0.28..8.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=2,936)

  • Index Cond: (baglanti_anlasma_id = y.baglanti_anlasma_id)
18. 5.872 5.872 ↑ 1.0 1 2,936

Index Scan using pk_tesis on skys_tesis t (cost=0.28..0.44 rows=1 width=30) (actual time=0.002..0.002 rows=1 loops=2,936)

  • Index Cond: (tesis_id = y.tesis_id)
19. 6.468 6.468 ↑ 1.0 1 2,156

Index Scan using pk_kullanici on skys_kullanici k1 (cost=0.28..0.43 rows=1 width=58) (actual time=0.003..0.003 rows=1 loops=2,156)

  • Index Cond: (kullanici_id = t.kullanici_id)
  • Filter: (kullanici_ad IS NOT NULL)
20. 0.000 0.000 ↓ 0.0 0 2,155

Index Scan using pk_geri_odeme_hareket on skys_geri_odeme_hareket h (cost=0.15..0.18 rows=1 width=42) (actual time=0.000..0.000 rows=0 loops=2,155)

  • Index Cond: (((SubPlan 19)) = geri_odeme_hareket_id)
21.          

SubPlan (for Result)

22. 0.000 21.760 ↑ 1.0 1 40

Aggregate (cost=14.56..14.57 rows=1 width=32) (actual time=0.544..0.544 rows=1 loops=40)

23.          

Initplan (for Aggregate)

24. 0.160 0.160 ↑ 1.0 1 40

Index Scan using ba_id_idx on skys_tesis_sozlesme (cost=0.28..8.30 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=40)

  • Index Cond: (baglanti_anlasma_id = y.baglanti_anlasma_id)
25. 21.720 21.720 ↓ 0.0 0 40

Seq Scan on skys_geri_odeme r (cost=0.00..6.25 rows=1 width=5) (actual time=0.543..0.543 rows=0 loops=40)

  • Filter: (skys.fnc_geri_odemenin_tesis_sozlesmesi(t_geri_odeme_tip_id, bedel_id) = $10)
  • Rows Removed by Filter: 39
26. 0.000 20.840 ↑ 1.0 1 40

Aggregate (cost=14.56..14.57 rows=1 width=32) (actual time=0.521..0.521 rows=1 loops=40)

27.          

Initplan (for Aggregate)

28. 0.120 0.120 ↑ 1.0 1 40

Index Scan using ba_id_idx on skys_tesis_sozlesme skys_tesis_sozlesme_1 (cost=0.28..8.30 rows=1 width=4) (actual time=0.002..0.003 rows=1 loops=40)

  • Index Cond: (baglanti_anlasma_id = y.baglanti_anlasma_id)
29. 20.760 20.760 ↓ 0.0 0 40

Seq Scan on skys_geri_odeme u (cost=0.00..6.25 rows=1 width=6) (actual time=0.519..0.519 rows=0 loops=40)

  • Filter: (skys.fnc_geri_odemenin_tesis_sozlesmesi(t_geri_odeme_tip_id, bedel_id) = $12)
  • Rows Removed by Filter: 39
30.          

SubPlan (for Subquery Scan)

31. 0.020 0.200 ↑ 1.0 1 20

Limit (cost=8.46..8.47 rows=1 width=8) (actual time=0.010..0.010 rows=1 loops=20)

32. 0.020 0.180 ↑ 1.0 1 20

Aggregate (cost=8.46..8.47 rows=1 width=8) (actual time=0.009..0.009 rows=1 loops=20)

33. 0.160 0.160 ↓ 0.0 0 20

Index Scan using w5_file_attachment_table_id_table_pk_idx on w5_file_attachment cx (cost=0.43..8.45 rows=1 width=0) (actual time=0.008..0.008 rows=0 loops=20)

  • Index Cond: ((table_id = 1875) AND ((table_pk)::text = (z.pkpkpk_id)::text))
  • Filter: (customization_id = 0)
34. 0.020 0.880 ↑ 1.0 1 20

Aggregate (cost=17.21..17.22 rows=1 width=32) (actual time=0.044..0.044 rows=1 loops=20)

35. 0.064 0.860 ↑ 3.0 1 20

Hash Join (cost=13.88..17.20 rows=3 width=28) (actual time=0.042..0.043 rows=1 loops=20)

  • Hash Cond: ((q.satir)::integer = x.ba_neden_id)
36. 0.040 0.780 ↑ 200.0 1 20

HashAggregate (cost=12.75..14.75 rows=200 width=516) (actual time=0.039..0.039 rows=1 loops=20)

  • Group Key: (q.satir)::integer
37. 0.740 0.740 ↑ 1,000.0 1 20

Function Scan on tool_parse_numbers q (cost=0.25..10.25 rows=1,000 width=516) (actual time=0.037..0.037 rows=1 loops=20)

38. 0.006 0.016 ↓ 1.5 9 1

Hash (cost=1.06..1.06 rows=6 width=32) (actual time=0.016..0.016 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
39. 0.010 0.010 ↓ 1.5 9 1

Seq Scan on t_skys_ba_neden x (cost=0.00..1.06 rows=6 width=32) (actual time=0.009..0.010 rows=9 loops=1)

40. 0.040 0.040 ↑ 1.0 1 20

Seq Scan on t_skys_gecerlilik_durum x_1 (cost=0.00..1.02 rows=1 width=11) (actual time=0.002..0.002 rows=1 loops=20)

  • Filter: (gecerlilik_durum_id = z.t_gecerlilik_durum_id)
  • Rows Removed by Filter: 1
41. 0.120 0.120 ↑ 1.0 1 20

Index Scan using tesis_id_active_flag_t_tesis_tur_id_idx on skys_tesis x_2 (cost=0.28..8.30 rows=1 width=14) (actual time=0.006..0.006 rows=1 loops=20)

  • Index Cond: (tesis_id = z.tesis_id)
42. 0.060 0.060 ↑ 1.0 1 20

Index Scan using pk_kullanici on skys_kullanici x_3 (cost=0.28..8.29 rows=1 width=44) (actual time=0.003..0.003 rows=1 loops=20)

  • Index Cond: (kullanici_id = z.imzalayan_kullanici_id)
43. 0.040 0.040 ↑ 1.0 1 20

Seq Scan on t_skys_tesis_tur x_4 (cost=0.00..1.10 rows=1 width=17) (actual time=0.002..0.002 rows=1 loops=20)

  • Filter: (tesis_tur_id = z.t_tesis_tur_id)
  • Rows Removed by Filter: 7
44. 0.040 0.040 ↓ 0.0 0 20

Seq Scan on t_skys_geri_odeme_bildirim x_5 (cost=0.00..1.04 rows=1 width=15) (actual time=0.002..0.002 rows=0 loops=20)

  • Filter: (geri_odeme_bildirim_id = z.kamulastirma_geri_odeme_durumu)
  • Rows Removed by Filter: 3
45. 0.000 0.000 ↓ 0.0 0 20

Index Scan using pk_t_skys_tesis_geri_odeme_durumu on t_skys_tesis_geri_odeme_durumu x_6 (cost=0.15..8.17 rows=1 width=108) (actual time=0.000..0.000 rows=0 loops=20)

  • Index Cond: (tesis_geri_odeme_durumu_id = z.tesis_geri_odeme_durumu)
46. 0.020 0.260 ↑ 1.0 1 20

Aggregate (cost=39.40..39.41 rows=1 width=32) (actual time=0.013..0.013 rows=1 loops=20)

47. 0.072 0.240 ↓ 0.0 0 20

Hash Join (cost=17.25..38.67 rows=290 width=108) (actual time=0.012..0.012 rows=0 loops=20)

  • Hash Cond: (x_7.guncel_tesis_bedeli_bilgisi_id = (q_1.satir)::integer)
48. 0.008 0.008 ↑ 580.0 1 1

Seq Scan on t_skys_guncel_tesis_bedeli_bilgisi x_7 (cost=0.00..15.80 rows=580 width=112) (actual time=0.008..0.008 rows=1 loops=1)

49. 0.020 0.160 ↓ 0.0 0 20

Hash (cost=14.75..14.75 rows=200 width=516) (actual time=0.008..0.008 rows=0 loops=20)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
50. 0.020 0.140 ↓ 0.0 0 20

HashAggregate (cost=12.75..14.75 rows=200 width=516) (actual time=0.007..0.007 rows=0 loops=20)

  • Group Key: (q_1.satir)::integer
51. 0.120 0.120 ↓ 0.0 0 20

Function Scan on tool_parse_numbers q_1 (cost=0.25..10.25 rows=1,000 width=516) (actual time=0.006..0.006 rows=0 loops=20)

Planning time : 4.343 ms
Execution time : 301.528 ms