On 04/10/2013 06:31 AM, Zahid Quadri wrote:
please suggest if there is any way which i can find which tables need
indexes in postgresql.
If you have 8.4 or newer, you can look in pg_stat_statements for queries
that use a lot of time. Check the where clauses for columns or
transforms that can
On Wed, Apr 10, 2013 at 10:19 PM, JotaComm wrote:
> Hello,
>
>
> 2013/4/10 Thomas Kellerer
>
>> Zahid Quadri, 10.04.2013 13:31:
>>
>> hi,,
>>>
>>> please suggest if there is any way which i can find which tables need
>>> indexes in postgresql.
>>>
>>
> You have some possibilities:
>
> - the log
On Wed, Apr 10, 2013 at 9:19 AM, JotaComm wrote:
> Hello,
>
>
> 2013/4/10 Thomas Kellerer
>
>> Zahid Quadri, 10.04.2013 13:31:
>>
>> hi,,
>>>
>>> please suggest if there is any way which i can find which tables need
>>> indexes in postgresql.
>>>
>>
> You have some possibilities:
>
> - the log
Hello,
2013/4/10 Thomas Kellerer
> Zahid Quadri, 10.04.2013 13:31:
>
> hi,,
>>
>> please suggest if there is any way which i can find which tables need
>> indexes in postgresql.
>>
>
You have some possibilities:
- the log file (slow queries)
- statistics with old information (see the ANALYZE
Zahid Quadri, 10.04.2013 13:31:
hi,,
please suggest if there is any way which i can find which tables need indexes
in postgresql.
Tables don't need indexes. Queries do. You will need to show us the queries in
question (e.g. those that are slow) in order to decide which index is helpful.
Th
Sent from my iPad
On 10-Apr-2013, at 17:01, Zahid Quadri wrote:
> hi,,
>
> please suggest if there is any way which i can find which tables need indexes
> in postgresql.
>
>
>
>
If the table under consideration has lots of data,and queries on it are very
slow,you could consider addin
hi,,
please suggest if there is any way which i can find which tables need indexes
in postgresql.
