explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S6WL

Settings
# exclusive inclusive rows x rows loops node
1. 2,744.277 95,461.653 ↑ 5.1 32 1

HashAggregate (cost=2,461,635.94..2,461,637.57 rows=163 width=8) (actual time=95,461.631..95,461.653 rows=32 loops=1)

  • Group Key: this_.screenings_eenheid
2. 24,222.133 92,717.376 ↓ 1.0 4,435,637 1

Hash Join (cost=1,582,465.63..2,450,581.13 rows=4,421,924 width=8) (actual time=53,911.699..92,717.376 rows=4,435,637 loops=1)

  • Hash Cond: (mammografi3_.id = this_.mammografie)
3. 14,587.534 14,587.534 ↓ 1.0 23,090,750 1

Seq Scan on mammografie mammografi3_ (cost=0.00..448,832.48 rows=23,084,548 width=8) (actual time=0.010..14,587.534 rows=23,090,750 loops=1)

4. 3,193.469 53,907.709 ↓ 1.0 4,435,637 1

Hash (cost=1,505,599.58..1,505,599.58 rows=4,421,924 width=16) (actual time=53,907.708..53,907.709 rows=4,435,637 loops=1)

  • Buckets: 2097152 Batches: 4 Memory Usage: 68392kB
5. 25,137.000 50,714.240 ↓ 1.0 4,435,637 1

Hash Join (cost=591,787.84..1,505,599.58 rows=4,421,924 width=16) (actual time=9,898.578..50,714.240 rows=4,435,637 loops=1)

  • Hash Cond: (this_.laatste_beoordeling = beoordelin1_.id)
6. 15,686.618 15,686.618 ↑ 1.0 23,090,750 1

Seq Scan on onderzoek this_ (cost=0.00..565,324.88 rows=23,090,988 width=24) (actual time=0.017..15,686.618 rows=23,090,750 loops=1)

7. 3,334.007 9,890.622 ↓ 1.0 4,435,637 1

Hash (cost=519,235.44..519,235.44 rows=4,422,192 width=8) (actual time=9,890.620..9,890.622 rows=4,435,637 loops=1)

  • Buckets: 4194304 Batches: 4 Memory Usage: 76149kB
8. 6,014.999 6,556.615 ↓ 1.0 4,435,637 1

Bitmap Heap Scan on beoordeling beoordelin1_ (cost=78,541.30..519,235.44 rows=4,422,192 width=8) (actual time=686.707..6,556.615 rows=4,435,637 loops=1)

  • Recheck Cond: (beoordelings_eenheid = ANY ('{363151622,363151620,363151618}'::bigint[]))
  • Heap Blocks: exact=376796
9. 541.616 541.616 ↓ 1.0 4,435,637 1

Bitmap Index Scan on idx_8aa01da671eff274 (cost=0.00..77,435.75 rows=4,422,192 width=0) (actual time=541.615..541.616 rows=4,435,637 loops=1)

  • Index Cond: (beoordelings_eenheid = ANY ('{363151622,363151620,363151618}'::bigint[]))
Planning time : 0.896 ms
Execution time : 95,462.527 ms