explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BVwE

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.040 ↑ 1.0 2 1

Unique (cost=1.05..1.07 rows=2 width=4) (actual time=0.038..0.040 rows=2 loops=1)

2. 0.036 0.036 ↑ 1.0 2 1

Sort (cost=1.05..1.06 rows=2 width=4) (actual time=0.036..0.036 rows=2 loops=1)

3. 0.013 0.013 ↑ 1.0 2 1

Append (cost=0.00..1.04 rows=2 width=4) (actual time=0.010..0.013 rows=2 loops=1)

4. 0.010 0.010 ↑ 1.0 1 1

Seq Scan on extract_jobs (cost=0.00..1.01 rows=1 width=8) (actual time=0.009..0.010 rows=1 loops=1)

  • Filter: ((job_name)::text = 'evolve'::text)
5. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.001 rows=1 loops=1)

Planning time : 0.052 ms
Execution time : 0.059 ms