explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bGrU

Settings
# exclusive inclusive rows x rows loops node
1. 0.024 0.134 ↓ 2.9 46 1

Nested Loop (cost=0.28..52.32 rows=16 width=203) (actual time=0.057..0.134 rows=46 loops=1)

2. 0.080 0.080 ↑ 1.0 2 1

Seq Scan on pg_class c (cost=0.00..11.65 rows=2 width=4) (actual time=0.043..0.080 rows=2 loops=1)

  • Filter: (relname = ANY ('{pg_class,pg_namespace}'::name[]))
  • Rows Removed by Filter: 291
3. 0.030 0.030 ↓ 2.9 23 2

Index Scan using pg_attribute_relid_attnum_index on pg_attribute a (cost=0.28..20.25 rows=8 width=203) (actual time=0.007..0.015 rows=23 loops=2)

  • Index Cond: (attrelid = c.oid)