explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HWTE

Settings
# exclusive inclusive rows x rows loops node
1. 226.161 63,207.307 ↓ 0.0 0 1

Update on user_has_series uhs (cost=21,205.28..159,324.09 rows=505 width=137) (actual time=63,207.307..63,207.307 rows=0 loops=1)

2. 62,822.122 62,981.146 ↓ 1.6 809 1

Hash Join (cost=21,205.28..159,324.09 rows=505 width=137) (actual time=227.935..62,981.146 rows=809 loops=1)

  • Hash Cond: (uhs.id_series = sbp.id_series)
3. 91.094 158.997 ↑ 2.6 80,788 1

Bitmap Heap Scan on user_has_series uhs (cost=21,201.48..158,288.77 rows=206,392 width=944) (actual time=77.325..158.997 rows=80,788 loops=1)

  • Recheck Cond: (id_brand = 'AC'::bpchar)
  • Heap Blocks: exact=40072
4. 67.903 67.903 ↑ 1.8 112,306 1

Bitmap Index Scan on user_has_series_pkey (cost=0.00..21,149.88 rows=206,392 width=0) (actual time=67.903..67.903 rows=112,306 loops=1)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
6. 0.016 0.016 ↑ 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.016 rows=10 loops=1)

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