On Thu, Nov 17, 2016 at 3:55 AM, Metatrader EA wrote:
> How can I check this?
Several options are listed in the docs:
https://www.postgresql.org/docs/9.6/static/monitoring.html
--
Michael
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your sub
Hi,
How can I check this?
//Bill
On Thu, Nov 17, 2016 at 12:02 PM, Guillaume Cottenceau wrote:
> Locks? (VACUUM FULL, etc) Autovacuum?
>
> > Hi,
> >
> > I run this query select count(*) from analyse_forecast where
> daterange_analyse
> > <@ daterange( current_date - 150, current_date, '[]') ;
Locks? (VACUUM FULL, etc) Autovacuum?
> Hi,
>
> I run this query select count(*) from analyse_forecast where
> daterange_analyse
> <@ daterange( current_date - 150, current_date, '[]') ;
>
> Sometimes will query be quick and sometimes is same query SUPER SLO
>
> Something I can do ? Somethin
Hi,
I run this query select count(*) from analyse_forecast where
daterange_analyse <@ daterange( current_date - 150, current_date, '[]') ;
Sometimes will query be quick and sometimes is same query SUPER SLO
Something I can do ? Something I can check for ?
//Bill
On Thu, Jun 10, 2010 at 5:36 AM, AI Rumman wrote:
> I found only AccessShareLock in pg_locks during the query.
> And the query does not return data though I have been waiting for 10 mins.
>
> Do you have any idea ?
I have queries that run for hours. As long as it's using CPU / IO
(use top in uni
AI Rumman wrote:
> [It takes a long time to return 2.6 million rows.]
> Any more idea, please.
I don't recall you telling us exactly what the environment and
connection type is in which you're trying to return this large
result set. Any specific suggestions would depend on that
information.
Any more idea, please.
Is table partition a good solution for query optimization?
On Fri, Jun 11, 2010 at 11:09 AM, Amit Khandekar <
amit.khande...@enterprisedb.com> wrote:
>
>
> On 10 June 2010 18:47, AI Rumman wrote:
>
>> I am using Postgresql 8.1 and did not find FETCH_COUNT
>>
>>
> Oh ok. Lo
On 10 June 2010 18:47, AI Rumman wrote:
> I am using Postgresql 8.1 and did not find FETCH_COUNT
>
>
Oh ok. Looks like FETCH_COUNT was introduced in 8.2
> On Thu, Jun 10, 2010 at 6:55 PM, Amit Khandekar <
> amit.khande...@enterprisedb.com> wrote:
>
>>
>>
>> On 10 June 2010 18:05, AI Rumman wro
I am using Postgresql 8.1 and did not find FETCH_COUNT
On Thu, Jun 10, 2010 at 6:55 PM, Amit Khandekar <
amit.khande...@enterprisedb.com> wrote:
>
>
> On 10 June 2010 18:05, AI Rumman wrote:
>
>> Could you please give me the link for cursor- How to use it?
>>
>>
>> On Thu, Jun 10, 2010 at 6:28 P
On 10 June 2010 18:05, AI Rumman wrote:
> Could you please give me the link for cursor- How to use it?
>
>
> On Thu, Jun 10, 2010 at 6:28 PM, Kevin Grittner <
> kevin.gritt...@wicourts.gov> wrote:
>
>> AI Rumman wrote:
>>
>> >> Merge Left Join (cost=9500.30..101672.51 rows=2629549 width=506)
>>
Could you please give me the link for cursor- How to use it?
On Thu, Jun 10, 2010 at 6:28 PM, Kevin Grittner wrote:
> AI Rumman wrote:
>
> >> Merge Left Join (cost=9500.30..101672.51 rows=2629549 width=506)
>
> > And the query does not return data though I have been waiting for
> > 10 mins.
> >
AI Rumman wrote:
>> Merge Left Join (cost=9500.30..101672.51 rows=2629549 width=506)
> And the query does not return data though I have been waiting for
> 10 mins.
>
> Do you have any idea ?
Unless you use a cursor, PostgreSQL interfaces typically don't show
any response on the client side u
2010/6/10 AI Rumman
> I found only AccessShareLock in pg_locks during the query.
> And the query does not return data though I have been waiting for 10 mins.
>
> Do you have any idea ?
>
>
> On Thu, Jun 10, 2010 at 5:26 PM, Szymon Guz wrote:
>
>>
>>
>> 2010/6/10 AI Rumman
>>
>> Can anyone pleas
I found only AccessShareLock in pg_locks during the query.
And the query does not return data though I have been waiting for 10 mins.
Do you have any idea ?
On Thu, Jun 10, 2010 at 5:26 PM, Szymon Guz wrote:
>
>
> 2010/6/10 AI Rumman
>
> Can anyone please tell me why the following query hangs?
2010/6/10 AI Rumman
> Can anyone please tell me why the following query hangs?
> This is a part of a large query.
>
> explain
> select *
> from vtiger_emaildetails
> inner join vtiger_vantage_email_track on vtiger_emaildetails.emailid =
> vtiger_vantage_email_track.mailid
> left join vtiger_seact
Can anyone please tell me why the following query hangs?
This is a part of a large query.
explain
select *
from vtiger_emaildetails
inner join vtiger_vantage_email_track on vtiger_emaildetails.emailid =
vtiger_vantage_email_track.mailid
left join vtiger_seactivityrel on vtiger_seactivityrel.activi
16 matches
Mail list logo