You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
analytics/lib/plausible/stats
Karl-Aksel Puulmann 3115c6e7a8
Reducing JOINs in queries (#3966)
* Move experimental_session_count? logic to within query object

* WIP new querying system for deciding what tables to query

* both -> either

* Include sample_percent in both tables

* Remove a hanging TODO

* Allow filtering by visit props on event queries if flag is on

* Make default sessions join more conditional

* Simplify events_join_sessions?

* Add some TODOs

* Fix assignment

* Handle entry/exit page visit props separately from props stored in events table

* Update test which created sessions/events differently from everyone else

* Make query_events private

* Dont filter by session properties on events table if querying sessions and joining in events

* Handle visits, pageviews, events and visitors metrics from other table

* both -> either

* events, pageviews are strictly event metrics

* Add support for (plain) breakdowns deciding which table to use

* Run tests with experimental_reduced_joins as a separate job

Also refactor which tests are run with postgres:15 to reduce number of jobs

* moduledocs for TableDecider

* Fix matrix

* Custom build name

* Move TEST_EXPERIMENTAL_REDUCED_JOINS check

* Handle percentage separately from other metrics

* Remove debug code

* TableDecider tests

* both => sample_percent

* Improve naming

* Simplify code

* Breakdowns retain old behavior if getting metric visitors

* Unify behavior of entry/exit page hostnames with rest

* Fix test naming
3 years ago
..
filters Reducing JOINs in queries (#3966) 3 years ago
aggregate.ex Reducing JOINs in queries (#3966) 3 years ago
base.ex Reducing JOINs in queries (#3966) 3 years ago
breakdown.ex Reducing JOINs in queries (#3966) 3 years ago
clickhouse.ex Implement UI for multiple imports (#3727) 3 years ago
compare.ex Fix division by zero in imported queries (#3890) 3 years ago
comparisons.ex Generalize Cache/Warmers - extract only specifics to `Site.Cache` (#3716) 3 years ago
current_visitors.ex Clean up after V2 migration (#2868) 4 years ago
custom_props.ex Add `event:goal` property to Stats API (#3718) 3 years ago
email_report.ex Small bugfix + refactor email reports (#3642) 3 years ago
filter_suggestions.ex Filter by hostnames (#3963) 3 years ago
fragments.ex Remove ARRAY JOINs (#3708) 3 years ago
imported.ex Fix division by zero in imported queries (#3890) 3 years ago
interval.ex Add multiple imports per site (#3724) 3 years ago
metrics.ex Timeseries for conversion rate (#3919) 3 years ago
props.ex Add `event:goal` property to Stats API (#3718) 3 years ago
query.ex Reducing JOINs in queries (#3966) 3 years ago
table_decider.ex Reducing JOINs in queries (#3966) 3 years ago
timeseries.ex Reducing JOINs in queries (#3966) 3 years ago
util.ex Re-apply Move conversion_rate logic from elixir to clickhouse (#3924) 3 years ago