obclient(root@nwtestsys)[hhit_asset]> EXPLAIN -> SELECT assepa.port_type,assepa.process_user,assepa.online_state AS online_state,assea.business_ids AS business_name,assepa.product_version,assepa.id,assepa.uid,assepa.port,assepa.first_time,assepa.inactivated AS deactive_status,assepa.port AS port_severity,assepa.ip,assepa.host_ip,assepa.process_time,assepa.local_address,assepa.last_source_type,assepa.ts,assepa.pid,assepa.ipv6,assepa.process,assepa.product,assepa.host_ipv6 FROM ( SELECT * FROM hhit_asset_port AS assepa WHERE (assepa.ts = 1) AND assepa.port IN(SELECT PORT FROM hhit_port port WHERE port.severity in(3) ) AND assepa.ts IN(1) AND ( assepa.ip_long >= 0 ) GROUP BY assepa.ts,assepa.uid,assepa.port ORDER BY gc_sort_key,id LIMIT 0,17 ) AS assepa LEFT JOIN hhit_asset AS assea ON assea.ts = assepa.ts AND assea.uid = assepa.uid GROUP BY assepa.ts,assepa.uid,assepa.port ORDER BY gc_sort_key,id LIMIT 0,17; +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Query Plan | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | ================================================================================ | | |ID|OPERATOR |NAME |EST.ROWS|EST.TIME(us)| | | -------------------------------------------------------------------------------- | | |0 |PX COORDINATOR | |17 |6071181 | | | |1 |└─EXCHANGE OUT DISTR |:EX10002 |17 |6071054 | | | |2 | └─LIMIT | |17 |6070769 | | | |3 | └─NESTED-LOOP OUTER JOIN | |17 |6070769 | | | |4 | ├─EXCHANGE IN DISTR | |17 |6070303 | | | |5 | │ └─EXCHANGE OUT DISTR (BC2HOST) |:EX10001 |17 |6070180 | | | |6 | │ └─SUBPLAN SCAN |assepa |17 |6069901 | | | |7 | │ └─LIMIT | |17 |6069901 | | | |8 | │ └─TOP-N SORT | |17 |6069901 | | | |9 | │ └─HASH RIGHT SEMI JOIN | |10141848|5656430 | | | |10| │ ├─EXCHANGE IN DISTR | |64516 |38417 | | | |11| │ │ └─EXCHANGE OUT DISTR |:EX10000 |64516 |28488 | | | |12| │ │ └─SUBPLAN SCAN |VIEW1 |64516 |6344 | | | |13| │ │ └─TABLE FULL SCAN|port |64516 |6173 | | | |14| │ └─TABLE FULL SCAN |assepa |10141848|4446253 | | | |15| └─TABLE GET |assea(nkey)|1 |27 | | | ================================================================================ | | Outputs & filters: | | ------------------------------------- | | 0 - output([INTERNAL_FUNCTION(assepa.port_type, assepa.process_user, assepa.online_state, assea.business_ids, assepa.product_version, assepa.id, assepa.uid, | | assepa.port, assepa.first_time, assepa.inactivated, assepa.port, assepa.ip, assepa.host_ip, assepa.process_time, assepa.local_address, assepa.last_source_type, | | assepa.ts, assepa.pid, assepa.ipv6, assepa.process, assepa.product, assepa.host_ipv6)]), filter(nil), rowset=256 | | 1 - output([INTERNAL_FUNCTION(assepa.port_type, assepa.process_user, assepa.online_state, assea.business_ids, assepa.product_version, assepa.id, assepa.uid, | | assepa.port, assepa.first_time, assepa.inactivated, assepa.port, assepa.ip, assepa.host_ip, assepa.process_time, assepa.local_address, assepa.last_source_type, | | assepa.ts, assepa.pid, assepa.ipv6, assepa.process, assepa.product, assepa.host_ipv6)]), filter(nil), rowset=256 | | is_single, dop=1 | | 2 - output([assepa.port], [assepa.uid], [assepa.id], [assepa.ts], [assepa.ip], [assepa.host_ip], [assepa.ipv6], [assepa.host_ipv6], [assepa.port_type], | | [assepa.online_state], [assepa.first_time], [assepa.last_source_type], [assepa.product], [assepa.product_version], [assepa.process], [assepa.process_user], | | [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated], [assea.business_ids]), filter(nil), rowset=256 | | limit(17), offset(0) | | 3 - output([assepa.port], [assepa.uid], [assepa.id], [assepa.ts], [assepa.ip], [assepa.host_ip], [assepa.ipv6], [assepa.host_ipv6], [assepa.port_type], | | [assepa.online_state], [assepa.first_time], [assepa.last_source_type], [assepa.product], [assepa.product_version], [assepa.process], [assepa.process_user], | | [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated], [assea.business_ids]), filter(nil), rowset=256 | | conds(nil), nl_params_([assepa.uid(:1)]), use_batch=true | | 4 - output([assepa.port], [assepa.uid], [assepa.id], [assepa.ts], [assepa.ip], [assepa.host_ip], [assepa.ipv6], [assepa.host_ipv6], [assepa.port_type], | | [assepa.online_state], [assepa.first_time], [assepa.last_source_type], [assepa.product], [assepa.product_version], [assepa.process], [assepa.process_user], | | [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated]), filter(nil), rowset=256 | | 5 - output([assepa.port], [assepa.uid], [assepa.id], [assepa.ts], [assepa.ip], [assepa.host_ip], [assepa.ipv6], [assepa.host_ipv6], [assepa.port_type], | | [assepa.online_state], [assepa.first_time], [assepa.last_source_type], [assepa.product], [assepa.product_version], [assepa.process], [assepa.process_user], | | [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated]), filter(nil), rowset=256 | | is_single, dop=1 | | 6 - output([assepa.id], [assepa.ts], [assepa.uid], [assepa.ip], [assepa.host_ip], [assepa.ipv6], [assepa.host_ipv6], [assepa.port], [assepa.port_type], | | [assepa.online_state], [assepa.first_time], [assepa.last_source_type], [assepa.product], [assepa.product_version], [assepa.process], [assepa.process_user], | | [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated]), filter(nil), rowset=256 | | access([assepa.id], [assepa.ts], [assepa.uid], [assepa.ip], [assepa.host_ip], [assepa.ipv6], [assepa.host_ipv6], [assepa.port], [assepa.port_type], | | [assepa.online_state], [assepa.first_time], [assepa.last_source_type], [assepa.product], [assepa.product_version], [assepa.process], [assepa.process_user], | | [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated]) | | 7 - output([assepa.id], [assepa.ts], [assepa.uid], [assepa.ip], [assepa.host_ip], [assepa.ipv6], [assepa.host_ipv6], [assepa.port], [assepa.port_type], | | [assepa.online_state], [assepa.first_time], [assepa.last_source_type], [assepa.product], [assepa.product_version], [assepa.process], [assepa.process_user], | | [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated], [assepa.gc_sort_key]), filter(nil), rowset=256 | | limit(17), offset(0) | | 8 - output([assepa.id], [assepa.ts], [assepa.uid], [assepa.ip], [assepa.host_ip], [assepa.ipv6], [assepa.host_ipv6], [assepa.port], [assepa.port_type], | | [assepa.online_state], [assepa.first_time], [assepa.last_source_type], [assepa.product], [assepa.product_version], [assepa.process], [assepa.process_user], | | [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated], [assepa.gc_sort_key]), filter(nil), rowset=256 | | sort_keys([assepa.gc_sort_key, ASC], [assepa.id, ASC]), topn(17 + 0) | | 9 - output([assepa.id], [assepa.ts], [assepa.uid], [assepa.ip], [assepa.host_ip], [assepa.ipv6], [assepa.host_ipv6], [assepa.port], [assepa.port_type], | | [assepa.online_state], [assepa.first_time], [assepa.last_source_type], [assepa.product], [assepa.product_version], [assepa.process], [assepa.process_user], | | [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated], [assepa.gc_sort_key]), filter(nil), rowset=256 | | equal_conds([assepa.port = VIEW1.PORT]), other_conds(nil) | | 10 - output([VIEW1.PORT]), filter(nil), rowset=256 | | 11 - output([VIEW1.PORT]), filter(nil), rowset=256 | | is_single, dop=1 | | 12 - output([VIEW1.PORT]), filter(nil), rowset=256 | | access([VIEW1.PORT]) | | 13 - output([port.port]), filter([port.severity = 3]), rowset=256 | | access([port.severity], [port.port]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([port.id], [port.ts]), range(MIN,MIN ; MAX,MAX)always true | | 14 - output([assepa.id], [assepa.ts], [assepa.online_state], [assepa.process], [assepa.product], [assepa.product_version], [assepa.gc_sort_key], [assepa.port], | | [assepa.uid], [assepa.ip], [assepa.host_ip], [assepa.ipv6], [assepa.host_ipv6], [assepa.port_type], [assepa.first_time], [assepa.last_source_type], [assepa.process_user], | | [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated]), filter([assepa.ts = 1], [assepa.ip_long >= 0]), rowset=256 | | access([assepa.id], [assepa.ts], [assepa.online_state], [assepa.process], [assepa.product], [assepa.product_version], [assepa.gc_sort_key], [assepa.port], | | [assepa.ip_long], [assepa.uid], [assepa.ip], [assepa.host_ip], [assepa.ipv6], [assepa.host_ipv6], [assepa.port_type], [assepa.first_time], [assepa.last_source_type], | | [assepa.process_user], [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false,false], | | range_key([assepa.id], [assepa.ts]), range(MIN,MIN ; MAX,MAX)always true | | 15 - output([assea.business_ids]), filter(nil), rowset=256 | | access([GROUP_ID], [assea.id], [assea.ts], [assea.business_ids]), partitions(p0) | | is_index_back=true, is_global_index=false, | | range_key([assea.ts], [assea.uid], [assea.shadow_pk_0], [assea.shadow_pk_1]), range(MIN ; MAX), | | range_cond([assea.ts = 1], [assea.uid = :1]) | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 84 rows in set, 1 warning (0.042 sec)