explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AFZ1

Settings

Optimization(s) for this plan:

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

Sort (cost=230,050.50..230,051.84 rows=534 width=1,619) (actual time=2,268.907..2,270.441 rows=9,982 loops=1)

  • Sort Key: trn_psp_merchant_id
  • Sort Method: quicksort Memory: 10522kB
2. 2,241.085 2,241.085 ↓ 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=52.743..2,241.085 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: 708732