Am 31.05.19 um 14:06 schrieb Saurabh Agrawal:
Which query are you trying to run?
you can show us also the EXPLAIN - Output.
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
Which query are you trying to run?
On Fri, May 31, 2019, 16:45 Sonam Sharma wrote:
> I only fetched 2 rows and it's responding
>
> On Fri, May 31, 2019, 4:39 PM Nicklas Avén
> wrote:
>
>> To find out if there is some locking problem or just takes time for the
>> client to handle the data, ask j
I only fetched 2 rows and it's responding
On Fri, May 31, 2019, 4:39 PM Nicklas Avén
wrote:
> To find out if there is some locking problem or just takes time for the
> client to handle the data, ask just for a small subset of the table.
>
>
> If
>
> select * from table limit 1;
>
> works it is p
To find out if there is some locking problem or just takes time for the
client to handle the data, ask just for a small subset of the table.
If
select * from table limit 1;
works it is probably just taking a lot of time to send all the data to
the client.
If the data set includes something
ADding to this, this no of records are present on this table : 19087314
On Fri, May 31, 2019 at 4:28 PM Sonam Sharma wrote:
> Hi Team ,
>
> when i am trying to do select on one table , its hanging and not giving
> any output.
> Can someone please advice what should I check for this ?
>
Hi Team ,
when i am trying to do select on one table , its hanging and not giving any
output.
Can someone please advice what should I check for this ?
