explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wLOp

Settings
# exclusive inclusive rows x rows loops node
1. 136.175 850.119 ↑ 1.0 108,887 1

Hash Join (cost=350.82..140,541.72 rows=111,631 width=1,718) (actual time=2.796..850.119 rows=108,887 loops=1)

  • Hash Cond: (offer."venueId" = venue.id)
2. 711.177 711.177 ↑ 1.0 853,413 1

Seq Scan on offer (cost=0.00..137,949.13 rows=853,413 width=1,435) (actual time=0.010..711.177 rows=853,413 loops=1)

3. 0.175 2.767 ↑ 1.0 797 1

Hash (cost=340.86..340.86 rows=797 width=283) (actual time=2.766..2.767 rows=797 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 209kB
4. 2.592 2.592 ↑ 1.0 797 1

Seq Scan on venue (cost=0.00..340.86 rows=797 width=283) (actual time=0.043..2.592 rows=797 loops=1)

  • Filter: (("departementCode")::text = ANY ('{75,77,78,91,92,93,94,95}'::text[]))
  • Rows Removed by Filter: 5296
Planning time : 0.535 ms
Execution time : 855.266 ms