explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VDU

Settings
# exclusive inclusive rows x rows loops node
1. 48.403 801.215 ↑ 5.4 30 1

HashAggregate (cost=263,949.58..263,951.21 rows=163 width=8) (actual time=801.194..801.215 rows=30 loops=1)

  • Group Key: this_.screenings_eenheid
2. 21.393 752.812 ↓ 1.1 82,844 1

Gather (cost=1,909.64..263,753.91 rows=78,268 width=8) (actual time=38.324..752.812 rows=82,844 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 266.925 731.419 ↑ 1.2 27,615 3

Nested Loop (cost=909.64..254,927.11 rows=32,612 width=8) (actual time=30.502..731.419 rows=27,615 loops=3)

4. 36.229 464.486 ↑ 1.2 27,615 3

Hash Join (cost=909.20..238,499.49 rows=32,612 width=16) (actual time=30.448..464.486 rows=27,615 loops=3)

  • Hash Cond: (beoordelin3_.parent = centraleee4_.id)
5. 37.270 412.484 ↑ 1.2 27,615 3

Hash Join (cost=455.10..237,959.78 rows=32,612 width=24) (actual time=14.561..412.484 rows=27,615 loops=3)

  • Hash Cond: (beoordelin1_.beoordelings_eenheid = beoordelin3_.id)
6. 274.410 360.875 ↑ 1.2 27,615 3

Nested Loop (cost=1.00..237,420.03 rows=32,612 width=24) (actual time=0.151..360.875 rows=27,615 loops=3)

7. 86.457 86.457 ↑ 1.2 27,615 3

Parallel Index Scan using idx_mamma_beoordeling_status on beoordeling beoordelin1_ (cost=0.56..25,169.15 rows=32,614 width=24) (actual time=0.105..86.457 rows=27,615 loops=3)

  • Index Cond: ((status)::text = 'UITSLAG_ONGUNSTIG'::text)
  • Filter: (beoordelings_eenheid = ANY ('{363151622,363151620,363151618}'::bigint[]))
  • Rows Removed by Filter: 107718
8. 0.008 0.008 ↑ 1.0 1 82,844

Index Scan using uk_i514b8e20fu0de7ngbar2ksop on onderzoek this_ (cost=0.44..6.51 rows=1 width=24) (actual time=0.008..0.008 rows=1 loops=82,844)

  • Index Cond: (laatste_beoordeling = beoordelin1_.id)
9. 6.790 14.339 ↑ 1.0 9,249 3

Hash (cost=338.49..338.49 rows=9,249 width=16) (actual time=14.339..14.339 rows=9,249 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 494kB
10. 7.549 7.549 ↑ 1.0 9,249 3

Seq Scan on org_organisatie beoordelin3_ (cost=0.00..338.49 rows=9,249 width=16) (actual time=0.009..7.549 rows=9,249 loops=3)

11. 7.547 15.773 ↑ 1.0 9,249 3

Hash (cost=338.49..338.49 rows=9,249 width=8) (actual time=15.773..15.773 rows=9,249 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 490kB
12. 8.226 8.226 ↑ 1.0 9,249 3

Seq Scan on org_organisatie centraleee4_ (cost=0.00..338.49 rows=9,249 width=8) (actual time=0.018..8.226 rows=9,249 loops=3)

13. 0.008 0.008 ↑ 1.0 1 82,844

Index Only Scan using mammografie_pkey on mammografie mammografi2_ (cost=0.44..0.50 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=82,844)

  • Index Cond: (id = this_.mammografie)
  • Heap Fetches: 82844
Planning time : 1.350 ms
Execution time : 820.804 ms