explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PFdp : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.227 ↓ 5.0 5 1

Nested Loop (cost=0.00..46.89 rows=1 width=73) (actual time=0.185..0.227 rows=5 loops=1)

  • Join Filter: (c.relowner = n.nspowner)
2. 0.194 0.194 ↓ 5.0 5 1

Seq Scan on pg_class c (cost=0.00..45.34 rows=1 width=77) (actual time=0.171..0.194 rows=5 loops=1)

  • Filter: (relname ~~ '%cpla_national_customer%'::text)
  • Rows Removed by Filter: 1006
3. 0.025 0.025 ↑ 1.0 1 5

Seq Scan on pg_namespace n (cost=0.00..1.54 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=5)

  • Filter: (nspname = 'tpniewski'::name)
  • Rows Removed by Filter: 42
Planning time : 0.392 ms
Execution time : 0.275 ms