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 |LIMIT                                         |                |17      |80093964    |
*************************** 5. row ***************************
Query Plan: |1 |└─NESTED-LOOP OUTER JOIN                      |                |17      |80093964    |
*************************** 6. row ***************************
Query Plan: |2 |  ├─PX COORDINATOR                            |                |17      |80093499    |
*************************** 7. row ***************************
Query Plan: |3 |  │ └─EXCHANGE OUT DISTR                      |:EX10001        |17      |80093375    |
*************************** 8. row ***************************
Query Plan: |4 |  │   └─SUBPLAN SCAN                          |assepa          |17      |80093097    |
*************************** 9. row ***************************
Query Plan: |5 |  │     └─LIMIT                               |                |17      |80093096    |
*************************** 10. row ***************************
Query Plan: |6 |  │       └─TOP-N SORT                        |                |17      |80093096    |
*************************** 11. row ***************************
Query Plan: |7 |  │         └─NESTED-LOOP JOIN                |                |10418982|79668327    |
*************************** 12. row ***************************
Query Plan: |8 |  │           ├─EXCHANGE IN DISTR             |                |62606   |55665       |
*************************** 13. row ***************************
Query Plan: |9 |  │           │ └─EXCHANGE OUT DISTR (BC2HOST)|:EX10000        |62606   |46030       |
*************************** 14. row ***************************
Query Plan: |10|  │           │   └─SUBPLAN SCAN              |VIEW2           |62606   |24542       |
*************************** 15. row ***************************
Query Plan: |11|  │           │     └─HASH DISTINCT           |                |62606   |24376       |
*************************** 16. row ***************************
Query Plan: |12|  │           │       └─TABLE FULL SCAN       |port            |64516   |6173        |
*************************** 17. row ***************************
Query Plan: |13|  │           └─TABLE RANGE SCAN              |assepa(port_key)|198     |1266        |
*************************** 18. row ***************************
Query Plan: |14|  └─TABLE GET                                 |assea(nkey)     |1       |27          |
*************************** 19. row ***************************
Query Plan: ==========================================================================================
*************************** 20. row ***************************
Query Plan: Outputs & filters:
*************************** 21. row ***************************
Query Plan: -------------------------------------
*************************** 22. row ***************************
Query Plan:   0 - output([assepa.port_type], [assepa.process_user], [assepa.online_state], [assea.business_ids], [assepa.product_version], [assepa.id], [assepa.uid],
*************************** 23. row ***************************
Query Plan:        [assepa.port], [assepa.first_time], [assepa.inactivated], [assepa.port], [assepa.ip], [assepa.host_ip], [assepa.process_time], [assepa.local_address], 
*************************** 24. row ***************************
Query Plan:       [assepa.last_source_type], [assepa.ts], [assepa.pid], [assepa.ipv6], [assepa.process], [assepa.product], [assepa.host_ipv6]), filter(nil), rowset=256
*************************** 25. row ***************************
Query Plan:       limit(17), offset(0)
*************************** 26. row ***************************
Query Plan:   1 - output([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.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:       conds(nil), nl_params_([assepa.uid(:2)]), use_batch=true
*************************** 30. row ***************************
Query Plan:   2 - output([assepa.port_type], [assepa.process_user], [assepa.online_state], [assepa.product_version], [assepa.id], [assepa.uid], [assepa.port], [assepa.first_time],
*************************** 31. row ***************************
Query Plan:        [assepa.inactivated], [assepa.ip], [assepa.host_ip], [assepa.process_time], [assepa.local_address], [assepa.last_source_type], [assepa.ts], [assepa.pid],
*************************** 32. row ***************************
Query Plan:        [assepa.ipv6], [assepa.process], [assepa.product], [assepa.host_ipv6]), filter(nil), rowset=256
*************************** 33. row ***************************
Query Plan:   3 - output([assepa.port_type], [assepa.process_user], [assepa.online_state], [assepa.product_version], [assepa.id], [assepa.uid], [assepa.port], [assepa.first_time],
*************************** 34. row ***************************
Query Plan:        [assepa.inactivated], [assepa.ip], [assepa.host_ip], [assepa.process_time], [assepa.local_address], [assepa.last_source_type], [assepa.ts], [assepa.pid],
*************************** 35. row ***************************
Query Plan:        [assepa.ipv6], [assepa.process], [assepa.product], [assepa.host_ipv6]), filter(nil), rowset=256
*************************** 36. row ***************************
Query Plan:       is_single, dop=1
*************************** 37. row ***************************
Query Plan:   4 - output([assepa.id], [assepa.ts], [assepa.uid], [assepa.ip], [assepa.host_ip], [assepa.ipv6], [assepa.host_ipv6], [assepa.port], [assepa.port_type],
*************************** 38. row ***************************
Query Plan:        [assepa.online_state], [assepa.first_time], [assepa.last_source_type], [assepa.product], [assepa.product_version], [assepa.process], [assepa.process_user],
*************************** 39. row ***************************
Query Plan:        [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated]), filter(nil), rowset=256
*************************** 40. 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],
*************************** 41. row ***************************
Query Plan:        [assepa.online_state], [assepa.first_time], [assepa.last_source_type], [assepa.product], [assepa.product_version], [assepa.process], [assepa.process_user],
*************************** 42. row ***************************
Query Plan:        [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated])
*************************** 43. row ***************************
Query Plan:   5 - output([assepa.id], [assepa.ts], [assepa.uid], [assepa.ip], [assepa.host_ip], [assepa.ipv6], [assepa.host_ipv6], [assepa.port], [assepa.port_type],
*************************** 44. row ***************************
Query Plan:        [assepa.online_state], [assepa.first_time], [assepa.last_source_type], [assepa.product], [assepa.product_version], [assepa.process], [assepa.process_user],
*************************** 45. row ***************************
Query Plan:        [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated], [assepa.gc_sort_key]), filter(nil), rowset=256
*************************** 46. row ***************************
Query Plan:       limit(17), offset(0)
*************************** 47. 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],
*************************** 48. row ***************************
Query Plan:        [assepa.online_state], [assepa.first_time], [assepa.last_source_type], [assepa.product], [assepa.product_version], [assepa.process], [assepa.process_user],
*************************** 49. row ***************************
Query Plan:        [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated], [assepa.gc_sort_key]), filter(nil), rowset=256
*************************** 50. row ***************************
Query Plan:       sort_keys([assepa.gc_sort_key, ASC], [assepa.id, ASC]), topn(17 + 0)
*************************** 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:       conds(nil), nl_params_([VIEW2.VIEW1.PORT(:1)]), use_batch=true
*************************** 55. row ***************************
Query Plan:   8 - output([VIEW2.VIEW1.PORT]), filter(nil), rowset=256
*************************** 56. row ***************************
Query Plan:   9 - output([VIEW2.VIEW1.PORT]), filter(nil), rowset=256
*************************** 57. row ***************************
Query Plan:       is_single, dop=1
*************************** 58. row ***************************
Query Plan:  10 - output([VIEW2.VIEW1.PORT]), filter(nil), rowset=256
*************************** 59. row ***************************
Query Plan:       access([VIEW2.VIEW1.PORT])
*************************** 60. row ***************************
Query Plan:  11 - output([port.port]), filter(nil), rowset=256
*************************** 61. row ***************************
Query Plan:       distinct([port.port])
*************************** 62. row ***************************
Query Plan:  12 - output([port.port]), filter([port.severity = 3]), rowset=256
*************************** 63. row ***************************
Query Plan:       access([port.severity], [port.port]), partitions(p0)
*************************** 64. row ***************************
Query Plan:       is_index_back=false, is_global_index=false, filter_before_indexback[false], 
*************************** 65. row ***************************
Query Plan:       range_key([port.id], [port.ts]), range(MIN,MIN ; MAX,MAX)always true
*************************** 66. row ***************************
Query Plan:  13 - output([assepa.id], [assepa.ts], [assepa.online_state], [assepa.process], [assepa.product], [assepa.product_version], [assepa.gc_sort_key], [assepa.port],
*************************** 67. 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],
*************************** 68. row ***************************
Query Plan:        [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated]), filter([assepa.ts = 1], [assepa.ip_long >= 0]), rowset=256
*************************** 69. row ***************************
Query Plan:       access([GROUP_ID], [assepa.id], [assepa.ts], [assepa.online_state], [assepa.process], [assepa.product], [assepa.product_version], [assepa.gc_sort_key],
*************************** 70. row ***************************
Query Plan:        [assepa.port], [assepa.ip_long], [assepa.uid], [assepa.ip], [assepa.host_ip], [assepa.ipv6], [assepa.host_ipv6], [assepa.port_type], [assepa.first_time],
*************************** 71. row ***************************
Query Plan:        [assepa.last_source_type], [assepa.process_user], [assepa.process_time], [assepa.local_address], [assepa.pid], [assepa.inactivated]), partitions(p0)
*************************** 72. row ***************************
Query Plan:       is_index_back=true, is_global_index=false, filter_before_indexback[true,false], 
*************************** 73. row ***************************
Query Plan:       range_key([assepa.port], [assepa.id], [assepa.ts]), range(MIN ; MAX), 
*************************** 74. row ***************************
Query Plan:       range_cond([assepa.port = :1])
*************************** 75. row ***************************
Query Plan:  14 - output([assea.business_ids]), filter(nil), rowset=256
*************************** 76. row ***************************
Query Plan:       access([GROUP_ID], [assea.id], [assea.ts], [assea.business_ids]), partitions(p0)
*************************** 77. row ***************************
Query Plan:       is_index_back=true, is_global_index=false, 
*************************** 78. row ***************************
Query Plan:       range_key([assea.ts], [assea.uid], [assea.shadow_pk_0], [assea.shadow_pk_1]), range(MIN ; MAX), 
*************************** 79. row ***************************
Query Plan:       range_cond([assea.ts = 1], [assea.uid = :2])
79 rows in set, 1 warning (0.063 sec)

ERROR: No query specified