explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MzP

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 54.484 ↓ 0.0 0 1

Limit (cost=1,000.00..22,006.83 rows=1 width=4) (actual time=54.484..54.484 rows=0 loops=1)

2. 7.278 57.193 ↓ 0.0 0 1

Gather (cost=1,000.00..22,006.83 rows=1 width=4) (actual time=54.482..57.193 rows=0 loops=1)

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

Parallel Seq Scan on student_cluster_memberships (cost=0.00..21,006.73 rows=1 width=4) (actual time=49.915..49.915 rows=0 loops=3)

  • Filter: ((student_id = 698) AND (student_cluster_id = 38))
  • Rows Removed by Filter: 476,892