Queries and views

Started by David Canaover 24 years ago2 messagesgeneral
Jump to latest
#1David Cana
david@cherrytel.com

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.

#2Emmanuel SARACCO
esaracco@noos.fr
In reply to: David Cana (#1)
Re: Queries and views

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: esaracco@noos.fr