explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iKIB : Optimization for: plan #DcXx

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 4,931.522 14,786.897 ↑ 7.8 97 1

HashAggregate (cost=930,352.95..930,370.05 rows=760 width=555) (actual time=14,786.856..14,786.897 rows=97 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. 9,247.677 9,855.375 ↑ 1.0 4,766,857 1

Bitmap Heap Scan on teste (cost=123,484.69..713,737.76 rows=4,813,671 width=392) (actual time=614.407..9,855.375 rows=4,766,857 loops=1)

  • Recheck Cond: ((datahora >= '2017-01-01 00:00:00'::timestamp without time zone) AND (datahora <= '2017-12-31 23:59:59'::timestamp without time zone))
  • Rows Removed by Index Recheck: 59
  • Heap Blocks: exact=32368 lossy=79312
3. 607.698 607.698 ↑ 1.0 4,766,857 1

Bitmap Index Scan on cidx_teste_datahora_unidadenegocio (cost=0.00..122,281.27 rows=4,813,671 width=0) (actual time=607.698..607.698 rows=4,766,857 loops=1)

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