PDA

View Full Version : Show SQL queries that HM run against PostgreSQL



oksi
05-20-2009, 01:53 PM
Hi all,

I've read that it's possible to view all the queries that PostgreSQL run ( http://chrismiles.info/systemsadmin/databases/articles/viewing-current-postgresql-queries/ ). I follow all the steps that are explain there but the result is that I cannot not read HM queries because in column that it supposed to be the query it appears IDLE :S (in this case I launch a report in HM and wants to now the equivalent in SQL - row number 7)
http://img34.imageshack.us/img34/1152/sqlquery.jpg


Are there any other way to obtain it?

Thanks in advance.

oksi
05-20-2009, 06:30 PM
edit the holdemmanager.config file and change the


<setting name="LogDatabaseCommands">False</setting>
To
<setting name="LogDatabaseCommands">True</setting>

Then relaunch HM and run the report. Then look
for the DBTrace.log file and it will show the queries that were used.


That's the solution!
Thx to RVG72

:)

brunowillis
06-19-2009, 06:10 AM
Hi,

all False(s) to True? Or only one specific False?

I would need queries for

a.) getting BB/100 for given player
b.) getting #hands for given player

maybe someone can help me out?

oksi
06-19-2009, 09:30 AM
You have to change this to true, sorry. =)

setting name="LogDatabaseCommands"

brunowillis
06-19-2009, 12:39 PM
ok thx.

Got the #hands and BB/100 for player x to work with

count(ph.*) as Hands
sum(ph.netamountwon/1.0/gt.bigblind)/count(ph.*)*50 as BigBets100

projections

SootedNinjas
08-13-2009, 04:31 AM
edit the holdemmanager.config file and change the

<setting name="LogDatabaseCommands">False</setting>
To
<setting name="LogDatabaseCommands">True</setting>

Then relaunch HM and run the report. Then look
for the DBTrace.log file and it will show the queries that were used.


That's the solution!
Thx to RVG72

:)

Where is DBTrace.log located ?

DonPablo
05-16-2011, 04:39 AM
Does anyone know how to do this with the latest Holdem Manager and the latest PostrgreSQL ?

and btw, where are those files located ?

Thank you !

Sarek
05-16-2011, 06:13 AM
See "Logs" folder in HM install path

DonPablo
05-16-2011, 07:25 AM
See "Logs" folder in HM install path

Yes, I have found it but there isn't any file named DBTrace.log. Where it could be ? I have opened with notepad all those files and none is a logfile like expected one...

Second, I have found one holdemmanager.config file right inside HM installation folder but there is any setting name="LogDatabaseCommands" in order to change it to 'true'... :confused:


Any help, please ?

Thank you !

netsrak
05-16-2011, 08:17 AM
You need to activate the tracing in the file config\holdemmanager.config.

After doing this and running some HM reports the file dbtrace.log should be in the logs subfolder.