Skip to content

Instantly share code, notes, and snippets.

SELECT
p0."id",
p0."table_id",
p0."deleted_at",
b1."id",
b1."subject_id",
b1."verb_id",
b1."object_id",
b13."id",
b13."is_sensitive",
@mayel
mayel / explain.sql
Last active October 26, 2024 17:55
[warning] Slow database query: ok db=10449ms repo=Elixir.Bonfire.Common.Repo
EXPLAIN ( ANALYZE TRUE, VERBOSE FALSE, COSTS TRUE, TIMING TRUE, SUMMARY TRUE, FORMAT TEXT ) SELECT b0."id", b0."feed_id", b1."id", b1."subject_id", b1."verb_id", b1."object_id", b15."id", b15."is_sensitive", b20."id", b20."reply_to_id", b20."thread_id", b20."direct_replies_count", b20."nested_replies_count", b20."total_replies_count", b20."path", p3."id", p3."table_id", p3."deleted_at", b18."id", b18."name", b18."summary", b18."website", b18."location", b18."icon_id", b18."image_id", b19."id", b19."creator_id", b19."path", b19."file", b19."size", b19."media_type", b19."metadata", b19."deleted_at", b17."id", b17."username", b17."username_hash", b17."outbox_id", b17."inbox_id", b17."notifications_id", b10."id", b10."creator_id", p11."id", p11."table_id", p11."deleted_at", b13."id", b13."name", b13."summary", b13."website", b13."location", b13."icon_id", b13."image_id", b14."id", b14."creator_id", b14."path", b14."file", b14."size",
[debug] query with deferred join: #Ecto.Query<from p0 in Needle.Pointer, as: :main_object,
left_join: a1 in assoc(p0, :activity), as: :activity,
join: f2 in ^#Ecto.Query<from f0 in subquery(from f0 in Bonfire.Data.Social.FeedPublish,
as: :main_object,
join: a1 in Bonfire.Data.Social.Activity,
as: :activity,
on: a1.id == f0.id,
join: p2 in Needle.Pointer,
as: :activity_pointer,
defmodule Bonfire.Social.Feeds.Funnel do
@moduledoc """
Determines the appropriate filters, joins, and/or preloads for feed queries based.
Helper for `Bonfire.Social.Feeds` and `Bonfire.Social.FeedActivities`, and `Bonfire.Social.Activities`.
"""
use Bonfire.Common.E
alias Bonfire.Common.Config
defmodule Bonfire.Social.Feeds.Presets do
@moduledoc """
Preset feed definitions
"""
use Bonfire.Common.E
import Bonfire.Common.Utils
alias Bonfire.Common.Config
alias Bonfire.Common.Types
defmodule Bonfire.Common.EnvConfig do
@moduledoc """
A Want type that reads environment variables and returns them as keyword lists or map(s).
## Features
- Collects environment variables with a specified prefix.
- Allows key transformation via `:transform_keys`.
- Supports type casting via `:want_values` using the `Want` library.
- Supports both single (e.g. `MYAPP_DB_HOST`) and a list of configuration groups (e.g. `MYAPP_DB_1_HOST`, `MYAPP_DB_2_HOST`, etc).