explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L76T

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.101 ↓ 0.0 0 1

GroupAggregate (cost=62.61..62.74 rows=2 width=2,948) (actual time=0.101..0.101 rows=0 loops=1)

  • Group Key: r.away_team, (CASE WHEN ((rt.display_name)::text = 'Purchase'::text) THEN ''::character varying ELSE d.name END), creatorname.employee_name, rs.display_name, r.home_team, e.event_date, e.event_unique_id, st.name, r.request_number, r.ticket_count, requestername.employee_name, (CASE WHEN ((rt.display_name)::text = 'Purchase'::text) THEN ''::character varying ELSE r.gl_code END)
2. 0.046 0.101 ↓ 0.0 0 1

Sort (cost=62.61..62.62 rows=2 width=2,940) (actual time=0.101..0.101 rows=0 loops=1)

  • Sort Key: r.away_team, (CASE WHEN ((rt.display_name)::text = 'Purchase'::text) THEN ''::character varying ELSE d.name END), creatorname.employee_name, rs.display_name, r.home_team, e.event_date, e.event_unique_id, st.name, r.request_number, r.ticket_count, requestername.employee_name, (CASE WHEN ((rt.display_name)::text = 'Purchase'::text) THEN ''::character varying ELSE r.gl_code END)
  • Sort Method: quicksort Memory: 25kB
3. 0.000 0.055 ↓ 0.0 0 1

Nested Loop Left Join (cost=49.18..62.60 rows=2 width=2,940) (actual time=0.055..0.055 rows=0 loops=1)

4. 0.027 0.055 ↓ 0.0 0 1

Hash Right Join (cost=49.05..61.08 rows=2 width=3,241) (actual time=0.054..0.055 rows=0 loops=1)

  • Hash Cond: (rtm.request_id = r.id)
5. 0.000 0.000 ↓ 0.0 0

Seq Scan on request_ticket_map rtm (cost=0.00..11.70 rows=85 width=32) (never executed)

  • Filter: is_active
6. 0.000 0.028 ↓ 0.0 0 1

Hash (cost=49.03..49.03 rows=1 width=3,241) (actual time=0.028..0.028 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
7. 0.000 0.028 ↓ 0.0 0 1

Nested Loop Left Join (cost=43.22..49.03 rows=1 width=3,241) (actual time=0.028..0.028 rows=0 loops=1)

8. 0.000 0.028 ↓ 0.0 0 1

Nested Loop (cost=43.08..48.77 rows=1 width=3,236) (actual time=0.028..0.028 rows=0 loops=1)

9. 0.009 0.028 ↓ 0.0 0 1

Hash Right Join (cost=42.94..46.57 rows=1 width=3,238) (actual time=0.028..0.028 rows=0 loops=1)

  • Hash Cond: (uam.account_id = r.account_id)
10. 0.000 0.000 ↓ 0.0 0

Seq Scan on department_account_map uam (cost=0.00..3.18 rows=117 width=32) (never executed)

  • Filter: is_active
11. 0.001 0.019 ↓ 0.0 0 1

Hash (cost=42.92..42.92 rows=1 width=3,238) (actual time=0.018..0.019 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
12. 0.000 0.018 ↓ 0.0 0 1

Nested Loop (cost=11.03..42.92 rows=1 width=3,238) (actual time=0.018..0.018 rows=0 loops=1)

13. 0.000 0.018 ↓ 0.0 0 1

Nested Loop (cost=10.89..34.62 rows=1 width=3,222) (actual time=0.018..0.018 rows=0 loops=1)

14. 0.000 0.018 ↓ 0.0 0 1

Nested Loop (cost=10.74..31.09 rows=1 width=3,238) (actual time=0.018..0.018 rows=0 loops=1)

15. 0.000 0.018 ↓ 0.0 0 1

Nested Loop (cost=10.61..27.15 rows=1 width=2,738) (actual time=0.018..0.018 rows=0 loops=1)

16. 0.000 0.018 ↓ 0.0 0 1

Nested Loop (cost=10.46..25.47 rows=1 width=2,738) (actual time=0.018..0.018 rows=0 loops=1)

17. 0.000 0.018 ↓ 0.0 0 1

Nested Loop (cost=10.32..21.91 rows=1 width=1,706) (actual time=0.018..0.018 rows=0 loops=1)

  • Join Filter: (r.request_type = rt.id)
18. 0.012 0.012 ↓ 2.0 6 1

Seq Scan on request_type rt (cost=0.00..1.06 rows=3 width=234) (actual time=0.011..0.012 rows=6 loops=1)

  • Filter: is_active
19. 0.003 0.006 ↓ 0.0 0 6

Materialize (cost=10.32..20.76 rows=2 width=1,504) (actual time=0.001..0.001 rows=0 loops=6)

20. 0.002 0.003 ↓ 0.0 0 1

Hash Join (cost=10.32..20.75 rows=2 width=1,504) (actual time=0.002..0.003 rows=0 loops=1)

  • Hash Cond: (r.creator = creatorname.id)
21. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on request r (cost=0.00..10.40 rows=10 width=1,004) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (is_active AND is_active)
22. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.20..10.20 rows=10 width=532) (never executed)

23. 0.000 0.000 ↓ 0.0 0

Seq Scan on user_info creatorname (cost=0.00..10.20 rows=10 width=532) (never executed)

  • Filter: is_active
24. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_evt_id_is_active on event e (cost=0.14..3.35 rows=1 width=1,064) (never executed)

  • Index Cond: (id = r.event_id)
25. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_season on season s (cost=0.14..1.67 rows=1 width=96) (never executed)

  • Index Cond: (id = e.season_id)
  • Filter: (is_active AND ((start_year)::text = '2019'::text) AND ((end_year)::text = '2020'::text) AND (((type)::character varying)::text = 'e9d61527-def7-46be-9167-bb1644185768'::text) AND ((e.event_date)::date >= (start_date)::date) AND ((e.event_date)::date <= (end_date)::date))
26. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_user_info on user_info requestername (cost=0.14..3.35 rows=1 width=532) (never executed)

  • Index Cond: (id = r.requester)
  • Filter: is_active
27. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_request_details on request_details rd (cost=0.14..3.36 rows=1 width=16) (never executed)

  • Index Cond: (id = r.request_details_id)
  • Filter: is_active
28. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_season_type on season_type st (cost=0.14..8.16 rows=1 width=48) (never executed)

  • Index Cond: (id = s.type)
  • Filter: is_active
29. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_request_status on request_status rs (cost=0.14..2.16 rows=1 width=30) (never executed)

  • Index Cond: (id = r.request_status)
  • Filter: (is_active IS TRUE)
30. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_department on department d (cost=0.14..0.26 rows=1 width=37) (never executed)

  • Index Cond: (uam.department_id = id)
  • Filter: is_active
31. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ticket on ticket ti (cost=0.14..0.67 rows=1 width=24) (never executed)

  • Index Cond: (id = rtm.ticket_id)
  • Filter: is_active