QUERY PLAN ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Limit (cost=6592.75..6593.25 rows=200 width=378) (actual time=14.206..14.210 rows=0 loops=1) Output: events2.created_at, events2.event_type, events2.sequence, events2."position", events2.payload, events2.creator, events2.owner, events2.instance_id, events2.aggregate_type, events2 .aggregate_id, events2.revision, events2.in_tx_order Buffers: shared hit=447 read=16 I/O Timings: read=11.899 InitPlan 1 (returns $0) -> Seq Scan on projections.current_states (cost=0.00..3.20 rows=1 width=10) (actual time=0.015..0.015 rows=1 loops=1) Output: current_states."position" Filter: ((current_states.projection_name = 'projections.users14'::text) AND (current_states.instance_id = '298583134000167036'::text)) Rows Removed by Filter: 79 Buffers: shared hit=2 InitPlan 2 (returns $1) -> Aggregate (cost=2.59..2.60 rows=1 width=32) (actual time=1.124..1.126 rows=1 loops=1) Output: COALESCE(EXTRACT(epoch FROM min(s.xact_start)), EXTRACT(epoch FROM now())) -> Nested Loop (cost=0.00..2.59 rows=1 width=8) (actual time=0.421..0.422 rows=0 loops=1) Output: s.xact_start Inner Unique: true Join Filter: (s.datid = d.oid) -> Function Scan on pg_catalog.pg_stat_get_activity s (cost=0.00..1.38 rows=1 width=16) (actual time=0.420..0.420 rows=0 loops=1) Output: s.datid, s.pid, s.usesysid, s.application_name, s.state, s.query, s.wait_event_type, s.wait_event, s.xact_start, s.query_start, s.backend_start, s.state_change, s.client_addr, s.client_hostname, s.client_port, s.backend_xid, s.backend_xmin, s.backend_type, s.ssl, s.sslversion, s.sslcipher, s.sslbits, s.ssl_client_dn, s.ssl_client_serial, s.ssl_issuer_dn, s.gss_auth, s.gss_princ, s.gss_enc, s.leader_pid, s.query_id Function Call: pg_stat_get_activity(NULL::integer) Filter: ((s.application_name = ANY ('{zitadel_es_pusher_298583134000167036}'::text[])) AND (s.state <> 'idle'::text)) Rows Removed by Filter: 96 -> Seq Scan on pg_catalog.pg_database d (cost=0.00..1.20 rows=1 width=4) (never executed) Output: d.oid, d.datname, d.datdba, d.encoding, d.datcollate, d.datctype, d.datistemplate, d.datallowconn, d.datconnlimit, d.datlastsysoid, d.datfrozenxid, d.datminmxid, d.dattablespace, d.datacl Filter: (d.datname = current_database()) InitPlan 3 (returns $2) -> Seq Scan on projections.current_states current_states_1 (cost=0.00..3.20 rows=1 width=4) (actual time=0.277..0.278 rows=1 loops=1) Output: current_states_1.filter_offset Filter: ((current_states_1.projection_name = 'projections.users14'::text) AND (current_states_1.instance_id = '298583134000167036'::text)) Rows Removed by Filter: 79 Buffers: shared hit=2 -> Sort (cost=6582.92..6591.18 rows=3302 width=378) (actual time=13.924..13.924 rows=0 loops=1) Output: events2.created_at, events2.event_type, events2.sequence, events2."position", events2.payload, events2.creator, events2.owner, events2.instance_id, events2.aggregate_type, events2.aggregate_id, events2.revision, events2.in_tx_order Sort Key: events2."position", events2.in_tx_order Sort Method: quicksort Memory: 25kB Buffers: shared hit=445 read=16 I/O Timings: read=11.899 -> Index Scan using es_projection on eventstore.events2 (cost=0.69..6389.93 rows=3302 width=378) (actual time=13.891..13.891 rows=0 loops=1) Output: events2.created_at, events2.event_type, events2.sequence, events2."position", events2.payload, events2.creator, events2.owner, events2.instance_id, events2.aggregate_type, events2.aggregate_id, events2.revision, events2.in_tx_order Index Cond: ((events2.instance_id = '298583134000167036'::text) AND (events2.aggregate_type = ANY ('{user,org,instance}'::text[])) AND (events2.event_type = ANY ('{user.added,user.human.added,user.selfregistered,user.human.selfregistered,user.human.initialization.code.added,user.initialization.code.added,user.human.initialization.check.succeeded,user.initialization.check.succeeded,user.locked,user.unlocked,user.deactivated,user.reactivated,user.removed,user.username.changed,user.domain.claimed,user.human.profile.changed,user.profile.changed,user.human.phone.changed,user.phone.changed,user.human.phone.removed,user.phone.removed,user.human.phone.verified,user.phone.verified,user.human.email.changed,user.email.changed,user.human.email.verified,user.email.verified,user.human.avatar.added,user.human.avatar.removed,user.machine.added}'::text[])) AND (events2."position" >= $0) AND (events2."position" < $1)) Buffers: shared hit=439 read=16 I/O Timings: read=11.899 Query Identifier: -7760303501205971142 Planning: Buffers: shared hit=528 read=21 dirtied=1 I/O Timings: read=15.344 Planning Time: 18.115 ms Execution Time: 14.361 ms (48 rows)