explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bwu8

Settings
# exclusive inclusive rows x rows loops node
1. 0.297 46,249.331 ↓ 1.4 789 1

Limit (cost=6,878.25..6,939.74 rows=572 width=437) (actual time=46,248.038..46,249.331 rows=789 loops=1)

2. 0.832 46,249.034 ↓ 1.4 789 1

Group (cost=6,878.25..6,939.74 rows=572 width=437) (actual time=46,248.036..46,249.034 rows=789 loops=1)

  • Group Key: (to_char(timezone('Europe/Copenhagen'::text, ((track."timestamp")::timestamp without time zone)::timestamp with time zone), 'YYYY-MM-DD HH24:MI:SS'::text)), track.event, (to_char(timezone('Europe/Copenhagen'::text, ((track.sent_at)::timestamp without time zone)::timestamp with time zone), 'YYYY-MM-DD HH24:MI:SS'::text)), track.properties__product, track.properties__product_id, track.properties__action, track.properties__component_name, track.properties__component_type, track.properties__destination, track.properties__flow, track.properties__product_enum, track.context__traits__cell_phone_device, track.context__device__model, track.context__device__manufacturer, track.context__device__type, track.context__device__id, track.properties__claim_id, track.properties__incident_cause, track.properties__incident_time, track.properties__brand_and_model, track.properties__item_impacted, (COALESCE((track.properties__in_possession__bi)::text, track.properties__in_possession__st)), track.properties__possession_check_own_lang, track.properties__repair_check_check_own_lang, track.properties__purchase_date, (COALESCE((track.properties__purchase_amt__bi)::integer, (track.properties__purchase_amt__st)::integer)), track.context__app__version
3. 7.386 46,248.202 ↓ 1.4 794 1

Sort (cost=6,878.25..6,879.68 rows=572 width=437) (actual time=46,248.033..46,248.202 rows=794 loops=1)

  • Sort Key: (to_char(timezone('Europe/Copenhagen'::text, ((track."timestamp")::timestamp without time zone)::timestamp with time zone), 'YYYY-MM-DD HH24:MI:SS'::text)), track.event, (to_char(timezone('Europe/Copenhagen'::text, ((track.sent_at)::timestamp without time zone)::timestamp with time zone), 'YYYY-MM-DD HH24:MI:SS'::text)), track.properties__product, track.properties__product_id, track.properties__action, track.properties__component_name, track.properties__component_type, track.properties__destination, track.properties__flow, track.properties__product_enum, track.context__traits__cell_phone_device, track.context__device__model, track.context__device__manufacturer, track.context__device__type, track.context__device__id, track.properties__claim_id, track.properties__incident_cause, track.properties__incident_time, track.properties__brand_and_model, track.properties__item_impacted, (COALESCE((track.properties__in_possession__bi)::text, track.properties__in_possession__st)), track.properties__possession_check_own_lang, track.properties__repair_check_check_own_lang, track.properties__purchase_date, (COALESCE((track.properties__purchase_amt__bi)::integer, (track.properties__purchase_amt__st)::integer)), track.context__app__version
  • Sort Method: quicksort Memory: 254kB
4. 32.604 46,240.816 ↓ 1.4 794 1

Nested Loop (cost=0.56..6,852.05 rows=572 width=437) (actual time=0.426..46,240.816 rows=794 loops=1)

5. 46,194.714 46,194.714 ↓ 1.4 794 1

Index Scan using track_user_id_idx on track (cost=0.56..2,318.56 rows=572 width=477) (actual time=0.023..46,194.714 rows=794 loops=1)

  • Index Cond: (user_id = 'a86004c1-79a8-4e59-bc6a-2df2bc2aa09d'::text)
6. 0.955 13.498 ↑ 1.0 1 794

Materialize (cost=0.00..4,504.89 rows=1 width=37) (actual time=0.001..0.017 rows=1 loops=794)

7. 12.543 12.543 ↑ 1.0 1 1

Seq Scan on "user" user_db (cost=0.00..4,504.89 rows=1 width=37) (actual time=0.370..12.543 rows=1 loops=1)

  • Filter: (external_id = 'a86004c1-79a8-4e59-bc6a-2df2bc2aa09d'::text)
  • Rows Removed by Filter: 84710
Planning time : 0.428 ms
Execution time : 46,249.623 ms