Jesper Krogh <jesper(at)krogh(dot)cc> writes:
> According to the documentation the default cost is 1 for builin
> functions and 100 for others, is this true for the ts-stuff also?
Yeah. There was some recent discussion of pushing up the default cost
for some of these obviously-not-so-cheap functions, but nothing's been
done yet.
> Can I query the database for the cost of the functions?
See pg_proc.
regards, tom lane