explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1jZv : IRIS 10 - with offer

Settings
# exclusive inclusive rows x rows loops node
1. 47.120 293.983 ↓ 2.5 109,363 1

Gather (cost=1,189.99..125,954.11 rows=43,581 width=1,676) (actual time=1.313..293.983 rows=109,363 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 158.744 246.863 ↓ 2.0 21,873 5 / 5

Hash Join (cost=189.99..120,596.01 rows=10,895 width=1,676) (actual time=0.767..246.863 rows=21,873 loops=5)

  • Hash Cond: (offer."venueId" = venue.id)
3. 87.492 87.492 ↑ 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.492 rows=170,683 loops=5)

4. 0.181 0.627 ↑ 1.0 315 5 / 5

Hash (cost=186.05..186.05 rows=315 width=251) (actual time=0.627..0.627 rows=315 loops=5)

  • Buckets: 1024 Batches: 1 Memory Usage: 78kB
5. 0.446 0.446 ↑ 1.0 315 5 / 5

Index Scan using idx_venue_iris on venue (cost=0.28..186.05 rows=315 width=251) (actual time=0.106..0.446 rows=315 loops=5)

  • Index Cond: ((iris)::text = ANY ('{1000,10752}'::text[]))
Planning time : 0.635 ms
Execution time : 300.584 ms