/sql-statements/sql-statement-show-analyze-status.md

https://github.com/pingcap/docs · Markdown · 53 lines · 38 code · 15 blank · 0 comment · 0 complexity · 2294629265d22be9e137065a926b52d1 MD5 · raw file 

    

  1. ---
    2. 

  2. title: SHOW ANALYZE STATUS
    3. 

  3. summary: An overview of the usage of SHOW ANALYZE STATUS for the TiDB database。
    4. 

  4. aliases: ['/docs/dev/sql-statements/sql-statement-show-analyze-status/']
    5. 

  5. ---
    6. 

  6. 

  7. # SHOW ANALYZE STATUS
    8. 

  8. 

  9. The `SHOW ANALYZE STATUS` statement shows the statistics collection tasks being executed by TiDB and a limited number of historical task records.
    10. 

  10. 

  11. ## Synopsis
    12. 

  12. 

  13. **ShowStmt:**
    14. 

  14. 

  15. ![ShowStmt](/media/sqlgram/ShowStmt.png)
    16. 

  16. 

  17. **ShowTargetFilterable:**
    18. 

  18. 

  19. ![ShowTargetFilterable](/media/sqlgram/ShowTargetFilterable.png)
    20. 

  20. 

  21. ## Examples
    22. 

  22. 

  23. {{< copyable "sql" >}}
    24. 

  24. 

  25. ```sql
    26. 

  26. create table t(x int, index idx(x)) partition by hash(x) partition 4;
    27. 

  27. analyze table t;
    28. 

  28. show analyze status;
    29. 

  29. ```
    30. 

  30. 

  31. ```sql
    32. 

  32. +--------------+------------+----------------+-------------------+----------------+---------------------+----------+
    33. 

  33. | Table_schema | Table_name | Partition_name | Job_info          | Processed_rows | Start_time          | State    |
    34. 

  34. +--------------+------------+----------------+-------------------+----------------+---------------------+----------+
    35. 

  35. | test         | t          | p1             | analyze columns   |              0 | 2020-05-25 17:23:55 | finished |
    36. 

  36. | test         | t          | p0             | analyze columns   |              0 | 2020-05-25 17:23:55 | finished |
    37. 

  37. | test         | t          | p0             | analyze index idx |              0 | 2020-05-25 17:23:55 | finished |
    38. 

  38. | test         | t          | p1             | analyze index idx |              0 | 2020-05-25 17:23:55 | finished |
    39. 

  39. | test         | t          | p2             | analyze index idx |              0 | 2020-05-25 17:23:55 | finished |
    40. 

  40. | test         | t          | p3             | analyze index idx |              0 | 2020-05-25 17:23:55 | finished |
    41. 

  41. | test         | t          | p3             | analyze columns   |              0 | 2020-05-25 17:23:55 | finished |
    42. 

  42. | test         | t          | p2             | analyze columns   |              0 | 2020-05-25 17:23:55 | finished |
    43. 

  43. +--------------+------------+----------------+-------------------+----------------+---------------------+----------+
    44. 

  44. 8 rows in set (0.00 sec)
    45. 

  45. ```
    46. 

  46. 

  47. ## MySQL compatibility
    48. 

  48. 

  49. This statement is a TiDB extension to MySQL syntax.
    50. 

  50. 

  51. ## See also
    52. 

  52. 

  53. * [ANALYZE_STATUS table](/information-schema/information-schema-analyze-status.md)
    54.