My first Lazarus application! pgprofiler
lazarus / 8-Other

----------------------------------------------------------------------
rgh · 2016-02-21 16:33

With thanks to those who helped me recently in this forum & the
community here for such a great tool!

The application displays Postgresql activity.
http://www.xentu.com/pgprofiler/


Right, now I'm going to see if I can get it to build on Linux.....

----------------------------------------------------------------------
rgh · 2016-02-21 17:59

Source at bitbucket:

https://bitbucket.org/twistedlizard/pgprofiler.git

----------------------------------------------------------------------
avra · 2016-02-22 20:47

Quote from: rgh on February 21, 2016, 06:59:22 pmSource at bitbucket:

https://twistedlizard@bitbucket.org/twistedlizard/pgprofiler.git
Nice. However your public link should be
https://bitbucket.org/twistedlizard/pgprofiler.git

----------------------------------------------------------------------
rgh · 2016-02-22 21:24

Quote from: avra on February 22, 2016, 09:47:53 pmNice. However your
public link should be
https://bitbucket.org/twistedlizard/pgprofiler.git

thanks avra, I've changed it

----------------------------------------------------------------------
JD · 2016-02-22 21:25

Quote from: rgh on February 21, 2016, 05:33:49 pmWith thanks to those
who helped me recently in this forum & the community here for such a
great tool!

The application displays Postgresql activity.
http://www.xentu.com/pgprofiler/


Right, now I'm going to see if I can get it to build on Linux.....

First of all I would like to say congratulations! I hope using Lazarus
continues to give you fulfilment.

That said, I tried your tool on my system. And while I was able to
connect, clicking on the Run button gives me an Access Violation error
& no profiling is done.

JD

----------------------------------------------------------------------
rgh · 2016-02-22 21:37

Quote from: JD on February 22, 2016, 10:25:12 pmThat said, I tried
your tool on my system. And while I was able to connect, clicking on
the Run button gives me an Access Violation error & no profiling is
done.


Did you change the log output to csv on postgresql?
In postgresql.conf:
log_destination = 'csvlog'

After connecting,  did the Log File combo populate with those server
side csv files?

----------------------------------------------------------------------
JD · 2016-02-22 21:50

Quote from: rgh on February 22, 2016, 10:37:04 pmDid you change the
log output to csv on postgresql?
In postgresql.conf:
log_destination = 'csvlog'

After connecting,  did the Log File combo populate with those server
side csv files?

My bad! Sorry, I haven't done that. I'll do it & let you know how it
turns out.

JD

----------------------------------------------------------------------
rgh · 2016-02-22 21:53

I can reproduce that error if there are no csv log files for the app
to look at, I forgot to cater for that possibility.

Thanks. I'll have the app check for their existence & issue a warning
if none are found.