explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2ZEi

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 3,789.230 ↑ 1.0 1 1

Limit (cost=357,983.16..357,983.16 rows=1 width=925) (actual time=3,789.230..3,789.230 rows=1 loops=1)

2. 132.279 3,789.230 ↑ 255,594.0 1 1

Sort (cost=357,983.16..358,622.14 rows=255,594 width=925) (actual time=3,789.230..3,789.230 rows=1 loops=1)

  • Sort Key: "paymentDate" DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 1,504.961 3,656.951 ↓ 1.1 277,776 1

Bitmap Heap Scan on "Payment" (cost=5,363.96..356,705.19 rows=255,594 width=925) (actual time=2,166.849..3,656.951 rows=277,776 loops=1)

  • Recheck Cond: ("accountId" = 3)
  • Rows Removed by Index Recheck: 818,647
  • Filter: ((currency)::text = 'usd'::text)
  • Heap Blocks: exact=39,386 lossy=105,972
4. 2,151.990 2,151.990 ↑ 1.0 277,776 1

Bitmap Index Scan on payment_accountid_index (cost=0.00..5,300.06 rows=286,884 width=0) (actual time=2,151.990..2,151.990 rows=277,776 loops=1)

  • Index Cond: ("accountId" = 3)