Skip to content

SHOW TOPICS

Synopsis

1
SHOW | LIST [ALL] TOPICS [EXTENDED];

Description

SHOW TOPICS lists the available topics in the Kafka cluster that ksqlDB is configured to connect to (default setting for bootstrap.servers: localhost:9092). SHOW TOPICS EXTENDED also displays consumer groups and their active consumer counts.

SHOW TOPICS does not display hidden topics by default, such as: * KSQL internal topics, like the KSQL command topic or changelog & repartition topics, or topics that match any pattern in the ksql.hidden.topics configuration.

SHOW ALL TOPICS lists all topics, including hidden topics.

Example

1
2
3
4
5
6
7
8
ksql> SHOW TOPICS;

 Kafka Topic                                                                           | Partitions | Replicas
---------------------------------------------------------------------------------------------------------------
 default_ksql_processing_log                                                           | 1          | 1
 pageviews                                                                             | 1          | 1
 users                                                                                 | 1          | 1
---------------------------------------------------------------------------------------------------------------
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
ksql> SHOW ALL TOPICS;

 Kafka Topic                                                                           | Partitions | Replicas
--------------------------------------------------------------------------------------------------------------
 _confluent-ksql-default__command_topic                                                | 1          | 1
 _confluent-ksql-default_query_CTAS_USERS_0-Aggregate-Aggregate-Materialize-changelog  | 1          | 1
 _confluent-ksql-default_query_CTAS_USERS_0-Aggregate-GroupBy-repartition              | 1          | 1
 default_ksql_processing_log                                                           | 1          | 1
 pageviews                                                                             | 1          | 1
 users                                                                                 | 1          | 1
--------------------------------------------------------------------------------------------------------------

Last update: 2020-07-21