explain.depesz.com

PostgreSQL's explain analyze made readable

Result: clZv

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 11,170.214 ↓ 36.1 433 1

Limit (cost=435,028.85..435,028.91 rows=12 width=19) (actual time=11,158.921..11,170.214 rows=433 loops=1)

2. 5.532 11,170.185 ↓ 36.1 433 1

Group (cost=435,028.85..435,028.91 rows=12 width=19) (actual time=11,158.920..11,170.185 rows=433 loops=1)

  • Group Key: requester_organizations.name
3. 46.833 11,164.653 ↓ 6,676.3 80,116 1

Sort (cost=435,028.85..435,028.88 rows=12 width=19) (actual time=11,158.918..11,164.653 rows=80,116 loops=1)

  • Sort Key: requester_organizations.name
  • Sort Method: quicksort Memory: 8209kB
4. 0.000 11,117.820 ↓ 6,676.3 80,116 1

Nested Loop (cost=31.76..435,028.64 rows=12 width=19) (actual time=47.989..11,117.820 rows=80,116 loops=1)

5. 33.449 10,788.515 ↓ 3,659.0 340,284 1

Nested Loop (cost=31.48..434,999.55 rows=93 width=8) (actual time=44.500..10,788.515 rows=340,284 loops=1)

6. 109.557 1,567.398 ↓ 3,659.0 340,284 1

Hash Join (cost=31.05..434,930.36 rows=93 width=8) (actual time=43.488..1,567.398 rows=340,284 loops=1)

  • Hash Cond: (tickets.assignee_id = assignees.id)
7. 1,414.496 1,414.496 ↓ 1.0 805,819 1

Seq Scan on tickets (cost=0.00..431,878.07 rows=805,415 width=16) (actual time=0.107..1,414.496 rows=805,819 loops=1)

  • Filter: ((created_at >= '2017-01-01 08:00:00'::timestamp without time zone) AND (created_at < '2019-03-01 08:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1890867
8. 0.075 43.345 ↑ 1.2 245 1

Hash (cost=27.28..27.28 rows=302 width=8) (actual time=43.345..43.345 rows=245 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
9. 43.270 43.270 ↑ 1.2 245 1

Index Scan using users_role on users assignees (cost=0.43..27.28 rows=302 width=8) (actual time=0.018..43.270 rows=245 loops=1)

  • Index Cond: (role = ANY ('{Admin,Agent}'::text[]))
10. 9,187.668 9,187.668 ↑ 1.0 1 340,284

Index Scan using users_pkey on users requesters (cost=0.43..0.73 rows=1 width=16) (actual time=0.026..0.027 rows=1 loops=340,284)

11. 340.284 340.284 ↓ 0.0 0 340,284

Index Scan using organizations_pkey on organizations requester_organizations (cost=0.28..0.30 rows=1 width=27) (actual time=0.001..0.001 rows=0 loops=340,284)

  • Filter: (status = 'Active'::text)
Planning time : 1.074 ms
Execution time : 11,170.777 ms