explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dkHa : Optimization for: plan #dGTf

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 3,651,259.986 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
2.          

SubPlan (for Seq 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. 4,841,293.024 4,841,444.982 ↑ 1.6 434,636 80,102

Materialize (cost=0.00..25,274.48 rows=698,832 width=8) (actual time=0.004..60.441 rows=434,636 loops=80,102)

5. 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