explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C4m3

Settings
# exclusive inclusive rows x rows loops node
1. 47.883 1,566.950 ↓ 1.9 5,942 1

HashAggregate (cost=7,121.95..7,152.87 rows=3,092 width=12) (actual time=1,562.215..1,566.950 rows=5,942 loops=1)

  • Group Key: ah.cid, ah.ap_payment_id
2. 34.584 1,519.067 ↑ 1.4 7,878 1

WindowAgg (cost=6,693.99..6,907.97 rows=10,699 width=20) (actual time=1,457.835..1,519.067 rows=7,878 loops=1)

3. 35.739 1,484.483 ↑ 1.4 7,878 1

Sort (cost=6,693.99..6,720.73 rows=10,699 width=16) (actual time=1,457.813..1,484.483 rows=7,878 loops=1)

  • Sort Key: ah.ap_payment_id
  • Sort Method: quicksort Memory: 562kB
4. 1,424.900 1,448.744 ↑ 1.4 7,878 1

Bitmap Heap Scan on ap_headers ah (cost=258.08..5,977.95 rows=10,699 width=16) (actual time=27.031..1,448.744 rows=7,878 loops=1)

  • Recheck Cond: ((cid = 12975) AND (ap_payment_id IS NOT NULL))
  • Heap Blocks: exact=2136
5. 23.844 23.844 ↑ 1.4 7,878 1

Bitmap Index Scan on idx_ap_headers_ap_payment_id (cost=0.00..255.41 rows=10,699 width=0) (actual time=23.843..23.844 rows=7,878 loops=1)

  • Index Cond: ((cid = 12975) AND (ap_payment_id IS NOT NULL))