explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vAGL

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.221 810.403 ↑ 1.0 1 1

Aggregate (cost=48,971.38..48,971.39 rows=1 width=8) (actual time=810.403..810.403 rows=1 loops=1)

  • Output: count(DISTINCT gebeurteni0_.id)
2. 0.085 810.182 ↓ 500.0 500 1

Nested Loop (cost=29,556.63..48,971.38 rows=1 width=8) (actual time=32.198..810.182 rows=500 loops=1)

  • Output: gebeurteni0_.id
3. 1.210 799.315 ↓ 1,797.0 1,797 1

Nested Loop (cost=29,556.20..48,970.21 rows=1 width=16) (actual time=32.074..799.315 rows=1,797 loops=1)

  • Output: gebeurteni0_.id, aclobjecti1_.id
  • Inner Unique: true
4. 1.436 792.714 ↓ 1,797.0 1,797 1

Nested Loop (cost=29,555.77..48,965.38 rows=1 width=8) (actual time=32.039..792.714 rows=1,797 loops=1)

  • Output: gebeurteni0_.id
5. 7.635 771.511 ↓ 179.7 1,797 1

Nested Loop (cost=29,555.33..48,924.96 rows=10 width=16) (actual time=32.002..771.511 rows=1,797 loops=1)

  • Output: gebeurteni0_.id, aclobjecti4_.id
6. 6.466 262.765 ↓ 143.8 38,547 1

Nested Loop (cost=29,554.90..48,567.42 rows=268 width=16) (actual time=30.379..262.765 rows=38,547 loops=1)

  • Output: projectfas3_.id, aclobjecti4_.id
7. 28.405 189.387 ↓ 11.1 11,152 1

Merge Join (cost=29,554.47..47,616.74 rows=1,003 width=24) (actual time=30.357..189.387 rows=11,152 loops=1)

  • Output: aclobjecti4_.object_id_identity, aclobjecti4_.id, hoedanighe6_.td_project_id
  • Merge Cond: (aclobjecti4_.object_id_identity = hoedanighe6_.td_project_id)
8. 127.967 127.967 ↑ 1.0 276,704 1

Index Scan using idx_acl_object_identity_project on omv.acl_object_identity aclobjecti4_ (cost=0.42..89,492.29 rows=280,124 width=16) (actual time=0.021..127.967 rows=276,704 loops=1)

  • Output: aclobjecti4_.id, aclobjecti4_.object_id_class, aclobjecti4_.object_id_identity, aclobjecti4_.parent_object, aclobjecti4_.owner_sid, aclobjecti4_.entries_inheriting, aclobjecti4_.ct_update
9. 6.178 33.015 ↓ 1.1 11,152 1

Sort (cost=29,554.02..29,579.25 rows=10,095 width=8) (actual time=30.299..33.015 rows=11,152 loops=1)

  • Output: hoedanighe6_.td_project_id
  • Sort Key: hoedanighe6_.td_project_id
  • Sort Method: quicksort Memory: 907kB
10. 25.132 26.837 ↓ 1.1 11,152 1

Bitmap Heap Scan on omv.tr_hoedanigheid hoedanighe6_ (cost=240.22..28,882.63 rows=10,095 width=8) (actual time=3.070..26.837 rows=11,152 loops=1)

  • Output: hoedanighe6_.td_project_id
  • Recheck Cond: (hoedanighe6_.td_persoon_id = '11017'::bigint)
  • Filter: (((hoedanighe6_.datum_tot > '2020-03-25'::date) OR (hoedanighe6_.datum_tot IS NULL)) AND (hoedanighe6_.datum_van <= '2020-03-25'::date))
  • Heap Blocks: exact=9926
11. 1.705 1.705 ↓ 1.1 11,152 1

Bitmap Index Scan on idx_tr_hoedanigheid_td_persoon_id (cost=0.00..237.69 rows=10,302 width=0) (actual time=1.704..1.705 rows=11,152 loops=1)

  • Index Cond: (hoedanighe6_.td_persoon_id = '11017'::bigint)
12. 66.912 66.912 ↑ 1.0 3 11,152

Index Scan using idx_tr_projectfase_td_project_id on omv.tr_projectfase projectfas3_ (cost=0.42..0.92 rows=3 width=16) (actual time=0.003..0.006 rows=3 loops=11,152)

  • Output: projectfas3_.id, projectfas3_.uuid, projectfas3_.td_project_id, projectfas3_.tp_fase_id, projectfas3_.dt_start, projectfas3_.dt_eind, projectfas3_.dt_uitersteeinde, projectfas3_.dt_verwachteinde, projectfas3_.definitief, projectfas3_.actief, projectfas3_.ts_creatie, projectfas3_.ts_modificatie, projectfas3_.ct_update, projectfas3_.permanent_uuid, projectfas3_.dt_uiterstebesluit
  • Index Cond: (projectfas3_.td_project_id = aclobjecti4_.object_id_identity)
13. 501.111 501.111 ↓ 0.0 0 38,547

Index Scan using idx_td_gebeurtenis_tr_projectfase_id on omv.td_gebeurtenis gebeurteni0_ (cost=0.43..1.32 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=38,547)

  • Output: gebeurteni0_.id, gebeurteni0_.uuid, gebeurteni0_.datum, gebeurteni0_.td_datablokinhoud_id, gebeurteni0_.tr_projectfase_id, gebeurteni0_.tr_hoedanigheid_id, gebeurteni0_.tp_gebeurtenis_id, gebeurteni0_.registratietijdstip, gebeurteni0_.td_vraag_gebeurtenis_id, gebeurteni0_.tp_gebeurtenis_bericht_status_id, gebeurteni0_.tp_gebeurtenisstatus_id, gebeurteni0_.td_dossier_id, gebeurteni0_.groep_uuid, gebeurteni0_.ts_creatie, gebeurteni0_.ts_modificatie, gebeurteni0_.ct_update, gebeurteni0_.permanent_uuid
  • Index Cond: (gebeurteni0_.tr_projectfase_id = projectfas3_.id)
  • Filter: ((gebeurteni0_.registratietijdstip >= '2020-03-20 00:00:00'::timestamp without time zone) AND (gebeurteni0_.registratietijdstip <= '2020-03-25 23:59:59.999'::timestamp without time zone))
  • Rows Removed by Filter: 9
14. 19.767 19.767 ↑ 1.0 1 1,797

Index Scan using idx_acl_entry_acl_object_identity on omv.acl_entry aclentry5_ (cost=0.44..4.03 rows=1 width=8) (actual time=0.009..0.011 rows=1 loops=1,797)

  • Output: aclentry5_.id, aclentry5_.acl_object_identity, aclentry5_.ace_order, aclentry5_.sid, aclentry5_.mask, aclentry5_.granting, aclentry5_.audit_success, aclentry5_.audit_failure, aclentry5_.ct_update
  • Index Cond: (aclentry5_.acl_object_identity = aclobjecti4_.id)
  • Filter: (aclentry5_.granting AND (aclentry5_.sid = '11017'::bigint))
  • Rows Removed by Filter: 16
15. 5.391 5.391 ↑ 1.0 1 1,797

Index Scan using idx_acl_object_identity_gebeurtenis on omv.acl_object_identity aclobjecti1_ (cost=0.43..4.84 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=1,797)

  • Output: aclobjecti1_.id, aclobjecti1_.object_id_class, aclobjecti1_.object_id_identity, aclobjecti1_.parent_object, aclobjecti1_.owner_sid, aclobjecti1_.entries_inheriting, aclobjecti1_.ct_update
  • Index Cond: (aclobjecti1_.object_id_identity = gebeurteni0_.id)
16. 10.782 10.782 ↓ 0.0 0 1,797

Index Scan using idx_acl_entry_acl_object_identity on omv.acl_entry aclentry2_ (cost=0.44..1.15 rows=1 width=8) (actual time=0.005..0.006 rows=0 loops=1,797)

  • Output: aclentry2_.id, aclentry2_.acl_object_identity, aclentry2_.ace_order, aclentry2_.sid, aclentry2_.mask, aclentry2_.granting, aclentry2_.audit_success, aclentry2_.audit_failure, aclentry2_.ct_update
  • Index Cond: (aclentry2_.acl_object_identity = aclobjecti1_.id)
  • Filter: (aclentry2_.granting AND (aclentry2_.sid = '11017'::bigint))
  • Rows Removed by Filter: 5
Planning time : 14.125 ms
Execution time : 810.543 ms