explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vrs6

Settings
# exclusive inclusive rows x rows loops node
1. 222.829 65,620.195 ↑ 1.7 746 1

HashAggregate (cost=5,209.13..5,531.01 rows=1,238 width=40) (actual time=65,619.989..65,620.195 rows=746 loops=1)

  • Group Key: uhs.id_series, tool.jsonb_merge(sbp.progression, uhs.progression)
2. 64,674.448 65,397.366 ↓ 1.2 1,479 1

Hash Join (cost=1,679.40..5,202.94 rows=1,238 width=40) (actual time=737.554..65,397.366 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. 3.524 3.524 ↑ 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.026..3.524 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. 5.192 719.394 ↑ 1.0 9,377 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 4732kB
5. 714.202 714.202 ↑ 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..714.202 rows=9,377 loops=1)