How to calculate Total money bet using PT?

[Pokerpun]

I am interested in how to know the total gross amount of money I have put into a pot in my poker lifetime, can I find that out with PT or estimate it roughly?

[Phil153]

If you've converted your databases to postgresql, you can put the following query in the SQL window

select sum(total_bet) as TOTAL_BET, sum(total_won) as TOTAL_WON, sum(total_won-total_bet) as NET_WON from game_players inner join players on players.player_id = game_players.player_id where players.screen_name = 'Pokerpun'

Replace Pokerpun with your screen name, leave the ''. If you don't have postgresql, it's a bit more complicated. It's probably easier to install postgresql and convert the database than anything else.

[Maunzekater]

Don't forget to append a semicolon to the query if you enter the query in the sql window.

[pococurante]

I bet that would be an interesting number to see. I'm a barely above breakeven player at low stakes... I wonder if I could truthfully say "I've gambled a million dollars in my life".

[Maunzekater]

$35k since August? wtf?????

[MYNAMEIZGREG]

So if I bet 3k into a 650 pot because the guy only has 500 left this query show me as betting the 3k I assume?