0,19	0	0,04	175	4,02
execution time (ms)	planning time (ms)	slowest node (ms)	largest node (rows)	costliest node

Plan Width	36
Temp Written Blocks	0
Local Dirtied Blocks	0
Temp Read Blocks	0
Local Read Blocks	0
Plan Rows	10
Shared Read Blocks	0
Shared Dirtied Blocks	0
Total Cost	13.15
Local Written Blocks	0
Parallel Aware	false
Actual Startup Time	0.191
Actual Loops	1
Node Type	Limit
Output	["customer5.id","(sum(orderitem2.unitprice))"]
Shared Hit Blocks	9
Startup Cost	13.13
Actual Total Time	0.194
Local Hit Blocks	0
Actual Rows	5
Shared Written Blocks	0

Temp Written Blocks	0
Local Read Blocks	0
Plan Rows	11
Sort Key	["(sum(orderitem2.unitprice)) DESC"]
Total Cost	13.16
Sort Method	quicksort
Local Written Blocks	0
Output	["customer5.id","(sum(orderitem2.unitprice))"]
Shared Hit Blocks	9
Startup Cost	13.13
Actual Total Time	0.192
Local Hit Blocks	0
Parent Relationship	Outer
Sort Space Used	25
Plan Width	36
Local Dirtied Blocks	0
Temp Read Blocks	0
Sort Space Type	Memory
Shared Read Blocks	0
Shared Dirtied Blocks	0
Parallel Aware	false
Actual Startup Time	0.19
Actual Loops	1
Node Type	Sort
Actual Rows	5
Shared Written Blocks	0

Temp Written Blocks	0
Group Key	["customer5.id"]
Local Read Blocks	0
Plan Rows	11
Partial Mode	Simple
Total Cost	12.94
Local Written Blocks	0
Output	["customer5.id","sum(orderitem2.unitprice)"]
Shared Hit Blocks	6
Startup Cost	12.8
Actual Total Time	0.168
Local Hit Blocks	0
Parent Relationship	Outer
Plan Width	36
Local Dirtied Blocks	0
Temp Read Blocks	0
Shared Read Blocks	0
Shared Dirtied Blocks	0
Parallel Aware	false
Actual Startup Time	0.164
Actual Loops	1
Node Type	Aggregate
Strategy	Hashed
Actual Rows	5
Shared Written Blocks	0

Join Type	Inner
Temp Written Blocks	0
Local Read Blocks	0
Plan Rows	22
Inner Unique	false
Total Cost	12.69
Local Written Blocks	0
Output	["customer5.id","orderitem2.unitprice"]
Shared Hit Blocks	6
Startup Cost	7.69
Actual Total Time	0.154
Local Hit Blocks	0
Parent Relationship	Outer
Plan Width	11
Local Dirtied Blocks	0
Temp Read Blocks	0
Hash Cond	(orderitem2.orderid = theorder1.id)
Shared Read Blocks	0
Shared Dirtied Blocks	0
Parallel Aware	false
Actual Startup Time	0.105
Actual Loops	1
Node Type	Hash Join
Actual Rows	8
Shared Written Blocks	0

Relation Name	orderitem
Schema	public
Temp Written Blocks	0
Local Read Blocks	0
Plan Rows	202
Total Cost	4.02
Local Written Blocks	0
Output	["orderitem2.unitprice","orderitem2.orderid"]
Shared Hit Blocks	2
Startup Cost	0.0
Actual Total Time	0.043
Local Hit Blocks	0
Parent Relationship	Outer
Plan Width	11
Local Dirtied Blocks	0
Temp Read Blocks	0
Shared Read Blocks	0
Shared Dirtied Blocks	0
Parallel Aware	false
Actual Startup Time	0.009
Alias	orderitem2
Actual Loops	1
Node Type	Seq Scan
Actual Rows	153
Shared Written Blocks	0

Relation Name	theorder
Schema	public
Temp Written Blocks	0
Local Read Blocks	0
Plan Rows	162
Total Cost	3.62
Local Written Blocks	0
Output	["theorder1.id","theorder1.customerid"]
Shared Hit Blocks	2
Startup Cost	0.0
Actual Total Time	0.034
Local Hit Blocks	0
Parent Relationship	Outer
Plan Width	8
Local Dirtied Blocks	0
Temp Read Blocks	0
Shared Read Blocks	0
Shared Dirtied Blocks	0
Parallel Aware	false
Actual Startup Time	0.006
Alias	theorder1
Actual Loops	1
Node Type	Seq Scan
Actual Rows	175
Shared Written Blocks	0

Relation Name	customer
Schema	public
Temp Written Blocks	0
Local Read Blocks	0
Plan Rows	11
Total Cost	3.26
Local Written Blocks	0
Output	["customer5.id"]
Shared Hit Blocks	2
Startup Cost	0.0
Actual Total Time	0.021
Local Hit Blocks	0
Parent Relationship	Outer
Plan Width	4
Local Dirtied Blocks	0
Temp Read Blocks	0
Shared Read Blocks	0
Shared Dirtied Blocks	0
Rows Removed by Filter	90
Parallel Aware	false
Actual Startup Time	0.007
Filter	((customer5.lastname)::text ~~ 'B%'::text)
Alias	customer5
Actual Loops	1
Node Type	Seq Scan
Actual Rows	11
Shared Written Blocks	0

LIMIT	0ms \| 1,03%
	Rows: 5

SORT	0,02ms \| 12,37%
	Rows: 5

AGGREGATE	0,01ms \| 7,22%
	Rows: 5

HASH JOIN	0,02ms \| 11,86%
	Rows: 8