explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QWgg

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 3,747.094 ↑ 1.0 1 1

Finalize Aggregate (cost=519,106.66..519,106.67 rows=1 width=8) (actual time=3,747.094..3,747.094 rows=1 loops=1)

2. 59.663 3,791.883 ↓ 1.5 3 1

Gather (cost=519,106.45..519,106.66 rows=2 width=8) (actual time=3,746.925..3,791.883 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 160.124 3,732.220 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=518,106.45..518,106.46 rows=1 width=8) (actual time=3,732.219..3,732.220 rows=1 loops=3)

4. 1,962.444 3,572.096 ↓ 18.6 1,846,823 3 / 3

Hash Join (cost=272.53..517,857.64 rows=99,525 width=0) (actual time=2.422..3,572.096 rows=1,846,823 loops=3)

  • Hash Cond: (b.beoordelings_eenheid = be.id)
5. 1,607.472 1,607.472 ↑ 1.2 7,763,063 3 / 3

Parallel Seq Scan on beoordeling b (cost=0.00..480,201.27 rows=9,703,627 width=8) (actual time=0.026..1,607.472 rows=7,763,063 loops=3)

6. 0.021 2.180 ↑ 19.2 5 3 / 3

Hash (cost=271.33..271.33 rows=96 width=8) (actual time=2.180..2.180 rows=5 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.010 2.159 ↑ 19.2 5 3 / 3

Nested Loop (cost=195.64..271.33 rows=96 width=8) (actual time=2.129..2.159 rows=5 loops=3)

8. 0.108 0.108 ↑ 1.0 1 3 / 3

Index Only Scan using org_organisatie_pkey on org_organisatie so (cost=0.29..8.30 rows=1 width=8) (actual time=0.106..0.108 rows=1 loops=3)

  • Index Cond: (id = 60096047)
  • Heap Fetches: 3
9. 0.406 2.041 ↑ 19.2 5 3 / 3

Merge Join (cost=195.36..262.07 rows=96 width=16) (actual time=2.015..2.041 rows=5 loops=3)

  • Merge Cond: (be.parent = ce.id)
10. 0.999 0.999 ↑ 19.1 490 3 / 3

Index Scan using idx_d21c031ac4ab08aa on org_organisatie be (cost=0.29..1,147.85 rows=9,360 width=16) (actual time=0.066..0.999 rows=490 loops=3)

11. 0.131 0.636 ↑ 1.0 96 3 / 3

Sort (cost=195.07..195.31 rows=96 width=16) (actual time=0.619..0.636 rows=96 loops=3)

  • Sort Key: ce.id
  • Sort Method: quicksort Memory: 29kB
  • Worker 0: Sort Method: quicksort Memory: 29kB
  • Worker 1: Sort Method: quicksort Memory: 29kB
12. 0.440 0.505 ↑ 1.0 96 3 / 3

Bitmap Heap Scan on org_organisatie ce (cost=5.03..191.91 rows=96 width=16) (actual time=0.090..0.505 rows=96 loops=3)

  • Recheck Cond: (regio = 60096047)
  • Heap Blocks: exact=29
13. 0.065 0.065 ↑ 1.0 96 3 / 3

Bitmap Index Scan on idx_d21c031a675f0ba (cost=0.00..5.00 rows=96 width=0) (actual time=0.065..0.065 rows=96 loops=3)

  • Index Cond: (regio = 60096047)
Planning time : 1.500 ms
Execution time : 3,792.042 ms