explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M2ud

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

Limit (cost=0.43..2.96 rows=1 width=929) (actual time=0.041..0.041 rows=1 loops=1)

2. 0.040 0.040 ↑ 255,594.0 1 1

Index Scan using payment_accountid_currency_paymentdate_state_index on "Payment" (cost=0.43..647,300.29 rows=255,594 width=929) (actual time=0.040..0.040 rows=1 loops=1)

  • Index Cond: (("accountId" = 3) AND ((currency)::text = 'usd'::text))