explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Gx7V

Settings
# exclusive inclusive rows x rows loops node
1. 4,243.543 7,154.800 ↑ 8.6 11 1

HashAggregate (cost=910,746.90..910,749.04 rows=95 width=552) (actual time=7,154.794..7,154.800 rows=11 loops=1)

  • Group Key: NULL::text, NULL::text, anomes, NULL::text, NULL::text, NULL::text, NULL::text, NULL::text, NULL::text, NULL::text, NULL::text, NULL::text, NULL::text
2. 2,343.117 2,911.257 ↑ 1.0 4,488,708 1

Bitmap Heap Scan on teste (cost=117,610.78..704,430.81 rows=4,584,802 width=421) (actual time=573.231..2,911.257 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. 568.140 568.140 ↑ 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=568.140..568.140 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))