Slow response in Query result

Toad Edge
1

Execution time is higher for a simple SQL even though i have a limit of 500 in SQL. This occur when a table has huge no of records.

Same SQL using PSQL execute in 100~200 msec, using Toad Edge 1500 ~2500 msec.
Explain plan is same in both the place. We notice there is wait event Client READ/Write when executing from TOAD Edge.

Postgres DB version -11.4

Please let us know if any information required.

2

Hi, limit is applied only on data grid. In SQL worsheet are loaded all data specified by query.
br.
Miroslav Stanik

3

Hi,

while executing in work sheet. In SQL i have added limit 500 still query run slow with client read/write wait