explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 79mB : Optimization for: plan #cHGC

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.003 0.480 ↑ 1.0 1 1

Aggregate (cost=288.80..288.81 rows=1 width=8) (actual time=0.479..0.480 rows=1 loops=1)

2. 0.477 0.477 ↓ 0.0 0 1

Seq Scan on jobs (cost=0.00..288.80 rows=1 width=0) (actual time=0.476..0.477 rows=0 loops=1)

  • Filter: (region = 'EU'::text)
  • Rows Removed by Filter: 384
Planning time : 0.091 ms