explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N0Uz

Settings
# exclusive inclusive rows x rows loops node
1. 35.375 518.184 ↓ 1.5 3 1

Gather (cost=148,527.45..148,527.66 rows=2 width=8) (actual time=518.138..518.184 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Functions: 14
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 3.521 ms, Inlining 0.000 ms, Optimization 8.110 ms, Emission 14.143 ms, Total 25.774 ms"Execution Time: 519.884 ms
2. 50.263 482.809 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=147,527.45..147,527.46 rows=1 width=8) (actual time=482.809..482.809 rows=1 loops=3)

3. 432.546 432.546 ↑ 1.3 900,172 3 / 3

Parallel Seq Scan on "users-reports" (cost=0.00..144,710.50 rows=1,126,779 width=0) (actual time=7.682..432.546 rows=900,172 loops=3)

  • Filter: ((oxygen <= 95) AND (stress >= 3))
  • Rows Removed by Filter: 1100495