explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VT4k

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

Sort (cost=114.92..114.94 rows=5 width=17,877) (actual rows= loops=)

  • Sort Key: issue.created_ts DESC
2.          

CTE issue

3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=9.72..23.32 rows=5 width=1,521) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=9.58..22.14 rows=5 width=1,494) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=9.44..20.58 rows=5 width=1,466) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=9.29..18.42 rows=5 width=1,406) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=9.15..16.00 rows=5 width=1,384) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=9.01..12.03 rows=5 width=940) (actual rows= loops=)

  • Hash Cond: (issue_1.id = "ANY_subquery".id)
9. 0.000 0.000 ↓ 0.0

Seq Scan on issue issue_1 (cost=0.00..2.77 rows=77 width=940) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash (cost=8.94..8.94 rows=5 width=8) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Subquery Scan on ANY_subquery (cost=8.88..8.94 rows=5 width=8) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Limit (cost=8.88..8.89 rows=5 width=16) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Sort (cost=8.88..8.89 rows=5 width=16) (actual rows= loops=)

  • Sort Key: issue_2.created_ts DESC
14. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=5.76..8.82 rows=5 width=16) (actual rows= loops=)

  • Hash Cond: (issue_2.id = isin.issue_id)
15. 0.000 0.000 ↓ 0.0

Seq Scan on issue issue_2 (cost=0.00..2.96 rows=8 width=16) (actual rows= loops=)

  • Filter: (created_ts > '2019-01-01 00:00:00+02'::timestamp with time zone)
16. 0.000 0.000 ↓ 0.0

Hash (cost=5.15..5.15 rows=49 width=8) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.48..5.15 rows=49 width=8) (actual rows= loops=)

  • Hash Cond: (isin.interaction_id = inte_1.id)
18. 0.000 0.000 ↓ 0.0

Seq Scan on issue_interaction isin (cost=0.00..1.86 rows=86 width=16) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Hash (cost=2.00..2.00 rows=38 width=8) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Seq Scan on interaction inte_1 (cost=0.00..2.00 rows=38 width=8) (actual rows= loops=)

  • Filter: ((created_by_person_id = 1) OR (behalf_of_person_id = 1))
21. 0.000 0.000 ↓ 0.0

Index Scan using issue_external_reference_issue_id_type_external_id_idx on issue_external_reference iser (cost=0.14..0.78 rows=1 width=452) (actual rows= loops=)

  • Index Cond: (issue_id = issue_1.id)
22. 0.000 0.000 ↓ 0.0

Index Scan using person_pkey on person pers_next_inte (cost=0.14..0.47 rows=1 width=22) (actual rows= loops=)

  • Index Cond: (id = issue_1.next_interaction_person_id)
23. 0.000 0.000 ↓ 0.0

Index Scan using customer_pkey on customer cust (cost=0.14..0.42 rows=1 width=60) (actual rows= loops=)

  • Index Cond: (id = issue_1.customer_id)
24. 0.000 0.000 ↓ 0.0

Index Scan using person_pkey on person pers_owner (cost=0.14..0.30 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = cust.owner_person_id)
25. 0.000 0.000 ↓ 0.0

Index Scan using legal_entity_pkey on legal_entity leen (cost=0.14..0.23 rows=1 width=35) (actual rows= loops=)

  • Index Cond: (id = cust.legal_entity_id)
26. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=46.60..91.54 rows=5 width=17,877) (actual rows= loops=)

  • Hash Cond: (issue.id = customer_product.issue_id)
27. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=35.47..80.35 rows=5 width=17,835) (actual rows= loops=)

  • Hash Cond: (issue.id = related_address.issue_id)
28. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=24.80..69.60 rows=5 width=16,253) (actual rows= loops=)

  • Hash Cond: (issue.id = catalog_service.issue_id)
29. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=13.22..57.96 rows=5 width=15,705) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=13.08..55.26 rows=5 width=15,189) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=12.94..52.57 rows=5 width=14,673) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=12.79..49.87 rows=5 width=14,157) (actual rows= loops=)

  • Hash Cond: (upper((issue.resolved_by)::text) = upper((resolver.username)::text))
33. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.45..38.44 rows=5 width=13,439) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.30..34.01 rows=5 width=12,721) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.16..31.35 rows=5 width=12,707) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.01..28.70 rows=5 width=12,693) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.88..24.29 rows=5 width=10,355) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.73..19.85 rows=5 width=10,347) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.59..15.41 rows=5 width=10,338) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.44..10.96 rows=5 width=10,320) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.30..6.54 rows=5 width=9,521) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.16..2.13 rows=5 width=6,876) (actual rows= loops=)

  • Hash Cond: (inte.id = issue.first_interaction_id)
43. 0.000 0.000 ↓ 0.0

Seq Scan on interaction inte (cost=0.00..1.67 rows=67 width=110) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Hash (cost=0.10..0.10 rows=5 width=6,766) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

CTE Scan on issue (cost=0.00..0.10 rows=5 width=6,766) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Index Scan using email_interaction_pkey on email_interaction emin (cost=0.14..0.87 rows=1 width=2,653) (actual rows= loops=)

  • Index Cond: (id = inte.email_interaction_id)
47. 0.000 0.000 ↓ 0.0

Index Scan using sms_interaction_pkey on sms_interaction smin (cost=0.14..0.87 rows=1 width=807) (actual rows= loops=)

  • Index Cond: (id = inte.sms_interaction_id)
48. 0.000 0.000 ↓ 0.0

Index Scan using call_interaction_pkey on call_interaction cain (cost=0.14..0.88 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (id = inte.call_interaction_id)
49. 0.000 0.000 ↓ 0.0

Index Scan using direct_interaction_pkey on direct_interaction diin (cost=0.14..0.88 rows=1 width=9) (actual rows= loops=)

  • Index Cond: (id = inte.direct_interaction_id)
50. 0.000 0.000 ↓ 0.0

Index Only Scan using self_service_interaction_pkey on self_service_interaction sesi (cost=0.14..0.88 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = inte.self_service_interaction_id)
51. 0.000 0.000 ↓ 0.0

Index Scan using letter_interaction_pkey on letter_interaction lein (cost=0.14..0.87 rows=1 width=2,354) (actual rows= loops=)

  • Index Cond: (id = inte.letter_interaction_id)
52. 0.000 0.000 ↓ 0.0

Index Scan using person_pkey on person pers_created_by (cost=0.14..0.52 rows=1 width=22) (actual rows= loops=)

  • Index Cond: (id = inte.created_by_person_id)
53. 0.000 0.000 ↓ 0.0

Index Scan using person_pkey on person pers_behalf_of (cost=0.14..0.52 rows=1 width=22) (actual rows= loops=)

  • Index Cond: (id = inte.behalf_of_person_id)
54. 0.000 0.000 ↓ 0.0

Index Scan using employee_username_upper_idx on employee empl (cost=0.14..0.88 rows=1 width=718) (actual rows= loops=)

  • Index Cond: (upper((username)::text) = upper((inte.created_by_username)::text))
55. 0.000 0.000 ↓ 0.0

Hash (cost=10.60..10.60 rows=60 width=718) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Seq Scan on employee resolver (cost=0.00..10.60 rows=60 width=718) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Index Scan using issue_interaction_content_call_interaction_id_idx on issue_interaction_content isic_call (cost=0.14..0.53 rows=1 width=532) (actual rows= loops=)

  • Index Cond: (cain.id = call_interaction_id)
58. 0.000 0.000 ↓ 0.0

Index Scan using issue_interaction_content_direct_interaction_id_idx on issue_interaction_content isic_direct (cost=0.14..0.53 rows=1 width=532) (actual rows= loops=)

  • Index Cond: (diin.id = direct_interaction_id)
59. 0.000 0.000 ↓ 0.0

Index Scan using issue_interaction_content_self_service_interaction_id_idx on issue_interaction_content isic_self_service (cost=0.14..0.53 rows=1 width=532) (actual rows= loops=)

  • Index Cond: (sesi.id = self_service_interaction_id)
60. 0.000 0.000 ↓ 0.0

Hash (cost=10.70..10.70 rows=70 width=556) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Seq Scan on catalog_service (cost=0.00..10.70 rows=70 width=556) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Hash (cost=10.30..10.30 rows=30 width=1,590) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Seq Scan on related_address (cost=0.00..10.30 rows=30 width=1,590) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Hash (cost=10.50..10.50 rows=50 width=838) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Seq Scan on customer_product (cost=0.00..10.50 rows=50 width=838) (actual rows= loops=)