explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iHAC

Settings
# exclusive inclusive rows x rows loops node
1. 1.295 24,852.404 ↓ 4.0 4 1

GroupAggregate (cost=3,270.81..3,270.88 rows=1 width=48) (actual time=24,851.114..24,852.404 rows=4 loops=1)

  • Group Key: (CASE bb.performancelevel WHEN '1'::text THEN 'ADVANCED'::character varying WHEN '2'::text THEN 'PROFICIENT'::character varying WHEN '3'::text THEN 'BELOW BASIC'::character varying WHEN '4'::text THEN 'NEARLY MET STANDARD'::character varying WHEN '5'::text THEN 'NOT MET STANDARD'::character varying WHEN '6'::text THEN 'FAR BELOW BASIC'::character varying ELSE bb.performancelevel END)
2. 0.651 24,851.109 ↓ 821.0 821 1

Sort (cost=3,270.81..3,270.81 rows=1 width=52) (actual time=24,851.064..24,851.109 rows=821 loops=1)

  • Sort Key: (CASE bb.performancelevel WHEN '1'::text THEN 'ADVANCED'::character varying WHEN '2'::text THEN 'PROFICIENT'::character varying WHEN '3'::text THEN 'BELOW BASIC'::character varying WHEN '4'::text THEN 'NEARLY MET STANDARD'::character varying WHEN '5'::text THEN 'NOT MET STANDARD'::character varying WHEN '6'::text THEN 'FAR BELOW BASIC'::character varying ELSE bb.performancelevel END)
  • Sort Method: quicksort Memory: 89kB
3. 1,140.723 24,850.458 ↓ 821.0 821 1

Nested Loop (cost=0.81..3,270.80 rows=1 width=52) (actual time=3,352.258..24,850.458 rows=821 loops=1)

  • Join Filter: (a.studentid = bb.studentid)
  • Rows Removed by Join Filter: 11,984,063
4. 42.649 42.649 ↓ 1,654.0 1,654 1

Index Scan using assessnent_filters on assessment bb (cost=0.56..3,255.51 rows=1 width=20) (actual time=27.339..42.649 rows=1,654 loops=1)

  • Index Cond: ((accountid = 2) AND ((assessmenttypecode)::text = 'ELPACs'::text) AND (date >= '2019-08-08'::date) AND (date <= '2020-05-29'::date))
  • Filter: (((name)::text ~~* '%WL%'::text) OR ((subjectareacode)::text = 'WL'::text))
  • Rows Removed by Filter: 3,308
5. 23,667.086 23,667.086 ↓ 3,623.0 7,246 1,654

Function Scan on ufn_indicators_corefilter a (cost=0.25..15.25 rows=2 width=16) (actual time=1.133..14.309 rows=7,246 loops=1,654)

  • Filter: (('{sped}'::text[] && subgroup) AND (gradelevelcode <= 12))
  • Rows Removed by Filter: 24,158
Planning time : 6.588 ms