explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AKNH : Optimization for: plan #AFZ1

Settings

Optimization path:

Optimization(s) for this plan:

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

Index Scan using idx_trn_date_pm_status_reverse on sw_transactions (cost=0.70..230,026.31 rows=534 width=1,619) (actual time=49.652..2,120.035 rows=9,982 loops=1)

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