explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D9UL

Settings
# exclusive inclusive rows x rows loops node
1. 19.284 103.347 ↓ 1.7 15,022 1

Gather Merge (cost=7,620.32..8,638.30 rows=8,852 width=1,154) (actual time=82.552..103.347 rows=15,022 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 57.268 84.063 ↑ 1.2 7,511 2 / 2

Sort (cost=6,620.31..6,642.44 rows=8,852 width=1,154) (actual time=79.449..84.063 rows=7,511 loops=2)

  • Sort Key: (CASE WHEN ((s."HasUnreadMessages" IS NOT NULL) AND s."HasUnreadMessages") THEN true ELSE false END) DESC, (CASE WHEN (it."Type" = 'lockRequest'::text) THEN 0 ELSE 1 END), (((it."AdditionalInfo" ->> 'isCashDamage'::text))::boolean), (((it."AdditionalInfo" ->> 'isHelpRequested'::text))::boolean), it."CreationTime" DESC
  • Sort Method: external merge Disk: 5424kB
  • Worker 0: Sort Method: external merge Disk: 4888kB
3. 4.304 26.795 ↑ 1.2 7,511 2 / 2

Hash Left Join (cost=58.20..1,559.98 rows=8,852 width=1,154) (actual time=0.263..26.795 rows=7,511 loops=2)

  • Hash Cond: ("it.LastMessage.Creator"."Id" = "participantUserCreator"."Id")
4. 3.299 22.460 ↑ 1.2 7,511 2 / 2

Hash Left Join (cost=53.86..1,376.55 rows=8,852 width=1,022) (actual time=0.216..22.460 rows=7,511 loops=2)

  • Hash Cond: ("it.LastMessage.Creator"."Id" = "userCreator"."Id")
5. 2.807 19.151 ↑ 1.2 7,511 2 / 2

Hash Left Join (cost=34.19..1,333.40 rows=8,852 width=861) (actual time=0.195..19.151 rows=7,511 loops=2)

  • Hash Cond: (it."Id" = s."RequestId")
6. 3.011 16.324 ↑ 1.2 7,511 2 / 2

Hash Left Join (cost=25.87..1,301.84 rows=8,852 width=860) (actual time=0.165..16.324 rows=7,511 loops=2)

  • Hash Cond: (it."AssignedOperator" = assignee."Id")
7. 2.621 13.296 ↑ 1.2 7,511 2 / 2

Hash Left Join (cost=6.20..1,258.72 rows=8,852 width=699) (actual time=0.140..13.296 rows=7,511 loops=2)

  • Hash Cond: (it."ParticipantId" = participant."Id")
8. 2.878 10.643 ↑ 1.2 7,511 2 / 2

Hash Left Join (cost=2.17..1,230.38 rows=8,852 width=597) (actual time=0.097..10.643 rows=7,511 loops=2)

  • Hash Cond: (it."LastMessage_CreatorId" = "it.LastMessage.Creator"."Id")
9. 7.736 7.736 ↑ 1.2 7,511 2 / 2

Parallel Seq Scan on "Requests" it (cost=0.00..1,203.52 rows=8,852 width=556) (actual time=0.013..7.736 rows=7,511 loops=2)

10. 0.016 0.029 ↓ 1.6 81 2 / 2

Hash (cost=1.52..1.52 rows=52 width=41) (actual time=0.029..0.029 rows=81 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
11. 0.013 0.013 ↓ 1.6 81 2 / 2

Seq Scan on "DiscussionMembers" "it.LastMessage.Creator" (cost=0.00..1.52 rows=52 width=41) (actual time=0.008..0.013 rows=81 loops=2)

12. 0.016 0.032 ↓ 1.1 96 2 / 2

Hash (cost=2.90..2.90 rows=90 width=102) (actual time=0.032..0.032 rows=96 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
13. 0.016 0.016 ↓ 1.1 96 2 / 2

Seq Scan on "Participants" participant (cost=0.00..2.90 rows=90 width=102) (actual time=0.006..0.016 rows=96 loops=2)

14. 0.006 0.017 ↑ 23.9 18 2 / 2

Hash (cost=14.30..14.30 rows=430 width=161) (actual time=0.017..0.017 rows=18 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
15. 0.011 0.011 ↑ 23.9 18 2 / 2

Seq Scan on "Users" assignee (cost=0.00..14.30 rows=430 width=161) (actual time=0.008..0.011 rows=18 loops=2)

16. 0.001 0.020 ↓ 0.0 0 2 / 2

Hash (cost=8.30..8.30 rows=1 width=38) (actual time=0.019..0.020 rows=0 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
17. 0.019 0.019 ↓ 0.0 0 2 / 2

Index Scan using "IX_RequestSubscriptions_UserId" on "RequestSubscriptions" s (cost=0.29..8.30 rows=1 width=38) (actual time=0.019..0.019 rows=0 loops=2)

  • Index Cond: ("UserId" = '00000000-0000-0000-0000-000000000001'::text)
18. 0.006 0.010 ↑ 23.9 18 2 / 2

Hash (cost=14.30..14.30 rows=430 width=161) (actual time=0.010..0.010 rows=18 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
19. 0.004 0.004 ↑ 23.9 18 2 / 2

Seq Scan on "Users" "userCreator" (cost=0.00..14.30 rows=430 width=161) (actual time=0.002..0.004 rows=18 loops=2)

20. 0.013 0.031 ↑ 1.2 85 2 / 2

Hash (cost=3.04..3.04 rows=104 width=88) (actual time=0.031..0.031 rows=85 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
21. 0.018 0.018 ↑ 1.2 85 2 / 2

Seq Scan on "ParticipantUsers" "participantUserCreator" (cost=0.00..3.04 rows=104 width=88) (actual time=0.009..0.018 rows=85 loops=2)

Planning time : 2.865 ms
Execution time : 106.441 ms