explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UJcs

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.141 ↑ 1.0 1 1

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

2. 0.138 0.138 ↑ 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.138..0.138 rows=1 loops=1)

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