explain.depesz.com

A tool for finding a real cause for slow queries.

Result: RU3

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 10.734 43.677 ↑ 1.0 1 1

Aggregate (cost=13057.83..13057.84 rows=1 width=0) (actual time=43.676..43.677 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. 30.181 32.923 ↓ 2.9 18102 1

Bitmap Heap Scan on message_sms_mo (cost=99.32..13036.91 rows=6260 width=0) (actual time=4.787..32.923 rows=18102 loops=1)

  • Recheck Cond: (acco_id = $0)
  • Filter: ((msmo_mobile)::text !~~ '5500%'::text)
5. 2.742 2.742 ↓ 2.9 18102 1

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

  • Index Cond: (acco_id = $0)