tool/showstat4.c

   1 /*
   2 ** This utility program decodes and displays the content of the
   3 ** sqlite_stat4 table in the database file named on the command
   4 ** line.
   5 */
   6 #include <stdio.h>
   7 #include <string.h>
   8 #include <stdlib.h>
   9 #include <ctype.h>
  10 #include "sqlite3.h"
  11
  12 #define ISPRINT(X)  isprint((unsigned char)(X))
  13
  14 typedef sqlite3_int64 i64;   /* 64-bit signed integer type */
  15
  16
  17 /*
  18 ** Convert the var-int format into i64.  Return the number of bytes
  19 ** in the var-int.  Write the var-int value into *pVal.
  20 */
  21 static int decodeVarint(const unsigned char *z, i64 *pVal){
  22   i64 v = 0;
  23   int i;
  24   for(i=0; i<8; i++){
  25     v = (v<<7) + (z[i]&0x7f);
  26     if( (z[i]&0x80)==0 ){ *pVal = v; return i+1; }
  27   }
  28   v = (v<<8) + (z[i]&0xff);
  29   *pVal = v;
  30   return 9;
  31 }
  32
  33
  34
  35 int main(int argc, char **argv){
  36   sqlite3 *db;
  37   sqlite3_stmt *pStmt;
  38   char *zIdx = 0;
  39   int rc, j, x, y, mxHdr;
  40   const unsigned char *aSample;
  41   int nSample;
  42   i64 iVal;
  43   const char *zSep;
  44   int iRow = 0;
  45
  46   if( argc!=2 ){
  47     fprintf(stderr, "Usage: %s DATABASE-FILE\n", argv[0]);
  48     exit(1);
  49   }
  50   rc = sqlite3_open(argv[1], &db);
  51   if( rc!=SQLITE_OK || db==0 ){
  52     fprintf(stderr, "Cannot open database file [%s]\n", argv[1]);
  53     exit(1);
  54   }
  55   rc = sqlite3_prepare_v2(db,
  56         "SELECT tbl||'.'||idx, nEq, nLT, nDLt, sample "
  57         "FROM sqlite_stat4 ORDER BY 1", -1,
  58         &pStmt, 0);
  59   if( rc!=SQLITE_OK || pStmt==0 ){
  60     fprintf(stderr, "%s\n", sqlite3_errmsg(db));
  61     sqlite3_close(db);
  62     exit(1);
  63   }
  64   while( SQLITE_ROW==sqlite3_step(pStmt) ){
  65     if( zIdx==0 || strcmp(zIdx, (const char*)sqlite3_column_text(pStmt,0))!=0 ){
  66       if( zIdx ) printf("\n**************************************"
  67                         "**************\n\n");
  68       sqlite3_free(zIdx);
  69       zIdx = sqlite3_mprintf("%s", sqlite3_column_text(pStmt,0));
  70       iRow = 0;
  71     }
  72     printf("%s sample %d ------------------------------------\n", zIdx, ++iRow);
  73     printf("  nEq    = %s\n", sqlite3_column_text(pStmt,1));
  74     printf("  nLt    = %s\n", sqlite3_column_text(pStmt,2));
  75     printf("  nDLt   = %s\n", sqlite3_column_text(pStmt,3));
  76     printf("  sample = x'");
  77     aSample = sqlite3_column_blob(pStmt,4);
  78     nSample = sqlite3_column_bytes(pStmt,4);
  79     for(j=0; j<nSample; j++) printf("%02x", aSample[j]);
  80     printf("'\n          ");
  81     zSep = " ";
  82     x = decodeVarint(aSample, &iVal);
  83     if( iVal<x || iVal>nSample ){
  84       printf(" <error>\n");
  85       continue;
  86     }
  87     y = mxHdr = (int)iVal;
  88     while( x<mxHdr ){
  89       int sz;
  90       i64 v;
  91       x += decodeVarint(aSample+x, &iVal);
  92       if( x>mxHdr ) break;
  93       if( iVal<0 ) break;
  94       switch( iVal ){
  95         case 0:  sz = 0;  break;
  96         case 1:  sz = 1;  break;
  97         case 2:  sz = 2;  break;
  98         case 3:  sz = 3;  break;
  99         case 4:  sz = 4;  break;
 100         case 5:  sz = 6;  break;
 101         case 6:  sz = 8;  break;
 102         case 7:  sz = 8;  break;
 103         case 8:  sz = 0;  break;
 104         case 9:  sz = 0;  break;
 105         case 10:
 106         case 11: sz = 0;  break;
 107         default: sz = (int)(iVal-12)/2;  break;
 108       }
 109       if( y+sz>nSample ) break;
 110       if( iVal==0 ){
 111         printf("%sNULL", zSep);
 112       }else if( iVal==8 || iVal==9 ){
 113         printf("%s%d", zSep, ((int)iVal)-8);
 114       }else if( iVal<=7 ){
 115         v = (signed char)aSample[y];
 116         for(j=1; j<sz; j++){
 117           v = (v<<8) + aSample[y+j];
 118         }
 119         if( iVal==7 ){
 120           double r;
 121           char *z;
 122           memcpy(&r, &v, sizeof(r));
 123           z = sqlite3_mprintf("%s%!.15g", zSep, r);
 124           printf("%s", z);
 125           sqlite3_free(z);
 126         }else{
 127           printf("%s%lld", zSep, v);
 128         }
 129       }else if( (iVal&1)==0 ){
 130         printf("%sx'", zSep);
 131         for(j=0; j<sz; j++){
 132           printf("%02x", aSample[y+j]);
 133         }
 134         printf("'");
 135       }else{
 136         printf("%s'", zSep);
 137         for(j=0; j<sz; j++){
 138           char c = (char)aSample[y+j];
 139           if( ISPRINT(c) ){
 140             if( c=='\'' || c=='\\' ) putchar('\\');
 141             putchar(c);
 142           }else if( c=='\n' ){
 143             printf("\\n");
 144           }else if( c=='\t' ){
 145             printf("\\t");
 146           }else if( c=='\r' ){
 147             printf("\\r");
 148           }else{
 149             printf("\\%03o", c);
 150           }
 151         }
 152         printf("'");
 153       }
 154       zSep = ",";
 155       y += sz;
 156     }
 157     printf("\n");
 158   }
 159   sqlite3_free(zIdx);
 160   sqlite3_finalize(pStmt);
 161   sqlite3_close(db);
 162   return 0;
 163 }