I upgraded my dev server this morning from 6.0 to 6.5 on a Ubuntu 16 server. The upgrade went fine but the performance is horrible. Query’s that took ms now take a long time. I have an Index on _type and when i go and run the query from the web gui it takes forever
the simple test query is
select meta().id, name from Contacts where _type = "tract_info"
Below is the Plan Text Output, Is there anything i need to change ?
> {
> "#operator": "Sequence",
> "#stats": {
> "#phaseSwitches": 1,
> "execTime": "5.479µs"
> },
> "~children": [
> {
> "#operator": "Authorize",
> "#stats": {
> "#phaseSwitches": 3,
> "execTime": "6.543µs",
> "servTime": "2.588892ms"
> },
> "privileges": {
> "List": [
> {
> "Target": "default:Contacts",
> "Priv": 7
> }
> ]
> },
> "~child": {
> "#operator": "Sequence",
> "#stats": {
> "#phaseSwitches": 1,
> "execTime": "6.324µs"
> },
> "~children": [
> {
> "#operator": "IndexScan3",
> "#stats": {
> "#itemsOut": 13,
> "#phaseSwitches": 55,
> "execTime": "54.786µs",
> "kernTime": "7.477µs",
> "servTime": "1.186231ms"
> },
> "index": "Ottoman__type",
> "index_id": "f9d810b05a296595",
> "index_projection": {
> "primary_key": true
> },
> "keyspace": "Contacts",
> "namespace": "default",
> "spans": [
> {
> "exact": true,
> "range": [
> {
> "high": "\"tract_info\"",
> "inclusion": 3,
> "low": "\"tract_info\""
> }
> ]
> }
> ],
> "using": "gsi",
> "#time_normal": "00:00.001",
> "#time_absolute": 0.001241017
> },
> {
> "#operator": "Fetch",
> "#stats": {
> "#itemsIn": 13,
> "#itemsOut": 13,
> "#phaseSwitches": 57,
> "execTime": "73.358µs",
> "kernTime": "1.276431ms",
> "servTime": "19.471677798s"
> },
> "keyspace": "Contacts",
> "namespace": "default",
> "#time_normal": "00:19.471",
> "#time_absolute": 19.471751156000003
> },
> {
> "#operator": "Sequence",
> "#stats": {
> "#phaseSwitches": 1,
> "execTime": "2.984µs"
> },
> "~children": [
> {
> "#operator": "Filter",
> "#stats": {
> "#itemsIn": 13,
> "#itemsOut": 13,
> "#phaseSwitches": 55,
> "execTime": "246.846µs",
> "kernTime": "19.473074896s"
> },
> "condition": "((`Contacts`.`_type`) = \"tract_info\")",
> "#time_normal": "00:00.000",
> "#time_absolute": 0.000246846
> },
> {
> "#operator": "InitialProject",
> "#stats": {
> "#itemsIn": 13,
> "#itemsOut": 13,
> "#phaseSwitches": 44,
> "execTime": "269.816µs",
> "kernTime": "19.473298398s"
> },
> "result_terms": [
> {
> "expr": "(meta(`Contacts`).`id`)"
> },
> {
> "expr": "(`Contacts`.`name`)"
> }
> ],
> "#time_normal": "00:00.000",
> "#time_absolute": 0.000269816
> },
> {
> "#operator": "FinalProject",
> "#stats": {
> "#itemsIn": 13,
> "#itemsOut": 13,
> "#phaseSwitches": 40,
> "execTime": "21µs",
> "kernTime": "213.444µs"
> },
> "#time_normal": "00:00",
> "#time_absolute": 0
> }
> ],
> "#time_normal": "00:00.000",
> "#time_absolute": 0.000002984
> }
> ],
> "#time_normal": "00:00.000",
> "#time_absolute": 0.000006324
> },
> "#time_normal": "00:00.002",
> "#time_absolute": 0.0025954349999999997
> },
> {
> "#operator": "Stream",
> "#stats": {
> "#itemsIn": 13,
> "#itemsOut": 13,
> "#phaseSwitches": 29,
> "execTime": "196.155µs",
> "kernTime": "19.476264514s"
> },
> "#time_normal": "00:00.000",
> "#time_absolute": 0.000196155
> }
> ],
> "~versions": [
> "2.0.0-N1QL",
> "6.5.0-4960-enterprise"
> ],
> "#time_normal": "00:00.000",
> "#time_absolute": 0.000005479
> }