explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oeR2

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

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

  • One-Time Filter: (current_database() = 'aspdata'::name)
2.          

Initplan (forResult)

3. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (nspname = '1b9fa2655bda4386b543c836e06f6782'::name)
4. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ((relname = 'usersessionserverstatus'::name) AND (relnamespace = $0))
  • Filter: (relkind = 'r'::"char")