explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7YFC

Settings
# exclusive inclusive rows x rows loops node
1. 0.028 32.766 ↑ 4.7 14 1

WindowAgg (cost=7,723.81..7,725.46 rows=66 width=61) (actual time=32.750..32.766 rows=14 loops=1)

2. 0.064 32.738 ↑ 4.7 14 1

Sort (cost=7,723.81..7,723.98 rows=66 width=53) (actual time=32.737..32.738 rows=14 loops=1)

  • Sort Key: perf_point DESC, perf_correct, perf_wrong, user_fk DESC
  • Sort Method: quicksort Memory: 26kB
3. 12.087 32.674 ↑ 4.7 14 1

Gather (cost=1,000.00..7,721.82 rows=66 width=53) (actual time=2.129..32.674 rows=14 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 20.587 20.587 ↑ 5.6 5 3

Parallel Seq Scan on es_adaptif_exam_ranking (cost=0.00..6,715.22 rows=28 width=53) (actual time=10.235..20.587 rows=5 loops=3)

  • Filter: ((NOT isdeleted) AND (perf_point IS NOT NULL) AND ((school_fk)::text = 1d146fd5839b456d9c8ddafcbfb6fde8 ::text) AND (classroom_fk = 8) AND ((term_fk)::text = 2018-2019 ::text) AND (sub_type_fk = 150))
  • Rows Removed by Filter: 1715