explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sWnL

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,054.503 ↓ 0.0 0 1

Hash Join (cost=426,280.85..426,292.51 rows=2 width=1,728) (actual time=2,038.428..2,054.503 rows=0 loops=1)

  • Hash Cond: ((c.""accountId"")::text = (accountids.sfid)::text)
  • Index Cond: ((sfid)::text = ANY ('{0016000001Cs4zlAAB}'::text[]))
  • Index Cond: ((parentid)::text = (s.sfid)::text)
  • Workers Planned: 1
  • Workers Launched: 1
  • Sort Key: c.""dateTimeOpened"", c.""ticketNumber"" DESC
  • Sort Method: top-N heapsort Memory: 93kB
  • Worker 0: Sort Method: top-N heapsort Memory: 184kB
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Functions: 20
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 3.883 ms, Inlining 0.000 ms, Optimization 2.583 ms, Emission 41.381 ms, Total 47.847 ms"Execution Time: 2,058.554 ms
2. 22.189 22.189 ↑ 241.0 1 1 / 2

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

3. 22.174 22.174 ↑ 1.0 1 1 / 2

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

4. 0.012 0.012 ↓ 0.0 0 1 / 2

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

5. 0.001 0.001 ↑ 10.0 1 1 / 2

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.009 0.009 ↓ 0.0 0 1 / 2

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

7. 1,005.032 1,005.032 ↑ 1.0 100 1 / 2

Limit (cost=425,665.56..425,676.26 rows=100 width=1,006) (actual time=1,993.932..2,010.064 rows=100 loops=1)

8. 1,005.023 1,005.023 ↑ 24,890.9 100 1 / 2

Gather Merge (cost=425,665.56..691,998.62 rows=2,489,094 width=1,006) (actual time=1,993.929..2,010.045 rows=100 loops=1)

9. 1,983.105 1,983.105 ↑ 24,890.9 100 2 / 2

Sort (cost=424,665.56..425,910.10 rows=2,489,094 width=1,006) (actual time=1,983.091..1,983.105 rows=100 loops=2)

10. 1,413.916 1,413.916 ↑ 1.2 2,115,730 2 / 2

Parallel Seq Scan on mv_case c (cost=0.00..405,639.28 rows=2,489,094 width=1,006) (actual time=0.021..1,413.916 rows=2,115,730 loops=2)

11. 22.193 22.193 ↑ 241.0 1 1 / 2

Hash (cost=1.45..1.45 rows=241 width=722) (actual time=44.384..44.386 rows=1 loops=1)

12. 22.189 22.189 ↑ 241.0 1 1 / 2

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