explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c5WY

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 0.099 ↓ 1.5 12 1

Bitmap Heap Scan on booker.cb_chargeback_requests (cost=68.56..92.87 rows=8 width=473) (actual time=0.086..0.099 rows=12 loops=1)

  • Output: chargeback_request_id, dispute_request_id, marketplace_id, issuer, legacy_issuer_code, order_id, processing_division_id, request_status, institution_code, institution_dispute_id, detailed_reason_code, high_level_reason_code, payment_reference_id, chargeback_payment_ref_type, seals_payment_ref_type, fault_role, workflow_status, credit_amount, debit_amount, transaction_amount, currency_code, marketplace_currency_code, payment_signature, payment_method, payment_method_code, avs_code, reversal_id, amazon_fulfilled, amount_debited, seller_customer_id, buyer_customer_id, payment_transaction_date, request_received_date, representment_deadline_date, institution_comments, country_code, transaction_unit_class, record_version_number, created_by, creation_date, last_updated_by, last_updated_date, refund_percent, processing_status, settlement_verification_code, order_date, institute_cb_state, institute_cb_state_effec_date, exposed_dispute_state, raw_reason_code
  • Recheck Cond: (cb_chargeback_requests.seller_customer_id = 531071533)
  • Heap Blocks: exact=11
  • Buffers: shared hit=24
2. 0.079 0.079 ↓ 1.5 12 1

Bitmap Index Scan on i_cb_cr_ordid_buyerid_sellerid (cost=0.00..68.56 rows=8 width=0) (actual time=0.079..0.079 rows=12 loops=1)

  • Index Cond: (cb_chargeback_requests.seller_customer_id = 531071533)
  • Buffers: shared hit=13
Planning time : 0.126 ms