explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OEw1 : Tables without a single index

Settings
# exclusive inclusive rows x rows loops node
1. 0.049 0.662 ↑ 6.6 8 1

Hash Join (cost=6.83..25.99 rows=53 width=128) (actual time=0.432..0.662 rows=8 loops=1)

  • Hash Cond: (c.relnamespace = n.oid)
2. 0.061 0.581 ↑ 6.6 8 1

Hash Anti Join (cost=5.70..23.60 rows=53 width=68) (actual time=0.371..0.581 rows=8 loops=1)

  • Hash Cond: (c.oid = i.indrelid)
3. 0.346 0.346 ↑ 1.0 68 1

Seq Scan on pg_class c (cost=0.00..17.14 rows=68 width=72) (actual time=0.022..0.346 rows=68 loops=1)

  • Filter: (relkind = 'r'::"char")
  • Rows Removed by Filter: 264
4. 0.084 0.174 ↓ 1.1 132 1

Hash (cost=4.20..4.20 rows=120 width=4) (actual time=0.174..0.174 rows=132 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
5. 0.090 0.090 ↓ 1.1 132 1

Seq Scan on pg_index i (cost=0.00..4.20 rows=120 width=4) (actual time=0.006..0.090 rows=132 loops=1)

6. 0.011 0.032 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=68) (actual time=0.032..0.032 rows=6 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
7. 0.021 0.021 ↑ 1.0 6 1

Seq Scan on pg_namespace n (cost=0.00..1.06 rows=6 width=68) (actual time=0.014..0.021 rows=6 loops=1)

Planning time : 0.707 ms
Execution time : 0.770 ms