explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cI1u : PostgreSQL 13 - JSON

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 0.813 ↑ 32.0 1 1

Sort (cost=32.93..33.01 rows=32 width=224) (actual time=0.812..0.813 rows=1 loops=1)

  • Sort Key: n.nspname, c.relname
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=14
2. 0.107 0.801 ↑ 32.0 1 1

Hash Join (cost=1.09..32.13 rows=32 width=224) (actual time=0.147..0.801 rows=1 loops=1)

  • Buffers: shared hit=14
3. 0.648 0.648 ↓ 2.0 130 1

Seq Scan on pg_class c (cost=0..29.89 rows=65 width=73) (actual time=0.056..0.648 rows=130 loops=1)

  • Filter: ((relkind = ANY ('{r,p,v,m,S,f,""}'::"char"[])) AND pg_table_is_visible(oid))
  • Buffers: shared hit=13
4. 0.007 0.046 ↑ 2.0 1 1

Hash (cost=1.07..1.07 rows=2 width=68) (actual time=0.045..0.046 rows=1 loops=1)

  • Buffers: shared hit=1
5. 0.039 0.039 ↑ 2.0 1 1

Seq Scan on pg_namespace n (cost=0..1.07 rows=2 width=68) (actual time=0.036..0.039 rows=1 loops=1)

  • Filter: ((nspname <> 'pg_catalog'::name) AND (nspname <> 'information_schema'::name) AND (nspname !~ '^pg_toast'::text))
  • Buffers: shared hit=1
Planning time : 0.718 ms
Execution time : 0.928 ms