explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OSwM

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.140 ↓ 2.0 2 1

Nested Loop (cost=0.42..13.55 rows=1 width=382) (actual time=0.108..0.140 rows=2 loops=1)

  • Join Filter: (jp.ingangsdatum = jpp.ingangsdatum)
2. 0.003 0.104 ↑ 1.0 1 1

Nested Loop (cost=0.42..10.33 rows=1 width=23) (actual time=0.088..0.104 rows=1 loops=1)

  • Join Filter: (j.ingangsdatum = jp.ingangsdatum)
3. 0.039 0.039 ↑ 1.0 1 1

Index Scan using job_pkey on job j (cost=0.14..2.37 rows=1 width=9) (actual time=0.038..0.039 rows=1 loops=1)

  • Index Cond: ((cynosure_domein_code = 'POLI'::bpchar) AND (job_id = 'CDDR'::bpchar) AND (ingangsdatum <= CURRENT_DATE))
  • Filter: ((einddatum IS NULL) OR (einddatum > CURRENT_DATE))
4. 0.062 0.062 ↑ 1.0 1 1

Index Only Scan using job_proces_pkey on job_proces jp (cost=0.27..7.94 rows=1 width=14) (actual time=0.048..0.062 rows=1 loops=1)

  • Index Cond: ((job_id = 'CDDR'::bpchar) AND (proces_id = 'CDSD'::bpchar))
  • Heap Fetches: 0
5. 0.033 0.033 ↓ 2.0 2 1

Seq Scan on job_proces_parameter jpp (cost=0.00..3.21 rows=1 width=386) (actual time=0.018..0.033 rows=2 loops=1)

  • Filter: ((job_id = 'CDDR'::bpchar) AND (proces_id = 'CDSD'::bpchar) AND (parameter_groep_id = 'JOBS'::bpchar))
  • Rows Removed by Filter: 67
Planning time : 0.804 ms
Execution time : 0.235 ms