gistfile1.txt

*************************** 10. row ***************************
           Id: 11408
         User: root
         Host: localhost
           db: glt
      Command: Query
         Time: 212
        State: Sending data
         Info: SELECT (t1.cid + 1) as gap_starts_at,
       (SELECT MIN(t3.cid) -1 FROM acid_event t3 WHERE t3.cid > t1.cid) as gap_ends_at
FROM acid_event t1
WHERE NOT EXISTS (SELECT t2.cid FROM acid_event t2 WHERE t2.cid = t1.cid + 1)
HAVING gap_ends_at IS NOT NULL
    Rows_sent: 0
Rows_examined: 1589439392
    Rows_read: 1589439392