explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CwCb

Settings
# exclusive inclusive rows x rows loops node
1. 122.766 666.960 ↑ 2.6 108,764 1

Hash Join (cost=381.48..140,572.38 rows=284,471 width=1,718) (actual time=5.222..666.960 rows=108,764 loops=1)

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

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

3. 0.193 5.193 ↑ 2.8 736 1

Hash (cost=356.09..356.09 rows=2,031 width=283) (actual time=5.192..5.193 rows=736 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 201kB
4. 5.000 5.000 ↑ 2.8 736 1

Seq Scan on venue (cost=0.00..356.09 rows=2,031 width=283) (actual time=0.049..5.000 rows=736 loops=1)

  • Filter: (('(2.351837,48.863615)'::point <@> point((longitude)::double precision, (latitude)::double precision)) < '10'::double precision)
  • Rows Removed by Filter: 5357
Planning time : 0.583 ms
Execution time : 671.917 ms