Menu
▾
▴
#418 No responce at EXPLAIN ANALYZE to LEFT OUTER JOIN
Tested at : PG-XC v1.0.1
Postgres-XC branch, REL1_0_STABLE,updated. XC1_0_1_PG9_1-38-g3bcdab7
Commit ID ： 3bcdab7eafaa5d393b60d167dc5a08a240c5186f
Observed version
PG-XC v1.0.2
PG-XC v1.0.3
Not observed :
PG-XC v1.0.1
PG-XC v1.1
Environment :
Server 1 : GTM
Server 2 : GTM-Proxy & Coordinator
Server 3 : GTM-Proxy & Datanode1
Server 4 : GTM-Proxy & Datanode2
Server 5 : GTM-Proxy & Datanode3
Server 6 : GTM-Proxy & Datanode4
Test set :
DBT-2
Procedure :
postgres@pgxc01 scripts]$ psql -h 192.168.1.3 dbt2
psql (PGXC 1.0.2, based on PG 9.1.7)
Type "help" for help.
dbt2=# EXPLAIN ANALYZE SELECT * FROM item LEFT OUTER JOIN stock ON i_id = s_i_id where s_i_id < 2001 and s_w_id < 201;
--- No responce at least 10 minutes ---
[postgres@pgxc01 install_coord_perf]$ psql -h 192.168.1.3
psql (PGXC 1.0.2, based on PG 9.1.7)
Type "help" for help.
postgres=# SELECT
procpid,
start,
now() - start AS lap,
current_query
FROM
(SELECT
backendid,
pg_stat_get_backend_pid(S.backendid) AS procpid,
pg_stat_get_backend_activity_start(S.backendid) AS start,
pg_stat_get_backend_activity(S.backendid) AS current_query
FROM
(SELECT pg_stat_get_backend_idset() AS backendid) AS S
) AS S
WHERE
current_query <> ''
ORDER BY
lap DESC LIMIT 1;
procpid | start | lap | current_query
---------+-------------------------------+-----------------+-----------------------------------------------------------------
------------------------------------------------
9673 | 2013-03-07 12:22:54.929863+09 | 00:11:52.115181 | EXPLAIN ANALYZE SELECT * FROM item LEFT OUTER JOIN stock ON i_id
= s_i_id where s_i_id < 2001 and s_w_id < 201;
(1 row)
Test result at PG-XC v1.0.1 => O.K.
Testrd version :
PG-XC v1.0.1
Postgres-XC branch, REL1_0_STABLE,updated. XC1_0_1_PG9_1-38-g3bcdab7
Commit ID ： 3bcdab7eafaa5d393b60d167dc5a08a240c5186f
Procedure :
[postgres@pgxc01 scripts]$ psql -h 192.168.1.3 dbt2
psql (PGXC 1.0.1, based on PG 9.1.5)
Type "help" for help.
dbt2=# EXPLAIN ANALYZE SELECT * FROM item LEFT OUTER JOIN stock ON i_id = s_i_id where s_i_id < 2001 and s_w_id < 201;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------
Data Node Scan on "__REMOTE_FQS_QUERY__" (cost=0.00..0.00 rows=0 width=0) (actual time=55.507..7890.791 rows=400000 loops=1)
Node/s: dn1, dn2, dn3, dn4
Total runtime: 8005.650 ms
(3 rows)