Starting test...
Creating bucket...
Running explain with params...
[{u'plan': {u'#operator': u'Sequence',
            u'~children': [{u'#operator': u'Sequence',
                            u'~children': [{u'#operator': u'IndexScan',
                                            u'index': u'def_type',
                                            u'index_id': u'6cbffc81adaaf05',
                                            u'keyspace': u'travel-sample',
                                            u'namespace': u'default',
                                            u'spans': [{u'Range': {u'Inclusion': 0,
                                                                   u'Low': [u'null']}}],
                                            u'using': u'gsi'},
                                           {u'#operator': u'Fetch',
                                            u'keyspace': u'travel-sample',
                                            u'namespace': u'default'},
                                           {u'#operator': u'Parallel',
                                            u'~child': {u'#operator': u'Sequence',
                                                        u'~children': [{u'#operator': u'Filter',
                                                                        u'condition': u'((`travel-sample`.`type`) in $type)'},
                                                                       {u'#operator': u'InitialProject',
                                                                        u'result_terms': [{u'expr': u'(`travel-sample`.`id`)'},
                                                                                          {u'expr': u'(`travel-sample`.`type`)'}]}]}}]},
                           {u'#operator': u'Order',
                            u'limit': u'5',
                            u'sort_terms': [{u'expr': u'(`travel-sample`.`type`)'},
                                            {u'expr': u'(`travel-sample`.`id`)'}]},
                           {u'#operator': u'Limit', u'expr': u'5'},
                           {u'#operator': u'FinalProject'}]},
  u'text': u'\n    SELECT `id`, `type`\n    FROM `travel-sample` \n    WHERE `type` in $type\n    ORDER BY `type`, `id`\n    LIMIT 5'}]
None
Running explain no params...
[{u'plan': {u'#operator': u'Sequence',
            u'~children': [{u'#operator': u'Sequence',
                            u'~children': [{u'#operator': u'IndexScan',
                                            u'index': u'def_type',
                                            u'index_id': u'6cbffc81adaaf05',
                                            u'keyspace': u'travel-sample',
                                            u'namespace': u'default',
                                            u'spans': [{u'Range': {u'High': [u'"airline"'],
                                                                   u'Inclusion': 3,
                                                                   u'Low': [u'"airline"']}},
                                                       {u'Range': {u'High': [u'"airport"'],
                                                                   u'Inclusion': 3,
                                                                   u'Low': [u'"airport"']}},
                                                       {u'Range': {u'High': [u'"landmark"'],
                                                                   u'Inclusion': 3,
                                                                   u'Low': [u'"landmark"']}}],
                                            u'using': u'gsi'},
                                           {u'#operator': u'Fetch',
                                            u'keyspace': u'travel-sample',
                                            u'namespace': u'default'},
                                           {u'#operator': u'Parallel',
                                            u'~child': {u'#operator': u'Sequence',
                                                        u'~children': [{u'#operator': u'Filter',
                                                                        u'condition': u'((`travel-sample`.`type`) in ["airline", "airport", "landmark"])'},
                                                                       {u'#operator': u'InitialProject',
                                                                        u'result_terms': [{u'expr': u'(`travel-sample`.`id`)'},
                                                                                          {u'expr': u'(`travel-sample`.`type`)'}]}]}}]},
                           {u'#operator': u'Order',
                            u'limit': u'5',
                            u'sort_terms': [{u'expr': u'(`travel-sample`.`type`)'},
                                            {u'expr': u'(`travel-sample`.`id`)'}]},
                           {u'#operator': u'Limit', u'expr': u'5'},
                           {u'#operator': u'FinalProject'}]},
  u'text': u"\n    SELECT `id`, `type`\n    FROM `travel-sample` \n    WHERE `type` in ['airline', 'airport', 'landmark']\n    ORDER BY `type`, `id`\n    LIMIT 5"}]
None
Running query with params... 2017-08-16 19:49:17.701419
Fetching results... 2017-08-16 19:49:17.701470
Results:[{u'id': 10, u'type': u'airline'},
 {u'id': 21, u'type': u'airline'},
 {u'id': 22, u'type': u'airline'},
 {u'id': 24, u'type': u'airline'},
 {u'id': 35, u'type': u'airline'}]
None
Fetched 2017-08-16 19:49:19.507430
{u'metrics': {u'elapsedTime': u'1.804939577s',
              u'executionTime': u'1.804913832s',
              u'resultCount': 5,
              u'resultSize': 315,
              u'sortCount': 6650},
 u'requestID': u'6ce71420-b041-479f-ab74-85f096d18bee',
 u'results': [],
 u'signature': {u'id': u'json', u'type': u'json'},
 u'status': u'success'}
None
Time spent with params: 1.804939577s
Running query no params... 2017-08-16 19:49:19.507661
Fetching results... 2017-08-16 19:49:19.507683
Results:[{u'id': 10, u'type': u'airline'},
 {u'id': 21, u'type': u'airline'},
 {u'id': 22, u'type': u'airline'},
 {u'id': 24, u'type': u'airline'},
 {u'id': 35, u'type': u'airline'}]
None
Fetched 2017-08-16 19:49:19.881501
{u'metrics': {u'elapsedTime': u'372.65769ms',
              u'executionTime': u'372.617153ms',
              u'resultCount': 5,
              u'resultSize': 315,
              u'sortCount': 6650},
 u'requestID': u'ff63275d-890a-442d-a746-7b21a732a04f',
 u'results': [],
 u'signature': {u'id': u'json', u'type': u'json'},
 u'status': u'success'}
None
Time spent no params: 372.65769ms
End of test