explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uVO

Settings
# exclusive inclusive rows x rows loops node
1. 28.246 8,403.279 ↑ 6.8 36 1

GroupAggregate (cost=90,419.01..90,613.17 rows=245 width=88) (actual time=8,375.821..8,403.279 rows=36 loops=1)

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

Sort (cost=90,419.01..90,419.62 rows=245 width=44) (actual time=8,374.716..8,375.033 rows=3,934 loops=1)

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

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

  • Recheck Cond: (("trendTime" >= '1581372600000'::bigint) AND ("trendTime" < '1581372720000'::bigint))
  • Rows Removed by Index Recheck: 26589722
  • 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=415250
4. 97.810 97.810 ↓ 71.6 4,153,600 1

Bitmap Index Scan on "trendTimeIndexBrin" (cost=0.00..1,320.72 rows=57,993 width=0) (actual time=97.809..97.810 rows=4,153,600 loops=1)

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