explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kfmZ

Settings
# exclusive inclusive rows x rows loops node
1. 208.900 63,081.183 ↓ 0.0 0 1

Update on user_has_series uhs (cost=15,163.84..85,941.62 rows=199 width=137) (actual time=63,081.183..63,081.183 rows=0 loops=1)

2. 62,711.771 62,872.283 ↓ 4.1 809 1

Hash Join (cost=15,163.84..85,941.62 rows=199 width=137) (actual time=182.305..62,872.283 rows=809 loops=1)

  • Hash Cond: (uhs.id_series = sbp.id_series)
3. 89.293 160.483 ↑ 1.0 80,788 1

Bitmap Heap Scan on user_has_series uhs (cost=15,160.04..85,531.23 rows=81,359 width=944) (actual time=81.297..160.483 rows=80,788 loops=1)

  • Recheck Cond: (id_brand = 'AC'::bpchar)
  • Heap Blocks: exact=40169
4. 71.190 71.190 ↓ 1.4 113,633 1

Bitmap Index Scan on user_has_series_pkey (cost=0.00..15,139.70 rows=81,359 width=0) (actual time=71.190..71.190 rows=113,633 loops=1)

  • Index Cond: (id_brand = 'AC'::bpchar)
5. 0.011 0.029 ↑ 1.0 10 1

Hash (cost=3.67..3.67 rows=10 width=1,213) (actual time=0.029..0.029 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
6. 0.018 0.018 ↑ 1.0 10 1

Index Scan using social_series_progres_idx on social_series_progres sbp (cost=0.28..3.67 rows=10 width=1,213) (actual time=0.010..0.018 rows=10 loops=1)

  • Index Cond: ((id_series >= 500) AND (id_series <= 800))