explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aYN3 : Optimization for: aaaa; plan #juF8

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 52.723 72.491 ↓ 1.0 104,669 1

Hash Join (cost=1,290.95..4,242.39 rows=103,676 width=142) (actual time=5.401..72.491 rows=104,669 loops=1)

  • Hash Cond: (geceleme.rezid = rez.id)
2. 15.109 15.109 ↑ 1.0 110,997 1

Seq Scan on geceleme (cost=0.00..2,659.97 rows=110,997 width=73) (actual time=0.031..15.109 rows=110,997 loops=1)

3. 1.236 4.659 ↑ 1.0 10,922 1

Hash (cost=1,154.30..1,154.30 rows=10,932 width=69) (actual time=4.659..4.659 rows=10,922 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1238kB
4. 3.423 3.423 ↑ 1.0 10,922 1

Seq Scan on rez (cost=0.00..1,154.30 rows=10,932 width=69) (actual time=0.005..3.423 rows=10,922 loops=1)

  • Filter: (couttarih > '2019-04-12 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 782