explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Om7ar

Settings
# exclusive inclusive rows x rows loops node
1. 5,955.736 29,640.299 ↓ 6,532.0 6,532 1

Nested Loop (cost=3.52..6.88 rows=1 width=4) (actual time=25.952..29,640.299 rows=6,532 loops=1)

  • Join Filter: (xtransaction.org_donor_id = xt.org_donor_id)
  • Rows Removed by Join Filter: 71,808,761
2. 18.375 43.693 ↓ 2,343.0 2,343 1

GroupAggregate (cost=3.44..3.44 rows=1 width=4) (actual time=19.428..43.693 rows=2,343 loops=1)

  • Group Key: xtransaction.org_donor_id
  • Filter: (count(xtransaction.id) > 1)
  • Rows Removed by Filter: 24,119
3. 13.173 25.318 ↓ 30,651.0 30,651 1

Sort (cost=3.44..3.44 rows=1 width=8) (actual time=19.412..25.318 rows=30,651 loops=1)

  • Sort Key: xtransaction.org_donor_id
  • Sort Method: quicksort Memory: 2,205kB
4. 12.145 12.145 ↓ 30,651.0 30,651 1

Index Scan using ix_xtransaction__rpt_date_id on xtransaction (cost=0.09..3.43 rows=1 width=8) (actual time=0.024..12.145 rows=30,651 loops=1)

  • Index Cond: (rpt_date_id = 92)
5. 23,640.870 23,640.870 ↓ 30,651.0 30,651 2,343

Index Scan using ix_xtransaction__rpt_date_id on xtransaction xt (cost=0.09..3.43 rows=1 width=8) (actual time=0.011..10.090 rows=30,651 loops=2,343)

  • Index Cond: (rpt_date_id = 92)
Planning time : 0.263 ms
Execution time : 29,641.679 ms