Slow requests for Postgrest after upgrading to 12.0.2

Went from 200ms -> 1.3seconds

It is patching some json data 40kb to jsonb field

/rest/v1/page_versions?id=eq.f06559cc
Request Method:
PATCH

jwt;dur=401.9, parse;dur=408.2, plan;dur=42.1, transaction;dur=25191.8, response;dur=2.2

jwt;dur=401.9, parse;dur=408.2, plan;dur=42.1, transaction;dur=25191.8, response;dur=2.2

X-Kong-Upstream-Latency: 1052

X-Kong-Upstream-Latency: 1052

Also upgraded to latest Supabase-js

Any tips would be much appreciated, I really wanted the benefit of JWT caching

Extra notes:

- Requests to auth took 130ms
- get request to same table

jwt;dur=211.6, parse;dur=473.6, plan;dur=60.2, transaction;dur=676.9, response;dur=2.2

jwt;dur=211.6, parse;dur=473.6, plan;dur=60.2, transaction;dur=676.9, response;dur=2.2

X-Kong-Upstream-Latency: 527

X-Kong-Upstream-Latency: 527

Supabase•3y ago•

12 replies

Volkan

Slow requests for Postgrest after upgrading to 12.0.2

Went from 200ms -> 1.3seconds

It is patching some json data 40kb to jsonb field

/rest/v1/page_versions?id=eq.f06559cc
Request Method:
PATCH

jwt;dur=401.9, parse;dur=408.2, plan;dur=42.1, transaction;dur=25191.8, response;dur=2.2

jwt;dur=401.9, parse;dur=408.2, plan;dur=42.1, transaction;dur=25191.8, response;dur=2.2

X-Kong-Upstream-Latency: 1052

X-Kong-Upstream-Latency: 1052

Also upgraded to latest Supabase-js

Any tips would be much appreciated, I really wanted the benefit of JWT caching

Extra notes:

- Requests to auth took 130ms
- get request to same table

jwt;dur=211.6, parse;dur=473.6, plan;dur=60.2, transaction;dur=676.9, response;dur=2.2

jwt;dur=211.6, parse;dur=473.6, plan;dur=60.2, transaction;dur=676.9, response;dur=2.2

X-Kong-Upstream-Latency: 527

X-Kong-Upstream-Latency: 527

Slow requests for Postgrest after upgrading to 12.0.2

Similar Threads

Slow requests for Postgrest after upgrading to 12.0.2

Similar Threads

Similar Threads

Similar Threads