request execute slowly in PXC

  • Filter
  • Time
  • Show
Clear All
new posts

  • request execute slowly in PXC


    I need some help please. I don't understand when I execute this request :

    SELECT COUNT(DISTINCT crp.classifiedId) AS classifiedNb FROM ClassifiedRelProperty crp INNER JOIN ListValue lv ON lv.id = crp.listValueId INNER JOIN ListValueCreationRequest lvcr ON lvcr.targetListValueId = lv.id INNER JOIN RubricProperty rp ON rp.id = lvcr.rubricPropertyId INNER JOIN Classified c ON c.id = crp.classifiedId WHERE lvcr.currentStatus = true AND lvcr.status = 0 AND c.rubricId = rp.rubricId AND crp.propertyId = rp.propertyId;

    It's very slow in node 1 and 3 (10 mn) and quick in my node 2 (0,35 s)

    I don't have errors in my log.

    Do you know what's the problem ?

    Thx for your help

  • #2
    Compare the execution plan in both nodes with EXPLAIN. Maybe they are using different execution plans. Also, I assume that the hardware characteristics of both nodes are the same. Does this problem happen only with this query?