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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
