Re: explain analyze on a function

Alvaro Herrera wrote:
> Try doing a PREPARE and then EXPLAIN EXECUTE, like
>
> alvherre=# prepare foo as select generate_series(1, $1);
> PREPARE
>
> alvherre=# explain analyze execute foo(100);
> QUERY PLAN
> --------------------------------------------------------------------------------------
> Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.014..0.294 rows=100 loops=1)
> Total runtime: 0.550 ms
> (2 filas)
>
> alvherre=# explain analyze execute foo(10000);
> QUERY PLAN
> -----------------------------------------------------------------------------------------
> Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.012..35.082 rows=10000 loops=1)
> Total runtime: 59.077 ms
> (2 filas)
>
>
>

Hm, no luck ;(

prepare f1 as select * from
raspored.dohvati_statistiku_rada_u_smjenama_radnika($1, $2);
explain analyze execute f1(current_date, 4);

"Function Scan on dohvati_statistiku_rada_u_smjenama_radnika
(cost=0.00..12.50 rows=1000 width=188) (actual time=8013.779..8013.906
rows=75 loops=1)"
"Total runtime: 8014.073 ms"

Regards,
Rikard