explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j2CB

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 0.040 ↓ 0.0 0 1

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

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

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

  • Group Key: ('e.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.001 0.024 ↓ 0.0 0 1

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

4. 0.001 0.022 ↓ 0.0 0 1

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

5. 0.001 0.021 ↓ 0.0 0 1

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

  • Group Key: e.element_id, 'e.element_naam'::text, be.element_loggen_indicatie, be.vastleggen_acceptatie_toets_indicatie, bl.knooppunt_volgnummer, bl.element_waarde, bl.element_type_code
6. 0.015 0.020 ↓ 0.0 0 1

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

  • Sort Key: e.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.000 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.005 0.005 ↓ 0.0 0 1

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

  • Filter: (((element_waarde)::text <> '*undefined*'::text) AND (beslisboom_log_volgnummer = 1343131) AND (((element_naam)::text ~~* 'e.element_naam'::text) OR ((element_naam)::text ~~* 'e.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: (e.element_id = be.element_id)
10. 0.000 0.000 ↓ 0.0 0

Seq Scan on beslisboom_element e (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 = 'POLI.ACCT.AUTO.002'::bpchar)
  • Filter: ((element_loggen_indicatie = 'J'::bpchar) OR (vastleggen_acceptatie_toets_indicatie = 'J'::bpchar))
13. 0.000 0.001 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=0.00..14.51 rows=1 width=156) (actual time=0.001..0.001 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=156) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((beslisboom_log_volgnummer > 2) AND ((element_naam)::text = 'sessie_id'::text))
Planning time : 0.989 ms
Execution time : 0.260 ms