explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nBVA

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.128 ↓ 0.0 0 1

Bitmap Heap Scan on booker.cb_chargeback_requests (cost=68.56..78.81 rows=3 width=473) (actual time=0.127..0.128 rows=0 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.buyer_customer_id = '531071513241'::numeric)
  • Buffers: shared hit=13
2. 0.125 0.125 ↓ 0.0 0 1

Bitmap Index Scan on i_cb_cr_ordid_buyerid_sellerid (cost=0.00..68.56 rows=3 width=0) (actual time=0.125..0.125 rows=0 loops=1)

  • Index Cond: (cb_chargeback_requests.buyer_customer_id = '531071513241'::numeric)
  • Buffers: shared hit=13
Planning time : 0.149 ms