explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tHx4

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 9.123 ↓ 0.0 0 1

Limit (cost=2,526.61..2,526.62 rows=1 width=24) (actual time=9.123..9.123 rows=0 loops=1)

2. 0.035 9.122 ↓ 0.0 0 1

Sort (cost=2,526.61..2,526.62 rows=1 width=24) (actual time=9.122..9.122 rows=0 loops=1)

  • Sort Key: tblapplication.crbportabledate
  • Sort Method: quicksort Memory: 25kB
3. 0.000 9.087 ↓ 0.0 0 1

Nested Loop (cost=1.53..2,526.60 rows=1 width=24) (actual time=9.087..9.087 rows=0 loops=1)

4. 0.001 9.087 ↓ 0.0 0 1

Nested Loop (cost=1.11..2,525.87 rows=1 width=24) (actual time=9.086..9.087 rows=0 loops=1)

  • Join Filter: (tblapplication.applicationid = groups.foreignkey)
5. 0.001 9.086 ↓ 0.0 0 1

Nested Loop (cost=0.68..2,523.48 rows=1 width=24) (actual time=9.086..9.086 rows=0 loops=1)

6. 9.085 9.085 ↓ 0.0 0 1

Function Scan on applications_where_adminuser_has_role (cost=0.25..10.25 rows=1,000 width=4) (actual time=9.085..9.085 rows=0 loops=1)

7. 0.000 0.000 ↓ 0.0 0

Index Scan using tblapplication_pkey on tblapplication (cost=0.43..2.51 rows=1 width=20) (never executed)

  • Index Cond: (applicationid = applications_where_adminuser_has_role.applications_where_adminuser_has_role)
  • Filter: ((crbportabledate IS NOT NULL) AND (stage >= 'Interview'::nn_stage) AND (crbportabledate > now()) AND CASE stage WHEN 'Authorisation'::nn_stage THEN false WHEN 'Longlisting'::nn_stage THEN (state = ANY ('{Received,Sponsorship,Sorted}'::nn_state[])) WHEN 'Shortlisting'::nn_stage THEN (state = ANY ('{Shortlist,Evaluate}'::nn_state[])) WHEN 'Interview'::nn_stage THEN (state = ANY ('{Schedule,Interview,Exempt,NextRoundSchedule,NextRoundExempt}'::nn_state[])) WHEN 'Offer'::nn_stage THEN (state = ANY ('{Pending,Conditional,ChecksOK,WorkTrial,ReadyForStartDate}'::nn_state[])) WHEN 'Starting'::nn_stage THEN (state = ANY ('{StartDateBooked,UpdateStaffRecord,ChecksOutstanding,ChecksComplete}'::nn_state[])) WHEN 'Outcome'::nn_stage THEN (state = 'Recruited'::nn_state) ELSE NULL::boolean END)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_foreignkey_idx on groups (cost=0.43..2.38 rows=1 width=8) (never executed)

  • Index Cond: ((foreignkey = applications_where_adminuser_has_role.applications_where_adminuser_has_role) AND ((keytable)::text = 'tblapplication'::text))
9. 0.000 0.000 ↓ 0.0 0

Index Scan using ticket_groupid_statesondashboard_idx on ticket (cost=0.42..0.72 rows=1 width=8) (never executed)

  • Index Cond: (groupid = groups.groupid)
  • Filter: ((state = 'CheckPortableDBS'::ticketstates) AND (tickettype = 'Convictions'::tickettypes))
Planning time : 9.107 ms
Execution time : 10.155 ms