explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xdsy

Settings
# exclusive inclusive rows x rows loops node
1. 2,961.378 3,110.473 ↓ 29.2 356,710 1

Bitmap Heap Scan on docdeu (cost=140.24..13,686.94 rows=12,221 width=3,460) (actual time=255.892..3,110.473 rows=356,710 loops=1)

  • Recheck Cond: (estado = 'A'::bpchar)
  • Heap Blocks: exact=273858
2. 149.095 149.095 ↓ 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=149.095..149.095 rows=702,112 loops=1)

  • Index Cond: (estado = 'A'::bpchar)
Planning time : 0.271 ms
Execution time : 3,134.798 ms