explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bifM : Optimization for: Optimization for: plan #AFZ1; plan #AKNH

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1,247.384 1,247.384 ↓ 18.7 9,982 1

Index Scan using idx_sw_transactions_trn_processing_method on sw_transactions (cost=0.57..103,810.41 rows=534 width=1,619) (actual time=9.062..1,247.384 rows=9,982 loops=1)

  • Index Cond: (((trn_processing_method)::text = 'Cielo3_Br'::text) AND (trn_created_at > '2020-01-04 02:01:55-03'::timestamp with time zone))
  • Filter: ((trn_psp_response_cod)::text = ANY ('{16,18,20,27}'::text[]))
  • Rows Removed by Filter: 708745