explain.depesz.com

PostgreSQL's explain analyze made readable

Result: k64N : IRIS 2 - with offer

Settings
# exclusive inclusive rows x rows loops node
1. 101.643 417.710 ↓ 2.5 109,363 1

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

  • Workers Planned: 4
  • Workers Launched: 4
2. 208.759 316.067 ↓ 2.0 21,873 5 / 5

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

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

4. 0.175 0.629 ↑ 1.0 315 5 / 5

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 78kB
5. 0.454 0.454 ↑ 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.132..0.454 rows=315 loops=5)

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