pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedpgAgent stats
9+ messages / 3 participants
[nested] [flat]
* pgAgent stats
@ 2010-03-16 07:40 Marcin Krawczyk <jankes.mk@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Marcin Krawczyk @ 2010-03-16 07:40 UTC (permalink / raw)
To: pgsql-sql
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
mk
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: pgAgent stats
@ 2010-03-17 12:02 Guillaume Lelarge <guillaume@lelarge.info>
parent: Marcin Krawczyk <jankes.mk@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Guillaume Lelarge @ 2010-03-17 12:02 UTC (permalink / raw)
To: Marcin Krawczyk <jankes.mk@gmail.com>; +Cc: pgsql-sql
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 associated with statistics tabs ?? Any ideas ?
>
Which release of pgAdmin?
AFAICT, 1.10 Jobs' and Steps' statistics are last run time, status,
start time, stop time, and duration.
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: pgAgent stats
@ 2010-03-17 12:15 Marcin Krawczyk <jankes.mk@gmail.com>
parent: Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 1 reply; 9+ messages in thread
From: Marcin Krawczyk @ 2010-03-17 12:15 UTC (permalink / raw)
To: Guillaume Lelarge <guillaume@lelarge.info>; +Cc: pgsql-sql
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 jsljstid = 5 ORDER BY jslstart DESC LIMIT
0
obviously the problem is LIMIT 0 clause but why it is there remains
a mystery... pgAdmin bug ? a configuration issue ?
regards
mk
2010/3/17 Guillaume Lelarge <guillaume@lelarge.info>
> 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 associated with statistics tabs ?? Any ideas
> ?
> >
>
> Which release of pgAdmin?
>
> AFAICT, 1.10 Jobs' and Steps' statistics are last run time, status,
> start time, stop time, and duration.
>
>
> --
> Guillaume.
> http://www.postgresqlfr.org
> http://dalibo.com
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: pgAgent stats
@ 2010-03-17 12:19 Dave Page <dpage@pgadmin.org>
parent: Marcin Krawczyk <jankes.mk@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Dave Page @ 2010-03-17 12:19 UTC (permalink / raw)
To: Marcin Krawczyk <jankes.mk@gmail.com>; +Cc: Guillaume Lelarge <guillaume@lelarge.info>; pgsql-sql
On Wed, Mar 17, 2010 at 12:15 PM, Marcin Krawczyk <jankes.mk@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, (jslstart +
> jslduration) AS endtime, jsloutput
> FROM pgagent.pga_jobsteplog WHERE jsljstid = 5 ORDER BY jslstart DESC LIMIT
> 0
> obviously the problem is LIMIT 0 clause but why it is there remains
> a mystery... pgAdmin bug ? a configuration issue ?
Check the 'Maximum number of rows to retrieve' option on the Query tab
of the Options dialog.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
PG East Conference: http://www.enterprisedb.com/community/nav-pg-east-2010.do
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: pgAgent stats
@ 2010-03-17 12:24 Marcin Krawczyk <jankes.mk@gmail.com>
parent: Dave Page <dpage@pgadmin.org>
0 siblings, 1 reply; 9+ messages in thread
From: Marcin Krawczyk @ 2010-03-17 12:24 UTC (permalink / raw)
To: Dave Page <dpage@pgadmin.org>; +Cc: Guillaume Lelarge <guillaume@lelarge.info>; pgsql-sql
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 <dpage@pgadmin.org>
> On Wed, Mar 17, 2010 at 12:15 PM, Marcin Krawczyk <jankes.mk@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, (jslstart +
> > jslduration) AS endtime, jsloutput
> > FROM pgagent.pga_jobsteplog WHERE jsljstid = 5 ORDER BY jslstart DESC
> LIMIT
> > 0
> > obviously the problem is LIMIT 0 clause but why it is there remains
> > a mystery... pgAdmin bug ? a configuration issue ?
>
> Check the 'Maximum number of rows to retrieve' option on the Query tab
> of the Options dialog.
>
>
>
> --
> Dave Page
> EnterpriseDB UK: http://www.enterprisedb.com
> PG East Conference:
> http://www.enterprisedb.com/community/nav-pg-east-2010.do
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: pgAgent stats
@ 2010-03-17 12:28 Dave Page <dpage@pgadmin.org>
parent: Marcin Krawczyk <jankes.mk@gmail.com>
0 siblings, 2 replies; 9+ messages in thread
From: Dave Page @ 2010-03-17 12:28 UTC (permalink / raw)
To: Marcin Krawczyk <jankes.mk@gmail.com>; +Cc: Guillaume Lelarge <guillaume@lelarge.info>; pgsql-sql
On Wed, Mar 17, 2010 at 12:24 PM, Marcin Krawczyk <jankes.mk@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 job and
job step statistics rows to retrieve when viewing the statistics in
the main browser. Unlike the statistics for other objects which
normally consist of a fixed number of rows, a row is created every
time a job or job step is executed. The most recent statistics will be
shown.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
PG East Conference: http://www.enterprisedb.com/community/nav-pg-east-2010.do
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: pgAgent stats
@ 2010-03-17 12:40 Marcin Krawczyk <jankes.mk@gmail.com>
parent: Dave Page <dpage@pgadmin.org>
1 sibling, 1 reply; 9+ messages in thread
From: Marcin Krawczyk @ 2010-03-17 12:40 UTC (permalink / raw)
To: Dave Page <dpage@pgadmin.org>; +Cc: Guillaume Lelarge <guillaume@lelarge.info>; pgsql-sql
Yeah... my bad. Sorry for being a pain in the a... ;)
pozdrowienia
mk
2010/3/17 Dave Page <dpage@pgadmin.org>
> On Wed, Mar 17, 2010 at 12:24 PM, Marcin Krawczyk <jankes.mk@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 job and
> job step statistics rows to retrieve when viewing the statistics in
> the main browser. Unlike the statistics for other objects which
> normally consist of a fixed number of rows, a row is created every
> time a job or job step is executed. The most recent statistics will be
> shown.
>
>
> --
> Dave Page
> EnterpriseDB UK: http://www.enterprisedb.com
> PG East Conference:
> http://www.enterprisedb.com/community/nav-pg-east-2010.do
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: pgAgent stats
@ 2010-03-17 12:42 Marcin Krawczyk <jankes.mk@gmail.com>
parent: Dave Page <dpage@pgadmin.org>
1 sibling, 0 replies; 9+ messages in thread
From: Marcin Krawczyk @ 2010-03-17 12:42 UTC (permalink / raw)
To: Dave Page <dpage@pgadmin.org>; +Cc: Guillaume Lelarge <guillaume@lelarge.info>; pgsql-sql
Thanks for your help guys.
regards
mk
2010/3/17 Dave Page <dpage@pgadmin.org>
> On Wed, Mar 17, 2010 at 12:24 PM, Marcin Krawczyk <jankes.mk@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 job and
> job step statistics rows to retrieve when viewing the statistics in
> the main browser. Unlike the statistics for other objects which
> normally consist of a fixed number of rows, a row is created every
> time a job or job step is executed. The most recent statistics will be
> shown.
>
>
> --
> Dave Page
> EnterpriseDB UK: http://www.enterprisedb.com
> PG East Conference:
> http://www.enterprisedb.com/community/nav-pg-east-2010.do
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: pgAgent stats
@ 2010-03-17 12:43 Dave Page <dpage@pgadmin.org>
parent: Marcin Krawczyk <jankes.mk@gmail.com>
0 siblings, 0 replies; 9+ messages in thread
From: Dave Page @ 2010-03-17 12:43 UTC (permalink / raw)
To: Marcin Krawczyk <jankes.mk@gmail.com>; +Cc: Guillaume Lelarge <guillaume@lelarge.info>; pgsql-sql
:-)
On Wed, Mar 17, 2010 at 12:40 PM, Marcin Krawczyk <jankes.mk@gmail.com> wrote:
> Yeah... my bad. Sorry for being a pain in the a... ;)
>
> pozdrowienia
> mk
>
>
> 2010/3/17 Dave Page <dpage@pgadmin.org>
>>
>> On Wed, Mar 17, 2010 at 12:24 PM, Marcin Krawczyk <jankes.mk@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 job and
>> job step statistics rows to retrieve when viewing the statistics in
>> the main browser. Unlike the statistics for other objects which
>> normally consist of a fixed number of rows, a row is created every
>> time a job or job step is executed. The most recent statistics will be
>> shown.
>>
>>
>> --
>> Dave Page
>> EnterpriseDB UK: http://www.enterprisedb.com
>> PG East Conference:
>> http://www.enterprisedb.com/community/nav-pg-east-2010.do
>
>
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
PG East Conference: http://www.enterprisedb.com/community/nav-pg-east-2010.do
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2010-03-17 12:43 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-03-16 07:40 pgAgent stats Marcin Krawczyk <jankes.mk@gmail.com>
2010-03-17 12:02 ` Guillaume Lelarge <guillaume@lelarge.info>
2010-03-17 12:15 ` Marcin Krawczyk <jankes.mk@gmail.com>
2010-03-17 12:19 ` Dave Page <dpage@pgadmin.org>
2010-03-17 12:24 ` Marcin Krawczyk <jankes.mk@gmail.com>
2010-03-17 12:28 ` Dave Page <dpage@pgadmin.org>
2010-03-17 12:40 ` Marcin Krawczyk <jankes.mk@gmail.com>
2010-03-17 12:43 ` Dave Page <dpage@pgadmin.org>
2010-03-17 12:42 ` Marcin Krawczyk <jankes.mk@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox