get_top_streams_by_statistic_type(p_stream_statistic_type_id integer, p_limit integer DEFAULT 10, p_start_date timestamp without time zone DEFAULT NULL::timestamp without time zone, p_end_date timestamp without time zone DEFAULT NULL::timestamp without time zone)


Description

Returns the top streams ranked by total statistic value for a specific type, optionally within a date range.

Parameters

Name Type Mode
p_stream_statistic_type_id integer IN
p_limit integer IN
p_start_date timestamp without time zone IN
p_end_date timestamp without time zone IN
stream_id integer TABLE
total_value bigint TABLE
avg_value numeric TABLE
max_value integer TABLE
count_entries integer TABLE

Definition