On 14.05.2013 12:23, Sameer Thakur wrote:
Hello,
I am trying to find predicate information for a given SQL query plan as
provided by Oracle using DBMS_XPLAN. I am looking at the EXPLAIN command
for getting this query plan information, with no luck so far.
Does the EXPLAIN command provide predicate information?
Sure. For example,
postgres=# explain select * from a where id = 123;
QUERY PLAN
---
Seq Scan on a (cost=0.00..40.00 rows=12 width=4)
Filter: (id = 123)
(2 rows)
The predicate is right there on the Filter line. Likewise for a join:
postgres=# explain select * from a, b where a.id = b.id;
QUERY PLAN
-
Hash Join (cost=64.00..134.00 rows=2400 width=8)
Hash Cond: (a.id = b.id)
- Seq Scan on a (cost=0.00..34.00 rows=2400 width=4)
- Hash (cost=34.00..34.00 rows=2400 width=4)
- Seq Scan on b (cost=0.00..34.00 rows=2400 width=4)
(5 rows)
The join predicate is on the Hash Cond line.
- Heikki
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance