explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TyJh

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 497.635 ↑ 1.0 8 1

Limit (cost=767,160.61..767,160.63 rows=8 width=13) (actual time=497.633..497.635 rows=8 loops=1)

2. 25.581 497.629 ↑ 9,304.9 8 1

Sort (cost=767,160.61..767,346.71 rows=74,439 width=13) (actual time=497.627..497.629 rows=8 loops=1)

  • Sort Key: this_.amount DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 20.567 472.048 ↑ 1.5 49,769 1

Hash Semi Join (cost=5,441.72..765,671.83 rows=74,439 width=13) (actual time=22.899..472.048 rows=49,769 loops=1)

  • Hash Cond: (pl1_.parent_id = player.parent_id)
4. 27.956 450.936 ↑ 1.5 49,769 1

Hash Join (cost=5,382.00..764,588.57 rows=74,439 width=17) (actual time=22.348..450.936 rows=49,769 loops=1)

  • Hash Cond: (this_.player_id = pl1_.id)
5. 401.221 422.729 ↑ 1.5 49,769 1

Bitmap Heap Scan on internal_transaction this_ (cost=5,332.42..763,515.45 rows=74,439 width=13) (actual time=22.088..422.729 rows=49,769 loops=1)

  • Recheck Cond: (date >= ((now())::date - 3))
  • Filter: (type_id = 2)
  • Rows Removed by Filter: 165917
  • Heap Blocks: exact=2499
6. 21.508 21.508 ↑ 1.3 215,686 1

Bitmap Index Scan on idx_internal_transaction_date (cost=0.00..5,313.81 rows=287,631 width=0) (actual time=21.508..21.508 rows=215,686 loops=1)

  • Index Cond: (date >= ((now())::date - 3))
7. 0.101 0.251 ↑ 1.4 572 1

Hash (cost=39.26..39.26 rows=826 width=8) (actual time=0.251..0.251 rows=572 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 31kB
8. 0.150 0.150 ↑ 1.4 572 1

Seq Scan on player pl1_ (cost=0.00..39.26 rows=826 width=8) (actual time=0.006..0.150 rows=572 loops=1)

9. 0.080 0.545 ↑ 1.4 392 1

Hash (cost=52.64..52.64 rows=566 width=4) (actual time=0.545..0.545 rows=392 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
10. 0.353 0.465 ↑ 1.4 392 1

HashAggregate (cost=41.32..46.98 rows=566 width=4) (actual time=0.400..0.465 rows=392 loops=1)

  • Group Key: player.parent_id
11. 0.112 0.112 ↑ 1.4 572 1

Seq Scan on player (cost=0.00..39.26 rows=826 width=4) (actual time=0.007..0.112 rows=572 loops=1)