[#MDEV-22891] Optimizer trace: const tables are not clearly visible

[MDEV-22891] Optimizer trace: const tables are not clearly visible Created: 2020-06-14 Updated: 2020-06-16 Resolved: 2020-06-15
Status:	Closed
Project:	MariaDB Server
Component/s:	Optimizer
Fix Version/s:	10.5.4

Type:

Task

Priority:

Major

Reporter:

Sergei Petrunia

Assignee:

Sergei Petrunia

Resolution:

Fixed

Votes:

Labels:

None

Description

Encountered this when debugging ~~MDEV-22866~~:

It is not immediately apparent from the optimizer trace which tables are constant.

This is important when debugging join optimization, so it would be nice if this was shown.

Comments

Comment by Sergei Petrunia [ 2020-06-14 ]

Wait, they are shown for inner joins

            "rows_estimation": [

                "table": "t1",

                "rows": 1,

                "cost": 1,

                "table_type": "const"

},

Generated at Thu Feb 08 09:18:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.