explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BHFa : Analise desnomalizada

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 4,612.693 9,291.521 ↑ 8.6 88 1

HashAggregate (cost=910,746.90..910,764.00 rows=760 width=555) (actual time=9,291.483..9,291.521 rows=88 loops=1)

  • Group Key: anomes, unidadenegocio, NULL::text, NULL::text, NULL::text, NULL::text, NULL::text, NULL::text, NULL::text, NULL::text, NULL::text, NULL::text, NULL::text
2. 4,097.896 4,678.828 ↑ 1.0 4,488,708 1

Bitmap Heap Scan on teste (cost=117,610.78..704,430.81 rows=4,584,802 width=392) (actual time=585.585..4,678.828 rows=4,488,708 loops=1)

  • Recheck Cond: ((datahora >= '2018-01-01 00:00:00'::timestamp without time zone) AND (datahora <= '2018-12-31 23:59:59'::timestamp without time zone))
  • Rows Removed by Index Recheck: 21
  • Heap Blocks: exact=25899 lossy=79267
3. 580.932 580.932 ↑ 1.0 4,488,708 1

Bitmap Index Scan on cidx_teste_datahora_unidadenegocio (cost=0.00..116,464.58 rows=4,584,802 width=0) (actual time=580.932..580.932 rows=4,488,708 loops=1)

  • Index Cond: ((datahora >= '2018-01-01 00:00:00'::timestamp without time zone) AND (datahora <= '2018-12-31 23:59:59'::timestamp without time zone))