explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wxNl

Settings
# exclusive inclusive rows x rows loops node
1. 15,525.329 15,525.389 ↑ 1.0 1 1

Nested Loop (cost=0.84..22.25 rows=1 width=32) (actual time=15,525.383..15,525.389 rows=1 loops=1)

  • Join Filter: (p.pronamespace = n.oid)
2. 0.001 0.044 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.84..20.91 rows=1 width=8) (actual time=0.039..0.044 rows=1 loops=1)

3. 0.003 0.037 ↑ 1.0 1 1

Nested Loop (cost=0.56..16.60 rows=1 width=8) (actual time=0.032..0.037 rows=1 loops=1)

4. 0.026 0.026 ↑ 1.0 1 1

Index Scan using pg_proc_proname_args_nsp_index on pg_proc p (cost=0.28..8.30 rows=1 width=12) (actual time=0.022..0.026 rows=1 loops=1)

  • Index Cond: (proname = 'cpm_sp_v21_release'::name)
  • Filter: (prokind = 'p'::"char")
5. 0.008 0.008 ↑ 1.0 1 1

Index Only Scan using pg_type_oid_index on pg_type t (cost=0.28..8.30 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (oid = p.prorettype)
  • Heap Fetches: 0
6. 0.006 0.006 ↓ 0.0 0 1

Index Only Scan using pg_description_o_c_o_index on pg_description d (cost=0.28..4.30 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (objoid = p.oid)
  • Heap Fetches: 0
7. 0.016 0.016 ↑ 1.0 1 1

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

  • Filter: (nspname ~ 'public'::text)
  • Rows Removed by Filter: 4