explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Mwy : Tables without a single index - JOIN order forced

Settings
# exclusive inclusive rows x rows loops node
1. 0.080 0.798 ↑ 6.6 8 1

Hash Anti Join (cost=6.83..25.67 rows=53 width=128) (actual time=0.520..0.798 rows=8 loops=1)

  • Hash Cond: (c.oid = i.indrelid)
2. 0.098 0.529 ↑ 1.0 68 1

Hash Join (cost=1.14..19.21 rows=68 width=132) (actual time=0.120..0.529 rows=68 loops=1)

  • Hash Cond: (c.relnamespace = n.oid)
3. 0.369 0.369 ↑ 1.0 68 1

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

  • Filter: (relkind = 'r'::"char")
  • Rows Removed by Filter: 264
4. 0.049 0.062 ↑ 1.0 6 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
5. 0.013 0.013 ↑ 1.0 6 1

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

6. 0.099 0.189 ↓ 1.1 132 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
7. 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.007..0.090 rows=132 loops=1)

Planning time : 0.730 ms
Execution time : 0.937 ms