explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sBZr

Settings
# exclusive inclusive rows x rows loops node
1. 224.185 74,971.649 ↑ 1.7 746 1

HashAggregate (cost=5,209.13..5,531.01 rows=1,238 width=40) (actual time=74,971.443..74,971.649 rows=746 loops=1)

  • Group Key: uhs.id_series, tool.jsonb_merge(sbp.progression, uhs.progression)
2. 74,720.436 74,747.464 ↓ 1.2 1,479 1

Hash Join (cost=1,679.40..5,202.94 rows=1,238 width=40) (actual time=43.260..74,747.464 rows=1,479 loops=1)

  • Hash Cond: (uhs.id_series = sbp.id_series)
  • Join Filter: (sbp.updated_at > uhs.structure_updated_at)
  • Rows Removed by Join Filter: 20
3. 6.014 6.014 ↑ 2.5 1,499 1

Index Scan using user_has_series_id_series_brand_idx on user_has_series uhs (cost=0.42..3,154.10 rows=3,714 width=861) (actual time=0.105..6.014 rows=1,499 loops=1)

  • Index Cond: ((id_brand = 'AC'::bpchar) AND (id_series = ANY ('{4,49,58,74,77,87,100,106,133,182,274,290}'::bigint[])))
4. 7.874 21.014 ↑ 1.0 9,377 1

Hash (cost=1,561.77..1,561.77 rows=9,377 width=466) (actual time=21.014..21.014 rows=9,377 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 4732kB
5. 13.140 13.140 ↑ 1.0 9,377 1

Seq Scan on series_base_progression_ac sbp (cost=0.00..1,561.77 rows=9,377 width=466) (actual time=0.006..13.140 rows=9,377 loops=1)