explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nh3

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.003 11,889.141 ↑ 1.0 1 1

Limit (cost=1,000.00..119,980.48 rows=1 width=451) (actual time=2.239..11,889.141 rows=1 loops=1)

2. 3,969.710 11,889.138 ↑ 1.0 1 1

Gather (cost=1,000.00..119,980.48 rows=1 width=451) (actual time=2.237..11,889.138 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 7,919.428 7,919.428 ↓ 0.0 0 3 / 3

Parallel Seq Scan on notifications (cost=0.00..118,980.38 rows=1 width=451) (actual time=7,919.428..7,919.428 rows=0 loops=3)

  • Filter: (((name)::text = 'ACTIVITY_ASSIGNATION'::text) AND ((user_uuid)::text = '5a988be1-5c8c-470a-9e8c-0bb42dbf8702'::text) AND ((activity_uuid)::text = '4294be3c-ee9a-4388-b62c-84b6ab2bbbec'::text) AND ((company_uuid)::text = 'b7fa583e-a144-4ec2-9464-e1e514512fb4'::text) AND ((notification_type)::text = 'EMAIL'::text))
  • Rows Removed by Filter: 661,409
Planning time : 0.112 ms
Execution time : 11,889.177 ms