Skip site navigation (1) Skip section navigation (2)

Re: odd explain diagram in head versions

From: Jeremy Drake <pgsql(at)jdrake(dot)com>
To: Dave Page <dpage(at)postgresql(dot)org>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: odd explain diagram in head versions
Date: 2007-03-30 06:13:17
Message-ID: Pine.BSO.4.64.0703292303340.685@resin.csoft.net (view raw or flat)
Thread:
Lists: pgadmin-hackers
On Thu, 29 Mar 2007, Dave Page wrote:

> Jeremy Drake wrote
> >
> > The problem seems to be that the trigger information is overlaid on the
> > index scan in the graph, resulting in an unreadable mess of text.
> >
>
> Looks like it. Can you provide me a self contain test case please?

Sure.  Here's a simple schema to demonstrate the problem:

CREATE TABLE tbl1
(
  tbl1id integer NOT NULL PRIMARY KEY
);

CREATE TABLE tbl2
(
  tbl2id integer NOT NULL PRIMARY KEY,
  tbl1id integer NOT NULL REFERENCES tbl1(tbl1id) ON DELETE CASCADE
);

INSERT INTO tbl1(tbl1id) SELECT x from generate_series(0,4) t(x);
INSERT INTO tbl2(tbl1id, tbl2id) SELECT tbl1id, x + tbl1id*5 FROM
	tbl1, generate_series(0,4) t(x);


In the query window, make sure the explain analyze option is on and ask it
to explain the query:

DELETE FROM tbl1 WHERE tbl1id BETWEEN 1 AND 3;


-- 
There are people so addicted to exaggeration
that they can't tell the truth without lying.
		-- Josh Billings

In response to

Responses

pgadmin-hackers by date

Next:From: svnDate: 2007-03-30 08:20:31
Subject: SVN Commit by dpage: r6141 - in trunk/pgadmin3: . pgadmin/include/schema pgadmin/schema
Previous:From: svnDate: 2007-03-29 21:42:15
Subject: SVN Commit by guillaume: r6140 - trunk/www/locale/zh_CN/LC_MESSAGES

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group