In database session when doing replication

Hi,

I'm currently debugging my SSIS replication from Source system to Greenplum.
A few days ago I have timeout issue, some of the packages get timeout error.
My last setting is COMMAND_TIMEOUT=1200, now I have to set COMMAND_TIMEOUT=12000.

When I looked into the session tracker, I found something strange repeated queries :
- select count(*)::float4
- select avg(pg_column_size(Ta.description))::float4
it seems that it looped all the column and start doing those count and avg ...

My question is :
- is that code normal ?
- will that impacted on query performance ?

Thank u

Hi,
Last time we experienced an database error.. so that count query popped up.
Confirmed now we're not having it again, and the performance is going back to normal.

thank u