hi, you can use the EXPLAIN instruction. "\h EXPLAIN" in psql for help.
bye David Cana wrote: > Hello! > > I have got a view like: > > create view consulta_material as > select > material.clave as clave, > referencia, > sede.nombre_es as nombre_sede, clave_sede, > soporte.nombre_es as nombre_soporte, clave_soporte, > area_materiales.nombre_es as nombre_area_materiales, > clave_area_materia > autor, > titulo, > descripcion, > fecha_intro, fecha_modificacion > > from material, sede, soporte, area_materiales > > where (material.clave_sede = sede.clave) > and (material.clave_soporte = soporte.clave) > and (material.clave_area_materiales = area_materiales.clave); > > IŽd like to know the performance difference between... > > select * from consulta_material where clave=1; > > And... > > select > material.clave as clave, > referencia, > sede.nombre_es as nombre_sede, clave_sede, > soporte.nombre_es as nombre_soporte, clave_soporte, > area_materiales.nombre_es as nombre_area_materiales, > clave_area_materia > autor, > titulo, > descripcion, > fecha_intro, fecha_modificacion > > from material, sede, soporte, area_materiales > > where (material.clave_sede = sede.clave) > and (material.clave_soporte = soporte.clave) > and (material.clave_area_materiales = area_materiales.clave) > and (material.clave=1); > > How can I measure SQL queries and views? > > Thanks. > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > > > -- Emmanuel SARACCO Email: [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
