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

Re: Problem in graphical explain

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Miha Radej <miha(dot)radej(at)siix(dot)com>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Problem in graphical explain
Date: 2006-04-12 17:08:14
Message-ID: 443D33FE.8050200@pse-consulting.de (view raw or flat)
Thread:
Lists: pgadmin-hackers
Miha Radej wrote:
> Hi!
> 
> I have some tables and playing with a query and graphical explain got me
> to a strange result - a grey line across the entire window; see
> http://mcajvar.prkoritu.net/pgadmin/graphic_explain_db1.png .

There's something wrong here :-)

> 
> I then made an exact duplicate copy of the users, database, everything I
> could think of and tried to duplicate the strange display. But the
> problem wouldn't occur in this local copy; see
> http://mcajvar.prkoritu.net/pgadmin/graphic_explain_db2.png .
> 
> Does pgAdmin use the output of the explain query in order to construct
> the graphic illustration?

It does.

  If so then these may be helpful:
> 
> This yields foo graphics:
> Nested Loop  (cost=0.00..0.01 rows=1 width=485)
>   Join Filter: ("outer".id = "inner".id_eventi)
>   ->  Seq Scan on eventi t1  (cost=0.00..0.00 rows=1 width=12)
>         Filter: ((datum >= '2006-04-12 00:00:00'::timestamp without
> time zone) AND (datum <= '2006-05-12 00:00:00'::timestamp without time
> zone) AND (prikaz = 1::smallint))
>   ->  Seq Scan on eventi_vsebina t2  (cost=0.00..0.00 rows=1 width=477)
>         Filter: (narocilnica = 1::smallint)
> 
> This yields a nice illustration:
> Nested Loop  (cost=0.00..47.26 rows=1 width=485)
>   Join Filter: ("outer".id = "inner".id_eventi)
>   ->  Seq Scan on eventi t1  (cost=0.00..35.38 rows=1 width=12)
>         Filter: ((datum >= '2006-04-12 00:00:00'::timestamp without
> time zone) AND (datum <= '2006-05-12 00:00:00'::timestamp without time
> zone) AND (prikaz = 1::smallint))
>   ->  Seq Scan on eventi_vsebina t2  (cost=0.00..11.88 rows=1 width=477)
>         Filter: (narocilnica = 1::smallint)

Hm, don't see why this clashes, something wrong with cost=0? Will have 
to debug this some day.

Regards,
Andreas

In response to

pgadmin-hackers by date

Next:From: Magnus HaganderDate: 2006-04-12 17:22:08
Subject: Re: Clipboard update
Previous:From: Andreas PflugDate: 2006-04-12 17:05:25
Subject: Re: Clipboard update

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