explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LrIm : Optimization for: plan #Nxmj

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.033 3.627 ↑ 1.0 1 1

Aggregate (cost=16.79..16.80 rows=1 width=0) (actual time=3.626..3.627 rows=1 loops=1)

2. 0.216 3.594 ↑ 1.0 92 1

Hash Join (cost=4.17..16.55 rows=92 width=0) (actual time=3.349..3.594 rows=92 loops=1)

  • Hash Cond: (pg_class.oid = pg_index.indrelid)
3. 0.140 0.140 ↑ 1.0 255 1

Seq Scan on pg_class (cost=0.00..9.55 rows=255 width=4) (actual time=0.016..0.140 rows=255 loops=1)

4. 0.051 3.238 ↑ 1.0 92 1

Hash (cost=3.02..3.02 rows=92 width=4) (actual time=3.238..3.238 rows=92 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 4kB
5. 3.187 3.187 ↑ 1.0 92 1

Seq Scan on pg_index (cost=0.00..3.02 rows=92 width=4) (actual time=0.008..3.187 rows=92 loops=1)

  • Filter: indisunique