[14:59:57,134][WARNING][long-qry-#32][LongRunningQueryManager] Query execution is too long [globalQueryId=efb58659-86ed-420b-aadc-744b7df7ddef_2936, duration=3715ms, type=LOCAL, distributedJoin=false, enforceJoinOrder=true, lazy=false, schema=PUBLIC, sql='select T0.* , T1.HIDE
from TABLE1 as T0
left JOIN
( select key1, key2, count(*) AS HIDE
        from TABLE1
        GROUP BY key1, key2
) as T1
ON T0.key1 = T1.key1 AND T0.key2 = T1.key2', plan=SELECT
    T0.INTERNALID,
    T0.COLUMN1,
    T0.COLUMN2,
    T0.COLUMN3,
    T0.COLUMN4,
    T0.COLUMN5,
    T0.COLUMN6,
    T0.COLUMN7,
    T0.COLUMN8,
    T0.COLUMN9,
    T0.COLUMN10,
    T0.KEY1,
    T0.KEY2,
    T1.HIDE
FROM PUBLIC.TABLE1 T0
    /* PUBLIC.TABLE1.__SCAN_ */
    /* scanCount: 787 */
LEFT OUTER JOIN (
    SELECT
        KEY1,
        KEY2,
        COUNT(*) AS HIDE
    FROM PUBLIC.TABLE1
    GROUP BY KEY1, KEY2
) T1
    /* SELECT
        KEY1,
        KEY2,
        COUNT(*) AS HIDE
    FROM PUBLIC.TABLE1
        /++ PUBLIC.TABLE1.__SCAN_ ++/
        /++ scanCount: 2599 ++/
    WHERE (KEY1 IS ?1)
        AND (KEY2 IS ?2)
    GROUP BY KEY1, KEY2: KEY1 = T0.KEY1
        AND KEY2 = T0.KEY2
     */
    ON (T0.KEY1 = T1.KEY1)
    AND (T0.KEY2 = T1.KEY2)
    /* scanCount: 1572 */]
[15:00:00,135][WARNING][long-qry-#32][LongRunningQueryManager] Query execution is too long [globalQueryId=efb58659-86ed-420b-aadc-744b7df7ddef_2936, duration=6713ms, type=LOCAL, distributedJoin=false, enforceJoinOrder=true, lazy=false, schema=PUBLIC, sql='select T0.* , T1.HIDE
from TABLE1 as T0
left JOIN
( select key1, key2, count(*) AS HIDE
        from TABLE1
        GROUP BY key1, key2
) as T1
ON T0.key1 = T1.key1 AND T0.key2 = T1.key2', plan=SELECT
    T0.INTERNALID,
    T0.COLUMN1,
    T0.COLUMN2,
    T0.COLUMN3,
    T0.COLUMN4,
    T0.COLUMN5,
    T0.COLUMN6,
    T0.COLUMN7,
    T0.COLUMN8,
    T0.COLUMN9,
    T0.COLUMN10,
    T0.KEY1,
    T0.KEY2,
    T1.HIDE
FROM PUBLIC.TABLE1 T0
    /* PUBLIC.TABLE1.__SCAN_ */
    /* scanCount: 1336 */
LEFT OUTER JOIN (
    SELECT
        KEY1,
        KEY2,
        COUNT(*) AS HIDE
    FROM PUBLIC.TABLE1
    GROUP BY KEY1, KEY2
) T1
    /* SELECT
        KEY1,
        KEY2,
        COUNT(*) AS HIDE
    FROM PUBLIC.TABLE1
        /++ PUBLIC.TABLE1.__SCAN_ ++/
        /++ scanCount: 1307 ++/
    WHERE (KEY1 IS ?1)
        AND (KEY2 IS ?2)
    GROUP BY KEY1, KEY2: KEY1 = T0.KEY1
        AND KEY2 = T0.KEY2
     */
    ON (T0.KEY1 = T1.KEY1)
    AND (T0.KEY2 = T1.KEY2)
    /* scanCount: 2670 */]
[15:00:06,136][WARNING][long-qry-#32][LongRunningQueryManager] Query execution is too long [globalQueryId=efb58659-86ed-420b-aadc-744b7df7ddef_2936, duration=12718ms, type=LOCAL, distributedJoin=false, enforceJoinOrder=true, lazy=false, schema=PUBLIC, sql='select T0.* , T1.HIDE
from TABLE1 as T0
left JOIN
( select key1, key2, count(*) AS HIDE
        from TABLE1
        GROUP BY key1, key2
) as T1
ON T0.key1 = T1.key1 AND T0.key2 = T1.key2', plan=SELECT
    T0.INTERNALID,
    T0.COLUMN1,
    T0.COLUMN2,
    T0.COLUMN3,
    T0.COLUMN4,
    T0.COLUMN5,
    T0.COLUMN6,
    T0.COLUMN7,
    T0.COLUMN8,
    T0.COLUMN9,
    T0.COLUMN10,
    T0.KEY1,
    T0.KEY2,
    T1.HIDE
FROM PUBLIC.TABLE1 T0
    /* PUBLIC.TABLE1.__SCAN_ */
    /* scanCount: 2399 */
LEFT OUTER JOIN (
    SELECT
        KEY1,
        KEY2,
        COUNT(*) AS HIDE
    FROM PUBLIC.TABLE1
    GROUP BY KEY1, KEY2
) T1
    /* SELECT
        KEY1,
        KEY2,
        COUNT(*) AS HIDE
    FROM PUBLIC.TABLE1
        /++ PUBLIC.TABLE1.__SCAN_ ++/
        /++ scanCount: 3754 ++/
    WHERE (KEY1 IS ?1)
        AND (KEY2 IS ?2)
    GROUP BY KEY1, KEY2: KEY1 = T0.KEY1
        AND KEY2 = T0.KEY2
     */
    ON (T0.KEY1 = T1.KEY1)
    AND (T0.KEY2 = T1.KEY2)
    /* scanCount: 4796 */]
[15:00:11,443][INFO][tcp-disco-srvr-[:47500]-#3-#46][TcpDiscoverySpi] TCP discovery accepted incoming connection [rmtAddr=/192.168.50.158, rmtPort=48396]
[15:00:11,443][INFO][tcp-disco-srvr-[:47500]-#3-#46][TcpDiscoverySpi] TCP discovery spawning a new thread for connection [rmtAddr=/192.168.50.158, rmtPort=48396]
[15:00:11,444][INFO][tcp-disco-sock-reader-[]-#1241-#9880][TcpDiscoverySpi] Started serving remote node connection [rmtAddr=/192.168.50.158:48396, rmtPort=48396]
[15:00:11,445][INFO][tcp-disco-sock-reader-[]-#1241-#9880][TcpDiscoverySpi] Received ping request from the remote node [rmtNodeId=489c41e0-84ad-4757-a6c4-c6b8397c3e22, rmtAddr=/192.168.50.158:48396, rmtPort=48396]
[15:00:11,445][INFO][tcp-disco-sock-reader-[]-#1241-#9880][TcpDiscoverySpi] Finished writing ping response [rmtNodeId=489c41e0-84ad-4757-a6c4-c6b8397c3e22, rmtAddr=/192.168.50.158:48396, rmtPort=48396]
[15:00:11,445][INFO][tcp-disco-sock-reader-[]-#1241-#9880][TcpDiscoverySpi] Finished serving remote node connection [rmtAddr=/192.168.50.158:48396, rmtPort=48396, rmtNodeId=null]
[15:00:15,599][WARNING][client-connector-#81][IgniteH2Indexing] Long running query is finished [globalQueryId=efb58659-86ed-420b-aadc-744b7df7ddef_2936, duration=22174ms, type=LOCAL, distributedJoin=false, enforceJoinOrder=true, lazy=false, schema=PUBLIC, sql='select T0.* , T1.HIDE
from TABLE1 as T0
left JOIN
( select key1, key2, count(*) AS HIDE
        from TABLE1
        GROUP BY key1, key2
) as T1
ON T0.key1 = T1.key1 AND T0.key2 = T1.key2', plan=SELECT
    T0.INTERNALID,
    T0.COLUMN1,
    T0.COLUMN2,
    T0.COLUMN3,
    T0.COLUMN4,
    T0.COLUMN5,
    T0.COLUMN6,
    T0.COLUMN7,
    T0.COLUMN8,
    T0.COLUMN9,
    T0.COLUMN10,
    T0.KEY1,
    T0.KEY2,
    T1.HIDE
FROM PUBLIC.TABLE1 T0
    /* PUBLIC.TABLE1.__SCAN_ */
    /* scanCount: 4417 */
LEFT OUTER JOIN (
    SELECT
        KEY1,
        KEY2,
        COUNT(*) AS HIDE
    FROM PUBLIC.TABLE1
    GROUP BY KEY1, KEY2
) T1
    /* SELECT
        KEY1,
        KEY2,
        COUNT(*) AS HIDE
    FROM PUBLIC.TABLE1
        /++ PUBLIC.TABLE1.__SCAN_ ++/
        /++ scanCount: 4417 ++/
    WHERE (KEY1 IS ?1)
        AND (KEY2 IS ?2)
    GROUP BY KEY1, KEY2: KEY1 = T0.KEY1
        AND KEY2 = T0.KEY2
     */
    ON (T0.KEY1 = T1.KEY1)
    AND (T0.KEY2 = T1.KEY2)
    /* scanCount: 8832 */]
[15:00:20,081][INFO][tcp-disco-srvr-[:47500]-#3-#46][TcpDiscoverySpi] TCP discovery accepted incoming connection [rmtAddr=/192.168.50.173, rmtPort=34619]
[15:00:20,081][INFO][tcp-disco-srvr-[:47500]-#3-#46][TcpDiscoverySpi] TCP discovery spawning a new thread for connection [rmtAddr=/192.168.50.173, rmtPort=34619]
[15:00:20,082][INFO][tcp-disco-sock-reader-[]-#1242-#9882][TcpDiscoverySpi] Started serving remote node connection [rmtAddr=/192.168.50.173:34619, rmtPort=34619]
[15:00:20,082][INFO][tcp-disco-sock-reader-[]-#1242-#9882][TcpDiscoverySpi] Received ping request from the remote node [rmtNodeId=d55c823a-e4a4-413a-9dd2-518fe7b34809, rmtAddr=/192.168.50.173:34619, rmtPort=34619]
[15:00:20,082][INFO][tcp-disco-sock-reader-[]-#1242-#9882][TcpDiscoverySpi] Finished writing ping response [rmtNodeId=d55c823a-e4a4-413a-9dd2-518fe7b34809, rmtAddr=/192.168.50.173:34619, rmtPort=34619]
[15:00:20,082][INFO][tcp-disco-sock-reader-[]-#1242-#9882][TcpDiscoverySpi] Finished serving remote node connection [rmtAddr=/192.168.50.173:34619, rmtPort=34619, rmtNodeId=null]