explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HnXa

Settings
# exclusive inclusive rows x rows loops node
1. 14.866 580.083 ↓ 1.9 5,942 1

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

  • Group Key: ah.cid, ah.ap_payment_id
2. 37.119 565.217 ↑ 1.4 7,878 1

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

3. 12.228 528.098 ↑ 1.4 7,878 1

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

  • Sort Key: ah.ap_payment_id
  • Sort Method: quicksort Memory: 562kB
4. 501.924 515.870 ↑ 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=17.866..515.870 rows=7,878 loops=1)

  • Recheck Cond: ((cid = 12975) AND (ap_payment_id IS NOT NULL))
  • Heap Blocks: exact=2136
5. 13.946 13.946 ↑ 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=13.945..13.946 rows=7,878 loops=1)

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