explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vCtR

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=90,420.49..90,614.65 rows=245 width=88) (actual rows= loops=)

  • Group Key: (("trendTime" - ("trendTime" % '120000'::bigint))), header
2. 0.000 0.000 ↓ 0.0

Sort (cost=90,420.49..90,421.10 rows=245 width=44) (actual rows= loops=)

  • Sort Key: (("trendTime" - ("trendTime" % '120000'::bigint))), header
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "Tag" (cost=1,320.79..90,402.80 rows=245 width=44) (actual rows= loops=)

  • Recheck Cond: (("trendTime" >= '1581372600000'::bigint) AND ("trendTime" < '1581372720000'::bigint))
  • 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[]))
4. 0.000 0.000 ↓ 0.0

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