explain.depesz.com

PostgreSQL's explain analyze made readable

Result: O8Oh

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1.374 ↓ 0.0 0 1

Limit (cost=6,661.37..6,661.37 rows=1 width=925) (actual time=1.374..1.374 rows=0 loops=1)

2. 0.014 1.374 ↓ 0.0 0 1

Sort (cost=6,661.37..6,666.38 rows=2,006 width=925) (actual time=1.374..1.374 rows=0 loops=1)

  • Sort Key: "paymentDate" DESC
  • Sort Method: quicksort Memory: 25kB
3. 1.360 1.360 ↓ 0.0 0 1

Index Scan using payment_accountid_index on "Payment" (cost=0.43..6,651.34 rows=2,006 width=925) (actual time=1.360..1.360 rows=0 loops=1)

  • Index Cond: ("accountId" = 1)
  • Filter: ((currency)::text = 'usd'::text)
  • Rows Removed by Filter: 938