explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KqaX

Settings
# exclusive inclusive rows x rows loops node
1. 0.026 0.085 ↓ 0.0 0 1

Hash Right Join (cost=49.05..61.09 rows=2 width=2,918) (actual time=0.085..0.085 rows=0 loops=1)

  • Hash Cond: (rtm.request_id = r.id)
2. 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
3. 0.001 0.059 ↓ 0.0 0 1

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

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

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

5. 0.000 0.058 ↓ 0.0 0 1

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

6. 0.021 0.058 ↓ 0.0 0 1

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

  • Hash Cond: (uam.account_id = r.account_id)
7. 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
8. 0.000 0.037 ↓ 0.0 0 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
9. 0.001 0.037 ↓ 0.0 0 1

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

10. 0.000 0.036 ↓ 0.0 0 1

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

11. 0.000 0.036 ↓ 0.0 0 1

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

12. 0.001 0.036 ↓ 0.0 0 1

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

13. 0.000 0.035 ↓ 0.0 0 1

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

14. 0.002 0.035 ↓ 0.0 0 1

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

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

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

  • Filter: is_active
16. 0.008 0.012 ↓ 0.0 0 6

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

17. 0.001 0.004 ↓ 0.0 0 1

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

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

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

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

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

20. 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
21. 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)
22. 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))
23. 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
24. 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
25. 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
26. 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=16) (never executed)

  • Index Cond: (id = r.request_status)
  • Filter: (is_active IS TRUE)
27. 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