explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IqG : EXPLAIN SELECT * FROM pg_class WHERE relnamespace IN ( SELECT oid FROM pg_namespace WHERE nspname='public');

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

Hash Join (cost=1.09..13.59 rows=97 width=203) (actual rows= loops=)

  • Hash Cond: (pg_class.relnamespace = pg_namespace.oid)
2. 0.000 0.000 ↓ 0.0

Seq Scan on pg_class (cost=0.00..10.92 rows=292 width=203) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=1.07..1.07 rows=1 width=4) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on pg_namespace (cost=0.00..1.07 rows=1 width=4) (actual rows= loops=)

  • Filter: (nspname = 'public'::name)