Re: Why schema of table is removed from explain?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: depesz(at)depesz(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Why schema of table is removed from explain?
Date: 2011-09-01 20:24:59
Message-ID: 21474.1314908699@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hubert depesz lubaczewski <depesz(at)depesz(dot)com> writes:
> $ explain select * from x.y limit 1;
> QUERY PLAN
> ------------------------------------------------------------
> Limit (cost=0.00..0.04 rows=1 width=189)
> -> Seq Scan on y (cost=0.00..13.70 rows=370 width=189)
> (2 rows)

> Why it doesn't show "Seq Scan on x.y" ?

The non-plain-text output formats provide that sort of detail, if you
need it.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2011-09-01 20:35:14 Re: Why schema of table is removed from explain?
Previous Message David Johnston 2011-09-01 19:24:09 How to get around this limitation (ALTER DATABASE db SET search_path = ...)