explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QSJU : donderdag

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.016 0.055 ↓ 0.0 0 1

Sort (cost=34.69..34.70 rows=4 width=168) (actual time=0.055..0.055 rows=0 loops=1)

  • Sort Key: *SELECT* 1.knooppunt_volgnummer
  • Sort Method: quicksort Memory: 25kB
2. 0.002 0.039 ↓ 0.0 0 1

HashAggregate (cost=34.57..34.61 rows=4 width=168) (actual time=0.039..0.039 rows=0 loops=1)

  • Group Key: ('element_naam'::text), *SELECT* 1.element_id, *SELECT* 1.element_loggen_indicatie, *SELECT* 1.vastleggen_acceptatie_toets_indicatie, *SELECT* 1.element_type_code, *SELECT* 1.element_waarde, *SELECT* 1.knooppunt_volgnummer
3. 0.000 0.037 ↓ 0.0 0 1

Append (cost=19.90..34.50 rows=4 width=168) (actual time=0.037..0.037 rows=0 loops=1)

4. 0.001 0.035 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1 (cost=19.90..19.99 rows=3 width=96) (actual time=0.035..0.035 rows=0 loops=1)

5. 0.000 0.034 ↓ 0.0 0 1

Group (cost=19.90..19.96 rows=3 width=96) (actual time=0.034..0.034 rows=0 loops=1)

  • Group Key: e2.element_id, 'element_naam'::text, be.element_loggen_indicatie, be.vastleggen_acceptatie_toets_indicatie, bl.knooppunt_volgnummer, bl.element_waarde, bl.element_type_code
6. 0.029 0.034 ↓ 0.0 0 1

Sort (cost=19.90..19.90 rows=3 width=96) (actual time=0.033..0.034 rows=0 loops=1)

  • Sort Key: e2.element_id, be.element_loggen_indicatie, be.vastleggen_acceptatie_toets_indicatie, bl.knooppunt_volgnummer, bl.element_waarde, bl.element_type_code
  • Sort Method: quicksort Memory: 25kB
7. 0.001 0.005 ↓ 0.0 0 1

Nested Loop (cost=1.90..19.87 rows=3 width=96) (actual time=0.005..0.005 rows=0 loops=1)

8. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on beslisboom_log bl (cost=0.00..16.00 rows=1 width=56) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (((element_waarde)::text <> '2'::text) AND (beslisboom_log_volgnummer = 1) AND (((element_naam)::text ~~ 'element_naam'::text) OR ((element_naam)::text ~~ 'element_naam-'::text)))
9. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1.90..3.84 rows=3 width=8) (never executed)

  • Hash Cond: (e2.element_id = be.element_id)
10. 0.000 0.000 ↓ 0.0 0

Seq Scan on beslisboom_element e2 (cost=0.00..1.72 rows=72 width=4) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.89..1.89 rows=1 width=8) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Index Scan using beslisboom_element_pkey on beslisboom_element be (cost=0.14..1.89 rows=1 width=8) (never executed)

  • Index Cond: (beslisboom_id = '1'::bpchar)
  • Filter: ((element_loggen_indicatie = 'y'::bpchar) OR (vastleggen_acceptatie_toets_indicatie = 'y'::bpchar))
13. 0.001 0.002 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=0.00..14.51 rows=1 width=148) (actual time=0.001..0.002 rows=0 loops=1)

14. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on beslisboom_log bl_1 (cost=0.00..14.50 rows=1 width=148) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((beslisboom_log_volgnummer = 2) AND ((element_naam)::text = 'geen'::text))
Planning time : 0.964 ms
Execution time : 0.288 ms