Re: [PERFORM] 57 minute SELECT

2013-10-03 Thread Samuel Stearns
-Original Message- From: Claudio Freire [mailto:klaussfre...@gmail.com] Sent: Thursday, 3 October 2013 11:16 AM To: Samuel Stearns Cc: David Johnston; pgsql-performance@postgresql.org Subject: Re: [PERFORM] 57 minute SELECT On Wed, Oct 2, 2013 at 10:17 PM, Samuel Stearns wrote: > T

Re: [PERFORM] 57 minute SELECT

2013-10-03 Thread Samuel Stearns
ay, 4 October 2013 1:55 AM To: Samuel Stearns Cc: Claudio Freire; David Johnston; pgsql-performance@postgresql.org Subject: Re: [PERFORM] 57 minute SELECT On Thu, Oct 03, 2013 at 09:20:52AM -0700, David Kerr wrote: - On Thu, Oct 03, 2013 at 01:47:29AM +0000, Samuel Stearns wrote: - - Thanks, Cl

Re: [PERFORM] 57 minute SELECT

2013-10-02 Thread Samuel Stearns
inal Message- From: Claudio Freire [mailto:klaussfre...@gmail.com] Sent: Thursday, 3 October 2013 1:44 PM To: Samuel Stearns Cc: David Johnston; pgsql-performance@postgresql.org Subject: Re: [PERFORM] 57 minute SELECT On Wed, Oct 2, 2013 at 10:47 PM, Samuel Stearns wrote: > Thanks, Claudi

Re: [PERFORM] 57 minute SELECT

2013-10-02 Thread Samuel Stearns
gresql.org Subject: Re: [PERFORM] 57 minute SELECT Samuel Stearns-2 wrote > EXPLAIN: &g

Re: [PERFORM] 57 minute SELECT

2013-10-02 Thread Samuel Stearns
Thanks, Claudio: http://explain.depesz.com/s/WJQx -Original Message- From: Claudio Freire [mailto:klaussfre...@gmail.com] Sent: Thursday, 3 October 2013 11:16 AM To: Samuel Stearns Cc: David Johnston; pgsql-performance@postgresql.org Subject: Re: [PERFORM] 57 minute SELECT On Wed, Oct

Re: [PERFORM] 57 minute SELECT

2013-10-02 Thread Samuel Stearns
ive = 't'::bpchar) OR (active = 's'::bpchar)) Total runtime: 3419878.638 ms Thank you, Sam -Original Message- From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of Samuel Stearns Sent: Thursday, 3 October 2013 11:00

Re: [PERFORM] 57 minute SELECT

2013-10-02 Thread Samuel Stearns
;2013-08-01 00:00:00'::timestamp without time zone) AND (public.syslog_master.datetime >= '2013-04-12 00:00:00'::timestamp without time -Original Message- From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of David Joh

Re: [PERFORM] 57 minute SELECT

2013-10-02 Thread Samuel Stearns
The last part, the EXPLAIN, is too big to send. Is there an alternative way I can get it too you, other than chopping it up and sending in multiple parts? Thank you, Sam From: Samuel Stearns Sent: Thursday, 3 October 2013 10:34 AM To: Samuel Stearns; pgsql-performance@postgresql.org Subject

Re: [PERFORM] 57 minute SELECT

2013-10-02 Thread Samuel Stearns
x27;2013-08-01 00:00:00' AND datetime >= '2013-04-12 00:00:00' AND syslog.ip = devices.ip AND (devices.active = 't' OR devices.active = 's'); Thank you, Sam From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-ow...@post

[PERFORM] 57 minute SELECT

2013-10-02 Thread Samuel Stearns
Howdy, I'm going to post this in 2 parts as I think it's too big for 1 post. Environment: PG 8.4.17 Linux Ubuntu 10.04 Total RAM - 1G Things that have been performed: 1. Explain on SELECT. 2. ANALYZE database. 3. VACUUM database. 4. shared_buffers = 256M 5. e

[PERFORM] Advice on tuning slow query

2013-05-21 Thread Samuel Stearns
syslog, devices WHERE syslog.ip IN (SELECT ip FROM devices, mongroups WHERE (active = 't' OR active = 's') AND devices.hostgroup = mongroups.hostgroup AND devices.hostname || '.' || devices.hostpop = 'pe1.mel4' AND devices.id != '1291') AND datetime <= '2013-04-24 00:00:00' AND datetime >= '2013-04-21 00:00:00' AND syslog.ip = devices.ip AND ( devices.active = 't' OR devices.active = 's' ); Is there anything I can do to get the SELECT to run a little quicker. Thank you, Samuel Stearns