explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c1QB

Settings
# exclusive inclusive rows x rows loops node
1. 38,850.382 38,970.311 ↓ 4.1 318,487 1

Bitmap Heap Scan on arq_rem_consumidores c (cost=5,477.58..136,797.34 rows=78,105 width=41) (actual time=136.536..38,970.311 rows=318,487 loops=1)

  • Recheck Cond: (cod_arq_rem_arquivo >= 996)
  • Filter: (rem_com_data_enrichment_response IS NOT NULL)
  • Rows Removed by Filter: 15,403
  • Heap Blocks: exact=36,994
2. 119.929 119.929 ↓ 1.1 337,576 1

Bitmap Index Scan on arq_rem_consumidores_cod_arq_rem_arquivo_idx (cost=0.00..5,458.05 rows=296,750 width=0) (actual time=119.929..119.929 rows=337,576 loops=1)

  • Index Cond: (cod_arq_rem_arquivo >= 996)
Planning time : 0.293 ms
Execution time : 41,718.524 ms