Re: Getting fancy errors when accessing information_schema on 10.5 - Mailing list pgsql-admin

Axel Rau <Axel.Rau@Chaos1.DE> writes:
> Am 30.10.2018 um 14:45 schrieb Tom Lane <tgl@sss.pgh.pa.us>:
>> Axel, would you try two more things on that DB?

> nextcloud=> explain select ((pg_has_role(relowner, 'USAGE'::text) OR has_sequence_privilege(oid, 'SELECT, UPDATE,
USAGE'::text)))from pg_class; 
>                         QUERY PLAN
> -----------------------------------------------------------
>  Seq Scan on pg_class  (cost=0.00..28.56 rows=656 width=1)
> (1 row)

> nextcloud=> explain select (relkind = 'S'::"char") from pg_class;
>                         QUERY PLAN
> -----------------------------------------------------------
>  Seq Scan on pg_class  (cost=0.00..28.56 rows=656 width=1)
> (1 row)

That is ... odd.  Is it possible that you have cpu_operator_cost set
to zero, or some very tiny number?

            regards, tom lane