explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I2tE : Optimization for: plan #DpuR

Settings

Optimization path:

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

GroupAggregate (cost=13,659.73..13,660.52 rows=1 width=88) (actual rows= loops=)

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

Sort (cost=13,659.73..13,659.73 rows=1 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,186.53..13,659.65 rows=1 width=44) (actual rows= loops=)

  • Recheck Cond: (("trendTime" >= '1581326880000'::bigint) AND ("trendTime" < '1581327600000'::bigint))
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "trendTimeIndexBrin" (cost=0.00..1,186.53 rows=8,283 width=0) (actual rows= loops=)