explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AeOu

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

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

2.          

CTE dataset

3. 2.394 188.697 ↓ 37.9 32,963 1

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

4. 109.385 186.303 ↓ 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=122.673..186.303 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.532 76.918 ↓ 0.0 0 1

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

6. 4.158 4.158 ↓ 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.158..4.158 rows=69,928 loops=1)

  • Index Cond: (cd_id_talhao = ANY ('{11695834,11695833}'::integer[]))
7. 72.228 72.228 ↓ 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=72.228..72.228 rows=1,105,459 loops=1)

  • Index Cond: (cd_estado = 'E'::bpchar)
Planning time : 16.266 ms
Execution time : 199.683 ms