explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x1jx

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 0.172 ↓ 4.0 12 1

Bitmap Heap Scan on booker.cb_chargeback_requests (cost=80.45..90.90 rows=3 width=475) (actual time=0.158..0.172 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'::numeric)
  • Heap Blocks: exact=11
  • Buffers: shared hit=27
2. 0.150 0.150 ↓ 4.0 12 1

Bitmap Index Scan on i_cb_cr_ordid_buyerid_sellerid (cost=0.00..80.45 rows=3 width=0) (actual time=0.150..0.150 rows=12 loops=1)

  • Index Cond: (cb_chargeback_requests.seller_customer_id = '531071533'::numeric)
  • Buffers: shared hit=16