explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7raO : IRIS 100 - with offer

Settings
# exclusive inclusive rows x rows loops node
1. 48.069 300.167 ↓ 2.5 109,363 1

Gather (cost=1,235.17..125,999.28 rows=43,581 width=1,676) (actual time=2.357..300.167 rows=109,363 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 163.016 252.098 ↓ 2.0 21,873 5 / 5

Hash Join (cost=235.17..120,641.18 rows=10,895 width=1,676) (actual time=1.511..252.098 rows=21,873 loops=5)

  • Hash Cond: (offer."venueId" = venue.id)
3. 87.720 87.720 ↑ 1.2 170,683 5 / 5

Parallel Seq Scan on offer (cost=0.00..119,852.43 rows=210,743 width=1,425) (actual time=0.015..87.720 rows=170,683 loops=5)

4. 0.197 1.362 ↑ 1.0 315 5 / 5

Hash (cost=231.23..231.23 rows=315 width=251) (actual time=1.362..1.362 rows=315 loops=5)

  • Buckets: 1,024 Batches: 1 Memory Usage: 78kB
5. 1.165 1.165 ↑ 1.0 315 5 / 5

Index Scan using idx_venue_iris on venue (cost=0.28..231.23 rows=315 width=251) (actual time=0.547..1.165 rows=315 loops=5)

  • Index Cond: ((iris)::text = ANY ('{900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,10752}'::text[]))
Planning time : 0.905 ms
Execution time : 305.620 ms