explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yC9s

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 40,733.365 ↑ 1.0 50 1

Limit (cost=165,664.75..165,664.88 rows=50 width=204) (actual time=40,733.354..40,733.365 rows=50 loops=1)

2. 47.144 40,733.356 ↑ 2,419.0 50 1

Sort (cost=165,664.75..165,967.12 rows=120,948 width=204) (actual time=40,733.352..40,733.356 rows=50 loops=1)

  • Sort Key: (count(*)) DESC, text
  • Sort Method: top-N heapsort Memory: 39kB
3. 79.919 40,686.212 ↓ 1.3 151,660 1

GroupAggregate (cost=158,993.09..161,646.94 rows=120,948 width=204) (actual time=40,023.371..40,686.212 rows=151,660 loops=1)

  • Group Key: text
4. 2,494.443 40,606.293 ↓ 1.2 238,826 1

Sort (cost=158,993.09..159,474.55 rows=192,583 width=196) (actual time=40,023.355..40,606.293 rows=238,826 loops=1)

  • Sort Key: text
  • Sort Method: external merge Disk: 38456kB
5. 12,380.750 38,111.850 ↓ 1.2 238,826 1

Bitmap Heap Scan on twitter (cost=16,541.64..123,658.00 rows=192,583 width=196) (actual time=25,760.215..38,111.850 rows=238,826 loops=1)

  • Recheck Cond: (symbol = 'BTC'::text)
  • Filter: ((is_spam = 0) AND (created_at_date >= (((now())::timestamp without time zone + '-25 days'::interval))::date) AND (created_at_date <= (((now())::timestamp without time zone + '-1 days'::interval))::date))
  • Rows Removed by Filter: 363123
  • Heap Blocks: exact=75583
6. 25,731.100 25,731.100 ↓ 1.0 601,949 1

Bitmap Index Scan on twitter_symbol_idx (cost=0.00..16,493.50 rows=599,609 width=0) (actual time=25,731.100..25,731.100 rows=601,949 loops=1)

  • Index Cond: (symbol = 'BTC'::text)
Planning time : 0.208 ms
Execution time : 40,738.270 ms