explain.depesz.com

A tool for finding a real cause for slow queries.

Result: D7b

options
# exclusive inclusive rows x rows loops node
1. 1.006 56.586 ↑ 1.0 1 1
→

Aggregate (cost=1038.65..1038.66 rows=1 width=0) (actual time=56.585..56.586 rows=1 loops=1)

2.          

Initplan (forAggregate)
3. 0.020 0.020 ↑ 1.0 1 1
→

Index Scan using uk_account_acco_alias on account (cost=0.00..5.27 rows=1 width=4) (actual time=0.019..0.020 rows=1 loops=1)

  • Index Cond: ((acco_alias)::text = 'amilrj'::text)
4. 2.252 55.560 ↓ 37.4 1646 1
→

Bitmap Heap Scan on message_sms_mo (cost=923.70..1033.26 rows=44 width=0) (actual time=53.434..55.560 rows=1646 loops=1)

  • Recheck Cond: ((acco_id = $0) AND (msmo_received >= '2012-04-01 00:00:00-03'::timestamp with time zone) AND (msmo_received < ('2012-04-01 00:00:00-03'::timestamp with time zone + '1 mon'::interval)))
  • Filter: ((msmo_mobile)::text !~~ '5500%'::text)
5. 2.012 53.308 ↓ 0.0 0 1
→

BitmapAnd (cost=923.70..923.70 rows=44 width=0) (actual time=53.308..53.308 rows=0 loops=1)

6. 3.027 3.027 ↓ 2.9 18101 1
→

Bitmap Index Scan on message_sms_mo_by_account (cost=0.00..97.75 rows=6261 width=0) (actual time=3.027..3.027 rows=18101 loops=1)

  • Index Cond: (acco_id = $0)
7. 48.269 48.269 ↓ 7.5 360750 1
→

Bitmap Index Scan on message_sms_mo_by_received (cost=0.00..825.68 rows=48244 width=0) (actual time=48.269..48.269 rows=360750 loops=1)

  • Index Cond: ((msmo_received >= '2012-04-01 00:00:00-03'::timestamp with time zone) AND (msmo_received < ('2012-04-01 00:00:00-03'::timestamp with time zone + '1 mon'::interval)))