explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QQJV

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.130 ↓ 2.0 2 1

Nested Loop (cost=0.00..30.95 rows=1 width=5,030) (actual time=0.035..0.130 rows=2 loops=1)

  • Join Filter: (assignments.context_id = courses.id)
  • Rows Removed by Join Filter: 10
2. 0.101 0.101 ↑ 1.0 4 1

Seq Scan on assignments (cost=0.00..22.56 rows=4 width=1,554) (actual time=0.024..0.101 rows=4 loops=1)

  • Filter: (((context_type)::text = 'Course'::text) AND ((title)::text = 'Roll Call Attendance'::text))
  • Rows Removed by Filter: 327
3. 0.011 0.024 ↑ 1.3 3 4

Materialize (cost=0.00..8.16 rows=4 width=3,476) (actual time=0.002..0.006 rows=3 loops=4)

4. 0.013 0.013 ↑ 1.3 3 1

Seq Scan on courses (cost=0.00..8.14 rows=4 width=3,476) (actual time=0.004..0.013 rows=3 loops=1)

  • Filter: ((workflow_state)::text = ANY ('{active,available}'::text[]))
  • Rows Removed by Filter: 8
Planning time : 2.452 ms
Execution time : 0.325 ms