explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sScU

Settings
# exclusive inclusive rows x rows loops node
1. 11.500 51.551 ↑ 1.0 1 1

Aggregate (cost=2,910.14..2,910.17 rows=1 width=120) (actual time=51.551..51.551 rows=1 loops=1)

2. 40.051 40.051 ↓ 1.0 26,780 1

Seq Scan on prod_reviews pw (cost=0.00..2,511.75 rows=26,559 width=4) (actual time=0.021..40.051 rows=26,780 loops=1)

  • Filter: (((visible_web)::text = 'S'::text) AND (cod_grupo_rw = 1))
  • Rows Removed by Filter: 25951