explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UekI

Settings
# exclusive inclusive rows x rows loops node
1. 198.303 198.303 ↓ 37.9 32,963 1

CTE Scan on dataset (cost=35,731.77..35,749.17 rows=870 width=36) (actual time=123.144..198.303 rows=32,963 loops=1)

2.          

CTE dataset

3. 2.401 189.617 ↓ 37.9 32,963 1

Append (cost=11,798.15..35,731.77 rows=870 width=36) (actual time=123.141..189.617 rows=32,963 loops=1)

4. 110.660 187.216 ↓ 37.9 32,963 1

Bitmap Heap Scan on ddn_mapa_cliente128 dm (cost=11,798.15..35,727.42 rows=870 width=36) (actual time=123.140..187.216 rows=32,963 loops=1)

  • Recheck Cond: ((cd_id_talhao = ANY ('{11695834,11695833}'::integer[])) AND (cd_estado = 'E'::bpchar))
  • Filter: ((vl_produtividade_colheita IS NOT NULL) AND (dt_hr_local_inicial >= '2020-02-11 19:42:30'::timestamp without time zone) AND (dt_hr_local_inicial <= '2020-02-12 17:57:54'::timestamp without time zone) AND (vl_produtividade_colheita <> '9999'::double precision) AND (cd_cliente = 128) AND (cd_id_operacao_cb = 290137))
  • Heap Blocks: exact=8460
5. 0.502 76.556 ↓ 0.0 0 1

BitmapAnd (cost=11,798.15..11,798.15 rows=23,414 width=0) (actual time=76.556..76.556 rows=0 loops=1)

6. 4.183 4.183 ↓ 1.8 69,928 1

Bitmap Index Scan on ddn_mapa_cliente128_cd_id_talhao_idx (cost=0.00..461.82 rows=38,141 width=0) (actual time=4.183..4.183 rows=69,928 loops=1)

  • Index Cond: (cd_id_talhao = ANY ('{11695834,11695833}'::integer[]))
7. 71.871 71.871 ↓ 1.2 1,105,459 1

Bitmap Index Scan on ddn_mapa_cliente128_cd_estado_idx (cost=0.00..11,335.64 rows=943,615 width=0) (actual time=71.871..71.871 rows=1,105,459 loops=1)

  • Index Cond: (cd_estado = 'E'::bpchar)
Planning time : 16.173 ms
Execution time : 200.198 ms