explain.depesz.com

A tool for finding a real cause for slow queries.

Result: npC

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 778.538 42,725.409 ↓ 1.0 387,451 1

Sort (cost=1,525,453.05..1,526,404.89 rows=380,737 width=38) (actual time=42,473.084..42,725.409 rows=387,451 loops=1)

  • Sort Key: public.sms_all.session, (abs(public.sms_all.user_id))
  • Sort Method: quicksort Memory: 42558kB
2. 25,331.432 41,946.871 ↓ 1.0 387,451 1

Hash Join (cost=591,621.60..1,490,161.70 rows=380,737 width=38) (actual time=11,982.614..41,946.871 rows=387,451 loops=1)

  • Hash Cond: (public.sms_all.session = public.sms_all.session)
3. 15,386.024 15,386.024 ↑ 1.0 21,043,299 1

Seq Scan on sms_all (cost=0.00..788,433.26 rows=21,069,526 width=38) (actual time=0.036..15,386.024 rows=21,043,299 loops=1)

4. 29.424 1,229.415 ↓ 24.1 41,215 1

Hash (cost=591,600.20..591,600.20 rows=1,712 width=8) (actual time=1,229.415..1,229.415 rows=41,215 loops=1)

5. 238.864 1,199.991 ↓ 24.1 41,215 1

Unique (cost=589,679.69..591,583.08 rows=1,712 width=8) (actual time=746.505..1,199.991 rows=41,215 loops=1)

6. 605.350 961.127 ↑ 1.1 360,417 1

Sort (cost=589,679.69..590,631.39 rows=380,678 width=8) (actual time=746.501..961.127 rows=360,417 loops=1)

  • Sort Key: public.sms_all.session
  • Sort Method: quicksort Memory: 29183kB
7. 312.194 355.777 ↑ 1.1 360,417 1

Bitmap Heap Scan on sms_all (cost=8,076.51..554,394.25 rows=380,678 width=8) (actual time=45.527..355.777 rows=360,417 loops=1)

  • Recheck Cond: ((send_date >= '2012-04-17 00:00:00+02'::timestamp with time zone) AND (send_date <= '2012-05-17 00:00:00+02'::timestamp with time zone))
8. 43.583 43.583 ↑ 1.1 360,417 1

Bitmap Index Scan on sms_all_send_date (cost=0.00..7,981.34 rows=380,678 width=0) (actual time=43.583..43.583 rows=360,417 loops=1)

  • Index Cond: ((send_date >= '2012-04-17 00:00:00+02'::timestamp with time zone) AND (send_date <= '2012-05-17 00:00:00+02'::timestamp with time zone))