explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kk0I

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

Sort (cost=635.95..635.95 rows=2 width=1,743) (actual time=1.407..1.409 rows=0 loops=1)

  • Sort Key: c.""ticketNumber"" DESC
  • Sort Method: quicksort Memory: 25kB
  • Index Cond: ((sfid)::text = ANY ('{0016000000MgRmKAAV}'::text[]))
  • Index Cond: ((parentid)::text = (s.sfid)::text)
  • Hash Cond: ((c.""accountId"")::text = (accountids.sfid)::text)
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
2. 1.282 1.282 ↑ 241.0 1 1

Recursive Union (cost=0.08..613.01 rows=241 width=67) (actual time=0.027..1.282 rows=1 loops=1)

3. 0.026 0.026 ↑ 1.0 1 1

Index Scan using account_sfid_key on account p (cost=0.08..4.09 rows=1 width=67) (actual time=0.025..0.026 rows=1 loops=1)

4. 1.253 1.253 ↓ 0.0 0 1

Nested Loop (cost=0.08..60.75 rows=24 width=67) (actual time=1.253..1.253 rows=0 loops=1)

5. 0.001 0.001 ↑ 10.0 1 1

WorkTable Scan on accountids s (cost=0.00..0.06 rows=10 width=54) (actual time=0.001..0.001 rows=1 loops=1)

6. 1.250 1.250 ↓ 0.0 0 1

Index Scan using account_parentid_idx on account c_1 (cost=0.08..6.06 rows=2 width=67) (actual time=1.249..1.250 rows=0 loops=1)

7. 1.403 1.403 ↓ 0.0 0 1

Hash Join (cost=2.38..22.94 rows=2 width=1,743) (actual time=1.402..1.403 rows=0 loops=1)

8. 0.089 0.089 ↑ 1.0 100 1

Limit (cost=0.09..19.70 rows=100 width=1,006) (actual time=0.015..0.089 rows=100 loops=1)

9. 0.081 0.081 ↑ 42,314.6 100 1

Index Scan using ""dateTimeOpened_new_index"" on mv_case c (cost=0.09..829,804.03 rows=4,231,459 width=1,006) (actual time=0.014..0.081 rows=100 loops=1)

10. 1.286 1.286 ↑ 241.0 1 1

Hash (cost=1.45..1.45 rows=241 width=722) (actual time=1.285..1.286 rows=1 loops=1)

11. 1.283 1.283 ↑ 241.0 1 1

CTE Scan on accountids (cost=0.00..1.45 rows=241 width=722) (actual time=0.028..1.283 rows=1 loops=1)