Schema load profile

Real application queries against the real schema at 1×, 10×, 100×, 1000× the seeded data, before and after the fix migration.

Queries profiled

real application statements

Scales

1× · 10× · 100× · 1000×

copies of the seeded tenant

Timed executions

135,504

each in its own rolled-back transaction

Failing at 1000× before

over budget, scanning, or timing out

Failing at 1000× after

5 improved · 0 regressed (Holm p < 0.01, |δ| ≥ 0.33, medians ≥ 1.25× apart)

p95 latency by query and scale · the pair under each scale is before (b) and after (a); darker is slower relative to that query's budget, red-ringed cells breach it. Rows are ordered worst first.

1% of budget→100× budget

Median latency against scale · log–log; a slope of 1 means the query grows linearly with the data, 0 means it is flat. The dashed hairline is the query's p95 budget. 8 of 58 queries are drawn: those that grow with scale (slope ≥ 0.3), breach a budget, or changed with the fix. The table below lists every query.

beforeafterbudget

Show:

p95 before and after at 1000× · the 6 queries that breach a budget on either side or changed materially, sorted by the before value; the short dashed tick is the budget. Faint connectors are differences that are not material.

beforeafterbudget

Every measurement

232 rows · open to filter by status

Status:

Query	Group	Path	Scale	Status	p50 before	p95 before	p50 after	p95 after	Ratio	Cliff's δ	p (Holm)	Plan
`documents-list-for-user` group 189	documents	request	1×	Within budget	1.9 ms	2.3 ms	1.7 ms	2.0 ms	0.86	-0.75	<0.0001	seq: property_ownerships (1), household_relationships (0) · idx: documents_building_property_idx, documents_legal_entity_subject_idx, documents_pkey, memberships_profile_place_role_unique, places_pkey, profiles_pkey, profiles_user_idx rewrite: admission as a union of three index-driven legs instead of EXISTS clauses inside one OR, so the planner no longer walks every profile
`documents-list-for-user` group 189	documents	request	10×	Within budget	31.1 ms	42.1 ms	1.8 ms	2.5 ms	0.06	-1.00	<0.0001	seq: household_relationships (0) · idx: documents_building_property_idx, documents_legal_entity_subject_idx, documents_pkey, memberships_profile_place_role_unique, places_pkey, profiles_pkey, profiles_user_idx, property_ownerships_profile_idx rewrite: admission as a union of three index-driven legs instead of EXISTS clauses inside one OR, so the planner no longer walks every profile
`documents-list-for-user` group 189	documents	request	100×	Within budget	307 ms	323 ms	1.7 ms	2.0 ms	0.01	-1.00	<0.0001	idx: documents_building_property_idx, documents_legal_entity_subject_idx, documents_pkey, household_relationships_granted_by_idx, memberships_profile_place_role_unique, places_pkey, profiles_pkey, profiles_user_idx, property_ownerships_profile_idx rewrite: admission as a union of three index-driven legs instead of EXISTS clauses inside one OR, so the planner no longer walks every profile
`documents-list-for-user` group 189	documents	request	1000×	Within budget	1.47 s	2.25 s	2.0 ms	4.2 ms	0.00	-1.00	<0.0001	idx: documents_building_property_idx, documents_legal_entity_subject_idx, documents_pkey, household_relationships_granted_by_idx, memberships_profile_place_role_unique, places_pkey, profiles_pkey, profiles_user_idx, property_ownerships_profile_idx rewrite: admission as a union of three index-driven legs instead of EXISTS clauses inside one OR, so the planner no longer walks every profile
`outbox-relay-poll` group 320	notifications	background	1×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.5 ms	1.03	0.07	1.0000	idx: outbox_events_due_order_idx
`outbox-relay-poll` group 320	notifications	background	10×	Within budget	0.7 ms	0.9 ms	0.6 ms	0.8 ms	0.81	-0.61	<0.0001	idx: outbox_events_due_order_idx
`outbox-relay-poll` group 320	notifications	background	100×	Within budget	1.5 ms	2.5 ms	0.4 ms	0.6 ms	0.25	-1.00	<0.0001	idx: outbox_events_due_order_idx
`outbox-relay-poll` group 320	notifications	background	1000×	Within budget	1.58 s	1.75 s	4.3 ms	5.2 ms	0.00	-1.00	<0.0001	idx: outbox_events_due_order_idx
`documents-count-for-user` group 190	documents	request	1×	Within budget	1.1 ms	1.3 ms	1.0 ms	1.2 ms	0.89	-0.61	<0.0001	seq: property_ownerships (1), household_relationships (1) · idx: documents_building_property_idx, documents_legal_entity_subject_idx, documents_pkey, memberships_profile_place_role_unique, profiles_user_idx rewrite: admission as a union of three index-driven legs instead of EXISTS clauses inside one OR, so the planner no longer walks every profile
`documents-count-for-user` group 190	documents	request	10×	Within budget	19.3 ms	20.9 ms	1.1 ms	1.2 ms	0.06	-1.00	<0.0001	seq: household_relationships (0) · idx: documents_building_property_idx, documents_legal_entity_subject_idx, documents_pkey, memberships_profile_place_role_unique, profiles_user_idx, property_ownerships_profile_idx rewrite: admission as a union of three index-driven legs instead of EXISTS clauses inside one OR, so the planner no longer walks every profile
`documents-count-for-user` group 190	documents	request	100×	Within budget	195 ms	252 ms	1.1 ms	1.5 ms	0.01	-1.00	<0.0001	idx: documents_building_property_idx, documents_legal_entity_subject_idx, documents_pkey, household_relationships_granted_by_idx, memberships_profile_place_role_unique, profiles_user_idx, property_ownerships_profile_idx rewrite: admission as a union of three index-driven legs instead of EXISTS clauses inside one OR, so the planner no longer walks every profile
`documents-count-for-user` group 190	documents	request	1000×	Within budget	910 ms	952 ms	1.2 ms	1.4 ms	0.00	-1.00	<0.0001	idx: documents_building_property_idx, documents_legal_entity_subject_idx, documents_pkey, household_relationships_granted_by_idx, memberships_profile_place_role_unique, profiles_user_idx, property_ownerships_profile_idx rewrite: admission as a union of three index-driven legs instead of EXISTS clauses inside one OR, so the planner no longer walks every profile
`bookings-journey-list` group 27	bookings	request	1×	Within budget	4.1 ms	6.6 ms	4.3 ms	6.3 ms	1.06	0.21	0.0018	seq: services (2.5), service_buildings (1.25), services (1) · idx: booking_cases_pkey, bookings_open_change_parent_idx, bookings_profile_idx, places_pkey
`bookings-journey-list` group 27	bookings	request	10×	Within budget	4.3 ms	5.2 ms	3.3 ms	3.8 ms	0.76	-0.13	1.0000	seq: services (3), service_buildings (1), services (1) · idx: booking_cases_pkey, bookings_open_change_parent_idx, bookings_profile_history_idx, bookings_property_idx, places_pkey
`bookings-journey-list` group 27	bookings	request	100×	Within budget	25.6 ms	30.6 ms	3.0 ms	5.2 ms	0.12	-1.00	<0.0001	seq: services (2.8), service_buildings (1.1), services (1) · idx: booking_cases_pkey, bookings_open_change_parent_idx, bookings_profile_idx, places_pkey
`bookings-journey-list` group 27	bookings	request	1000×	Within budget	509 ms	569 ms	2.5 ms	32.0 ms	0.00	-1.00	<0.0001	seq: services (2.71), services (1) · idx: booking_cases_pkey, bookings_open_change_parent_idx, bookings_profile_idx, places_pkey, service_buildings_service_id_building_unique
`requests-due-poll` group 192	requests	background	1×	Within budget	0.6 ms	0.7 ms	0.6 ms	0.7 ms	1.00	-0.02	1.0000	seq: requests (200), event_ledger (200)
`requests-due-poll` group 192	requests	background	10×	Scan grows with data sequential scan over requests reading 2,000 rows; sequential scan over event_ledger reading 2,000 rows	2.5 ms	2.7 ms	2.5 ms	2.7 ms	1.01	0.08	1.0000	seq: requests (2,000), event_ledger (2,000)
`requests-due-poll` group 192	requests	background	100×	Scan grows with data sequential scan over requests reading 20,000 rows; sequential scan over event_ledger reading 20,000 rows	33.0 ms	48.9 ms	34.7 ms	57.7 ms	1.05	0.20	0.0863	seq: requests (20,000), event_ledger (20,000)
`requests-due-poll` group 192	requests	background	1000×	Scan grows with data sequential scan over requests reading 200,000 rows; sequential scan over event_ledger reading 200,000 rows	370 ms	403 ms	369 ms	385 ms	1.00	-0.03	1.0000	seq: requests (200,000), event_ledger (200,000)
`move-in-applied` group 91	bookings	request	1×	Within budget	0.8 ms	1.4 ms	0.7 ms	1.2 ms	0.90	-0.37	<0.0001	idx: bookings_move_in_pkey, bookings_profile_idx, profiles_user_idx rewrite: restrict to the viewer's own profiles in SQL, so the read follows bookings_profile_idx instead of every approved application in the legal entity
`move-in-applied` group 91	bookings	request	10×	Within budget	2.2 ms	2.6 ms	0.7 ms	0.8 ms	0.30	-1.00	<0.0001	idx: bookings_move_in_pkey, bookings_profile_idx, profiles_user_idx rewrite: restrict to the viewer's own profiles in SQL, so the read follows bookings_profile_idx instead of every approved application in the legal entity
`move-in-applied` group 91	bookings	request	100×	Within budget	20.0 ms	22.5 ms	0.7 ms	0.9 ms	0.04	-1.00	<0.0001	idx: bookings_move_in_pkey, bookings_profile_idx, profiles_user_idx rewrite: restrict to the viewer's own profiles in SQL, so the read follows bookings_profile_idx instead of every approved application in the legal entity
`move-in-applied` group 91	bookings	request	1000×	Within budget	16.9 ms	21.7 ms	0.7 ms	1.1 ms	0.04	-1.00	<0.0001	idx: bookings_move_in_pkey, bookings_profile_idx, profiles_user_idx rewrite: restrict to the viewer's own profiles in SQL, so the read follows bookings_profile_idx instead of every approved application in the legal entity
`events-stale-state-poll` group 202	events	background	1×	Within budget	0.4 ms	0.5 ms	0.4 ms	0.5 ms	1.01	-0.05	1.0000	idx: events_staff_idx
`events-stale-state-poll` group 202	events	background	10×	Within budget	0.7 ms	0.8 ms	0.7 ms	0.8 ms	1.00	0.03	1.0000	idx: events_snagging_cycle_number_unique
`events-stale-state-poll` group 202	events	background	100×	Within budget	3.1 ms	3.7 ms	3.1 ms	3.7 ms	1.00	-0.01	1.0000	idx: events_snagging_cycle_number_unique
`events-stale-state-poll` group 202	events	background	1000×	Within budget	32.8 ms	45.5 ms	32.9 ms	62.9 ms	1.00	-0.00	1.0000	idx: events_snagging_cycle_number_unique
`invitation-by-email` group 257	residences	request	1×	Within budget	0.7 ms	1.4 ms	0.7 ms	1.7 ms	1.01	0.01	1.0000	seq: household_invitation_attempts (20), invitation (1) · idx: household_relationships_pkey
`invitation-by-email` group 257	residences	request	10×	Within budget	0.7 ms	0.8 ms	0.7 ms	0.8 ms	0.99	-0.01	1.0000	seq: invitation (1) · idx: household_invitation_attempts_invitation_unique, household_relationships_pkey
`invitation-by-email` group 257	residences	request	100×	Within budget	1.3 ms	2.0 ms	1.3 ms	1.9 ms	0.98	-0.05	1.0000	seq: invitation (1) · idx: household_invitation_attempts_invitation_unique, household_relationships_pkey
`invitation-by-email` group 257	residences	request	1000×	Within budget	8.0 ms	14.7 ms	8.0 ms	14.3 ms	1.00	-0.01	1.0000	seq: invitation (1) · idx: household_invitation_attempts_invitation_unique, household_relationships_pkey
`household-residences` group 269	residences	request	1×	Within budget	2.0 ms	2.4 ms	2.1 ms	2.6 ms	1.05	0.31	<0.0001	seq: household_relationship_properties (20), household_relationships (20) · idx: places_pkey, profiles_legal_entity_id_user_id_key
`household-residences` group 269	residences	request	10×	Within budget	1.6 ms	2.1 ms	2.0 ms	2.5 ms	1.23	0.59	<0.0001	idx: household_relationship_properties_relationship_idx, household_relationships_member_idx, places_pkey, profiles_user_idx
`household-residences` group 269	residences	request	100×	Within budget	1.3 ms	1.6 ms	1.3 ms	1.6 ms	1.00	0.05	1.0000	idx: household_relationship_properties_relationship_idx, household_relationships_member_idx, places_pkey, profiles_user_idx
`household-residences` group 269	residences	request	1000×	Within budget	1.6 ms	1.8 ms	1.6 ms	1.8 ms	0.99	-0.04	1.0000	idx: household_relationship_properties_relationship_idx, household_relationships_member_idx, places_pkey, profiles_user_idx
`profile-owning-property` group 408	residences	request	1×	Within budget	0.6 ms	1.7 ms	0.6 ms	1.4 ms	1.00	-0.01	1.0000	idx: profiles_user_idx, property_ownerships_property_profile_unique
`profile-owning-property` group 408	residences	request	10×	Within budget	0.5 ms	0.6 ms	0.5 ms	0.6 ms	1.03	0.08	1.0000	idx: profiles_user_idx, property_ownerships_property_profile_unique
`profile-owning-property` group 408	residences	request	100×	Within budget	0.3 ms	0.5 ms	0.4 ms	0.5 ms	1.00	0.03	1.0000	idx: profiles_user_idx, property_ownerships_property_profile_unique
`profile-owning-property` group 408	residences	request	1000×	Within budget	0.6 ms	1.7 ms	0.6 ms	1.5 ms	1.03	-0.01	1.0000	idx: profiles_user_idx, property_ownerships_property_profile_unique
`ownerships-of-property` group 371	residences	request	1×	Within budget	0.9 ms	2.2 ms	0.9 ms	2.3 ms	1.00	-0.01	1.0000	idx: places_id_legal_entity_kind_unique, profiles_legal_entity_id_id_user_unique, property_ownerships_property_profile_unique
`ownerships-of-property` group 371	residences	request	10×	Within budget	0.5 ms	0.7 ms	0.5 ms	0.7 ms	1.02	0.03	1.0000	idx: places_id_legal_entity_kind_unique, profiles_pkey, property_ownerships_property_profile_unique
`ownerships-of-property` group 371	residences	request	100×	Within budget	0.4 ms	0.5 ms	0.4 ms	0.5 ms	1.00	0.03	1.0000	idx: places_id_legal_entity_kind_unique, profiles_pkey, property_ownerships_property_profile_unique
`ownerships-of-property` group 371	residences	request	1000×	Within budget	0.7 ms	1.5 ms	0.7 ms	1.8 ms	1.01	0.05	1.0000	idx: places_id_legal_entity_kind_unique, profiles_pkey, property_ownerships_property_profile_unique
`amenity-free-slots` group 116	bookings	request	1×	Within budget	1.7 ms	4.1 ms	1.9 ms	4.6 ms	1.06	0.04	1.0000	idx: bookings_active_slot_unique, schedules_start_idx
`amenity-free-slots` group 116	bookings	request	10×	Within budget	0.8 ms	0.9 ms	0.8 ms	0.9 ms	1.00	0.02	1.0000	idx: bookings_active_slot_unique, schedules_service_building_start_unique
`amenity-free-slots` group 116	bookings	request	100×	Within budget	0.8 ms	0.9 ms	0.8 ms	1.0 ms	1.03	0.13	1.0000	idx: bookings_active_slot_unique, schedules_service_building_start_unique
`amenity-free-slots` group 116	bookings	request	1000×	Within budget	1.0 ms	1.2 ms	1.0 ms	1.2 ms	0.99	-0.05	1.0000	idx: bookings_active_slot_unique, schedules_service_building_start_unique
`invitation-context` group 252	residences	request	1×	Within budget	1.5 ms	2.3 ms	1.5 ms	2.1 ms	1.00	-0.02	1.0000	seq: household_relationships (20), household_invitation_attempts (1) · idx: household_relationship_properties_relationship_idx, places_pkey, profiles_legal_entity_id_id_user_unique
`invitation-context` group 252	residences	request	10×	Within budget	1.4 ms	1.9 ms	1.4 ms	1.9 ms	0.99	-0.02	1.0000	seq: household_relationship_properties (200) · idx: household_invitation_attempts_invitation_unique, household_relationships_pkey, places_pkey, profiles_legal_entity_id_id_user_unique
`invitation-context` group 252	residences	request	100×	Within budget	0.9 ms	1.1 ms	0.9 ms	1.1 ms	1.00	-0.01	1.0000	idx: household_invitation_attempts_invitation_unique, household_relationship_properties_relationship_idx, household_relationships_pkey, places_pkey, profiles_legal_entity_id_id_user_unique
`invitation-context` group 252	residences	request	1000×	Within budget	1.0 ms	1.2 ms	1.1 ms	1.2 ms	1.01	0.04	1.0000	idx: household_invitation_attempts_invitation_unique, household_relationship_properties_relationship_idx, household_relationships_pkey, places_pkey, profiles_legal_entity_id_id_user_unique
`bookings-recent-by-profile` group 33	bookings	request	1×	Within budget	0.6 ms	0.8 ms	0.6 ms	0.8 ms	1.00	0.02	1.0000	idx: bookings_profile_idx
`bookings-recent-by-profile` group 33	bookings	request	10×	Within budget	0.4 ms	0.6 ms	0.4 ms	0.6 ms	1.00	-0.01	1.0000	idx: bookings_profile_idx
`bookings-recent-by-profile` group 33	bookings	request	100×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	1.00	0.05	1.0000	idx: bookings_profile_idx
`bookings-recent-by-profile` group 33	bookings	request	1000×	Within budget	0.7 ms	1.2 ms	0.7 ms	1.6 ms	1.02	0.02	1.0000	idx: bookings_profile_idx
`owned-properties` group 370	residences	request	1×	Within budget	1.7 ms	3.2 ms	1.9 ms	3.7 ms	1.11	0.37	<0.0001	seq: places (202) · idx: places_pkey, profiles_legal_entity_id_id_user_unique, property_ownerships_property_profile_unique
`owned-properties` group 370	residences	request	10×	Within budget	0.8 ms	1.0 ms	0.9 ms	1.1 ms	1.15	0.69	<0.0001	idx: places_pkey, profiles_user_idx, property_ownerships_profile_idx
`owned-properties` group 370	residences	request	100×	Within budget	0.7 ms	0.9 ms	0.7 ms	0.9 ms	1.00	-0.01	1.0000	idx: places_pkey, profiles_user_idx, property_ownerships_profile_idx
`owned-properties` group 370	residences	request	1000×	Within budget	1.0 ms	1.2 ms	1.0 ms	1.2 ms	0.99	-0.05	1.0000	idx: places_pkey, profiles_user_idx, property_ownerships_profile_idx
`move-in-review` group 96	bookings	request	1×	Within budget	1.5 ms	2.2 ms	1.5 ms	2.0 ms	1.01	0.02	1.0000	idx: bookings_move_in_identity_unique, bookings_move_in_pkey, places_pkey, profiles_legal_entity_id_id_user_unique, profiles_user_idx, property_ownerships_property_profile_unique
`move-in-review` group 96	bookings	request	10×	Within budget	1.1 ms	1.4 ms	1.1 ms	1.4 ms	1.01	0.04	1.0000	idx: bookings_move_in_pkey, bookings_pkey, places_pkey, profiles_pkey, profiles_user_idx, property_ownerships_property_profile_unique
`move-in-review` group 96	bookings	request	100×	Within budget	0.9 ms	1.2 ms	0.9 ms	1.2 ms	1.00	0.01	1.0000	idx: bookings_move_in_identity_unique, bookings_move_in_pkey, places_pkey, profiles_pkey, profiles_user_idx, property_ownerships_profile_idx
`move-in-review` group 96	bookings	request	1000×	Within budget	0.9 ms	1.1 ms	0.9 ms	1.1 ms	1.00	-0.02	1.0000	idx: bookings_move_in_pkey, bookings_pkey, places_pkey, profiles_pkey, profiles_user_idx, property_ownerships_profile_idx
`rented-properties` group 374	residences	request	1×	Within budget	1.1 ms	1.4 ms	1.1 ms	1.4 ms	1.01	0.01	1.0000	seq: property_tenancies (20) · idx: places_pkey, profiles_user_idx
`rented-properties` group 374	residences	request	10×	Within budget	0.7 ms	1.0 ms	0.8 ms	1.1 ms	1.15	0.53	<0.0001	seq: property_tenancies (200) · idx: places_pkey, profiles_user_idx
`rented-properties` group 374	residences	request	100×	Within budget	0.7 ms	0.8 ms	0.7 ms	0.8 ms	1.01	0.03	1.0000	idx: places_pkey, profiles_user_idx, property_tenancies_profile_idx
`rented-properties` group 374	residences	request	1000×	Within budget	0.9 ms	1.0 ms	0.9 ms	1.0 ms	1.00	-0.01	1.0000	idx: places_pkey, profiles_user_idx, property_tenancies_profile_idx
`household-access-to-property` group 270	residences	request	1×	Within budget	0.9 ms	1.4 ms	0.9 ms	1.2 ms	1.00	-0.03	1.0000	seq: household_relationships (20), household_relationship_properties (1) · idx: places_id_legal_entity_kind_unique, profiles_legal_entity_id_id_user_unique
`household-access-to-property` group 270	residences	request	10×	Within budget	0.8 ms	1.0 ms	0.8 ms	1.1 ms	0.99	-0.05	1.0000	seq: household_relationship_properties (1) · idx: household_relationships_pkey, places_id_legal_entity_kind_unique, profiles_legal_entity_id_id_user_unique
`household-access-to-property` group 270	residences	request	100×	Within budget	0.8 ms	1.0 ms	0.8 ms	1.0 ms	1.01	0.01	1.0000	idx: household_relationship_properties_relationship_idx, household_relationships_member_idx, places_id_legal_entity_kind_unique, profiles_user_idx
`household-access-to-property` group 270	residences	request	1000×	Within budget	0.8 ms	1.0 ms	0.8 ms	1.0 ms	0.98	-0.05	1.0000	idx: household_relationship_properties_property_idx, household_relationships_member_idx, places_id_legal_entity_kind_unique, profiles_user_idx
`amenity-upcoming` group 110	bookings	request	1×	Within budget	1.2 ms	1.8 ms	1.2 ms	1.9 ms	1.00	-0.01	1.0000	seq: services (3), service_buildings (1) · idx: bookings_profile_history_idx, bookings_property_idx, places_pkey
`amenity-upcoming` group 110	bookings	request	10×	Within budget	0.9 ms	1.1 ms	0.8 ms	1.1 ms	0.98	-0.04	1.0000	seq: services (0), service_buildings (0) · idx: bookings_profile_history_idx, bookings_property_idx, places_pkey
`amenity-upcoming` group 110	bookings	request	100×	Within budget	0.8 ms	1.0 ms	0.8 ms	1.0 ms	1.01	0.03	1.0000	seq: services (3), service_buildings (1) · idx: bookings_profile_history_idx, bookings_property_idx, places_pkey
`amenity-upcoming` group 110	bookings	request	1000×	Within budget	0.8 ms	1.0 ms	0.8 ms	1.0 ms	1.01	0.00	1.0000	seq: services (3) · idx: bookings_profile_history_idx, bookings_property_idx, places_pkey, service_buildings_service_id_building_unique
`callback-context` group 346	residences	request	1×	Within budget	0.9 ms	1.2 ms	0.9 ms	1.2 ms	0.98	-0.04	1.0000	seq: staff (1), phone_numbers (1) · idx: places_kind_connector_id_unique, places_pkey, profiles_user_idx
`callback-context` group 346	residences	request	10×	Within budget	0.8 ms	1.0 ms	0.8 ms	1.0 ms	1.00	-0.01	1.0000	seq: staff (1) · idx: phone_numbers_primary_user_unique, places_pkey, profiles_user_idx
`callback-context` group 346	residences	request	100×	Within budget	0.5 ms	0.7 ms	0.5 ms	0.7 ms	1.00	-0.01	1.0000	idx: phone_numbers_primary_user_unique, places_pkey, profiles_user_idx, staff_pkey
`callback-context` group 346	residences	request	1000×	Within budget	0.6 ms	0.9 ms	0.6 ms	0.9 ms	0.98	-0.07	1.0000	idx: phone_numbers_primary_user_unique, places_pkey, profiles_user_idx, staff_pkey
`membership-buildings` group 302	identity	request	1×	Within budget	0.5 ms	0.7 ms	0.5 ms	0.7 ms	1.01	-0.01	1.0000	idx: memberships_profile_place_role_unique, profiles_user_idx
`membership-buildings` group 302	identity	request	10×	Within budget	0.3 ms	0.5 ms	0.3 ms	0.4 ms	0.98	-0.09	1.0000	idx: memberships_profile_place_role_unique, profiles_user_idx
`membership-buildings` group 302	identity	request	100×	Within budget	0.4 ms	0.6 ms	0.4 ms	0.6 ms	0.98	-0.03	1.0000	idx: memberships_profile_place_role_unique, profiles_user_idx
`membership-buildings` group 302	identity	request	1000×	Within budget	0.4 ms	0.9 ms	0.5 ms	0.7 ms	1.01	0.01	1.0000	idx: memberships_profile_place_role_unique, profiles_user_idx
`profile-sync-poll` group 388	identity	background	1×	Within budget	0.9 ms	1.4 ms	0.9 ms	1.5 ms	1.01	0.00	1.0000	seq: profiles (241), profiles (51)
`profile-sync-poll` group 388	identity	background	10×	Within budget	0.6 ms	0.8 ms	0.6 ms	0.8 ms	1.01	0.07	1.0000	idx: profiles_preferences_sync_pending_idx, profiles_user_idx
`profile-sync-poll` group 388	identity	background	100×	Within budget	0.6 ms	0.8 ms	0.6 ms	0.8 ms	1.01	0.02	1.0000	idx: profiles_preferences_sync_pending_idx, profiles_user_idx
`profile-sync-poll` group 388	identity	background	1000×	Within budget	0.7 ms	0.8 ms	0.7 ms	0.8 ms	1.00	-0.04	1.0000	idx: profiles_preferences_sync_pending_idx, profiles_user_idx
`holds-of-user-bookings` group 99	bookings	request	1×	Within budget	0.8 ms	1.0 ms	0.8 ms	1.0 ms	1.01	0.03	1.0000	idx: bookings_profile_idx, holds_booking_idx, profiles_user_idx
`holds-of-user-bookings` group 99	bookings	request	10×	Within budget	0.7 ms	0.9 ms	0.7 ms	0.9 ms	1.01	0.01	1.0000	idx: bookings_profile_idx, holds_booking_idx, profiles_user_idx
`holds-of-user-bookings` group 99	bookings	request	100×	Within budget	0.5 ms	0.7 ms	0.5 ms	0.7 ms	1.00	0.05	1.0000	idx: bookings_profile_idx, holds_booking_idx, profiles_user_idx
`holds-of-user-bookings` group 99	bookings	request	1000×	Within budget	0.6 ms	0.8 ms	0.6 ms	0.8 ms	0.99	-0.02	1.0000	idx: bookings_profile_idx, holds_booking_idx, profiles_user_idx
`bookings-page-by-cursor` group 49	bookings	request	1×	Within budget	0.6 ms	1.0 ms	0.6 ms	1.1 ms	1.00	0.00	1.0000	idx: bookings_profile_history_idx
`bookings-page-by-cursor` group 49	bookings	request	10×	Within budget	0.5 ms	0.6 ms	0.5 ms	0.6 ms	1.00	0.03	1.0000	idx: bookings_profile_history_idx
`bookings-page-by-cursor` group 49	bookings	request	100×	Within budget	0.3 ms	0.5 ms	0.3 ms	0.5 ms	1.01	0.05	1.0000	idx: bookings_profile_idx
`bookings-page-by-cursor` group 49	bookings	request	1000×	Within budget	0.6 ms	0.8 ms	0.6 ms	0.8 ms	1.02	0.06	1.0000	idx: bookings_profile_idx
`bookings-recovery-poll` group 39	bookings	background	1×	Within budget	1.0 ms	2.6 ms	1.0 ms	2.5 ms	0.99	-0.01	1.0000	idx: bookings_pending_workflow_recovery_idx
`bookings-recovery-poll` group 39	bookings	background	10×	Within budget	0.6 ms	0.8 ms	0.6 ms	0.7 ms	1.02	0.06	1.0000	idx: bookings_pending_workflow_recovery_idx
`bookings-recovery-poll` group 39	bookings	background	100×	Within budget	0.4 ms	0.5 ms	0.4 ms	0.5 ms	1.01	0.11	1.0000	idx: bookings_pending_workflow_recovery_idx
`bookings-recovery-poll` group 39	bookings	background	1000×	Within budget	0.5 ms	0.7 ms	0.5 ms	0.7 ms	1.01	0.02	1.0000	idx: bookings_pending_workflow_recovery_idx
`membership-at-place` group 297	identity	request	1×	Within budget	0.8 ms	0.9 ms	0.7 ms	0.8 ms	0.90	-0.47	<0.0001	idx: memberships_profile_place_role_unique, places_id_legal_entity_kind_unique, profiles_user_idx
`membership-at-place` group 297	identity	request	10×	Within budget	0.5 ms	0.6 ms	0.4 ms	0.6 ms	0.90	-0.44	<0.0001	idx: memberships_profile_place_role_unique, places_id_legal_entity_kind_unique, profiles_user_idx
`membership-at-place` group 297	identity	request	100×	Within budget	0.7 ms	1.0 ms	0.7 ms	1.1 ms	1.00	0.02	1.0000	idx: memberships_profile_place_role_unique, places_id_legal_entity_kind_unique, profiles_user_idx
`membership-at-place` group 297	identity	request	1000×	Within budget	0.5 ms	0.7 ms	0.5 ms	0.7 ms	0.98	-0.08	1.0000	idx: memberships_profile_place_role_unique, places_id_legal_entity_kind_unique, profiles_user_idx
`move-in-of-residence` group 93	bookings	request	1×	Within budget	0.9 ms	1.3 ms	0.9 ms	1.3 ms	1.00	0.02	1.0000	idx: bookings_move_in_pkey, bookings_profile_history_idx, bookings_property_idx, profiles_user_idx
`move-in-of-residence` group 93	bookings	request	10×	Within budget	0.7 ms	0.9 ms	0.7 ms	0.9 ms	1.02	0.10	1.0000	idx: bookings_move_in_pkey, bookings_profile_history_idx, bookings_property_idx, profiles_user_idx
`move-in-of-residence` group 93	bookings	request	100×	Within budget	0.5 ms	0.7 ms	0.5 ms	0.7 ms	1.01	0.04	1.0000	idx: bookings_move_in_pkey, bookings_profile_history_idx, bookings_property_idx, profiles_user_idx
`move-in-of-residence` group 93	bookings	request	1000×	Within budget	0.6 ms	0.7 ms	0.5 ms	0.7 ms	0.99	-0.05	1.0000	idx: bookings_move_in_pkey, bookings_profile_history_idx, bookings_property_idx, profiles_user_idx
`amenity-overlap-check` group 71	bookings	request	1×	Within budget	1.5 ms	5.2 ms	1.5 ms	5.5 ms	0.96	-0.05	1.0000	seq: bookings (1)
`amenity-overlap-check` group 71	bookings	request	10×	Within budget	0.5 ms	0.6 ms	0.5 ms	0.6 ms	1.01	0.06	1.0000	idx: bookings_active_period_exclude
`amenity-overlap-check` group 71	bookings	request	100×	Within budget	0.5 ms	0.7 ms	0.5 ms	0.7 ms	1.00	0.05	1.0000	idx: bookings_active_slot_unique
`amenity-overlap-check` group 71	bookings	request	1000×	Within budget	0.5 ms	0.6 ms	0.5 ms	0.6 ms	1.01	0.05	1.0000	idx: bookings_active_slot_unique
`memberships-by-user` group 301	identity	request	1×	Within budget	0.5 ms	0.6 ms	0.5 ms	0.7 ms	1.01	0.01	1.0000	idx: memberships_profile_place_role_unique, profiles_user_idx
`memberships-by-user` group 301	identity	request	10×	Within budget	0.3 ms	0.5 ms	0.3 ms	0.5 ms	0.96	-0.14	0.6098	idx: memberships_profile_place_role_unique, profiles_user_idx
`memberships-by-user` group 301	identity	request	100×	Within budget	0.3 ms	0.5 ms	0.3 ms	0.5 ms	0.97	-0.13	0.9359	idx: memberships_profile_place_role_unique, profiles_user_idx
`memberships-by-user` group 301	identity	request	1000×	Within budget	0.5 ms	0.6 ms	0.5 ms	0.6 ms	0.99	-0.02	1.0000	idx: memberships_profile_place_role_unique, profiles_user_idx
`session-by-token` group 421	identity	request	1×	Within budget	0.4 ms	0.6 ms	0.4 ms	0.5 ms	1.00	-0.00	1.0000	idx: session_token_key
`session-by-token` group 421	identity	request	10×	Within budget	0.3 ms	0.3 ms	0.2 ms	0.4 ms	0.99	-0.03	1.0000	idx: session_token_key
`session-by-token` group 421	identity	request	100×	Within budget	0.2 ms	0.3 ms	0.2 ms	0.3 ms	1.00	0.01	1.0000	idx: session_token_key
`session-by-token` group 421	identity	request	1000×	Within budget	0.4 ms	0.6 ms	0.4 ms	0.6 ms	0.97	-0.03	1.0000	idx: session_token_key
`user-by-phone` group 348	identity	request	1×	Within budget	0.4 ms	0.7 ms	0.4 ms	0.8 ms	0.99	-0.05	1.0000	idx: phone_numbers_number_owner_unique, user_pkey
`user-by-phone` group 348	identity	request	10×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	1.01	0.02	1.0000	idx: phone_numbers_number_owner_unique, user_pkey
`user-by-phone` group 348	identity	request	100×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	1.01	0.02	1.0000	idx: phone_numbers_number_owner_unique, user_pkey
`user-by-phone` group 348	identity	request	1000×	Within budget	0.4 ms	0.6 ms	0.4 ms	0.6 ms	1.00	-0.02	1.0000	idx: phone_numbers_number_owner_unique, user_pkey
`household-memberships` group 285	residences	request	1×	Within budget	0.7 ms	1.2 ms	0.7 ms	1.2 ms	0.99	0.02	1.0000	seq: household_relationships (20) · idx: profiles_user_idx
`household-memberships` group 285	residences	request	10×	Within budget	0.4 ms	0.6 ms	0.4 ms	0.6 ms	0.99	-0.04	1.0000	seq: household_relationships (200) · idx: profiles_user_idx
`household-memberships` group 285	residences	request	100×	Within budget	0.4 ms	0.7 ms	0.4 ms	0.7 ms	1.00	0.02	1.0000	idx: household_relationships_member_idx, profiles_user_idx
`household-memberships` group 285	residences	request	1000×	Within budget	0.4 ms	0.6 ms	0.4 ms	0.5 ms	0.99	-0.01	1.0000	idx: household_relationships_member_idx, profiles_user_idx
`user-by-email` group 444	identity	request	1×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	1.02	0.05	1.0000	idx: user_normalised_email_idx
`user-by-email` group 444	identity	request	10×	Within budget	0.2 ms	0.3 ms	0.2 ms	0.3 ms	1.02	0.05	1.0000	idx: user_normalised_email_idx
`user-by-email` group 444	identity	request	100×	Within budget	0.2 ms	0.4 ms	0.2 ms	0.4 ms	1.01	0.04	1.0000	idx: user_normalised_email_idx
`user-by-email` group 444	identity	request	1000×	Within budget	0.3 ms	0.5 ms	0.3 ms	0.6 ms	1.00	0.01	1.0000	idx: user_normalised_email_idx
`user-by-id` group 440	identity	request	1×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.5 ms	1.00	-0.01	1.0000	idx: user_pkey
`user-by-id` group 440	identity	request	10×	Within budget	0.2 ms	0.3 ms	0.2 ms	0.3 ms	0.99	-0.03	1.0000	idx: user_pkey
`user-by-id` group 440	identity	request	100×	Within budget	0.3 ms	0.3 ms	0.3 ms	0.3 ms	1.00	-0.06	1.0000	idx: user_pkey
`user-by-id` group 440	identity	request	1000×	Within budget	0.4 ms	0.5 ms	0.4 ms	0.6 ms	1.00	-0.01	1.0000	idx: user_pkey
`property-by-connector-id` group 354	residences	background	1×	Within budget	0.5 ms	0.9 ms	0.5 ms	0.9 ms	1.04	0.05	1.0000	idx: places_kind_connector_id_unique
`property-by-connector-id` group 354	residences	background	10×	Within budget	0.2 ms	0.3 ms	0.3 ms	0.3 ms	1.01	0.03	1.0000	idx: places_kind_connector_id_unique
`property-by-connector-id` group 354	residences	background	100×	Within budget	0.2 ms	0.4 ms	0.3 ms	0.3 ms	1.02	0.05	1.0000	idx: places_kind_connector_id_unique
`property-by-connector-id` group 354	residences	background	1000×	Within budget	0.4 ms	0.5 ms	0.3 ms	0.5 ms	0.98	-0.08	1.0000	idx: places_kind_connector_id_unique
`booking-by-idempotency-key` group 31	bookings	request	1×	Within budget	1.6 ms	6.8 ms	1.6 ms	5.3 ms	0.99	-0.01	1.0000	idx: bookings_idempotency_key_unique
`booking-by-idempotency-key` group 31	bookings	request	10×	Within budget	0.4 ms	0.5 ms	0.4 ms	0.6 ms	0.99	0.01	1.0000	idx: bookings_idempotency_key_unique
`booking-by-idempotency-key` group 31	bookings	request	100×	Within budget	0.3 ms	0.5 ms	0.3 ms	0.5 ms	1.01	0.06	1.0000	idx: bookings_idempotency_key_unique
`booking-by-idempotency-key` group 31	bookings	request	1000×	Within budget	0.4 ms	0.5 ms	0.4 ms	0.5 ms	0.99	-0.03	1.0000	idx: bookings_idempotency_key_unique
`notifications-page` group 316	notifications	request	1×	Within budget	0.3 ms	0.5 ms	0.3 ms	0.4 ms	1.01	0.03	1.0000	idx: notifications_user_created_id_idx
`notifications-page` group 316	notifications	request	10×	Within budget	0.4 ms	0.5 ms	0.4 ms	0.5 ms	1.00	-0.05	1.0000	idx: notifications_user_created_id_idx
`notifications-page` group 316	notifications	request	100×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	0.99	-0.06	1.0000	idx: notifications_user_created_id_idx
`notifications-page` group 316	notifications	request	1000×	Within budget	0.4 ms	0.5 ms	0.4 ms	0.5 ms	1.00	-0.04	1.0000	idx: notifications_user_created_id_idx
`place-connector-id` group 351	residences	request	1×	Within budget	0.4 ms	0.8 ms	0.4 ms	0.7 ms	0.99	-0.04	1.0000	idx: places_pkey
`place-connector-id` group 351	residences	request	10×	Within budget	0.3 ms	0.5 ms	0.3 ms	0.5 ms	1.01	0.03	1.0000	idx: places_pkey
`place-connector-id` group 351	residences	request	100×	Within budget	0.2 ms	0.3 ms	0.2 ms	0.3 ms	1.01	0.05	1.0000	idx: places_pkey
`place-connector-id` group 351	residences	request	1000×	Within budget	0.4 ms	0.5 ms	0.4 ms	0.5 ms	0.99	-0.04	1.0000	idx: places_pkey
`notifications-feed` group 313	notifications	request	1×	Within budget	0.4 ms	0.5 ms	0.4 ms	0.5 ms	1.00	0.01	1.0000	idx: notifications_user_created_id_idx
`notifications-feed` group 313	notifications	request	10×	Within budget	0.4 ms	0.7 ms	0.4 ms	0.7 ms	0.99	-0.01	1.0000	idx: notifications_user_created_id_idx
`notifications-feed` group 313	notifications	request	100×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	1.00	0.02	1.0000	idx: notifications_user_created_id_idx
`notifications-feed` group 313	notifications	request	1000×	Within budget	0.4 ms	0.5 ms	0.4 ms	0.5 ms	0.99	-0.04	1.0000	idx: notifications_user_created_id_idx
`buildings-by-connector-ids` group 287	residences	background	1×	Within budget	0.4 ms	0.5 ms	0.4 ms	0.5 ms	0.98	-0.04	1.0000	seq: legal_entities (1) · idx: places_kind_connector_id_unique
`buildings-by-connector-ids` group 287	residences	background	10×	Within budget	0.3 ms	0.7 ms	0.4 ms	0.6 ms	1.03	0.03	1.0000	seq: legal_entities (1) · idx: places_kind_connector_id_unique
`buildings-by-connector-ids` group 287	residences	background	100×	Within budget	0.2 ms	0.3 ms	0.2 ms	0.3 ms	0.99	-0.06	1.0000	seq: legal_entities (1) · idx: places_kind_connector_id_unique
`buildings-by-connector-ids` group 287	residences	background	1000×	Within budget	0.3 ms	0.5 ms	0.3 ms	0.4 ms	0.98	-0.06	1.0000	seq: legal_entities (1) · idx: places_kind_connector_id_unique
`profiles-by-user` group 380	identity	request	1×	Within budget	0.4 ms	0.6 ms	0.4 ms	0.6 ms	1.00	0.01	1.0000	idx: profiles_user_idx
`profiles-by-user` group 380	identity	request	10×	Within budget	0.2 ms	0.4 ms	0.2 ms	0.4 ms	1.01	0.00	1.0000	idx: profiles_user_idx
`profiles-by-user` group 380	identity	request	100×	Within budget	0.2 ms	0.3 ms	0.2 ms	0.3 ms	1.00	0.01	1.0000	idx: profiles_user_idx
`profiles-by-user` group 380	identity	request	1000×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.5 ms	0.99	-0.03	1.0000	idx: profiles_user_idx
`booking-lock` group 57	bookings	request	1×	Within budget	1.2 ms	7.2 ms	1.2 ms	6.5 ms	0.99	-0.02	1.0000	idx: bookings_service_change_identity_unique
`booking-lock` group 57	bookings	request	10×	Within budget	0.4 ms	0.5 ms	0.4 ms	0.5 ms	0.99	-0.02	1.0000	idx: bookings_pkey
`booking-lock` group 57	bookings	request	100×	Within budget	0.3 ms	0.5 ms	0.3 ms	0.5 ms	1.00	-0.01	1.0000	idx: bookings_service_change_identity_unique
`booking-lock` group 57	bookings	request	1000×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	1.00	-0.03	1.0000	idx: bookings_pkey
`notification-by-id` group 308	notifications	request	1×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	1.00	-0.01	1.0000	idx: notifications_pkey
`notification-by-id` group 308	notifications	request	10×	Within budget	0.4 ms	0.6 ms	0.4 ms	0.6 ms	1.00	-0.01	1.0000	idx: notifications_pkey
`notification-by-id` group 308	notifications	request	100×	Within budget	0.3 ms	0.3 ms	0.3 ms	0.3 ms	0.99	-0.04	1.0000	idx: notifications_pkey
`notification-by-id` group 308	notifications	request	1000×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	0.98	-0.07	1.0000	idx: notifications_pkey
`outbox-claim` group 319	notifications	background	1×	Within budget	0.3 ms	0.5 ms	0.3 ms	0.5 ms	1.02	0.09	1.0000	idx: outbox_events_pkey
`outbox-claim` group 319	notifications	background	10×	Within budget	0.4 ms	0.5 ms	0.4 ms	0.5 ms	1.03	0.07	1.0000	idx: outbox_events_pkey
`outbox-claim` group 319	notifications	background	100×	Within budget	0.4 ms	0.5 ms	0.4 ms	0.6 ms	1.02	0.06	1.0000	idx: outbox_events_pkey
`outbox-claim` group 319	notifications	background	1000×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	1.00	0.05	1.0000	idx: outbox_events_pkey
`events-latest-snagging-cycle` group 216	events	request	1×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	1.01	0.03	1.0000	idx: events_snagging_cycle_number_unique
`events-latest-snagging-cycle` group 216	events	request	10×	Within budget	0.3 ms	0.5 ms	0.3 ms	0.5 ms	1.01	0.02	1.0000	idx: events_snagging_cycle_number_unique
`events-latest-snagging-cycle` group 216	events	request	100×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	0.99	-0.03	1.0000	idx: events_snagging_cycle_number_unique
`events-latest-snagging-cycle` group 216	events	request	1000×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	0.99	-0.03	1.0000	idx: events_snagging_cycle_number_unique
`visit-mirror-poll` group 84	bookings	background	1×	Within budget	0.7 ms	6.5 ms	0.7 ms	7.1 ms	0.98	0.01	1.0000	idx: bookings_visit_mirror_due_idx
`visit-mirror-poll` group 84	bookings	background	10×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	1.02	0.02	1.0000	idx: bookings_visit_mirror_due_idx
`visit-mirror-poll` group 84	bookings	background	100×	Within budget	0.3 ms	0.5 ms	0.3 ms	0.5 ms	1.02	0.06	1.0000	idx: bookings_visit_mirror_due_idx
`visit-mirror-poll` group 84	bookings	background	1000×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	1.01	0.02	1.0000	idx: bookings_visit_mirror_due_idx
`notifications-all-of-user` group 311	notifications	request	1×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	0.98	0.02	1.0000	idx: notifications_user_created_id_idx
`notifications-all-of-user` group 311	notifications	request	10×	Within budget	0.3 ms	0.6 ms	0.3 ms	0.6 ms	0.97	-0.07	1.0000	idx: notifications_user_created_id_idx
`notifications-all-of-user` group 311	notifications	request	100×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	1.01	0.03	1.0000	idx: notifications_user_created_id_idx
`notifications-all-of-user` group 311	notifications	request	1000×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	0.99	-0.08	1.0000	idx: notifications_user_created_id_idx
`ledger-latest-for-consumer` group 191	requests	background	1×	Within budget	0.3 ms	0.3 ms	0.3 ms	0.4 ms	1.01	0.04	1.0000	idx: event_ledger_consumer_created_idx
`ledger-latest-for-consumer` group 191	requests	background	10×	Within budget	0.2 ms	0.3 ms	0.2 ms	0.3 ms	0.98	-0.04	1.0000	idx: event_ledger_consumer_created_idx
`ledger-latest-for-consumer` group 191	requests	background	100×	Within budget	0.4 ms	0.9 ms	0.4 ms	0.8 ms	0.98	-0.02	1.0000	idx: event_ledger_consumer_created_idx
`ledger-latest-for-consumer` group 191	requests	background	1000×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.3 ms	0.99	-0.03	1.0000	idx: event_ledger_consumer_created_idx
`request-by-idempotency-key` group 413	requests	request	1×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	0.99	-0.05	1.0000	idx: requests_user_kind_key_unique
`request-by-idempotency-key` group 413	requests	request	10×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	0.99	-0.02	1.0000	idx: requests_user_kind_key_unique
`request-by-idempotency-key` group 413	requests	request	100×	Within budget	0.3 ms	0.8 ms	0.3 ms	0.8 ms	0.97	0.00	1.0000	idx: requests_user_kind_key_unique
`request-by-idempotency-key` group 413	requests	request	1000×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	1.00	-0.01	1.0000	idx: requests_user_kind_key_unique
`hold-by-key` group 233	bookings	request	1×	Within budget	0.4 ms	0.6 ms	0.4 ms	0.6 ms	1.00	-0.01	1.0000	idx: holds_kind_key_unique
`hold-by-key` group 233	bookings	request	10×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	1.01	0.00	1.0000	idx: holds_kind_key_unique
`hold-by-key` group 233	bookings	request	100×	Within budget	0.3 ms	0.3 ms	0.3 ms	0.3 ms	1.01	0.03	1.0000	idx: holds_kind_key_unique
`hold-by-key` group 233	bookings	request	1000×	Within budget	0.3 ms	0.3 ms	0.3 ms	0.3 ms	0.99	-0.06	1.0000	idx: holds_kind_key_unique
`events-readiness-history` group 199	events	request	1×	Within budget	0.3 ms	0.5 ms	0.3 ms	0.5 ms	1.00	-0.04	1.0000	idx: events_readiness_unique
`events-readiness-history` group 199	events	request	10×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	0.99	0.01	1.0000	idx: events_readiness_unique
`events-readiness-history` group 199	events	request	100×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	1.02	0.08	1.0000	idx: events_readiness_unique
`events-readiness-history` group 199	events	request	1000×	Within budget	0.3 ms	0.3 ms	0.3 ms	0.3 ms	0.99	-0.08	1.0000	idx: events_readiness_unique
`documents-of-profile-by-category` group 184	documents	request	1×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	0.97	-0.03	1.0000	idx: documents_legal_entity_subject_idx
`documents-of-profile-by-category` group 184	documents	request	10×	Within budget	0.3 ms	0.5 ms	0.3 ms	0.5 ms	1.00	-0.03	1.0000	idx: documents_legal_entity_subject_idx
`documents-of-profile-by-category` group 184	documents	request	100×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	0.97	-0.03	1.0000	idx: documents_legal_entity_subject_idx
`documents-of-profile-by-category` group 184	documents	request	1000×	Within budget	0.3 ms	0.3 ms	0.3 ms	0.3 ms	1.00	-0.02	1.0000	idx: documents_legal_entity_subject_idx
`events-legal-acceptances` group 220	events	request	1×	Within budget	0.3 ms	0.5 ms	0.4 ms	0.5 ms	1.02	0.03	1.0000	idx: events_profile_idx
`events-legal-acceptances` group 220	events	request	10×	Within budget	0.5 ms	1.2 ms	0.5 ms	1.4 ms	1.00	0.01	1.0000	idx: events_profile_idx
`events-legal-acceptances` group 220	events	request	100×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	0.99	-0.04	1.0000	idx: events_profile_idx
`events-legal-acceptances` group 220	events	request	1000×	Within budget	0.3 ms	0.3 ms	0.3 ms	0.3 ms	0.98	-0.05	1.0000	idx: events_profile_idx
`events-current-state` group 204	events	request	1×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	0.99	-0.03	1.0000	idx: events_readiness_unique
`events-current-state` group 204	events	request	10×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	0.99	-0.04	1.0000	idx: events_readiness_unique
`events-current-state` group 204	events	request	100×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	1.00	-0.02	1.0000	idx: events_readiness_unique
`events-current-state` group 204	events	request	1000×	Within budget	0.3 ms	0.3 ms	0.3 ms	0.3 ms	0.99	-0.05	1.0000	idx: events_readiness_unique
`deliveries-reclaim-leases` group 143	notifications	background	1×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.4 ms	1.00	-0.00	1.0000	idx: deliveries_recovery_idx
`deliveries-reclaim-leases` group 143	notifications	background	10×	Within budget	0.2 ms	0.3 ms	0.2 ms	0.3 ms	1.00	-0.03	1.0000	idx: deliveries_recovery_idx
`deliveries-reclaim-leases` group 143	notifications	background	100×	Within budget	0.2 ms	0.3 ms	0.2 ms	0.3 ms	0.99	-0.03	1.0000	idx: deliveries_recovery_idx
`deliveries-reclaim-leases` group 143	notifications	background	1000×	Within budget	0.2 ms	0.3 ms	0.2 ms	0.3 ms	1.01	0.00	1.0000	idx: deliveries_recovery_idx
`audit-throttle-history` group 11	audit	request	1×	Within budget	0.2 ms	0.3 ms	0.2 ms	0.3 ms	0.98	-0.03	1.0000	idx: audit_events_throttle_idx
`audit-throttle-history` group 11	audit	request	10×	Within budget	0.2 ms	0.3 ms	0.2 ms	0.3 ms	1.02	0.02	1.0000	idx: audit_events_throttle_idx
`audit-throttle-history` group 11	audit	request	100×	Within budget	0.3 ms	0.5 ms	0.3 ms	0.5 ms	1.01	0.01	1.0000	idx: audit_events_throttle_idx
`audit-throttle-history` group 11	audit	request	1000×	Within budget	0.2 ms	0.3 ms	0.2 ms	0.3 ms	1.01	0.01	1.0000	idx: audit_events_throttle_idx
`documents-connected-of-profile` group 185	documents	background	1×	Within budget	0.3 ms	0.4 ms	0.3 ms	0.3 ms	0.99	-0.07	1.0000	idx: documents_legal_entity_subject_idx
`documents-connected-of-profile` group 185	documents	background	10×	Within budget	0.3 ms	0.5 ms	0.3 ms	0.5 ms	0.99	-0.03	1.0000	idx: documents_legal_entity_subject_idx
`documents-connected-of-profile` group 185	documents	background	100×	Within budget	0.2 ms	0.3 ms	0.2 ms	0.3 ms	0.98	-0.08	1.0000	idx: documents_legal_entity_subject_idx
`documents-connected-of-profile` group 185	documents	background	1000×	Within budget	0.2 ms	0.3 ms	0.2 ms	0.3 ms	0.99	-0.07	1.0000	idx: documents_legal_entity_subject_idx
`audit-last-throttle-event` group 1	audit	request	1×	Within budget	0.2 ms	0.4 ms	0.2 ms	0.3 ms	1.00	-0.01	1.0000	idx: audit_events_throttle_idx
`audit-last-throttle-event` group 1	audit	request	10×	Within budget	0.2 ms	0.3 ms	0.2 ms	0.3 ms	0.99	-0.01	1.0000	idx: audit_events_throttle_idx
`audit-last-throttle-event` group 1	audit	request	100×	Within budget	0.3 ms	0.3 ms	0.2 ms	0.4 ms	0.99	0.00	1.0000	idx: audit_events_throttle_idx
`audit-last-throttle-event` group 1	audit	request	1000×	Within budget	0.2 ms	0.3 ms	0.2 ms	0.3 ms	0.99	-0.04	1.0000	idx: audit_events_throttle_idx

Method

Data. Each scale clones the migrated schema and multiplies every relationship: 1×, 10×, 100×, 1000× the seeded tenant (buildings, properties, owners, tenants, household members, staff, bookings, notifications, audit and ledger rows). Foreign keys are verified after generation and every table is analysed.
Queries. The statements are the application's own, harvested from pg_stat_statements while its test suites ran, and executed as the runtime role under row-level security with the same request context the application sets.
Sampling. 12 deterministic parameter sets per query, up to 25 rounds (at least 5), a 15 s time budget per query, and a 20 s statement timeout. Every execution runs in its own transaction and rolls back, after one warm-up pass; before and after databases are interleaved execution by execution so drift affects both equally.
Statistics. Medians carry a 95% bootstrap interval. Before-versus-after uses the two-sided Mann–Whitney U test with Holm–Bonferroni correction across all comparisons (α = 0.01), Cliff's δ for effect size, and the Hodges–Lehmann shift and ratio of medians for magnitude. A difference counts as a change only when it is significant after correction and |δ| ≥ 0.33 and the medians are at least 1.25× apart; with hundreds of executions a shift of microseconds is significant but not material. Nothing assumes a normal distribution. The slope is the least-squares exponent of median latency against scale in log–log space.
Status. Budgets are p95 50 ms on the request path and 500 ms for background jobs. Timed out or failed: any execution hit the timeout or errored. Over budget: p95 over budget. Scan grows with data: within budget today but the plan reads at least 1,000 rows through a sequential scan, so it will not stay there.
Server. PostgreSQL 18.6 (Debian 18.6-1.pgdg12+2) on aarch64-unknown-linux-gnu, compiled by gcc (Debian 12.2.0-14+deb12u1) 12.2.0, 64-bit. Generated 2026-11-10T06:10:17.478Z.