🔍 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
  1. Clean up test/duplicate appointments
  2. Ensure API uses GROUP BY for slots
  3. Add database constraints to prevent overlaps
  4. 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 FAILED Sep 15 20:38:58
01K53X41ZRJBVNFPY173TT4GWE Test Customer
test1757846571@example.com		 Sep 15 16:00 FAILED 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