explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LuzSN

Settings
# exclusive inclusive rows x rows loops node
1. 8,719.501 8,917.159 ↑ 131.8 521 1

HashAggregate (cost=161,136.94..161,823.41 rows=68,647 width=1,130) (actual time=8,916.466..8,917.159 rows=521 loops=1)

  • Group Key: uhs.id_series, sbp.progression, sbp.progression_starts_at
2. 41.998 197.658 ↑ 1.6 44,253 1

Hash Join (cost=20,373.88..160,622.09 rows=68,647 width=1,130) (actual time=89.184..197.658 rows=44,253 loops=1)

  • Hash Cond: (uhs.id_series = sbp.id_series)
  • Join Filter: (sbp.updated_at > uhs.structure_updated_at)
  • Rows Removed by Join Filter: 36175
3. 76.844 142.679 ↑ 2.5 80,788 1

Bitmap Heap Scan on user_has_series uhs (cost=18,694.90..155,596.55 rows=205,942 width=16) (actual time=75.945..142.679 rows=80,788 loops=1)

  • Recheck Cond: (id_brand = 'AC'::bpchar)
  • Heap Blocks: exact=40075
4. 65.835 65.835 ↑ 1.8 111,625 1

Bitmap Index Scan on user_has_series_id_user_idx (cost=0.00..18,643.42 rows=205,942 width=0) (actual time=65.835..65.835 rows=111,625 loops=1)

  • Index Cond: (id_brand = 'AC'::bpchar)
5. 7.525 12.981 ↑ 1.0 9,377 1

Hash (cost=1,561.77..1,561.77 rows=9,377 width=1,138) (actual time=12.980..12.981 rows=9,377 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 10906kB
6. 5.456 5.456 ↑ 1.0 9,377 1

Seq Scan on series_base_progression_ac sbp (cost=0.00..1,561.77 rows=9,377 width=1,138) (actual time=0.007..5.456 rows=9,377 loops=1)