explain.depesz.com

PostgreSQL's explain analyze made readable

Result: o1ck

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 18,542.350 ↑ 1.0 1 1

Limit (cost=817,498.57..830,781.74 rows=1 width=240) (actual time=18,542.344..18,542.350 rows=1 loops=1)

  • Buffers: shared hit=81454, temp read=38834 written=64270
2. 12.935 18,542.339 ↓ 6.7 20 1

Nested Loop Left Join (cost=777,649.08..817,498.57 rows=3 width=240) (actual time=18,430.202..18,542.339 rows=20 loops=1)

  • Join Filter: (player.fid = withdrawal.fuserid)
  • Rows Removed by Join Filter: 97400
  • Buffers: shared hit=81454, temp read=38834 written=64270
3. 12.426 18,508.924 ↓ 6.7 20 1

Nested Loop Left Join (cost=777,111.84..816,620.43 rows=3 width=208) (actual time=18,415.468..18,508.924 rows=20 loops=1)

  • Join Filter: (player.fid = deposit.fuserid)
  • Rows Removed by Join Filter: 93960
  • Buffers: shared hit=81148, temp read=38834 written=64270
4. 0.563 18,476.178 ↓ 6.7 20 1

Merge Left Join (cost=776,499.12..815,678.85 rows=3 width=176) (actual time=18,400.551..18,476.178 rows=20 loops=1)

  • Merge Cond: (player.fid = user_dailyreport.fuserid)
  • Buffers: shared hit=80797, temp read=38834 written=64270
5. 0.107 0.107 ↓ 6.7 20 1

Index Scan using idx_user_player_4 on user_player player (cost=0.42..47.39 rows=3 width=112) (actual time=0.047..0.107 rows=20 loops=1)

  • Index Cond: (((fwebcode)::text = 'SEA'::text) AND ((faffiliatecode)::text = 'F010'::text))
  • Buffers: shared hit=22
6. 39.657 18,475.508 ↑ 30.4 1,407 1

GroupAggregate (cost=776,498.70..815,095.98 rows=42,837 width=101) (actual time=18,399.868..18,475.508 rows=1,407 loops=1)

  • Group Key: user_dailyreport.fuserid
  • Buffers: shared hit=80775, temp read=38834 written=64270
7. 16,681.935 18,435.851 ↑ 32.6 116,425 1

Sort (cost=776,498.70..785,987.38 rows=3,795,473 width=47) (actual time=18,399.794..18,435.851 rows=116,425 loops=1)

  • Sort Key: user_dailyreport.fuserid
  • Sort Method: external merge Disk: 211512kB
  • Buffers: shared hit=80775, temp read=38834 written=64270
8. 1,753.916 1,753.916 ↑ 1.0 3,790,327 1

Seq Scan on user_dailyreport (cost=0.00..128,219.29 rows=3,795,473 width=47) (actual time=0.012..1,753.916 rows=3,790,327 loops=1)

  • Filter: (fgameid <> ALL ('{32,28}'::numeric[]))
  • Buffers: shared hit=80775
9. 7.039 20.320 ↑ 1.0 4,698 20

Materialize (cost=612.72..741.92 rows=4,698 width=69) (actual time=0.544..1.016 rows=4,698 loops=20)

  • Buffers: shared hit=351
10. 0.663 13.281 ↑ 1.0 4,698 1

Subquery Scan on deposit (cost=612.72..718.43 rows=4,698 width=69) (actual time=10.876..13.281 rows=4,698 loops=1)

  • Buffers: shared hit=351
11. 9.973 12.618 ↑ 1.0 4,698 1

HashAggregate (cost=612.72..671.45 rows=4,698 width=69) (actual time=10.875..12.618 rows=4,698 loops=1)

  • Group Key: user_deposit_daily.fuserid
  • Buffers: shared hit=351
12. 2.645 2.645 ↑ 1.0 17,448 1

Seq Scan on user_deposit_daily (cost=0.00..525.48 rows=17,448 width=42) (actual time=0.016..2.645 rows=17,448 loops=1)

  • Buffers: shared hit=351
13. 7.602 20.480 ↑ 1.0 4,870 20

Materialize (cost=537.24..671.17 rows=4,870 width=69) (actual time=0.517..1.024 rows=4,870 loops=20)

  • Buffers: shared hit=306
14. 0.673 12.878 ↑ 1.0 4,870 1

Subquery Scan on withdrawal (cost=537.24..646.82 rows=4,870 width=69) (actual time=10.330..12.878 rows=4,870 loops=1)

  • Buffers: shared hit=306
15. 9.914 12.205 ↑ 1.0 4,870 1

HashAggregate (cost=537.24..598.12 rows=4,870 width=69) (actual time=10.328..12.205 rows=4,870 loops=1)

  • Group Key: user_withdrawal_daily.fuserid
  • Buffers: shared hit=306
16. 2.291 2.291 ↑ 1.0 15,416 1

Seq Scan on user_withdrawal_daily (cost=0.00..460.16 rows=15,416 width=42) (actual time=0.010..2.291 rows=15,416 loops=1)

  • Buffers: shared hit=306",,,,,,,,,"DBeaver 5.1.6.201808262133