explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0nF4

Settings
# exclusive inclusive rows x rows loops node
1. 2,556.716 2,729.429 ↑ 675.6 18 1

Bitmap Heap Scan on docdeu (cost=140.23..13,685.40 rows=12,160 width=3,460) (actual time=700.291..2,729.429 rows=18 loops=1)

  • Recheck Cond: (estado = 'A'::bpchar)
  • Filter: (meses_transcurridos_neg IS NOT NULL)
  • Rows Removed by Filter: 356692
  • Heap Blocks: exact=273858
2. 172.713 172.713 ↓ 57.5 702,112 1

Bitmap Index Scan on i_docdeu_estado_codcob (cost=0.00..137.19 rows=12,221 width=0) (actual time=172.713..172.713 rows=702,112 loops=1)

  • Index Cond: (estado = 'A'::bpchar)
Planning time : 0.301 ms
Execution time : 2,729.526 ms