explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dPZm

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.003 176.333 ↑ 1.0 1 1

Limit (cost=1,000.00..98,005.89 rows=1 width=4) (actual time=0.200..176.333 rows=1 loops=1)

2. 61.724 176.330 ↑ 1.0 1 1

Gather (cost=1,000.00..98,005.89 rows=1 width=4) (actual time=0.199..176.330 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 114.606 114.606 ↓ 0.0 0 3 / 3

Parallel Seq Scan on mailer_notifications (cost=0.00..97,005.79 rows=1 width=4) (actual time=114.605..114.606 rows=0 loops=3)

  • Filter: (uuid = '0666e842-8492-419e-9f2a-ede0df57f23a'::uuid)
  • Rows Removed by Filter: 614,468
Planning time : 0.101 ms
Execution time : 176.372 ms