Re: How to list ALL PostgreSQL functions?

Thanks a lot.

How to size HW resources on a physical server for PG95+?

What does PG95+ like? Cpu? L1(expensive I think) 2 or 3 cache level?. RAM?

Any idea?

Thanks

Poul

2016-09-12 13:56 GMT+02:00 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:

> hubert depesz lubaczewski <depesz(at)depesz(dot)com> writes:
> > \df gives you list of user functions. you can add more parameters, to
> > limit/extend the list.
> > like:
> > \df pg_*
> > will list all functions (including system one) that start with pg_
> > \dfS
> > will list all system functions
> > \df+ *xlog*
> > will list all functions (including system) that contain "xlog" in their
> > name, with some additional columns, which include "description" - one
> > line info about the function.
>
> Also, you can make your own queries on pg_proc, which is all that psql is
> doing here. A nice abbreviated form is
>
> select oid::regprocedure, obj_description(oid, 'pg_proc') from pg_proc;
>
> which gives you just the name, arg types, and comment for each row.
>
> Keep in mind that
>
> 1. This will show you an awful lot of stuff that's not meant to be called
> directly from SQL, eg I/O functions, operator implementation functions,
> aggregate support functions, cast functions, index support functions.
> I count 2831 rows in pg_proc in a virgin installation as of HEAD, and
> probably not even 1000 of them are really meant to be called as functions
> in ordinary queries.
>
> 2. This will not show you some things that look like functions but are
> implemented by special grammar productions. For that you'd have to
> look into src/backend/parser/gram.y.
>
> regards, tom lane
>

--
Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA