Mladen Gogala <gogala.mladen@gmail.com> writes:
> The query from the view would probably merge view with the original and
> optimize everything as a single query. Unfortunately, there is no way to
> tell:
> mgogala=# explain select ename,job,sal from acct_view;
> QUERY PLAN
> ----------------------------------------------------
> Seq Scan on emp (cost=0.00..1.18 rows=3 width=21)
> Filter: (deptno = 10)
> (2 rows)
> The only tool that you have at your disposal is EXPLAIN.
No ... EXPLAIN VERBOSE would fill in the detail you want,
as somebody else already demonstrated in this thread.
regards, tom lane