explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xgOQ

Settings
# exclusive inclusive rows x rows loops node
1. 1,270.041 5,594.545 ↓ 0.0 0 1

Insert on jackpotdetails (cost=0.43..113,050.82 rows=762,735 width=36) (actual time=5,594.545..5,594.545 rows=0 loops=1)

2. 3,603.658 4,324.504 ↓ 1.1 819,715 1

GroupAggregate (cost=0.43..105,423.47 rows=762,735 width=36) (actual time=0.037..4,324.504 rows=819,715 loops=1)

  • Group Key: ghjd.game_history_reports_id
3. 720.846 720.846 ↑ 1.0 1,525,517 1

Index Only Scan using game_history_reports_jackpotdetails_id on game_history_reports_jackpotdetails ghjd (cost=0.43..84,447.90 rows=1,525,517 width=23) (actual time=0.018..720.846 rows=1,525,517 loops=1)

  • Heap Fetches: 1525517