explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ikid

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

Limit (cost=0.43..4.32 rows=1 width=925) (actual time=0.084..0.084 rows=1 loops=1)

2. 0.083 0.083 ↑ 119,619.0 1 1

Index Scan Backward using payment_paymentdate_index on "Payment" (cost=0.43..465,050.36 rows=119,619 width=925) (actual time=0.083..0.083 rows=1 loops=1)

  • Filter: ("accountId" = 2)
  • Rows Removed by Filter: 40
Planning time : 0.262 ms