explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oXeL

Settings
# exclusive inclusive rows x rows loops node
1. 0.036 370.937 ↓ 3.5 7 1

Group (cost=39.63..40.15 rows=2 width=712) (actual time=370.903..370.937 rows=7 loops=1)

  • Group Key: uhs.id_series, sbp.progression_starts_at, (tool.jsonb_merge(sbp.progression, uhs.progression))
2. 0.789 370.901 ↓ 3.5 7 1

Sort (cost=39.63..39.64 rows=2 width=712) (actual time=370.900..370.901 rows=7 loops=1)

  • Sort Key: sbp.progression_starts_at, (tool.jsonb_merge(sbp.progression, uhs.progression))
  • Sort Method: quicksort Memory: 81kB
3. 120.934 370.112 ↓ 3.5 7 1

Nested Loop (cost=0.71..39.62 rows=2 width=712) (actual time=81.166..370.112 rows=7 loops=1)

  • Join Filter: (sbp.updated_at > uhs.structure_updated_at)
  • Rows Removed by Join Filter: 1
4. 44.936 44.936 ↑ 1.0 1 1

Index Scan using brand_series_base_progression_ac_id_series_idx on series_base_progression_ac sbp (cost=0.29..2.50 rows=1 width=1,138) (actual time=44.934..44.936 rows=1 loops=1)

  • Index Cond: (id_series = 4)
5. 204.242 204.242 ↓ 1.6 8 1

Index Scan using user_has_series_id_series_idx on user_has_series uhs (cost=0.42..36.56 rows=5 width=861) (actual time=17.161..204.242 rows=8 loops=1)

  • Index Cond: (id_series = 4)
  • Filter: (id_brand = 'AC'::bpchar)
  • Rows Removed by Filter: 34