Re: Related to Foreign Table Accessing

Hi Team,

When I see the same query via pg_stat_activity it was hang on explain
statement.

How to handle this and moreover I found in docs there is a parameter I.e
analyze_sampling.

How to set this ?

On Thu, 30 Nov, 2023, 9:15 pm ROHIT SACHDEVA, <sachdeva(dot)rohit648(at)gmail(dot)com>
wrote:

> Hi Team,
>
> When i run the same query via client it takes around 2 seconds and when it
> is run at application side it is taking around 40 seconds
>
> Examples
> select animal_id from table where owner_id in ()
> limit 200 offset 1600 -- takes 2 seconds
> select animal_id from table where owner_id in ()
> limit 200 offset 1800 --takes 40 seconds.
>
> What will be this issue?
>
> On Tue, Nov 28, 2023 at 2:08 PM ROHIT SACHDEVA <
> sachdeva(dot)rohit648(at)gmail(dot)com> wrote:
>
>> Hi Team,
>> The application team is accessing a foreign table in batches of 200 rows,
>> but the problem they are facing is that the query is taking different times
>> for the same set of rows.
>> The foreign table is only 1 shard with a partition of 21, and the
>> partition we are using is a hash partition.
>>
>> What can I do at the database side to debug this or any configuration
>> parameter related to this wired behavior?
>> Have a Good day !!!
>>
>> Regards
>> Rohit Sachdeva
>>
>
>
> --
> Have a Good day !!!
>
> Regards
> Rohit Sachdeva
>