explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Xxz

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 328.019 ↓ 25.0 25 1

Limit (cost=64,371.71..64,371.72 rows=1 width=1,168) (actual time=328.019..328.019 rows=25 loops=1)

2. 0.000 328.019 ↓ 25.0 25 1

Sort (cost=64,371.71..64,371.72 rows=1 width=1,168) (actual time=328.019..328.019 rows=25 loops=1)

  • Sort Key: (distance('0101000020957F000051960F03DAE453C10E65AE6757BE4641'::geometry, geo_point))
  • Sort Method: quicksort Memory: 52kB
3. 72.004 328.019 ↓ 27.0 27 1

Bitmap Heap Scan on listing l (cost=8,995.09..64,371.70 rows=1 width=1,168) (actual time=264.015..328.019 rows=27 loops=1)

  • Recheck Cond: ((((date_from >= '2012-07-20'::date) AND (date_from <= '2012-07-22'::date)) OR ((date_to >= '2012-07-20'::date) AND (date_to <= '2012-07-22'::date))) AND (geo_accuracy > 5::smallint))
  • Filter: (active AND (geo_point && '0103000020957F00000100000005000000000000E06E3354C1000000E02D214641000000E06E3354C100000000815B474100000040459653C100000000815B474100000040459653C1000000E02D214641000000E06E3354C1000000E02D214641'::geometry) AND (emailed2 = 0) AND (distance('0101000020957F000051960F03DAE453C10E65AE6757BE4641'::geometry, geo_point) < 80467::double precision))
4. 8.001 256.015 ↓ 0.0 0 1

BitmapAnd (cost=8,995.09..8,995.09 rows=37,009 width=0) (actual time=256.015..256.015 rows=0 loops=1)

5. 0.000 20.001 ↓ 0.0 0 1

BitmapOr (cost=3,262.93..3,262.93 rows=81,823 width=0) (actual time=20.001..20.001 rows=0 loops=1)

6. 12.001 12.001 ↓ 1.0 40,567 1

Bitmap Index Scan on l_date_from (cost=0.00..1,608.39 rows=40,404 width=0) (actual time=12.001..12.001 rows=40,567 loops=1)

  • Index Cond: ((date_from >= '2012-07-20'::date) AND (date_from <= '2012-07-22'::date))
7. 8.000 8.000 ↓ 1.0 41,649 1

Bitmap Index Scan on l_date_to (cost=0.00..1,654.54 rows=41,419 width=0) (actual time=8.000..8.000 rows=41,649 loops=1)

  • Index Cond: ((date_to >= '2012-07-20'::date) AND (date_to <= '2012-07-22'::date))
8. 228.013 228.013 ↓ 1.0 153,168 1

Bitmap Index Scan on l_geo_accuracy (cost=0.00..5,731.90 rows=153,007 width=0) (actual time=228.013..228.013 rows=153,168 loops=1)

  • Index Cond: (geo_accuracy > 5::smallint)