explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 92j9

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 11.868 ↑ 1.0 1 1

Limit (cost=1,000..101,987.03 rows=1 width=22) (actual time=0.235..11.868 rows=1 loops=1)

  • Buffers: shared hit=1,355
2. 10.133 11.867 ↑ 2.0 1 1

Gather (cost=1,000..202,974.07 rows=2 width=22) (actual time=0.235..11.867 rows=1 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
  • Buffers: shared hit=1,355
3. 1.734 1.734 ↑ 1.0 1 6 / 6

Seq Scan on paypal_billing_agreement_context paypal_billing_agreement_context (cost=0..201,973.87 rows=1 width=22) (actual time=1.734..1.734 rows=1 loops=6)

  • Filter: ((paypal_billing_agreement_context.date_deleted IS NULL) AND ((paypal_billing_agreement_context.creation_billing_agreement_id)::text = 'B-69P1063710492324S'::text))
  • Buffers: shared hit=1,355
Planning time : 0.066 ms
Execution time : 11.881 ms