explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mWmQ

Settings
# exclusive inclusive rows x rows loops node
1. 31.012 8,525.828 ↑ 6.8 36 1

GroupAggregate (cost=90,420.54..90,614.70 rows=245 width=88) (actual time=8,495.632..8,525.828 rows=36 loops=1)

  • Group Key: header, (("trendTime" - ("trendTime" % '120000'::bigint)))
2. 2.592 8,494.816 ↓ 16.1 3,934 1

Sort (cost=90,420.54..90,421.15 rows=245 width=44) (actual time=8,494.378..8,494.816 rows=3,934 loops=1)

  • Sort Key: header, (("trendTime" - ("trendTime" % '120000'::bigint)))
  • Sort Method: quicksort Memory: 404kB
3. 8,397.580 8,492.224 ↓ 16.1 3,934 1

Bitmap Heap Scan on "Tag" (cost=1,320.79..90,402.86 rows=245 width=44) (actual time=5,939.628..8,492.224 rows=3,934 loops=1)

  • Recheck Cond: (("trendTime" >= '1581372600000'::bigint) AND ("trendTime" < '1581372720000'::bigint))
  • Rows Removed by Index Recheck: 26624348
  • Filter: (header = ANY ('{504388,507785,505844,408480,405793,668409,637241,343827,405652,307854,669693,374951,406682,538602,507404,408474,473438,440645,506540,406153,638768,573061,505805,374603,374332,636411,603163,407632,404676,373336,540258,374938,409103,342324,440122,637125}'::bigint[]))
  • Rows Removed by Filter: 185095
  • Heap Blocks: lossy=415783
4. 94.644 94.644 ↓ 71.7 4,158,720 1

Bitmap Index Scan on "trendTimeIndexBrin" (cost=0.00..1,320.72 rows=57,994 width=0) (actual time=94.644..94.644 rows=4,158,720 loops=1)

  • Index Cond: (("trendTime" >= '1581372600000'::bigint) AND ("trendTime" < '1581372720000'::bigint))
Planning time : 20.022 ms