explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OhBz

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

Limit (cost=0.43..4.87 rows=1 width=925) (actual time=0.070..0.070 rows=1 loops=1)

2. 0.069 0.069 ↑ 106,573.0 1 1

Index Scan Backward using payment_paymentdate_index on "Payment" (cost=0.43..472,653.29 rows=106,573 width=925) (actual time=0.069..0.069 rows=1 loops=1)

  • Filter: (((currency)::text = 'usd'::text) AND ("accountId" = 2))
  • Rows Removed by Filter: 40