View Full Version : Show SQL queries that HM run against PostgreSQL
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.
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?
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.
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.