Toad World® Forums

Slow response in Query result

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.

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

Hi,

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