explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iZb

Settings
# exclusive inclusive rows x rows loops node
1. 1,660.127 2,297.711 ↑ 121.5 2,361 1

GroupAggregate (cost=447,831.38..675,475.88 rows=286,962 width=88) (actual time=619.363..2,297.711 rows=2,361 loops=1)

  • Group Key: (("trendTime" - ("trendTime" % '120000'::bigint))), header
2. 150.413 637.584 ↑ 1.7 170,902 1

Sort (cost=447,831.38..448,549.52 rows=287,256 width=44) (actual time=617.500..637.584 rows=170,902 loops=1)

  • Sort Key: (("trendTime" - ("trendTime" % '120000'::bigint))), header
  • Sort Method: quicksort Memory: 19496kB
3. 460.522 487.171 ↑ 1.7 170,902 1

Bitmap Heap Scan on "Tag" (cost=447.45..412,455.09 rows=287,256 width=44) (actual time=34.473..487.171 rows=170,902 loops=1)

  • Recheck Cond: (("trendTime" >= '1568181600000'::bigint) AND ("trendTime" < '1568182800000'::bigint))
  • Rows Removed by Index Recheck: 377002
  • Heap Blocks: lossy=8435
4. 26.649 26.649 ↑ 3.5 84,480 1

Bitmap Index Scan on "trendTimeIndexBrin" (cost=0.00..375.63 rows=294,257 width=0) (actual time=26.649..26.649 rows=84,480 loops=1)

  • Index Cond: (("trendTime" >= '1568181600000'::bigint) AND ("trendTime" < '1568182800000'::bigint))
Planning time : 3.812 ms