explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1I4q

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

GroupAggregate (cost=6.91..7.00 rows=1 width=284) (actual rows= loops=)

  • Group Key: c.oid, n.nspname, c.relname
2. 0.000 0.000 ↓ 0.0

Sort (cost=6.91..6.91 rows=1 width=136) (actual rows= loops=)

  • Sort Key: c.oid
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..6.90 rows=1 width=136) (actual rows= loops=)

  • Join Filter: (c.relnamespace = n.oid)
4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.42..5.78 rows=1 width=76) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using pg_class_relname_nsp_index on pg_class c (cost=0.27..2.49 rows=1 width=72) (actual rows= loops=)

  • Index Cond: (relname = 'demo'::name)
  • Filter: (relkind = ANY ('{r,t,m}'::"char"[]))
6. 0.000 0.000 ↓ 0.0

Index Scan using pg_index_indrelid_index on pg_index i (cost=0.14..3.26 rows=2 width=8) (actual rows= loops=)

  • Index Cond: (c.oid = indrelid)
7. 0.000 0.000 ↓ 0.0

Seq Scan on pg_namespace n (cost=0.00..1.10 rows=1 width=68) (actual rows= loops=)

  • Filter: ((nspname <> ALL ('{pg_catalog,information_schema}'::name[])) AND (nspname !~ '^pg_toast'::text) AND (nspname = 'vacuum'::name))