From: | Miha Radej <miha(dot)radej(at)siix(dot)com> |
---|---|
To: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Problem in graphical explain |
Date: | 2006-04-12 15:37:18 |
Message-ID: | 443D1EAE.2040809@siix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
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 .
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? 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)
I tried refreshing multiple times in both databases, the results were
always the same. The foo display happens when working on a remote
database on Server 1, while the local tests were done on Server 2:
Server 1: 8.0.1 on DragonFlyBSD 1.2.6, compiled by GCC 2.95.4
Server 2: 8.0.3 on SuSE Linux 10.0, compiled by GCC 4.0.2
If there is any other info I can provide in order to help diagnose the
problem, let me know.
Regards,
Miha
From | Date | Subject | |
---|---|---|---|
Next Message | svn | 2006-04-12 15:52:25 | SVN Commit by dpage: r5077 - in trunk/pgadmin3: . src/frm src/ui |
Previous Message | edigeronimo | 2006-04-12 03:47:46 | Clipboard update |