? in explain query
От | Rajesh Kumar Mallah |
---|---|
Тема | ? in explain query |
Дата | |
Msg-id | 3FA49979.3070909@trade-india.com обсуждение исходный текст |
Ответы |
Re: ? in explain query
Application monitoring |
Список | pgsql-admin |
Hi ,
In the explain below are the references
"outer"."?column2?" = "inner"."?column2?"
Ok?
rt3=# SELECT version();
version
----------------------------------------------------------------
PostgreSQL 7.4beta5 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)
rt3=# explain analyze SELECT count(*) from Tickets main JOIN Groups as Groups_1 ON ( main.id = Groups_1.Instance);
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=9047.54..9047.54 rows=1 width=0) (actual time=2210.017..2210.018 rows=1 loops=1)
-> Merge Join (cost=7838.44..8914.51 rows=53211 width=0) (actual time=1480.912..2111.089 rows=47152 loops=1)
Merge Cond: ("outer"."?column2?" = "inner"."?column2?")
-> Sort (cost=1057.51..1083.58 rows=10431 width=4) (actual time=124.539..137.337 rows=10431 loops=1)
Sort Key: (main.id)::text
-> Seq Scan on tickets main (cost=0.00..361.31 rows=10431 width=4) (actual time=0.032..34.973 rows=10431 loops=1)
-> Sort (cost=6780.93..6936.18 rows=62097 width=8) (actual time=1356.213..1483.773 rows=62097 loops=1)
Sort Key: (groups_1.instance)::text
-> Seq Scan on groups groups_1 (cost=0.00..1336.97 rows=62097 width=8) (actual time=0.017..170.204 rows=62097 loops=1)
Total runtime: 2216.263 ms
(10 rows)
rt3=#
В списке pgsql-admin по дате отправления: