explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NcTp

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.024 ↑ 2.0 3 1

Sort (cost=2.27..2.28 rows=6 width=285) (actual time=0.023..0.024 rows=3 loops=1)

  • Sort Key: e.creation_timestamp
  • Sort Method: quicksort Memory: 25kB
2. 0.009 0.016 ↑ 2.0 3 1

Hash Join (cost=1.04..2.19 rows=6 width=285) (actual time=0.014..0.016 rows=3 loops=1)

  • Hash Cond: (e.parent_id = es.id)
3. 0.004 0.004 ↑ 2.0 3 1

Seq Scan on event e (cost=0.00..1.06 rows=6 width=256) (actual time=0.004..0.004 rows=3 loops=1)

4. 0.002 0.003 ↑ 2.0 1 1

Hash (cost=1.02..1.02 rows=2 width=62) (actual time=0.003..0.003 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.001 0.001 ↑ 2.0 1 1

Seq Scan on event_source es (cost=0.00..1.02 rows=2 width=62) (actual time=0.001..0.001 rows=1 loops=1)