#   E X P L A I N   ( A N A L Y Z E ,   B U F F E R S )   f o r   k e y s e t   h i s t o r y   p a g i n a t i o n 
 
 g e n e r a t e d _ a t _ u t c :   2 0 2 6 - 1 1 - 0 6 T 2 1 : 3 3 : 4 0 . 3 5 2 5 9 0 Z 
 
 m e s s a g e s _ i n _ c h a t :   1 0 0 0 0 
 
 c h a t _ i d :   c e 8 f 7 9 1 2 - 3 0 b 3 - 4 4 c 6 - 9 8 f 3 - a a e 3 3 8 2 0 9 b e a 
 
 q u e r y :   W H E R E   c h a t _ i d   =   ?   A N D   ( c r e a t e d _ a t ,   i d )   >   ( ? ,   ? )   O R D E R   B Y   c r e a t e d _ a t ,   i d   L I M I T   5 1 
 
 
 
 L i m i t     ( c o s t = 0 . 2 9 . . 1 1 . 8 1   r o w s = 5 1   w i d t h = 7 7 )   ( a c t u a l   t i m e = 0 . 0 2 4 . . 0 . 0 3 2   r o w s = 5 1   l o o p s = 1 ) 
 
     B u f f e r s :   s h a r e d   h i t = 4 
 
     - >     I n d e x   S c a n   u s i n g   m e s s a g e s _ c h a t _ c r e a t e d _ a t _ i d _ i d x   o n   m e s s a g e s     ( c o s t = 0 . 2 9 . . 9 7 3 . 3 1   r o w s = 4 3 0 5   w i d t h = 7 7 )   ( a c t u a l   t i m e = 0 . 0 2 3 . . 0 . 0 2 8   r o w s = 5 1   l o o p s = 1 ) 
 
                 I n d e x   C o n d :   ( ( c h a t _ i d   =   ' c e 8 f 7 9 1 2 - 3 0 b 3 - 4 4 c 6 - 9 8 f 3 - a a e 3 3 8 2 0 9 b e a ' : : u u i d )   A N D   ( R O W ( c r e a t e d _ a t ,   i d )   >   R O W ( ' 2 0 2 6 - 0 1 - 0 1   0 0 : 0 0 : 0 9 . 5 0 1 + 0 0 ' : : t i m e s t a m p   w i t h   t i m e   z o n e ,   ' 8 0 6 c 8 3 d c - f 5 6 6 - 4 7 3 6 - 8 e f 4 - 0 9 4 b d c d 2 8 f 3 3 ' : : u u i d ) ) ) 
 
                 B u f f e r s :   s h a r e d   h i t = 4 
 
 P l a n n i n g : 
 
     B u f f e r s :   s h a r e d   h i t = 7 
 
 P l a n n i n g   T i m e :   0 . 2 0 8   m s 
 
 E x e c u t i o n   T i m e :   0 . 1 3 8   m s 
 
 P A S S :   i n d e x   u s e d   o n   1 0 0 0 0   m e s s a g e s ;   e v i d e n c e   w r i t t e n   t o   / t m p / e x p l a i n _ h i s t o r y . t x t 
 
 