Re: calcular tiempo de consulta en Postgres

From: "Jaime Casanova" <systemguards(at)gmail(dot)com>
To: Alejandro Sepúlveda Sotomayor <jalitrox(at)msn(dot)com>
Cc: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: calcular tiempo de consulta en Postgres
Date: 2007-06-19 00:55:04
Message-ID: c2d9e70e0706181755x17eabee4re4d4c9f4048ec620@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

On 6/18/07, Alejandro Sepúlveda Sotomayor <jalitrox(at)msn(dot)com> wrote:
>
> Hola a todos: ¿Alguien sabe como tomarle el tiempo a una consulta en
> Postgres?
>

explain analyze

o en psql

\timing on

antes de tu consulta

--
Atentamente,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook

In response to

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Jaime Casanova 2007-06-19 00:57:42 Re: Ayuda con Función
Previous Message Alejandro Sepúlveda Sotomayor 2007-06-18 22:47:06 calcular tiempo de consulta en Postgres