explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3rrJ

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 51,216.324 78,635.300 ↓ 200.8 8,096,051 1

Gather (cost=1,000.00..955,466.91 rows=40,327 width=1,247) (actual time=10.779..78,635.300 rows=8,096,051 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 27,418.976 27,418.976 ↓ 160.6 2,698,684 3 / 3

Parallel Seq Scan on epv (cost=0.00..950,434.21 rows=16,803 width=1,247) (actual time=7.637..27,418.976 rows=2,698,684 loops=3)

  • Filter: (lower(status) = 'prnt'::text)
  • Rows Removed by Filter: 72
Planning time : 0.378 ms
Execution time : 80,018.242 ms