Re: Mark Felder 2013-05-13
> What version of DBIx-SearchBuilder do you have on that server? The
> RT guys usually recommend you have the latest possible so RT is
> performing the most sane/optimized queries possible for your
> database. I honestly don't know if it will make a difference for
> you,
Re: Tom Lane 2013-05-06 <1583.1367858...@sss.pgh.pa.us>
> The newer rowcount estimates are much further away from reality:
>
> > Unique (cost=1117.67..1118.46 rows=9 width=1115) (actual
> > time=82.646..85.695 rows=439 loops=1)
>
> > Unique (cost=784205.94..796940.08 rows=145533 width=1061)
On Mon, May 13, 2013 at 9:05 AM, Desbiens, Eric wrote:
> I tried also:
>
> select * from pg_class where oid=30352481;
>
> but didn't got anything
You probably want where relfilenode=30352481.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent
On Mon, May 13, 2013 at 4:33 PM, Tom Lane wrote:
> Robert Haas writes:
>> On Mon, May 13, 2013 at 4:14 PM, Tom Lane wrote:
>>> You know, of course, that the join size estimate isn't arrived at that
>>> way. Still, this point does make it seem more like a planner bug and
>>> less like bad input
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 predica
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?
Thank you
Sameer
