explain.depesz.com

PostgreSQL's explain analyze made readable

Result: miOf

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1.251 53.326 ↓ 0.0 0 1

Bitmap Heap Scan on docdeu (cost=82.47..95.85 rows=12 width=3,036) (actual time=53.326..53.326 rows=0 loops=1)

  • Recheck Cond: ((estado = 'A'::bpchar) AND (nit = '8605242188'::bigint))
  • Filter: (meses_transcurridos_neg IS NOT NULL)
  • Rows Removed by Filter: 5
  • Heap Blocks: exact=4
2. 5.394 52.075 ↓ 0.0 0 1

BitmapAnd (cost=82.47..82.47 rows=12 width=0) (actual time=52.075..52.075 rows=0 loops=1)

3. 46.657 46.657 ↓ 147.5 356,710 1

Bitmap Index Scan on docdeu_estado_idx (cost=0.00..26.26 rows=2,418 width=0) (actual time=46.657..46.657 rows=356,710 loops=1)

  • Index Cond: (estado = 'A'::bpchar)
4. 0.024 0.024 ↑ 483.6 5 1

Bitmap Index Scan on i_docdeu_nit (cost=0.00..55.96 rows=2,418 width=0) (actual time=0.024..0.024 rows=5 loops=1)

  • Index Cond: (nit = '8605242188'::bigint)
Planning time : 0.215 ms
Execution time : 53.376 ms