explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cwK9

Settings
# exclusive inclusive rows x rows loops node
1. 3.232 140.456 ↓ 8.3 124 1

Gather (cost=1,000.00..108,132.58 rows=15 width=69) (actual time=126.877..140.456 rows=124 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 137.224 137.224 ↓ 6.8 41 3 / 3

Parallel Seq Scan on subscriptions (cost=0.00..107,131.08 rows=6 width=69) (actual time=125.387..137.224 rows=41 loops=3)

  • Filter: (2828716 = user_id)
  • Rows Removed by Filter: 1,471,657
Planning time : 0.044 ms
Execution time : 140.482 ms