Postgres Pro
Downloads
Home   >   mailing lists

How can I check if my cursor statement is using index - Mailing list pgsql-general

From Dragan Matić
Subject How can I check if my cursor statement is using index
Date
Msg-id 433B9C5D.7090701@panforma.co.yu
Whole thread Raw
Responses Re: How can I check if my cursor statement is using index
Re: How can I check if my cursor statement is using index
List pgsql-general
Tree view 
I have a program that reads data from Postgresql database (version
8.0.3) through ODBC, but data retrieval is pretty slow. When I type the
same SQL sentence in pgadmin III or any other sql tool it is much
faster, and typing 'explain' clearly shows that it is using index.
However the program is reading data through a dynamic cursor, I would
like to know if there is a way to check if the same sql query generated
through dynamic cursor still uses indexes?
Thanks in advance

Dragan

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Hardware requirements
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Hardware requirements