Enormous DB pressure

Hello there!

My self-hosted Zitadel instance performs many SELECTs from the event store, resulting in the database reading thousands of rows per second.

SELECT created_at, event_type, "sequence", "position", payload, creator, "owner", instance_id, aggregate_type, aggregate_id, revision FROM eventstore.events2 WHERE instance_id = $1 AND aggregate_type = $2 AND aggregate_id = $3 AND event_type = ANY($4) ORDER BY "sequence"

SELECT created_at, event_type, "sequence", "position", payload, creator, "owner", instance_id, aggregate_type, aggregate_id, revision FROM eventstore.events2 WHERE instance_id = $1 AND aggregate_type = $2 AND aggregate_id = $3 AND event_type = ANY($4) ORDER BY "sequence"

About 2 QPS, fetching about 8K rows per second. This notably decreased the performance of the DB and Zitadel, especially CreateSessionCreateSession requests.

Has anyone else experienced this?

Zitadel 3.4.2
AWS Postgres 17, m6g.xlarge, 4vCPU, 16GB RAM.

ZITADEL•7mo ago•

2 replies

ashep

Enormous DB pressure

Hello there!

My self-hosted Zitadel instance performs many SELECTs from the event store, resulting in the database reading thousands of rows per second.

SELECT created_at, event_type, "sequence", "position", payload, creator, "owner", instance_id, aggregate_type, aggregate_id, revision FROM eventstore.events2 WHERE instance_id = $1 AND aggregate_type = $2 AND aggregate_id = $3 AND event_type = ANY($4) ORDER BY "sequence"

SELECT created_at, event_type, "sequence", "position", payload, creator, "owner", instance_id, aggregate_type, aggregate_id, revision FROM eventstore.events2 WHERE instance_id = $1 AND aggregate_type = $2 AND aggregate_id = $3 AND event_type = ANY($4) ORDER BY "sequence"

Continue the conversation

Join the Discord to ask follow-up questions and connect with the community

ZITADEL

ZITADEL - Identity infrastructure, simplified for you.

4,566 Members

Join

Enormous DB pressure

Enormous DB pressure

Continue the conversation

ZITADEL

Continue the conversation

ZITADEL

Similar Threads