explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 03D1 : 1

Settings
# exclusive inclusive rows x rows loops node
1. 0.062 0.253 ↓ 1.1 77 1

Hash Left Join (cost=2.18..18.49 rows=69 width=260) (actual time=0.057..0.253 rows=77 loops=1)

  • Output: n.nspname, c.relname, pg_get_userbyid(c.relowner), t.spcname, c.relhasindex, c.relhasrules, c.relhastriggers, c.relrowsecurity
  • Inner Unique: true
  • Hash Cond: (c.reltablespace = t.oid)
  • Buffers: shared hit=13
2. 0.063 0.185 ↓ 1.1 77 1

Hash Left Join (cost=1.14..16.71 rows=69 width=140) (actual time=0.041..0.185 rows=77 loops=1)

  • Output: c.relname, c.relowner, c.relhasindex, c.relhasrules, c.relhastriggers, c.relrowsecurity, c.reltablespace, n.nspname
  • Inner Unique: true
  • Hash Cond: (c.relnamespace = n.oid)
  • Buffers: shared hit=12
3. 0.109 0.109 ↓ 1.1 77 1

Seq Scan on pg_catalog.pg_class c (cost=0.00..15.26 rows=69 width=80) (actual time=0.012..0.109 rows=77 loops=1)

  • Output: c.relname, c.relnamespace, c.reltype, c.reloftype, c.relowner, c.relam, c.relfilenode, c.reltablespace, c.relpages, c.reltuples, c.relallvisible, c.reltoastrelid, c.relhasindex, c.relisshared, c.relpersistence, c.relkind, c.relnatts, c.relchecks, c.relhasoids, c.relhaspkey, c.relhasrules, c.relhastriggers, c.relhassubclass, c.relrowsecurity, c.relforcerowsecurity, c.relispopulated, c.relreplident, c.relispartition, c.relfrozenxid, c.relminmxid, c.relacl, c.reloptions, c.relpartbound
  • Filter: (c.relkind = ANY ('{r,p}'::"char"[]))
  • Rows Removed by Filter: 296
  • Buffers: shared hit=11
4. 0.007 0.013 ↓ 1.2 7 1

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

  • Output: n.nspname, n.oid
  • Buckets: 1024 Batches: 1 Memory Usage: 5kB
  • Buffers: shared hit=1
5. 0.006 0.006 ↓ 1.2 7 1

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

  • Output: n.nspname, n.oid
  • Buffers: shared hit=1
6. 0.002 0.006 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=68) (actual time=0.006..0.006 rows=2 loops=1)

  • Output: t.spcname, t.oid
  • Buckets: 1024 Batches: 1 Memory Usage: 5kB
  • Buffers: shared hit=1
7. 0.004 0.004 ↑ 1.0 2 1

Seq Scan on pg_catalog.pg_tablespace t (cost=0.00..1.02 rows=2 width=68) (actual time=0.003..0.004 rows=2 loops=1)

  • Output: t.spcname, t.oid
  • Buffers: shared hit=1
Planning time : 0.223 ms
Execution time : 0.352 ms