explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LFjy

Settings
# exclusive inclusive rows x rows loops node
1. 103.313 18,448.629 ↓ 0.0 0 1

Update on user_has_series uhs (cost=0.70..64,307.32 rows=202 width=137) (actual time=18,448.629..18,448.629 rows=0 loops=1)

2. 18,161.224 18,345.316 ↓ 2.4 491 1

Nested Loop (cost=0.70..64,307.32 rows=202 width=137) (actual time=103.558..18,345.316 rows=491 loops=1)

3. 0.032 0.032 ↑ 1.0 4 1

Index Scan using social_series_progres_idx on social_series_progres sbp (cost=0.28..5.57 rows=4 width=1,213) (actual time=0.012..0.032 rows=4 loops=1)

  • Index Cond: (id_series = ANY ('{3064,3114,9359,9430}'::bigint[]))
4. 184.060 184.060 ↓ 2.5 123 4

Index Scan using user_has_series_pkey on user_has_series uhs (cost=0.43..16,049.69 rows=50 width=944) (actual time=0.234..46.015 rows=123 loops=4)

  • Index Cond: ((id_brand = 'AC'::bpchar) AND (id_series = sbp.id_series))