Hi,
Le 16/03/2010 08:40, Marcin Krawczyk a écrit :
Hi list, does anyone know the reason for pgAdmin not showing the stats
neither for selected pgAgent step nor whole job ? The pga_joblog and
pga_jobsteplog both get populated with data on run so I was thinking that
maybe I'm missing some view
It's pgAdmin 1.10.0. I've partially identified the problem, pgAdmin log says
that following query gets executed when switching to job statistics tab :
SELECT jsljlgid, jslstatus, jslresult, jslstart, jslduration, (jslstart +
jslduration) AS endtime, jsloutput
FROM pgagent.pga_jobsteplog WHERE
On Wed, Mar 17, 2010 at 12:15 PM, Marcin Krawczyk jankes...@gmail.com wrote:
It's pgAdmin 1.10.0. I've partially identified the problem, pgAdmin log says
that following query gets executed when switching to job statistics tab :
SELECT jsljlgid, jslstatus, jslresult, jslstart, jslduration,
Ha, it worked :)) kind of funny though. It was set to 0 but it's supposed to
not limit anything when 0 :)) a bug ?
pozdrowienia / regards / salutations
mk
2010/3/17 Dave Page dp...@pgadmin.org
On Wed, Mar 17, 2010 at 12:15 PM, Marcin Krawczyk jankes...@gmail.com
wrote:
It's pgAdmin
On Wed, Mar 17, 2010 at 12:24 PM, Marcin Krawczyk jankes...@gmail.com wrote:
Ha, it worked :)) kind of funny though. It was set to 0 but it's supposed to
not limit anything when 0 :)) a bug ?
What makes you say that? The docs say:
Maximum rows to retrieve - This option specifies the number of
Yeah... my bad. Sorry for being a pain in the a... ;)
pozdrowienia
mk
2010/3/17 Dave Page dp...@pgadmin.org
On Wed, Mar 17, 2010 at 12:24 PM, Marcin Krawczyk jankes...@gmail.com
wrote:
Ha, it worked :)) kind of funny though. It was set to 0 but it's supposed
to
not limit anything when
Thanks for your help guys.
regards
mk
2010/3/17 Dave Page dp...@pgadmin.org
On Wed, Mar 17, 2010 at 12:24 PM, Marcin Krawczyk jankes...@gmail.com
wrote:
Ha, it worked :)) kind of funny though. It was set to 0 but it's supposed
to
not limit anything when 0 :)) a bug ?
What makes you
:-)
On Wed, Mar 17, 2010 at 12:40 PM, Marcin Krawczyk jankes...@gmail.com wrote:
Yeah... my bad. Sorry for being a pain in the a... ;)
pozdrowienia
mk
2010/3/17 Dave Page dp...@pgadmin.org
On Wed, Mar 17, 2010 at 12:24 PM, Marcin Krawczyk jankes...@gmail.com
wrote:
Ha, it worked :))
Hi list, does anyone know the reason for pgAdmin not showing the stats
neither for selected pgAgent step nor whole job ? The pga_joblog and
pga_jobsteplog both get populated with data on run so I was thinking that
maybe I'm missing some view associated with statistics tabs ?? Any ideas ?
regards