explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 7WA : Slow Plan

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 5.718 1856.231 ↑ 2.1 75 1

HashAggregate (cost=73969.66..73971.21 rows=155 width=4) (actual time=1856.161..1856.231 rows=75 loops=1)

2. 14.357 1850.513 ↓ 2.6 4213 1

Nested Loop (cost=1058.58..73961.60 rows=1612 width=4) (actual time=55.010..1850.513 rows=4213 loops=1)

3. 788.818 1806.588 ↓ 2.4 3696 1

Hash Left Join (cost=1058.58..71070.14 rows=1549 width=8) (actual time=54.993..1806.588 rows=3696 loops=1)

  • Hash Cond: ((crowdbreaks_tweet.place_id)::text = (crowdbreaks_place.place_id)::text)
  • Filter: ((crowdbreaks_tweet.coordinates @ '0103000020E61000000100000005000000AE47E17A141E5FC00000000000003840AE47E17A141E5FC029ED0DBE30B14840A4703D0AD7A350C029ED0DBE30B14840A4703D0AD7A350C00000000000003840AE47E17A141E5FC00000000000003840'::geometry) OR (crowdbreaks_place.centroid @ '0103000020E61000000100000005000000AE47E17A141E5FC00000000000003840AE47E17A141E5FC029ED0DBE30B14840A4703D0AD7A350C029ED0DBE30B14840A4703D0AD7A350C00000000000003840AE47E17A141E5FC00000000000003840'::geometry))
4. 981.540 981.540 ↓ 1.0 776228 1

Index Scan using crowdbreaks_tweet_crreated_at on crowdbreaks_tweet (cost=0.00..34997.78 rows=774681 width=125) (actual time=16.978..981.540 rows=776228 loops=1)

  • Index Cond: ((created_at > '2012-04-18 21:47:14.251348+00'::timestamp with time zone) AND (created_at < '2012-04-19 21:47:14.251351+00'::timestamp with time zone))
5. 18.741 36.230 ↑ 1.0 15848 1

Hash (cost=581.48..581.48 rows=15848 width=117) (actual time=36.230..36.230 rows=15848 loops=1)

  • Buckets: 1024 Batches: 4 Memory Usage: 269kB
6. 17.489 17.489 ↑ 1.0 15848 1

Seq Scan on crowdbreaks_place (cost=0.00..581.48 rows=15848 width=117) (actual time=0.005..17.489 rows=15848 loops=1)

7. 29.568 29.568 ↑ 1.0 1 3696

Index Scan using crowdbreaks_incomingkeyword_tweet_id on crowdbreaks_incomingkeyword (cost=0.00..1.85 rows=1 width=12) (actual time=0.006..0.008 rows=1 loops=3696)

  • Index Cond: (tweet_id = crowdbreaks_tweet.tweet_id)