explain.depesz.com

PostgreSQL's explain analyze made readable

Result: REtt

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 204.560 ↑ 1.0 1 1

Limit (cost=0.43..2.28 rows=1 width=925) (actual time=204.560..204.560 rows=1 loops=1)

2. 204.558 204.558 ↑ 255,594.0 1 1

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

  • Filter: (((currency)::text = 'usd'::text) AND ("accountId" = 3))
  • Rows Removed by Filter: 289
Planning time : 42.465 ms