explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Eq0B

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

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

  • Sort Key: c.""ticketNumber"" DESC
  • Sort Method: quicksort Memory: 25kB
  • Index Cond: ((sfid)::text = ANY ('{0016000001Cs4zlAAB}'::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. 0.044 0.044 ↑ 241.0 1 1

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

3. 0.024 0.024 ↑ 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.023..0.024 rows=1 loops=1)

4. 0.017 0.017 ↓ 0.0 0 1

Nested Loop (cost=0.08..60.75 rows=24 width=67) (actual time=0.016..0.017 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. 0.014 0.014 ↓ 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=0.014..0.014 rows=0 loops=1)

7. 6.108 6.108 ↓ 0.0 0 1

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

8. 6.030 6.030 ↑ 1.0 100 1

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

9. 6.020 6.020 ↑ 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=1.122..6.020 rows=100 loops=1)

10. 0.046 0.046 ↑ 241.0 1 1

Hash (cost=1.45..1.45 rows=241 width=722) (actual time=0.045..0.046 rows=1 loops=1)

11. 0.044 0.044 ↑ 241.0 1 1

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