explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KvwB

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 23.775 ↓ 0.0 0 1

Limit (cost=0.56..89.20 rows=1 width=925) (actual time=23.775..23.775 rows=0 loops=1)

2. 23.773 23.773 ↓ 0.0 0 1

Index Scan using payment_accountid_currency_periodend_state_index on "Payment" (cost=0.56..4,078.06 rows=46 width=925) (actual time=23.773..23.773 rows=0 loops=1)

  • Index Cond: (("accountId" = 2) AND ((currency)::text = 'usd'::text) AND ((state)::text = 'Pending'::text))