explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uKmJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.097 548.984 ↑ 1.6 39 1

Sort (cost=19,954.26..19,954.42 rows=61 width=27) (actual time=548.981..548.984 rows=39 loops=1)

  • Sort Key: (count(*)) DESC
  • Sort Method: quicksort Memory: 28kB
  • Buffers: shared hit=357 read=24798
2. 42.045 548.887 ↑ 1.6 39 1

GroupAggregate (cost=19,902.14..19,952.46 rows=61 width=27) (actual time=504.837..548.887 rows=39 loops=1)

  • Group Key: browsername
  • Buffers: shared hit=354 read=24798
3. 37.073 506.842 ↓ 5.3 26,229 1

Sort (cost=19,902.14..19,914.56 rows=4,971 width=43) (actual time=504.762..506.842 rows=26,229 loops=1)

  • Sort Key: browsername
  • Sort Method: quicksort Memory: 3051kB
  • Buffers: shared hit=354 read=24798
4. 458.469 469.769 ↓ 5.3 26,229 1

Bitmap Heap Scan on stats (cost=271.95..19,596.93 rows=4,971 width=43) (actual time=16.001..469.769 rows=26,229 loops=1)

  • Recheck Cond: ((company = 222) AND (createdate > '2018-01-01 00:00:00+01'::timestamp with time zone) AND (createdate < '2019-01-01 00:00:00+01'::timestamp with time zone))
  • Heap Blocks: exact=24933
  • Buffers: shared hit=351 read=24798
5. 11.300 11.300 ↓ 5.3 26,229 1

Bitmap Index Scan on stats_new_company_createdate_index_1 (cost=0.00..270.70 rows=4,971 width=0) (actual time=11.300..11.300 rows=26,229 loops=1)

  • Index Cond: ((company = 222) AND (createdate > '2018-01-01 00:00:00+01'::timestamp with time zone) AND (createdate < '2019-01-01 00:00:00+01'::timestamp with time zone))
  • Buffers: shared read=216
Planning time : 2.625 ms