explain-analyze.info

Summary

Time Node

Node (ms) Percent

Time	Node
Node (ms)	Percent
163263.458	100.00%	¶	`Limit (cost=0.0..22.63 rows=1 width=12) (actual time=163263.458..163263.458 rows=0 loops=1)`
163263.449	100.00%	¶	`-> Index Scan using fecha_id_index on "MUESTRA" (cost=0.0..4189184.53 rows=185124 width=12) (actual time=163263.449..163263.449 rows=0 loops=1) Index Cond: ("FECHA_MUESTRA" > to_timestamp('2008-05-01 00:00:00'::text, 'yyyy-MM-dd H24:MI:SS'::text)) Filter: ("ID_VARIABLE" = 17)`

163263.458

100.00%

 Limit (cost=0.0..22.63 rows=1 width=12) (actual time=163263.458..163263.458 rows=0 loops=1)

163263.449

100.00%

   -> Index Scan using fecha_id_index on "MUESTRA" (cost=0.0..4189184.53 rows=185124 width=12) (actual time=163263.449..163263.449 rows=0 loops=1)
         Index Cond: ("FECHA_MUESTRA" > to_timestamp('2008-05-01 00:00:00'::text, 'yyyy-MM-dd H24:MI:SS'::text))
         Filter: ("ID_VARIABLE" = 17)

Run-time

2 minutes 43.263526 seconds (163263.526 ms)

Highlighted rows indicate a disparity between the number of rows estimated and actually returned. You may want to run ANALYZE to update the server's statistics.
For more information on using EXPLAIN and interpreting its output, see the Postgres documentation, in particular the EXPLAIN and ANALYZE references pages, and Using Explain.

lenta