Skip to content

Instantly share code, notes, and snippets.

View ritukothari's full-sized avatar

Ritu Kothari ritukothari

  • @ DynAgility
View GitHub Profile
Query Plan
Fragment 1 [SINGLE]
Cost: CPU 12.00ms, Input: 43 rows (11.90kB), Output: 43 rows (11.90kB)
Output layout: [date_trunc_438, data_institutionid, data_sectionid, data_lessonid, data_userid, organizationid, departmentid, expr_397, expr_400, count_455]
Output partitioning: SINGLE []
- Sort[date_trunc_438 DESC_NULLS_LAST] => [date_trunc_438:timestamp, data_institutionid:varchar, data_sectionid:varchar, data_lessonid:varchar, data_userid:varchar, organizationid:varchar(64), departmentid:varchar(64), expr_397:bigint, expr_400:bigint, count_455:bigint]
Cost: 0.00%, Output: 43 rows (11.90kB)
Input avg.: 43.00 lines, Input std.dev.: 0.00%
- LocalExchange[SINGLE] () => date_trunc_438:timestamp, data_institutionid:varchar, data_sectionid:varchar, data_lessonid:varchar, data_userid:varchar, organizationid:varchar(64), departmentid:varchar(64), expr_397:bigint, expr_400:bigint, count_455:bigint
Cost: 50.00%, Output: 43 rows (11.90kB)