explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 76z

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 0.330 ↑ 1.0 1 1

Aggregate (cost=58.10..58.11 rows=1 width=8) (actual time=0.329..0.330 rows=1 loops=1)

2. 0.043 0.316 ↑ 1.0 284 1

Hash Join (cost=42.40..57.39 rows=286 width=0) (actual time=0.220..0.316 rows=284 loops=1)

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

Seq Scan on pg_index (cost=0.00..14.24 rows=286 width=4) (actual time=0.008..0.065 rows=284 loops=1)

  • Filter: indisunique
  • Rows Removed by Filter: 138
4. 0.075 0.208 ↑ 1.0 831 1

Hash (cost=31.62..31.62 rows=862 width=4) (actual time=0.208..0.208 rows=831 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 38kB
5. 0.133 0.133 ↑ 1.0 831 1

Seq Scan on pg_class (cost=0.00..31.62 rows=862 width=4) (actual time=0.005..0.133 rows=831 loops=1)