Troubleshooting KSQL – Part 2: What's Happening Under the Covers? | Confluent
Oct 4, 2018Robin Moffatt

Summary
This post, the second in a series on KSQL troubleshooting, delves into the internal workings of KSQL queries. It explains how to monitor message throughput and failed messages using `DESCRIBE EXTENDED`, how to view running queries with `SHOW QUERIES`, and how to understand the execution plan and processing topology using `EXPLAIN`. It also highlights the use of Confluent Control Center for monitoring streams and JMX metrics for deeper inspection of KSQL, Kafka Streams, and Kafka producer/consumer behavior. The post provides practical examples and links to GitHub for code samples.