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\G;
*************************** 1. row ***************************
Query Plan: ================================================================================
*************************** 2. row ***************************
Query Plan: |ID|OPERATOR                                 |NAME       |EST.ROWS|EST.TIME(us)|
*************************** 3. row ***************************
Query Plan: --------------------------------------------------------------------------------
*************************** 4. row ***************************
Query Plan: |0 |PX COORDINATOR                           |           |17      |6082526     |
*************************** 5. row ***************************
Query Plan: |1 |└─EXCHANGE OUT DISTR                     |:EX10002   |17      |6082400     |
*************************** 6. row ***************************
Query Plan: |2 |  └─LIMIT                                |           |17      |6082115     |
*************************** 7. row ***************************
Query Plan: |3 |    └─NESTED-LOOP OUTER JOIN             |           |17      |6082115     |
*************************** 8. row ***************************
Query Plan: |4 |      ├─EXCHANGE IN DISTR                |           |17      |6081649     |
*************************** 9. row ***************************
Query Plan: |5 |      │ └─EXCHANGE OUT DISTR (BC2HOST)   |:EX10001   |17      |6081525     |
*************************** 10. row ***************************
Query Plan: |6 |      │   └─SUBPLAN SCAN                 |assepa     |17      |6081247     |
*************************** 11. row ***************************
Query Plan: |7 |      │     └─LIMIT                      |           |17      |6081247     |
*************************** 12. row ***************************
Query Plan: |8 |      │       └─TOP-N SORT               |           |17      |6081247     |
*************************** 13. row ***************************
Query Plan: |9 |      │         └─HASH RIGHT SEMI JOIN   |           |10141848|5667776     |
*************************** 14. row ***************************
Query Plan: |10|      │           ├─EXCHANGE IN DISTR    |           |64516   |38417       |
*************************** 15. row ***************************
Query Plan: |11|      │           │ └─EXCHANGE OUT DISTR |:EX10000   |64516   |28488       |
*************************** 16. row ***************************
Query Plan: |12|      │           │   └─SUBPLAN SCAN     |VIEW1      |64516   |6344        |
*************************** 17. row ***************************
Query Plan: |13|      │           │     └─TABLE FULL SCAN|port       |64516   |6173        |
*************************** 18. row ***************************
Query Plan: |14|      │           └─TABLE FULL SCAN      |assepa     |10141848|4457598     |
*************************** 19. row ***************************
Query Plan: |15|      └─TABLE GET                        |assea(nkey)|1       |27          |
*************************** 20. row ***************************
Query Plan: ================================================================================
*************************** 21. row ***************************
Query Plan: Outputs & filters:
*************************** 22. row ***************************
Query Plan: -------------------------------------
*************************** 23. row ***************************
Query Plan:   0 - output([INTERNAL_FUNCTION(assepa.port_type, assepa.process_user, assepa.online_state, assea.business_ids, assepa.product_version, assepa.id, assepa.uid,
*************************** 24. row ***************************
Query Plan:        assepa.port, assepa.first_time, assepa.inactivated, assepa.port, assepa.ip, assepa.host_ip, assepa.process_time, assepa.local_address, assepa.last_source_type,
*************************** 25. row ***************************
Query Plan:        assepa.ts, assepa.pid, assepa.ipv6, assepa.process, assepa.product, assepa.host_ipv6)]), filter(nil), rowset=256
*************************** 26. row ***************************
Query Plan:   1 - output([INTERNAL_FUNCTION(assepa.port_type, assepa.process_user, assepa.online_state, assea.business_ids, assepa.product_version, assepa.id, assepa.uid,
*************************** 27. row ***************************
Query Plan:        assepa.port, assepa.first_time, assepa.inactivated, assepa.port, assepa.ip, assepa.host_ip, assepa.process_time, assepa.local_address, assepa.last_source_type,
*************************** 28. row ***************************
Query Plan:        assepa.ts, assepa.pid, assepa.ipv6, assepa.process, assepa.product, assepa.host_ipv6)]), filter(nil), rowset=256
*************************** 29. row ***************************
Query Plan:       is_single, dop=1
*************************** 30. row ***************************
Query Plan:   2 - output([assepa.port], [assepa.uid], [assepa.id], [assepa.ts], [assepa.ip], [assepa.host_ip], [assepa.ipv6], [assepa.host_ipv6], [assepa.port_type],
*************************** 31. row ***************************
Query Plan:        [assepa.online_state], [assepa.first_time], [assepa.last_source_type], [assepa.product], [assepa.product_version], [assepa.process], [assepa.process_user],
*************************** 32. row ***************************
Query Plan:        [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated], [assea.business_ids]), filter(nil), rowset=256
*************************** 33. row ***************************
Query Plan:       limit(17), offset(0)
*************************** 34. row ***************************
Query Plan:   3 - output([assepa.port], [assepa.uid], [assepa.id], [assepa.ts], [assepa.ip], [assepa.host_ip], [assepa.ipv6], [assepa.host_ipv6], [assepa.port_type],
*************************** 35. row ***************************
Query Plan:        [assepa.online_state], [assepa.first_time], [assepa.last_source_type], [assepa.product], [assepa.product_version], [assepa.process], [assepa.process_user],
*************************** 36. row ***************************
Query Plan:        [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated], [assea.business_ids]), filter(nil), rowset=256
*************************** 37. row ***************************
Query Plan:       conds(nil), nl_params_([assepa.uid(:1)]), use_batch=true
*************************** 38. row ***************************
Query Plan:   4 - output([assepa.port], [assepa.uid], [assepa.id], [assepa.ts], [assepa.ip], [assepa.host_ip], [assepa.ipv6], [assepa.host_ipv6], [assepa.port_type],
*************************** 39. row ***************************
Query Plan:        [assepa.online_state], [assepa.first_time], [assepa.last_source_type], [assepa.product], [assepa.product_version], [assepa.process], [assepa.process_user],
*************************** 40. row ***************************
Query Plan:        [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated]), filter(nil), rowset=256
*************************** 41. row ***************************
Query Plan:   5 - output([assepa.port], [assepa.uid], [assepa.id], [assepa.ts], [assepa.ip], [assepa.host_ip], [assepa.ipv6], [assepa.host_ipv6], [assepa.port_type],
*************************** 42. row ***************************
Query Plan:        [assepa.online_state], [assepa.first_time], [assepa.last_source_type], [assepa.product], [assepa.product_version], [assepa.process], [assepa.process_user],
*************************** 43. row ***************************
Query Plan:        [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated]), filter(nil), rowset=256
*************************** 44. row ***************************
Query Plan:       is_single, dop=1
*************************** 45. row ***************************
Query Plan:   6 - output([assepa.id], [assepa.ts], [assepa.uid], [assepa.ip], [assepa.host_ip], [assepa.ipv6], [assepa.host_ipv6], [assepa.port], [assepa.port_type],
*************************** 46. row ***************************
Query Plan:        [assepa.online_state], [assepa.first_time], [assepa.last_source_type], [assepa.product], [assepa.product_version], [assepa.process], [assepa.process_user],
*************************** 47. row ***************************
Query Plan:        [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated]), filter(nil), rowset=256
*************************** 48. row ***************************
Query Plan:       access([assepa.id], [assepa.ts], [assepa.uid], [assepa.ip], [assepa.host_ip], [assepa.ipv6], [assepa.host_ipv6], [assepa.port], [assepa.port_type],
*************************** 49. row ***************************
Query Plan:        [assepa.online_state], [assepa.first_time], [assepa.last_source_type], [assepa.product], [assepa.product_version], [assepa.process], [assepa.process_user],
*************************** 50. row ***************************
Query Plan:        [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated])
*************************** 51. row ***************************
Query Plan:   7 - output([assepa.id], [assepa.ts], [assepa.uid], [assepa.ip], [assepa.host_ip], [assepa.ipv6], [assepa.host_ipv6], [assepa.port], [assepa.port_type],
*************************** 52. row ***************************
Query Plan:        [assepa.online_state], [assepa.first_time], [assepa.last_source_type], [assepa.product], [assepa.product_version], [assepa.process], [assepa.process_user],
*************************** 53. row ***************************
Query Plan:        [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated], [assepa.gc_sort_key]), filter(nil), rowset=256
*************************** 54. row ***************************
Query Plan:       limit(17), offset(0)
*************************** 55. row ***************************
Query Plan:   8 - output([assepa.id], [assepa.ts], [assepa.uid], [assepa.ip], [assepa.host_ip], [assepa.ipv6], [assepa.host_ipv6], [assepa.port], [assepa.port_type],
*************************** 56. row ***************************
Query Plan:        [assepa.online_state], [assepa.first_time], [assepa.last_source_type], [assepa.product], [assepa.product_version], [assepa.process], [assepa.process_user],
*************************** 57. row ***************************
Query Plan:        [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated], [assepa.gc_sort_key]), filter(nil), rowset=256
*************************** 58. row ***************************
Query Plan:       sort_keys([assepa.gc_sort_key, ASC], [assepa.id, ASC]), topn(17 + 0)
*************************** 59. row ***************************
Query Plan:   9 - output([assepa.id], [assepa.ts], [assepa.uid], [assepa.ip], [assepa.host_ip], [assepa.ipv6], [assepa.host_ipv6], [assepa.port], [assepa.port_type],
*************************** 60. row ***************************
Query Plan:        [assepa.online_state], [assepa.first_time], [assepa.last_source_type], [assepa.product], [assepa.product_version], [assepa.process], [assepa.process_user],
*************************** 61. row ***************************
Query Plan:        [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated], [assepa.gc_sort_key]), filter(nil), rowset=256
*************************** 62. row ***************************
Query Plan:       equal_conds([assepa.port = VIEW1.PORT]), other_conds(nil)
*************************** 63. row ***************************
Query Plan:  10 - output([VIEW1.PORT]), filter(nil), rowset=256
*************************** 64. row ***************************
Query Plan:  11 - output([VIEW1.PORT]), filter(nil), rowset=256
*************************** 65. row ***************************
Query Plan:       is_single, dop=1
*************************** 66. row ***************************
Query Plan:  12 - output([VIEW1.PORT]), filter(nil), rowset=256
*************************** 67. row ***************************
Query Plan:       access([VIEW1.PORT])
*************************** 68. row ***************************
Query Plan:  13 - output([port.port]), filter([port.severity = 3]), rowset=256
*************************** 69. row ***************************
Query Plan:       access([port.severity], [port.port]), partitions(p0)
*************************** 70. row ***************************
Query Plan:       is_index_back=false, is_global_index=false, filter_before_indexback[false], 
*************************** 71. row ***************************
Query Plan:       range_key([port.id], [port.ts]), range(MIN,MIN ; MAX,MAX)always true
*************************** 72. row ***************************
Query Plan:  14 - output([assepa.id], [assepa.ts], [assepa.online_state], [assepa.process], [assepa.product], [assepa.product_version], [assepa.gc_sort_key], [assepa.port],
*************************** 73. row ***************************
Query Plan:        [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],
*************************** 74. row ***************************
Query Plan:        [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated]), filter([assepa.ts = 1], [assepa.ip_long >= 0]), rowset=256
*************************** 75. row ***************************
Query Plan:       access([assepa.id], [assepa.ts], [assepa.online_state], [assepa.process], [assepa.product], [assepa.product_version], [assepa.gc_sort_key], [assepa.port],
*************************** 76. row ***************************
Query Plan:        [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],
*************************** 77. row ***************************
Query Plan:        [assepa.process_user], [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated]), partitions(p0)
*************************** 78. row ***************************
Query Plan:       is_index_back=false, is_global_index=false, filter_before_indexback[false,false], 
*************************** 79. row ***************************
Query Plan:       range_key([assepa.id], [assepa.ts]), range(MIN,MIN ; MAX,MAX)always true
*************************** 80. row ***************************
Query Plan:  15 - output([assea.business_ids]), filter(nil), rowset=256
*************************** 81. row ***************************
Query Plan:       access([GROUP_ID], [assea.id], [assea.ts], [assea.business_ids]), partitions(p0)
*************************** 82. row ***************************
Query Plan:       is_index_back=true, is_global_index=false, 
*************************** 83. row ***************************
Query Plan:       range_key([assea.ts], [assea.uid], [assea.shadow_pk_0], [assea.shadow_pk_1]), range(MIN ; MAX), 
*************************** 84. row ***************************
Query Plan:       range_cond([assea.ts = 1], [assea.uid = :1])
84 rows in set, 1 warning (0.032 sec)

ERROR: No query specified