explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dGTf

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 8,492,553.010 8,492,707.097 ↓ 0.0 0 1

Seq Scan on mdl_block_recentlyaccesseditems (cost=459.25..1,082,202,295.96 rows=60,074 width=8) (actual time=8,492,707.097..8,492,707.097 rows=0 loops=1)

  • Filter: ((NOT (hashed SubPlan 1)) OR (NOT (SubPlan 2)))
  • Rows Removed by Filter: 80102
  • -> Materialize (cost=0.00..25274.48 rows=698832 width=8) (actual time=0.004..60.441 rows=434636 l
2.          

SubPlan (forSeq Scan)

3. 2.129 2.129 ↑ 1.0 11,141 1

Index Only Scan using mdl_cour_id_pk on mdl_course c (cost=0.29..431.40 rows=11,141 width=8) (actual time=0.031..2.129 rows=11,141 loops=1)

  • Heap Fetches: 0
4. 151.958 151.958 ↑ 1.2 596,903 1

Seq Scan on mdl_course_modules cm (cost=0.00..19,050.32 rows=698,832 width=8) (actual time=0.017..151.958 rows=596,903 loops=1)

Planning time : 13.010 ms
Execution time : 8,492,708.704 ms