One Tool to Analyze Them All

We are pleased to announce the implementation on explain.tensor.ru of basic support for analysis and visualization of plans specific to PostgreSQL-compatible solutions : Timescale , Citus , Greenplum and Redshift .









So if in the future you come across a plan similar to the usual result EXPLAIN



, but with some strange knots, you know where to go.

EXPLAIN <-> SQL

To develop the topic of matching plan and query nodes , the ability to quickly view and switch between them has been added:

Node definition supported [Parallel] Custom Scan (ChunkAppend)



:

The own time of Task



-nodes running on separate nodes of the cluster is determined based on the actual time Execution Time



: The







time of the "parent" is Custom Scan (Citus Adaptive)



calculated correctly, even if it is executed Task



simultaneously on several cluster nodes at once:

Learn more about analysis EXPLAIN



at Citus .

Specific nodes like Broadcast Motion, Redistribute Motion, Gather Motion, Partition Selector, Sequence



:

Learn more about analysis EXPLAIN



in Greenplum .

Work with all XN



-nodes is supported, including specific XN Network, XN Merge, XN Window



and data redistribution for Join



-nodes:

Learn more about analysis EXPLAIN



in Redshift .

---

If suddenly you find something that we have not yet taken into account - write in the comments.