explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 89c : test explain

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.041 0.738 ↑ 1.0 1 1

Aggregate (cost=26.34..26.35 rows=1 width=8) (actual time=0.737..0.738 rows=1 loops=1)

2. 0.164 0.697 ↑ 1.3 129 1

Hash Join (cost=19.70..25.93 rows=164 width=0) (actual time=0.533..0.697 rows=129 loops=1)

  • Hash Cond: (pg_index.indrelid = pg_class.oid)
3. 0.115 0.115 ↑ 1.3 129 1

Seq Scan on pg_index (cost=0.00..5.80 rows=164 width=4) (actual time=0.041..0.115 rows=129 loops=1)

  • Filter: indisunique
  • Rows Removed by Filter: 12
4. 0.203 0.418 ↓ 1.0 354 1

Hash (cost=15.42..15.42 rows=342 width=4) (actual time=0.417..0.418 rows=354 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
5. 0.215 0.215 ↓ 1.0 354 1

Seq Scan on pg_class (cost=0.00..15.42 rows=342 width=4) (actual time=0.017..0.215 rows=354 loops=1)