explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6Jd9

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 36.725 ↑ 1.0 1 1

Sort (cost=17.23..17.23 rows=1 width=13) (actual time=36.724..36.725 rows=1 loops=1)

  • Sort Key: transaction_mgt.id
  • Sort Method: quicksort Memory: 25kB
2. 0.989 36.696 ↑ 1.0 1 1

Nested Loop (cost=1.14..17.22 rows=1 width=13) (actual time=7.027..36.696 rows=1 loops=1)

3. 18.389 18.389 ↓ 1,237.0 1,237 1

Index Scan using transaction_mgt_recipient_user_account_id_issuer_user_accou_idx on transaction_mgt (cost=0.57..8.61 rows=1 width=13) (actual time=0.053..18.389 rows=1,237 loops=1)

  • Index Cond: ((recipient_user_account_id = 7078866) AND (issuer_user_account_id = 7077665) AND (type = 2))
  • Filter: ((id > 78000015) AND ((status_code)::text = ANY ('{NEW,GO,AUTHED,APPROVED,CANCELLED,REFUNDED,REJECTED,PSP_DIRECT,PSP_CAPTURED,CAPTURED}'::text[])))
  • Rows Removed by Filter: 8484
4. 17.318 17.318 ↓ 0.0 0 1,237

Index Scan using transaction_mgt_parameters_transaction_mgt_id_parameter_key_idx on transaction_mgt_parameters tp (cost=0.57..8.60 rows=1 width=4) (actual time=0.014..0.014 rows=0 loops=1,237)

  • Index Cond: ((transaction_mgt_id = transaction_mgt.id) AND (transaction_mgt_id > 78000015) AND (parameter_key = 'merchantUniqueId'::text))
  • Filter: (parameter_value = 'commission-9527-wsSubAccountId7078866'::text)
  • Rows Removed by Filter: 1