explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yPfJ

Settings
# exclusive inclusive rows x rows loops node
1. 15,627.463 15,627.517 ↑ 1.0 1 1

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

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

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

3. 0.002 0.029 ↑ 1.0 1 1

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

4. 0.018 0.018 ↑ 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.013..0.018 rows=1 loops=1)

  • Index Cond: (proname = 'cpm_sp_v21_release'::name)
  • Filter: (prokind = 'p'::"char")
5. 0.009 0.009 ↑ 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.009..0.009 rows=1 loops=1)

  • Index Cond: (oid = p.prorettype)
  • Heap Fetches: 0
6. 0.005 0.005 ↓ 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.005..0.005 rows=0 loops=1)

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

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

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