explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dkDJ : Optimization for: plan #92j9

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.021 ↑ 1.0 1 1

Limit (cost=0.43..2.1 rows=1 width=22) (actual time=0.021..0.021 rows=1 loops=1)

  • Buffers: shared hit=4
2. 0.021 0.021 ↑ 2.0 1 1

Index Scan using pbc_cbaid_idx on paypal_billing_agreement_context paypal_billing_agreement_context (cost=0.43..3.77 rows=2 width=22) (actual time=0.021..0.021 rows=1 loops=1)

  • Index Cond: ((paypal_billing_agreement_context.creation_billing_agreement_id)::text = 'B-69P1063710492324S'::text)
  • Buffers: shared hit=4
Planning time : 0.07 ms
Execution time : 0.032 ms