profile

{
    "id": {
        "part1": 2966802236110337000,
        "part2": -8870719091038307000
    },
    "type": 1,
    "start": 1456721174006,
    "end": 1456721201151,
    "query": "select * from Premise_XBuilding, Premise_XProperty where Premise_XBuilding.PID = Premise_XProperty.Did",
    "plan": "00-00    Screen : rowType = RecordType(ANY *, ANY *0): rowcount = 5.0, cumulative cost = {14.5 rows, 90.5 cpu, 0.0 io, 0.0 network, 35.2 memory}, id = 820\n00-01      ProjectAllowDup(*=[$0], *0=[$1]) : rowType = RecordType(ANY *, ANY *0): rowcount = 5.0, cumulative cost = {14.0 rows, 90.0 cpu, 0.0 io, 0.0 network, 35.2 memory}, id = 819\n00-02        Project(T0¦¦*=[$0], T1¦¦*=[$2]) : rowType = RecordType(ANY T0¦¦*, ANY T1¦¦*): rowcount = 5.0, cumulative cost = {14.0 rows, 90.0 cpu, 0.0 io, 0.0 network, 35.2 memory}, id = 818\n00-03          HashJoin(condition=[=($1, $3)], joinType=[inner]) : rowType = RecordType(ANY T0¦¦*, ANY PID, ANY T1¦¦*, ANY Did): rowcount = 5.0, cumulative cost = {14.0 rows, 90.0 cpu, 0.0 io, 0.0 network, 35.2 memory}, id = 817\n00-05            Project(T0¦¦*=[$0], PID=[$1]) : rowType = RecordType(ANY T0¦¦*, ANY PID): rowcount = 5.0, cumulative cost = {5.0 rows, 10.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 814\n00-07              Scan(groupscan=[MongoGroupScan [MongoScanSpec=MongoScanSpec [dbName=Apptudio, collectionName=Premise_XBuilding, filters=null], columns=[`*`]]]) : rowType = (DrillRecordRow[*, PID]): rowcount = 5.0, cumulative cost = {5.0 rows, 10.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 813\n00-04            Project(T1¦¦*=[$0], Did=[$1]) : rowType = RecordType(ANY T1¦¦*, ANY Did): rowcount = 2.0, cumulative cost = {2.0 rows, 4.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 816\n00-06              Scan(groupscan=[MongoGroupScan [MongoScanSpec=MongoScanSpec [dbName=Apptudio, collectionName=Premise_XProperty, filters=null], columns=[`*`]]]) : rowType = (DrillRecordRow[*, Did]): rowcount = 2.0, cumulative cost = {2.0 rows, 4.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 815\n",
    "foreman": {
        "address": "localhost",
        "userPort": 31010,
        "controlPort": 31011,
        "dataPort": 31012
    },
    "state": 2,
    "totalFragments": 1,
    "finishedFragments": 0,
    "fragmentProfile": [
        {
            "majorFragmentId": 0,
            "minorFragmentProfile": [
                {
                    "state": 3,
                    "minorFragmentId": 0,
                    "operatorProfile": [
                        {
                            "inputProfile": [
                                {
                                    "records": 5,
                                    "batches": 1,
                                    "schemas": 1
                                }
                            ],
                            "operatorId": 7,
                            "operatorType": 1009,
                            "setupNanos": 0,
                            "processNanos": 381093081,
                            "peakLocalMemoryAllocated": 532480,
                            "waitNanos": 0
                        },
                        {
                            "inputProfile": [
                                {
                                    "records": 5,
                                    "batches": 1,
                                    "schemas": 1
                                }
                            ],
                            "operatorId": 5,
                            "operatorType": 10,
                            "setupNanos": 120780647,
                            "processNanos": 1192086,
                            "peakLocalMemoryAllocated": 585728,
                            "waitNanos": 0
                        },
                        {
                            "inputProfile": [
                                {
                                    "records": 2,
                                    "batches": 1,
                                    "schemas": 1
                                }
                            ],
                            "operatorId": 6,
                            "operatorType": 1009,
                            "setupNanos": 0,
                            "processNanos": 284432524,
                            "peakLocalMemoryAllocated": 479232,
                            "waitNanos": 0
                        },
                        {
                            "inputProfile": [
                                {
                                    "records": 2,
                                    "batches": 1,
                                    "schemas": 1
                                }
                            ],
                            "operatorId": 4,
                            "operatorType": 10,
                            "setupNanos": 47460450,
                            "processNanos": 1056445,
                            "peakLocalMemoryAllocated": 532480,
                            "waitNanos": 0
                        },
                        {
                            "inputProfile": [
                                {
                                    "records": 7,
                                    "batches": 2,
                                    "schemas": 2
                                },
                                {
                                    "records": 0,
                                    "batches": 0,
                                    "schemas": 0
                                }
                            ],
                            "operatorId": 3,
                            "operatorType": 4,
                            "setupNanos": 0,
                            "processNanos": 712835136,
                            "peakLocalMemoryAllocated": 7483400,
                            "metric": [
                                {
                                    "metricId": 0,
                                    "longValue": 65536
                                },
                                {
                                    "metricId": 2,
                                    "longValue": 0
                                },
                                {
                                    "metricId": 1,
                                    "longValue": 2
                                },
                                {
                                    "metricId": 3,
                                    "longValue": 0
                                }
                            ],
                            "waitNanos": 0
                        },
                        {
                            "inputProfile": [
                                {
                                    "records": 3,
                                    "batches": 2,
                                    "schemas": 1
                                }
                            ],
                            "operatorId": 2,
                            "operatorType": 10,
                            "setupNanos": 1706659,
                            "processNanos": 3064309,
                            "peakLocalMemoryAllocated": 1011712,
                            "waitNanos": 0
                        },
                        {
                            "inputProfile": [
                                {
                                    "records": 3,
                                    "batches": 2,
                                    "schemas": 1
                                }
                            ],
                            "operatorId": 1,
                            "operatorType": 10,
                            "setupNanos": 1540402,
                            "processNanos": 2782831,
                            "peakLocalMemoryAllocated": 1011712,
                            "waitNanos": 0
                        },
                        {
                            "inputProfile": [
                                {
                                    "records": 3,
                                    "batches": 2,
                                    "schemas": 1
                                }
                            ],
                            "operatorId": 0,
                            "operatorType": 13,
                            "setupNanos": 0,
                            "processNanos": 3892247,
                            "peakLocalMemoryAllocated": 1011712,
                            "metric": [
                                {
                                    "metricId": 0,
                                    "longValue": 1224
                                }
                            ],
                            "waitNanos": 1790801
                        }
                    ],
                    "startTime": 1456721199550,
                    "endTime": 1456721201150,
                    "memoryUsed": 0,
                    "maxMemoryUsed": 14483912,
                    "endpoint": {
                        "address": "localhost",
                        "userPort": 31010,
                        "controlPort": 31011,
                        "dataPort": 31012
                    },
                    "lastUpdate": 1456721201151,
                    "lastProgress": 1456721201151
                }
            ]
        }
    ],
    "user": "anonymous"
}