explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UJK3

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

Seq Scan on mdl_block_recentlyaccesseditems (cost=806.34..3,636,994,005.04 rows=180,734 width=8) (actual rows= loops=)

  • Filter: ((NOT (hashed SubPlan 1)) OR (NOT (SubPlan 2)))
2.          

SubPlan (forSeq Scan)

3. 0.000 0.000 ↓ 0.0

Index Only Scan using mdl_cour_id_pk on mdl_course c (cost=0.29..777.48 rows=11,546 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..28,234.05 rows=780,470 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on mdl_course_modules cm (cost=0.00..21,282.70 rows=780,470 width=8) (actual rows= loops=)