3Bet Preflop vs Hero

[potamito]

Subqueries cannot be cached

So if i happend to create them and ren a full custom cache...Would the process freeze at some point? should i even start a custom cache?

[WhiteRider]

These columns will not be added to the custom cache, so rebuilding it won't change anything.

[5aaa]

I've read through this thread a few times now and still can't get my head around this stuff.

I'd like to make a simple '3bet vs hero' stat, when hero is the BTN (making a BTN steal attempt), and villain is either of the blinds. If someone could tell me how, or point me to the relevant post(s) in this thread, I'd really appreciate it.

[4StarGen]

I've read through this thread a few times now and still can't get my head around this stuff.

I'd like to make a simple '3bet vs hero' stat, when hero is the BTN (making a BTN steal attempt), and villain is either of the blinds. If someone could tell me how, or point me to the relevant post(s) in this thread, I'd really appreciate it.

Post your tries, someone will help

[5aaa]

I've read through this thread a few times now and still can't get my head around this stuff.

I'd like to make a simple '3bet vs hero' stat, when hero is the BTN (making a BTN steal attempt), and villain is either of the blinds. If someone could tell me how, or point me to the relevant post(s) in this thread, I'd really appreciate it.

Post your tries, someone will help

I eventually managed to get it to work, because I am a genius.

For anyone interested...

numerator:

Code: Select all

sum(if[cash_hand_player_statistics.flg_blind_def_opp and lookup_actions_p.action LIKE 'R%' and exists
  (select 1
   from cash_hand_player_statistics hero
   where hero.id_hand = cash_hand_player_statistics.id_hand
   and hero.flg_hero
   and hero.position = 0), 1, 0])

denominator:

Code: Select all

sum(if[cash_hand_player_statistics.flg_blind_def_opp and exists
  (select 1
   from cash_hand_player_statistics hero
   where hero.id_hand = cash_hand_player_statistics.id_hand
   and hero.flg_hero
   and hero.position = 0), 1, 0])

[4StarGen]

Congratz

[4StarGen]

I'm trying to make a vs Hero in the last 3 hours stat but performance are quite bad in the HUD (tooks 10 seconds to populate) while it works great in the report section, can I ask you why?

_3Bet_vs_Hero_last_3_hr_Non_cached

Code: Select all

sum(if[(now() at time zone 'GMT') - (interval '3 hours') < cash_hand_player_statistics.date_played AND cash_hand_player_statistics.flg_p_3bet_opp and exists
  (select 1
   from cash_hand_player_statistics hero
   where hero.id_hand = cash_hand_player_statistics.id_hand
   and hero.flg_hero
   and hero.flg_p_first_raise
   ), 1, 0])

_3bet_vs_hero_opp_Last_3_hr_non_cached

Code: Select all

sum(if[(now() at time zone 'GMT') - (interval '3 hours') < cash_hand_player_statistics.date_played AND cash_hand_player_statistics.flg_p_3bet_opp and exists
  (select 1
   from cash_hand_player_statistics hero
   where hero.id_hand = cash_hand_player_statistics.id_hand
   and hero.flg_hero
   and hero.flg_p_first_raise
   ), 1, 0])

[kraada]

How long does the non-cached query take when used in the HUD for that stat (you can find it in the log)?

[4StarGen]

Player's report
Query execution time: 23.71899678 ms

HUD (time to populate the pop up with the stat, along the others):
Query execution time: 13447.24508376 ms

while without the stat, the pop up is populating without any lag

[kraada]

Send me the query via PM and I'll take a look at it.