explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wsbw

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 25,202.900 25,368.658 ↓ 1.2 746,167 1

Bitmap Heap Scan on all_tb_toa_hist (cost=14,382.64..294,497.44 rows=641,320 width=88) (actual time=200.272..25,368.658 rows=746,167 loops=1)

  • Recheck Cond: ((("TipoAtiv")::text = ANY ('{"Bilhete Defeito","Bilhete Defeito GPON"}'::text[])) AND (("Estado")::text = 'Concluída'::text))
  • Heap Blocks: exact=138604
2. 165.758 165.758 ↓ 1.2 746,167 1

Bitmap Index Scan on idx_xtts_toa_2 (cost=0.00..14,222.31 rows=641,320 width=0) (actual time=165.757..165.758 rows=746,167 loops=1)

  • Index Cond: ((("TipoAtiv")::text = ANY ('{"Bilhete Defeito","Bilhete Defeito GPON"}'::text[])) AND (("Estado")::text = 'Concluída'::text))
Planning time : 0.146 ms
Execution time : 25,400.920 ms