explain.depesz.com

PostgreSQL's explain analyze made readable

Result: k5ex

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

Sort (cost=30,464.97..30,628.21 rows=65,296 width=32) (actual rows= loops=)

  • Sort Key: ((((n.nspname)::text || '.'::text) || (c.relname)::text))
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=30.94..25,243.02 rows=65,296 width=32) (actual rows= loops=)

  • Hash Cond: (c.relnamespace = n.oid)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.29..24,387.48 rows=65,296 width=68) (actual rows= loops=)

  • Hash Cond: (c.relowner = pg_authid.oid)
4. 0.000 0.000 ↓ 0.0

Seq Scan on pg_class c (cost=0.00..24,158.90 rows=65,296 width=72) (actual rows= loops=)

  • Filter: (relkind = ANY ('{r,""}'::"char"[]))
5. 0.000 0.000 ↓ 0.0

Hash (cost=1.13..1.13 rows=13 width=4) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on pg_authid (cost=0.00..1.13 rows=13 width=4) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=23.73..23.73 rows=473 width=68) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

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