explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ddu

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 60,001.290 ↑ 8.3 7 1

Nested Loop (cost=1.14..18.32 rows=58 width=128) (actual time=60,001.262..60,001.290 rows=7 loops=1)

  • Output: n.nspname, c.relname
  • Buffers: shared hit=13
2. 60,001.067 60,001.067 ↑ 1.0 1 1

Function Scan on pg_catalog.pg_sleep (cost=0.00..0.01 rows=1 width=0) (actual time=60,001.066..60,001.067 rows=1 loops=1)

  • Output: pg_sleep.pg_sleep
  • Function Call: pg_sleep('60'::double precision)
3. 0.027 0.216 ↑ 8.3 7 1

Hash Join (cost=1.14..17.73 rows=58 width=128) (actual time=0.190..0.216 rows=7 loops=1)

  • Output: c.relname, n.nspname
  • Inner Unique: true
  • Hash Cond: (c.relnamespace = n.oid)
  • Buffers: shared hit=13
4. 0.174 0.174 ↑ 1.0 69 1

Seq Scan on pg_catalog.pg_class c (cost=0.00..16.27 rows=69 width=72) (actual time=0.020..0.174 rows=69 loops=1)

  • Output: c.relname, c.relnamespace, c.reltype, c.reloftype, c.relowner, c.relam, c.relfilenode, c.reltablespace, c.relpages, c.reltuples, c.relallvisible, c.reltoastrelid, c.relhasindex, c.relisshared, c.relpersistence, c.relkind, c.relnatts, c.relchecks, c.relhasoids, c.relhasrules, c.relhastriggers, c.relhassubclass, c.relrowsecurity, c.relforcerowsecurity, c.relispopulated, c.relreplident, c.relispartition, c.relrewrite, c.relfrozenxid, c.relminmxid, c.relacl, c.reloptions, c.relpartbound
  • Filter: (c.relkind = ANY ('{r,p}'::"char"[]))
  • Rows Removed by Filter: 273
  • Buffers: shared hit=12
5. 0.005 0.015 ↑ 1.0 5 1

Hash (cost=1.07..1.07 rows=5 width=68) (actual time=0.015..0.015 rows=5 loops=1)

  • Output: n.nspname, n.oid
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
6. 0.010 0.010 ↑ 1.0 5 1

Seq Scan on pg_catalog.pg_namespace n (cost=0.00..1.07 rows=5 width=68) (actual time=0.007..0.010 rows=5 loops=1)

  • Output: n.nspname, n.oid
  • Filter: (n.nspname <> 'pg_catalog'::name)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1
Planning time : 0.338 ms
Execution time : 60,002.038 ms