pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: dan@sidhe.org
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: dan@sidhe.org,"Robert Haas" <robertmhaas@gmail.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Trying to track down weird query stalls
Date: Mon, 30 Mar 2009 16:49:55 -0400 (EDT)
Message-ID: <61646.199.172.169.32.1238446195.squirrel@localhost> (raw)
In-Reply-To: <20090330203939.GF23023@alvh.no-ip.org>
References: <58166.199.172.169.15.1238435452.squirrel@localhost>
	<603c8f070903301131p8086067ob552d09e8b21c82@mail.gmail.com>
	<56921.199.172.169.36.1238438533.squirrel@localhost>
	<dcc563d10903301238u135d82bpf498c2d40ac31977@mail.gmail.com>
	<57654.199.172.169.17.1238442145.squirrel@localhost>
	<dcc563d10903301247t58bef7cbsd0b6d3bbd1a5e046@mail.gmail.com>
	<56164.199.172.169.17.1238443348.squirrel@localhost>
	<603c8f070903301313u1a9606a3m27da187b5e376785@mail.gmail.com>
	<56504.199.172.169.35.1238445194.squirrel@localhost>
	<20090330203939.GF23023@alvh.no-ip.org>

> dan@sidhe.org escribió:
>
>> where libinstance.libdate <= 1238445044
>>    and libinstance.enddate > 1238445044
>>    and libinstance.libinstanceid = libobject.libinstanceid
>>    and libinstance.architecture = ?
>
> How are you generating the explain?  My bet is that you're just
> substituting a literal in the architecture condition, but if the driver
> is smart then maybe it's preparating the query beforehand.  You'll get a
> different plan in that case.

I don't think so. Perl's DBI is involved, but the statement's in a
variable. The code in question is:

   if ($db->{debug}) {
    $db->debug("SQL is: $sql\n");
    my $rows = $db->{dbh}->selectall_arrayref("explain analyze $sql",
                                              undef, $db->{arch},
                                              $db->{basebranch});
    foreach my $row (@$rows) {
      $db->debug(join(" ", @$row). "\n");
    }
    $db->debug_stamp("Initial query done\n");
  }

  $rows = $db->{dbh}->selectall_arrayref($sql,
					 undef, $db->{arch},
					 $db->{basebranch});

There's no transform of the sql variable between the two statements, just
a quick loop over the returned rows from the explain analyze to print them
out. (I did try to make sure that the debugging bits were done the same
way as the mainline code, but I may have bobbled something)

-Dan





view thread (19+ messages)  latest in thread

Message-ID: <61646.199.172.169.32.1238446195.squirrel@localhost>
Permalink:  ../61646.199.172.169.32.1238446195.squirrel@localhost/
Also on:    postgresql.org/message-id/61646.199.172.169.32.1238446195.squirrel@localhost

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: dan@sidhe.org, alvherre@commandprompt.com, robertmhaas@gmail.com, scott.marlowe@gmail.com
  Subject: Re: Trying to track down weird query stalls
  In-Reply-To: <61646.199.172.169.32.1238446195.squirrel@localhost>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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