explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yVpy

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 0.262 ↑ 7.5 4 1

Sort (cost=29.77..29.85 rows=30 width=224) (actual time=0.262..0.262 rows=4 loops=1)

  • Sort Key: n.nspname, c.relname
  • Sort Method: quicksort Memory: 26kB
  • Buffers: shared hit=12
2. 0.037 0.240 ↑ 7.5 4 1

Hash Join (cost=1.14..29.04 rows=30 width=224) (actual time=0.057..0.240 rows=4 loops=1)

  • Hash Cond: (c.relnamespace = n.oid)
  • Buffers: shared hit=12
3. 0.179 0.179 ↓ 1.9 114 1

Seq Scan on pg_class c (cost=0.00..26.62 rows=60 width=73) (actual time=0.018..0.179 rows=114 loops=1)

  • Filter: ((relkind = ANY ('{r,p,v,m,S,f,""}'::"char"[])) AND pg_table_is_visible(oid))
  • Rows Removed by Filter: 243
  • Buffers: shared hit=11
4. 0.004 0.024 ↑ 1.5 2 1

Hash (cost=1.10..1.10 rows=3 width=68) (actual time=0.024..0.024 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
5. 0.020 0.020 ↑ 1.5 2 1

Seq Scan on pg_namespace n (cost=0.00..1.10 rows=3 width=68) (actual time=0.015..0.020 rows=2 loops=1)

  • Filter: ((nspname <> 'pg_catalog'::name) AND (nspname <> 'information_schema'::name) AND (nspname !~ '^pg_toast'::text))
  • Rows Removed by Filter: 4
  • Buffers: shared hit=1