explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ex6t

Settings
# exclusive inclusive rows x rows loops node
1. 0.051 5.417 ↑ 1.0 1 1

Aggregate (cost=3,315.29..3,315.30 rows=1 width=8) (actual time=5.416..5.417 rows=1 loops=1)

2. 0.000 5.366 ↓ 0.0 0 1

Nested Loop (cost=2.98..3,315.29 rows=1 width=8) (actual time=5.366..5.366 rows=0 loops=1)

  • Join Filter: ((gebeurteni3_.veiligheidscategorie <= hoedanighe10_.veiligheidscategorie) AND (hoedanighe9_.tp_hoedanigheid_id = hoedanighe10_.id))
3. 0.000 5.366 ↓ 0.0 0 1

Nested Loop (cost=2.98..3,312.26 rows=1 width=20) (actual time=5.366..5.366 rows=0 loops=1)

4. 0.001 5.366 ↓ 0.0 0 1

Nested Loop (cost=2.56..3,311.58 rows=1 width=36) (actual time=5.366..5.366 rows=0 loops=1)

5. 0.001 5.354 ↑ 1.0 1 1

Nested Loop (cost=2.14..3,310.95 rows=1 width=44) (actual time=0.346..5.354 rows=1 loops=1)

6. 0.002 5.341 ↑ 1.0 1 1

Nested Loop (cost=1.71..3,303.43 rows=1 width=36) (actual time=0.333..5.341 rows=1 loops=1)

  • Join Filter: ((project2_.parameterversie < 58) OR ((project2_.parameterversie >= 58) AND ((gebeurteni3_.code)::text <> ALL ('{BEVESTIGEN_WIJZIGINGSVERZOEK,GEVEN_EXTRA_INFORMATIE,VERWERPEN_WIJZIGINGSVERZOEK}'::text[]))))
7. 0.004 5.330 ↑ 1.0 1 1

Nested Loop (cost=1.42..3,303.03 rows=1 width=58) (actual time=0.322..5.330 rows=1 loops=1)

  • Join Filter: (gebeurteni0_.tp_gebeurtenis_id = gebeurteni3_.id)
  • Rows Removed by Join Filter: 9
8. 0.177 5.312 ↑ 1.0 1 1

Nested Loop (cost=1.42..3,290.36 rows=1 width=32) (actual time=0.304..5.312 rows=1 loops=1)

9. 0.620 2.779 ↓ 8.3 589 1

Nested Loop (cost=1.00..3,237.09 rows=71 width=40) (actual time=0.045..2.779 rows=589 loops=1)

10. 0.151 1.570 ↓ 1.4 589 1

Nested Loop (cost=0.71..3,034.23 rows=407 width=24) (actual time=0.033..1.570 rows=589 loops=1)

11. 0.241 0.241 ↓ 1.4 589 1

Index Scan using idx_gebeurtenis__registratietijdstip on td_gebeurtenis gebeurteni0_ (cost=0.42..584.06 rows=407 width=24) (actual time=0.022..0.241 rows=589 loops=1)

  • Index Cond: ((registratietijdstip >= '2020-09-01 00:00:00'::timestamp without time zone) AND (registratietijdstip <= '2020-09-02 00:00:00'::timestamp without time zone))
12. 1.178 1.178 ↑ 1.0 1 589

Index Scan using pk_tr_projectfase on tr_projectfase projectfas1_ (cost=0.29..6.02 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=589)

  • Index Cond: (id = gebeurteni0_.tr_projectfase_id)
13. 0.589 0.589 ↑ 1.0 1 589

Index Scan using idx_acl_object_identity_project on acl_object_identity aclobjecti7_ (cost=0.29..0.50 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=589)

  • Index Cond: (object_id_identity = projectfas1_.td_project_id)
14. 0.000 2.356 ↓ 0.0 0 589

Append (cost=0.42..0.74 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=589)

15. 2.356 2.356 ↓ 0.0 0 589

Index Scan using acl_entry_project_acl_object_identity_idx on acl_entry_project aclentry8_ (cost=0.42..0.74 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=589)

  • Index Cond: (acl_object_identity = aclobjecti7_.id)
  • Filter: (granting AND (object_id_class = 4) AND (sid = 10,001))
  • Rows Removed by Filter: 6
16. 0.014 0.014 ↑ 16.3 10 1

Seq Scan on tp_gebeurtenis gebeurteni3_ (cost=0.00..10.63 rows=163 width=42) (actual time=0.013..0.014 rows=10 loops=1)

17. 0.009 0.009 ↑ 1.0 1 1

Index Scan using pk_td_project on td_project project2_ (cost=0.29..0.38 rows=1 width=12) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (id = projectfas1_.td_project_id)
  • Filter: ((parameterversie < 58) OR (parameterversie >= 58))
18. 0.012 0.012 ↑ 1.0 1 1

Index Scan using idx_acl_object_identity_gebeurtenis on acl_object_identity aclobjecti4_ (cost=0.42..7.52 rows=1 width=16) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: (object_id_identity = gebeurteni0_.id)
19. 0.001 0.011 ↓ 0.0 0 1

Append (cost=0.42..0.63 rows=1 width=8) (actual time=0.011..0.011 rows=0 loops=1)

20. 0.010 0.010 ↓ 0.0 0 1

Index Scan using acl_entry_gebeurtenis_acl_object_identity_idx on acl_entry_gebeurtenis aclentry5_ (cost=0.42..0.62 rows=1 width=8) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (acl_object_identity = aclobjecti4_.id)
  • Filter: (granting AND (object_id_class = 3) AND (sid = 10,001))
  • Rows Removed by Filter: 1
21. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_hoedanigheid__td_project_id_td_persoon_id on tr_hoedanigheid hoedanighe9_ (cost=0.42..0.67 rows=1 width=16) (never executed)

  • Index Cond: ((td_project_id = projectfas1_.td_project_id) AND (td_persoon_id = 10,001))
  • Filter: (((datum_tot > '2020-09-02'::date) OR (datum_tot IS NULL)) AND (datum_van <= '2020-09-02'::date))
22. 0.000 0.000 ↓ 0.0 0

Seq Scan on tp_hoedanigheid hoedanighe10_ (cost=0.00..2.41 rows=41 width=12) (never executed)

Planning time : 11.353 ms
Execution time : 5.638 ms