explain.depesz.com

PostgreSQL's explain analyze made readable

Result: A1eB

Settings
# exclusive inclusive rows x rows loops node
1. 19.835 56.917 ↓ 2.6 9,150 1

Sort (cost=1,722.93..1,731.77 rows=3,538 width=49) (actual time=49.377..56.917 rows=9,150 loops=1)

  • Sort Key: g.mahalle_adi
  • Sort Method: quicksort Memory: 1,250kB
2. 16.644 37.082 ↓ 2.6 9,150 1

Nested Loop (cost=5.69..1,514.39 rows=3,538 width=49) (actual time=0.147..37.082 rows=9,150 loops=1)

3. 0.262 1.694 ↓ 2.0 71 1

Nested Loop (cost=5.26..560.10 rows=36 width=29) (actual time=0.103..1.694 rows=71 loops=1)

4. 0.351 1.006 ↓ 2.0 71 1

Nested Loop (cost=4.97..545.92 rows=36 width=6) (actual time=0.057..1.006 rows=71 loops=1)

5. 0.118 0.144 ↓ 1.5 73 1

Bitmap Heap Scan on takbis_mahalle tm (cost=4.68..162.04 rows=50 width=6) (actual time=0.039..0.144 rows=73 loops=1)

  • Recheck Cond: (takbis_ilce_oid = '1004'::numeric)
  • Heap Blocks: exact=4
6. 0.026 0.026 ↓ 1.5 73 1

Bitmap Index Scan on ix_takbis_mahalle_ilce (cost=0.00..4.67 rows=50 width=0) (actual time=0.025..0.026 rows=73 loops=1)

  • Index Cond: (takbis_ilce_oid = '1004'::numeric)
7. 0.511 0.511 ↑ 1.0 1 73

Index Scan using ix_takbis_mah_meop_mah_tak_mah on takbis_mahalle_gen_mahalle tmgm (cost=0.29..7.67 rows=1 width=12) (actual time=0.006..0.007 rows=1 loops=73)

  • Index Cond: (takbis_mahalle_oid = tm.oid)
8. 0.426 0.426 ↑ 1.0 1 71

Index Scan using pk_gen_mahalle on gen_mahalle g (cost=0.29..0.39 rows=1 width=23) (actual time=0.006..0.006 rows=1 loops=71)

  • Index Cond: (oid = tmgm.meop_mahalle_oid)
9. 18.744 18.744 ↑ 1.6 129 71

Index Scan using idx_tas_tasinmaz_oid_mahalle on tas_tasinmaz tt (cost=0.43..24.41 rows=210 width=38) (actual time=0.017..0.264 rows=129 loops=71)

  • Index Cond: (oid_mahalle = g.oid)
  • Filter: ((oid_tasinmaz_tipi = '1'::numeric) AND ((tasinmaz_durumu)::text = 'A'::text))
  • Rows Removed by Filter: 56