Problem in graphical explain
От | Miha Radej |
---|---|
Тема | Problem in graphical explain |
Дата | |
Msg-id | 443D1EAE.2040809@siix.com обсуждение исходный текст |
Ответы |
Re: Problem in graphical explain
Re: Problem in graphical explain |
Список | 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
В списке pgadmin-hackers по дате отправления: