explain.depesz.com

PostgreSQL's explain analyze made readable

Result: k2gT

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 585.370 ↑ 1.0 1 1

Finalize Aggregate (cost=151,334.29..151,334.30 rows=1 width=8) (actual time=585.370..585.370 rows=1 loops=1)

  • Functions: 14
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 9.825 ms, Inlining 0.000 ms, Optimization 1.127 ms, Emission 14.994 ms, Total 25.946 ms"Execution Time: 586.537 ms
2. 35.585 585.408 ↓ 1.5 3 1

Gather (cost=151,334.07..151,334.28 rows=2 width=8) (actual time=585.364..585.408 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 92.697 549.823 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=150,334.07..150,334.08 rows=1 width=8) (actual time=549.823..549.823 rows=1 loops=3)

4. 457.126 457.126 ↑ 1.2 1,800,397 3 / 3

Parallel Seq Scan on "users-reports" (cost=0.00..144,710.50 rows=2,249,429 width=0) (actual time=5.502..457.126 rows=1,800,397 loops=3)

  • Filter: ((oxygen <= 95) OR (stress >= 3))
  • Rows Removed by Filter: 200269