explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4ppV

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 10.284 1,425,076.001 ↑ 1.0 1 1

Aggregate (cost=266,865.61..266,865.62 rows=1 width=8) (actual time=1,425,076.000..1,425,076.001 rows=1 loops=1)

  • Buffers: shared hit=99541 dirtied=15
2. 7.227 1,425,065.717 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=46.18..266,865.60 rows=6 width=0) (actual time=643.664..1,425,065.717 rows=5,815 loops=1)

  • Join Filter: ((max_bal.fuserid)::bpchar = player.fid)
  • Buffers: shared hit=99541 dirtied=15
3. 8.546 1,425,058.490 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.56..266,849.35 rows=6 width=37) (actual time=643.654..1,425,058.490 rows=5,815 loops=1)

  • Join Filter: ((user_balancereport.fuserid)::bpchar = player.fid)
  • Buffers: shared hit=99541 dirtied=15
4. 21,754.941 1,425,049.944 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..266,841.10 rows=6 width=37) (actual time=643.628..1,425,049.944 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 42))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=99540 dirtied=15
5. 21,456.036 1,384,099.688 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..259,241.73 rows=6 width=78) (actual time=625.772..1,384,099.688 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 38))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=98372 dirtied=15
6. 21,527.250 1,343,570.452 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..251,642.37 rows=6 width=78) (actual time=607.860..1,343,570.452 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 34))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=97204 dirtied=15
7. 21,564.101 1,302,731.587 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..244,043.01 rows=6 width=78) (actual time=589.588..1,302,731.587 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 33))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=96036 dirtied=15
8. 21,431.391 1,262,111.731 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..236,443.65 rows=6 width=78) (actual time=571.403..1,262,111.731 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 36))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=94868 dirtied=15
9. 21,459.255 1,221,665.290 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..228,844.28 rows=6 width=78) (actual time=553.761..1,221,665.290 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 782))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=93700 dirtied=15
10. 22,306.969 1,181,092.130 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..221,244.92 rows=6 width=78) (actual time=536.504..1,181,092.130 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 781))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=92532 dirtied=15
11. 21,162.853 1,137,589.486 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..213,645.56 rows=6 width=78) (actual time=519.600..1,137,589.486 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 37))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=91364 dirtied=15
12. 21,434.619 1,097,394.138 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..206,046.20 rows=6 width=78) (actual time=503.145..1,097,394.138 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 41))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=90196 dirtied=15
13. 21,336.540 1,056,938.654 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..198,446.83 rows=6 width=78) (actual time=486.640..1,056,938.654 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 780))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=89028 dirtied=15
14. 21,580.532 1,016,505.654 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..190,847.47 rows=6 width=78) (actual time=469.925..1,016,505.654 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 32))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=87860 dirtied=15
15. 21,312.394 975,491.392 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..183,248.11 rows=6 width=78) (actual time=453.081..975,491.392 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 779))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=86692 dirtied=15
16. 21,218.343 935,117.428 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..175,648.75 rows=6 width=78) (actual time=436.315..935,117.428 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 40))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=85524 dirtied=15
17. 21,522.360 894,761.920 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..168,049.38 rows=6 width=78) (actual time=419.656..894,761.920 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 31))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=84356 dirtied=15
18. 21,331.874 854,160.545 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..160,450.02 rows=6 width=78) (actual time=402.864..854,160.545 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 30))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=83188 dirtied=15
19. 21,366.928 813,214.676 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..152,850.66 rows=6 width=78) (actual time=386.187..813,214.676 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 778))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=82020 dirtied=15
20. 21,354.022 772,844.328 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..145,251.30 rows=6 width=78) (actual time=369.545..772,844.328 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 29))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=80852 dirtied=15
21. 21,164.205 732,481.071 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..137,651.93 rows=6 width=78) (actual time=352.697..732,481.071 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 777))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=79684 dirtied=15
22. 21,953.335 692,220.406 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..130,052.57 rows=6 width=78) (actual time=335.552..692,220.406 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 27))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=78516 dirtied=15
23. 22,521.111 650,874.046 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..122,453.21 rows=6 width=78) (actual time=318.410..650,874.046 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 112))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=77348 dirtied=15
24. 21,681.107 609,215.770 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..114,853.85 rows=6 width=78) (actual time=301.590..609,215.770 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 111))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=76180 dirtied=15
25. 21,183.294 568,327.718 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..107,254.48 rows=6 width=78) (actual time=284.816..568,327.718 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 110))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=75012 dirtied=15
26. 21,226.901 527,925.849 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..99,655.12 rows=6 width=78) (actual time=268.009..527,925.849 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 22))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=73844 dirtied=15
27. 38.377 487,364.073 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.41..92,055.76 rows=6 width=78) (actual time=251.436..487,364.073 rows=5,815 loops=1)

  • Buffers: shared hit=72676 dirtied=15
28. 21,436.791 487,197.766 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.00..92,005.09 rows=6 width=78) (actual time=251.407..487,197.766 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 19))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=55162 dirtied=15
29. 21,244.413 446,466.805 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.00..84,405.73 rows=6 width=78) (actual time=234.622..446,466.805 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 14))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=53994 dirtied=15
30. 21,282.604 406,207.342 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.00..76,806.36 rows=6 width=78) (actual time=217.639..406,207.342 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 12))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=52826 dirtied=15
31. 21,411.097 365,909.688 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.00..69,207.00 rows=6 width=78) (actual time=200.896..365,909.688 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 11))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=51658 dirtied=15
32. 21,358.416 325,157.901 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.00..61,607.64 rows=6 width=78) (actual time=184.493..325,157.901 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 10))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=50490 dirtied=15
33. 21,179.439 284,499.500 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.00..54,008.28 rows=6 width=78) (actual time=165.461..284,499.500 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 9))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=49322 dirtied=15
34. 21,533.376 243,607.211 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.00..46,408.91 rows=6 width=78) (actual time=141.792..243,607.211 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 8))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=48154 dirtied=15
35. 38.846 202,913.410 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=35.00..38,809.55 rows=6 width=78) (actual time=118.538..202,913.410 rows=5,815 loops=1)

  • Buffers: shared hit=46986 dirtied=15
36. 21,343.016 202,775.709 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=34.59..38,758.88 rows=6 width=78) (actual time=118.493..202,775.709 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 6))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=29474 dirtied=15
37. 21,581.596 162,359.493 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=34.59..31,159.52 rows=6 width=78) (actual time=95.053..162,359.493 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 5))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=28306 dirtied=15
38. 21,154.576 121,629.102 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=34.59..23,560.16 rows=6 width=78) (actual time=71.926..121,629.102 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 4))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=27138 dirtied=15
39. 21,293.883 81,267.581 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=34.59..15,960.79 rows=6 width=78) (actual time=48.709..81,267.581 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 3))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=25970 dirtied=15
40. 21,286.917 40,894.683 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=34.59..8,361.43 rows=6 width=78) (actual time=25.326..40,894.683 rows=5,815 loops=1)

  • Join Filter: ((fund_out_cond_sportbook.id = player.fid) AND (fund_out_cond_sportbook.gameid = 2))
  • Rows Removed by Join Filter: 317027985
  • Buffers: shared hit=24802 dirtied=15
41. 47.142 342.671 ↓ 969.2 5,815 1

Nested Loop Left Join (cost=34.59..762.07 rows=6 width=78) (actual time=0.685..342.671 rows=5,815 loops=1)

  • Buffers: shared hit=23634 dirtied=15
42. 29.092 155.969 ↓ 969.2 5,815 1

Hash Join (cost=34.17..711.40 rows=6 width=37) (actual time=0.660..155.969 rows=5,815 loops=1)

  • Hash Cond: ((player.faffiliatecode)::text = (aff.fcode)::text)
  • Buffers: shared hit=6143 dirtied=15
43. 126.318 126.318 ↓ 581.5 5,815 1

Index Scan using idx_user_player_3 on user_player player (cost=0.42..677.54 rows=10 width=47) (actual time=0.089..126.318 rows=5,815 loops=1)

  • Index Cond: (((fcurrency)::text = 'VND'::text) AND ((fwebcode)::text = 'SEA'::text) AND (fhouseplayer = 'N'::bpchar))
  • Filter: ((floginname)::text ~~ '%sea_%'::text)
  • Buffers: shared hit=6117 dirtied=15
44. 0.076 0.559 ↓ 1.0 244 1

Hash (cost=30.79..30.79 rows=237 width=16) (actual time=0.559..0.559 rows=244 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
  • Buffers: shared hit=26
45. 0.483 0.483 ↓ 1.0 244 1

Seq Scan on affiliate_user aff (cost=0.00..30.79 rows=237 width=16) (actual time=0.132..0.483 rows=244 loops=1)

  • Filter: ((fwebcode)::text = 'SEA'::text)
  • Rows Removed by Filter: 148
  • Buffers: shared hit=26
46. 139.560 139.560 ↓ 0.0 0 5,815

Index Only Scan using pk_user_fundout_condition on user_fundout_condition fund_out_cond_sportbook (cost=0.41..8.43 rows=1 width=41) (actual time=0.024..0.024 rows=0 loops=5,815)

  • Index Cond: ((id = player.fid) AND (gameid = 1))
  • Heap Fetches: 0
  • Buffers: shared hit=17491
47. 19,255.201 19,265.095 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.001..3.313 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
48. 9.894 9.894 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_suncity (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.007..9.894 rows=54,519 loops=1)

  • Buffers: shared hit=1168
49. 19,070.697 19,079.015 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.281 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
50. 8.318 8.318 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_cake (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.008..8.318 rows=54,519 loops=1)

  • Buffers: shared hit=1168
51. 19,198.571 19,206.945 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.303 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
52. 8.374 8.374 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_hogame (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.007..8.374 rows=54,519 loops=1)

  • Buffers: shared hit=1168
53. 19,140.406 19,148.795 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.293 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
54. 8.389 8.389 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_eagame (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.007..8.389 rows=54,519 loops=1)

  • Buffers: shared hit=1168
55. 19,064.868 19,073.200 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.280 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
56. 8.332 8.332 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_onelab (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.018..8.332 rows=54,519 loops=1)

  • Buffers: shared hit=1168
57. 98.855 98.855 ↓ 0.0 0 5,815

Index Only Scan using pk_user_fundout_condition on user_fundout_condition fund_out_cond_charwell (cost=0.41..8.43 rows=1 width=37) (actual time=0.017..0.017 rows=0 loops=5,815)

  • Index Cond: ((id = player.fid) AND (gameid = 7))
  • Heap Fetches: 0
  • Buffers: shared hit=17512
58. 19,152.046 19,160.425 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.295 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
59. 8.379 8.379 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_deluxe (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.007..8.379 rows=54,519 loops=1)

  • Buffers: shared hit=1168
60. 19,704.517 19,712.850 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.390 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
61. 8.333 8.333 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_poker (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.007..8.333 rows=54,519 loops=1)

  • Buffers: shared hit=1168
62. 19,293.061 19,299.985 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.319 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
63. 6.924 6.924 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_obsb (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.008..6.924 rows=54,519 loops=1)

  • Buffers: shared hit=1168
64. 19,334.752 19,340.690 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.326 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
65. 5.938 5.938 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_obca (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.005..5.938 rows=54,519 loops=1)

  • Buffers: shared hit=1168
66. 19,008.953 19,015.050 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.270 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
67. 6.097 6.097 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_bbin (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.006..6.097 rows=54,519 loops=1)

  • Buffers: shared hit=1168
68. 19,008.911 19,015.050 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.270 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
69. 6.139 6.139 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_cr (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.006..6.139 rows=54,519 loops=1)

  • Buffers: shared hit=1168
70. 19,288.208 19,294.170 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.318 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
71. 5.962 5.962 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_pt (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.006..5.962 rows=54,519 loops=1)

  • Buffers: shared hit=1168
72. 127.930 127.930 ↓ 0.0 0 5,815

Index Only Scan using pk_user_fundout_condition on user_fundout_condition fund_out_cond_spotoption (cost=0.41..8.43 rows=1 width=37) (actual time=0.022..0.022 rows=0 loops=5,815)

  • Index Cond: ((id = player.fid) AND (gameid = 21))
  • Heap Fetches: 0
  • Buffers: shared hit=17514
73. 19,328.845 19,334.875 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.325 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
74. 6.030 6.030 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_188sb (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.010..6.030 rows=54,519 loops=1)

  • Buffers: shared hit=1168
75. 19,212.591 19,218.575 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.305 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
76. 5.984 5.984 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_ff (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.006..5.984 rows=54,519 loops=1)

  • Buffers: shared hit=1168
77. 19,200.942 19,206.945 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.303 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
78. 6.003 6.003 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_ms (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.005..6.003 rows=54,519 loops=1)

  • Buffers: shared hit=1168
79. 19,131.253 19,137.165 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.291 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
80. 5.912 5.912 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_st (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.005..5.912 rows=54,519 loops=1)

  • Buffers: shared hit=1168
81. 19,386.726 19,393.025 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.335 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
82. 6.299 6.299 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_ag (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.005..6.299 rows=54,519 loops=1)

  • Buffers: shared hit=1168
83. 19,090.250 19,096.460 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.284 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
84. 6.210 6.210 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_ugs (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.006..6.210 rows=54,519 loops=1)

  • Buffers: shared hit=1168
85. 19,003.225 19,009.235 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.269 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
86. 6.010 6.010 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_quickfire (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.005..6.010 rows=54,519 loops=1)

  • Buffers: shared hit=1168
87. 18,997.511 19,003.420 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.268 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
88. 5.909 5.909 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_genesis (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.005..5.909 rows=54,519 loops=1)

  • Buffers: shared hit=1168
89. 19,608.106 19,613.995 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.373 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
90. 5.889 5.889 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_cockfighting (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.006..5.889 rows=54,519 loops=1)

  • Buffers: shared hit=1168
91. 19,073.017 19,079.015 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.281 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
92. 5.998 5.998 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_vsl (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.005..5.998 rows=54,519 loops=1)

  • Buffers: shared hit=1168
93. 19,131.280 19,137.165 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.291 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
94. 5.885 5.885 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_esports (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.005..5.885 rows=54,519 loops=1)

  • Buffers: shared hit=1168
95. 19,055.626 19,061.570 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.278 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
96. 5.944 5.944 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_n2live (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.006..5.944 rows=54,519 loops=1)

  • Buffers: shared hit=1168
97. 19,427.756 19,433.730 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.342 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
98. 5.974 5.974 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_stag8 (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.005..5.974 rows=54,519 loops=1)

  • Buffers: shared hit=1168
99. 19,090.483 19,096.460 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.284 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
100. 5.977 5.977 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_lxv2 (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.005..5.977 rows=54,519 loops=1)

  • Buffers: shared hit=1168
101. 19,014.935 19,020.865 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.271 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
102. 5.930 5.930 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_allbet (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.006..5.930 rows=54,519 loops=1)

  • Buffers: shared hit=1168
103. 19,026.603 19,032.495 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.273 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
104. 5.892 5.892 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_joingames (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.005..5.892 rows=54,519 loops=1)

  • Buffers: shared hit=1168
105. 21,189.811 21,195.675 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.645 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
106. 5.864 5.864 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_dreamtech (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.005..5.864 rows=54,519 loops=1)

  • Buffers: shared hit=1168
107. 19,107.698 19,113.905 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.287 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
108. 6.207 6.207 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_spadegaming (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.006..6.207 rows=54,519 loops=1)

  • Buffers: shared hit=1168
109. 19,008.796 19,015.050 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.270 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
110. 6.254 6.254 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_evolution (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.006..6.254 rows=54,519 loops=1)

  • Buffers: shared hit=1168
111. 19,049.574 19,055.755 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.277 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
112. 6.181 6.181 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_playson (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.005..6.181 rows=54,519 loops=1)

  • Buffers: shared hit=1168
113. 19,305.419 19,311.615 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.321 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
114. 6.196 6.196 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_elite (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.005..6.196 rows=54,519 loops=1)

  • Buffers: shared hit=1168
115. 19,066.980 19,073.200 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.280 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
116. 6.220 6.220 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_ggpoker (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.005..6.220 rows=54,519 loops=1)

  • Buffers: shared hit=1168
117. 19,189.137 19,195.315 ↑ 1.0 54,519 5,815

Materialize (cost=0.00..1,989.02 rows=54,735 width=0) (actual time=0.000..3.301 rows=54,519 loops=5,815)

  • Buffers: shared hit=1168
118. 6.178 6.178 ↑ 1.0 54,519 1

Seq Scan on user_fundout_condition fund_out_cond_sungirl (cost=0.00..1,715.35 rows=54,735 width=0) (actual time=0.005..6.178 rows=54,519 loops=1)

  • Buffers: shared hit=1168
119. 0.000 0.000 ↓ 0.0 0 5,815

Materialize (cost=0.14..8.17 rows=1 width=90) (actual time=0.000..0.000 rows=0 loops=5,815)

  • Buffers: shared hit=1
120. 0.023 0.023 ↓ 0.0 0 1

Index Only Scan using idx_user_blrpt_dtidtotbal on user_balancereport (cost=0.14..8.16 rows=1 width=90) (actual time=0.023..0.023 rows=0 loops=1)

  • Index Cond: (freportdate = to_date('2019-01-16'::text, 'yyyy-mm-dd'::text))
  • Heap Fetches: 0
  • Buffers: shared hit=1
121. 0.000 0.000 ↓ 0.0 0 5,815

Materialize (cost=10.62..11.88 rows=50 width=90) (actual time=0.000..0.000 rows=0 loops=5,815)

122. 0.000 0.007 ↓ 0.0 0 1

Subquery Scan on max_bal (cost=10.62..11.62 rows=50 width=90) (actual time=0.007..0.007 rows=0 loops=1)

123. 0.003 0.007 ↓ 0.0 0 1

HashAggregate (cost=10.62..11.12 rows=50 width=122) (actual time=0.007..0.007 rows=0 loops=1)

  • Group Key: user_balancereport_1.fuserid
124. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on user_balancereport user_balancereport_1 (cost=0.00..10.50 rows=50 width=90) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: ((fuserid IS NOT NULL) AND (freportdate IS NOT NULL))",,,,,"SQL statement ""SELECT COUNT(1) FROM