Skip to content

Instantly share code, notes, and snippets.

@camsaul
Last active January 13, 2022 00:42
Show Gist options
  • Save camsaul/6382cdf65b5dc1f5b947fa02665cd05b to your computer and use it in GitHub Desktop.
Save camsaul/6382cdf65b5dc1f5b947fa02665cd05b to your computer and use it in GitHub Desktop.
Profiling Results
;; profile everything in a namespace
(doseq [[_ varr] (ns-interns *ns*)] (profile.core/profile-var* varr))
;; run something and get profiling results
(profile.core/profile {} (no-lazyness-test))
| :name | :n | :sum | :q1 | :med | :q3 | :sd | :mad |
|----------------------------------------------------------------------------------+-----------+-------+-------+-------+-------+-------+-------|
| #'metabase.query-processor.util.add-alias-info/selected-clauses | 4,036 | 24.5s | 5ms | 6ms | 7ms | 2ms | 1ms |
| #'metabase.query-processor.util.add-alias-info/clause-alias-info | 4,036 | 37.8s | 5ms | 6ms | 9ms | 7ms | 2ms |
| #'metabase.query-processor.util.add-alias-info/remove-namespaced-options | 3,047,388 | 1.8s | 0µs | 1µs | 1µs | 21µs | 0µs |
| #'metabase.query-processor.util.add-alias-info/clause->position | 4,036 | 24.6s | 5ms | 6ms | 7ms | 2ms | 1ms |
| #'metabase.query-processor.util.add-alias-info/exports | 2,008 | 730ms | 276µs | 322µs | 397µs | 422µs | 51µs |
| #'metabase.query-processor.util.add-alias-info/field-is-from-join-in-this-level? | 16,116 | 6ms | 0µs | 0µs | 0µs | 1µs | 0µs |
| #'metabase.query-processor.util.add-alias-info/field-desired-alias | 4,026 | 6.6s | 31µs | 60µs | 401µs | 3ms | 32µs |
| #'metabase.query-processor.util.add-alias-info/matching-field-in-source-query | 8,056 | 12.7s | 9µs | 12µs | 115µs | 3ms | 3µs |
| #'metabase.query-processor.util.add-alias-info/field-instance | 20,142 | 264ms | 6µs | 7µs | 11µs | 116µs | 1µs |
| #'metabase.query-processor.util.add-alias-info/field-source-alias | 4,030 | 6.4s | 19µs | 21µs | 165µs | 3ms | 3µs |
| #'metabase.query-processor.util.add-alias-info/unique-alias-fn | 8 | 152µs | 12µs | 14µs | 16µs | 15µs | 2µs |
| #'metabase.query-processor.util.add-alias-info/matching-field-in-join | 4,026 | 20ms | 1µs | 1µs | 2µs | 214µs | 0µs |
| #'metabase.query-processor.util.add-alias-info/escape-alias | 4,032 | 67ms | 6µs | 16µs | 22µs | 12µs | 9µs |
| #'metabase.query-processor.util.add-alias-info/field-name | 8,056 | 151ms | 7µs | 12µs | 27µs | 18µs | 5µs |
| #'metabase.query-processor.util.add-alias-info/field-table-id | 12,086 | 145ms | 7µs | 8µs | 10µs | 150µs | 1µs |
| #'metabase.query-processor.util.add-alias-info/add-alias-info* | 8 | 37.9s | 2.7s | 3.6s | 3.7s | 3.0s | 914ms |
| #'metabase.query-processor.util.add-alias-info/field-alias-in-source-query | 8,056 | 12.7s | 10µs | 13µs | 116µs | 3ms | 4µs |
| #'metabase.query-processor.util.add-alias-info/field-source-table-alias | 12,086 | 175ms | 8µs | 10µs | 13µs | 150µs | 2µs |
| #'metabase.query-processor.util.add-alias-info/field-alias-in-join | 4,026 | 30ms | 2µs | 3µs | 5µs | 219µs | 1µs |
| #'metabase.query-processor.util.add-alias-info/this-level-join-aliases | 8 | 90µs | 8µs | 9µs | 12µs | 6µs | 2µs |
| #'metabase.query-processor.util.add-alias-info/normalize-clause | 3,049,412 | 29.7s | 7µs | 9µs | 10µs | 61µs | 1µs |
| #'metabase.query-processor.util.add-alias-info/add-alias-info | 6 | 38.0s | 2.7s | 2.8s | 2.8s | 5.2s | 177ms |
@camsaul
Copy link
Author

camsaul commented Jan 13, 2022

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment