explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QOdg

Settings
# exclusive inclusive rows x rows loops node
1. 4.447 1,640.422 ↑ 1.6 42 1

Group (cost=1,660.90..1,678.58 rows=68 width=712) (actual time=1,635.972..1,640.422 rows=42 loops=1)

  • Group Key: uhs.id_series, sbp.progression_starts_at, (tool.jsonb_merge(sbp.progression, uhs.progression))
2. 49.061 1,635.975 ↑ 1.3 53 1

Sort (cost=1,660.90..1,661.07 rows=68 width=712) (actual time=1,635.968..1,635.975 rows=53 loops=1)

  • Sort Key: uhs.id_series, sbp.progression_starts_at, (tool.jsonb_merge(sbp.progression, uhs.progression))
  • Sort Method: quicksort Memory: 975kB
3. 1,539.984 1,586.914 ↑ 1.3 53 1

Nested Loop (cost=0.71..1,658.83 rows=68 width=712) (actual time=27.332..1,586.914 rows=53 loops=1)

4. 39.622 39.622 ↑ 3.2 63 1

Index Scan using user_has_series_id_series_idx on user_has_series uhs (cost=0.42..1,336.67 rows=204 width=861) (actual time=0.028..39.622 rows=63 loops=1)

  • Index Cond: (id_series = ANY ('{4,49,329}'::bigint[]))
  • Filter: (id_brand = 'AC'::bpchar)
  • Rows Removed by Filter: 631
5. 7.308 7.308 ↑ 1.0 1 63

Index Scan using brand_series_base_progression_ac_id_series_idx on series_base_progression_ac sbp (cost=0.29..1.49 rows=1 width=1,138) (actual time=0.115..0.116 rows=1 loops=63)

  • Index Cond: (id_series = uhs.id_series)
  • Filter: (updated_at > uhs.structure_updated_at)
  • Rows Removed by Filter: 0