explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5czj

Settings
# exclusive inclusive rows x rows loops node
1. 0.035 0.064 ↑ 1.0 1 1

Result (cost=2.84..4.86 rows=1 width=1) (actual time=0.064..0.064 rows=1 loops=1)

  • Output: true
  • One-Time Filter: (current_database() = 'aspdata'::name)
  • Buffers: shared hit=19
2.          

Initplan (forResult)

3. 0.008 0.008 ↑ 1.0 1 1

Index Scan using pg_namespace_nspname_index on pg_catalog.pg_namespace (cost=0.27..2.29 rows=1 width=4) (actual time=0.007..0.008 rows=1 loops=1)

  • Output: pg_namespace.oid
  • Index Cond: (pg_namespace.nspname = '1b9fa2655bda4386b543c836e06f6782'::name)
  • Buffers: shared hit=3
4. 0.021 0.021 ↑ 1.0 1 1

Index Scan using pg_class_relname_nsp_index on pg_catalog.pg_class (cost=2.84..4.86 rows=1 width=1) (actual time=0.021..0.021 rows=1 loops=1)

  • Output: pg_class.relname, pg_class.relnamespace, pg_class.reltype, pg_class.reloftype, pg_class.relowner, pg_class.relam, pg_class.relfilenode, pg_class.reltablespace, pg_class.relpages, pg_class.reltuples, pg_class.relallvisible, pg_class.reltoastrelid, pg_class.relhasindex, pg_class.relisshared, pg_class.relpersistence, pg_class.relkind, pg_class.relnatts, pg_class.relchecks, pg_class.relhasoids, pg_class.relhaspkey, pg_class.relhasrules, pg_class.relhastriggers, pg_class.relhassubclass, pg_class.relrowsecurity, pg_class.relforcerowsecurity, pg_class.relispopulated, pg_class.relreplident, pg_class.relfrozenxid, pg_class.relminmxid, pg_class.relacl, pg_class.reloptions
  • Index Cond: ((pg_class.relname = 'usersessionserverstatus'::name) AND (pg_class.relnamespace = $0))
  • Filter: (pg_class.relkind = 'r'::"char")
  • Buffers: shared hit=8