# request execute slowly in PXC

**URL:** <https://forums.percona.com/t/request-execute-slowly-in-pxc/2534>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [February 7, 2013, 7:01am UTC](https://forums.percona.com/t/request-execute-slowly-in-pxc/2534 "2013-02-07T07:01:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![azigui](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@azigui](https://forums.percona.com/u/azigui)\
**Post date:** [February 7, 2013, 7:01am UTC](https://forums.percona.com/t/request-execute-slowly-in-pxc/2534/1 "2013-02-07T07:01:29Z")

</div>

Hi,

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

---

<div class="post-metadata">

**Author:** ![miguelangelnieto](https://avatars.discourse-cdn.com/v4/letter/m/b9e5f3/32.png) [@miguelangelnieto](https://forums.percona.com/u/miguelangelnieto)\
**Post date:** [February 20, 2013, 7:08am UTC](https://forums.percona.com/t/request-execute-slowly-in-pxc/2534/2 "2013-02-20T07:08:06Z")

</div>

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?