Analyze Excess Appointments

⚠️ Overlapping Appointments (Same Time Slot)

❌ Found 1 overlapping appointment pairs!
These appointments are scheduled for the same time slot.

Time Slot	Appointment 1	Appointment 2	Actions
2025-09-12 14:30	ID: `01K4MM0DEGF1EDBMQW9YQVAKPW` Client: Sophie Simon Status: CONFIRMED	ID: `01K4MSQXGRHWJYGPH9DFM4M3J4` Client: Marie Michel Status: CONFIRMED

📊 Appointments Count Per Time Slot

✅ No time slots with multiple appointments!

👥 Duplicate Bookings by Same Customer

No customers with multiple active bookings.

⚙️ System Configuration Issues

Availability Cache Status

Total Slots: 0

Unique Slots: 0

Duplicates: 0

Recommended Actions

Clean up test/duplicate appointments
Ensure API uses GROUP BY for slots
Add database constraints to prevent overlaps
Implement mutex/lock during booking

📅 Recent Appointments (Last 20)

Booking ID	Customer	Date/Time	Status	Created
`01K57ARJEGASJHMJB6V40CCNMK`	Test Customer test1757961538@example.com	Sep 16 16:00	PENDING	Sep 15 20:38:58
`01K53X41ZRJBVNFPY173TT4GWE`	Test Customer test1757846571@example.com	Sep 15 16:00	PENDING	Sep 14 12:42:51
`01K4YR2SZR6BZQB2T7CVD0E11C`	Sophie Martin sophie.martin288@test.com	Sep 15 09:30	CONFIRMED	Sep 12 12:38:35
`01K4WT4N901B1M79B3K2TDG85S`	Emma Laurent emma.laurent6893@test.com	Sep 12 12:30	CONFIRMED	Sep 11 18:36:04
`01K4WT2GXG4PH9XQ3VY30RAW1D`	Pierre Michel pierre.michel1784@test.com	Sep 12 13:30	CONFIRMED	Sep 11 18:34:54
`01K4W0HAH0Q6KAWVV8RNQ3EBAZ`	Julie Dupont julie.dupont3649@test.com	Sep 12 13:00	CONFIRMED	Sep 11 11:08:36
`01K4VYPMK829K9RB044TR52TTY`	Jean Bernard jean.bernard5014@test.com	Sep 12 11:30	CONFIRMED	Sep 11 10:36:33
`01K4VYMTZGZ0JQTAV275CF50JP`	Thomas Michel thomas.michel7897@test.com	Sep 12 10:30	CONFIRMED	Sep 11 10:35:34
`01K4VTG3X8YW4PZTQ6JKR4QZQ9`	Pierre Bernard pierre.bernard2181@test.com	Sep 11 09:30	CONFIRMED	Sep 11 09:23:05
`01K4MTMTAG8D2S3JMEQPNMH6YE`	Sophie Simon sophie.simon3138@test.com	Sep 9 12:00	CONFIRMED	Sep 8 16:10:58
`01K4MSQXGRHWJYGPH9DFM4M3J4`	Marie Michel marie.michel2446@test.com	Sep 12 14:00	CONFIRMED	Sep 8 15:55:11
`01K4MSQSKRF8JQXKGMDQ1Z1C0B`	Julie Bernard julie.bernard2269@test.com	Sep 11 15:00	CONFIRMED	Sep 8 15:55:07
`01K4MSQMQG2CNYEM6KMG2R4GE9`	Sophie Dupont sophie.dupont1940@test.com	Sep 9 11:30	CONFIRMED	Sep 8 15:55:02
`01K4MMRVNRXE0AB02WBSHV0MXD`	Julie Dupont julie.dupont6865@test.com	Sep 10 10:00	CONFIRMED	Sep 8 14:28:19
`01K4MM0DEGF1EDBMQW9YQVAKPW`	Sophie Simon sophie.simon8701@test.com	Sep 12 14:30	CONFIRMED	Sep 8 14:14:58
`01K4MM09HGP3NWRX4Q4K8R8MYF`	Jean Simon jean.simon7354@test.com	Sep 11 14:00	CONFIRMED	Sep 8 14:14:54
`01K4MM03P0RNNYTK614DMHZ457`	Emma Moreau emma.moreau6960@test.com	Sep 10 11:30	CONFIRMED	Sep 8 14:14:48
`01K4MKXFPG2GQZZAB290SN7H6X`	Pierre Simon pierre.simon4276@test.com	Sep 9 11:00	CONFIRMED	Sep 8 14:13:22
`01K4MKQM6GFHTE1EEGQQBGB8WY`	Julie Durand julie.durand6826@test.com	Sep 9 10:30	CONFIRMED	Sep 8 14:10:10
`01K4MKQEB00211VTWAAPWC79NQ`	Jean Michel jean.michel1519@test.com	Sep 9 10:00	CONFIRMED	Sep 8 14:10:04

⚠️ Analyze Excess Appointments

3

0

173

2