explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DeS4

Settings
# exclusive inclusive rows x rows loops node
1. 0.305 5.186 ↓ 85.0 85 1

Nested Loop Left Join (cost=7.70..100.32 rows=1 width=39,615) (actual time=0.196..5.186 rows=85 loops=1)

2. 0.373 4.711 ↓ 85.0 85 1

Nested Loop (cost=7.42..92.02 rows=1 width=35,872) (actual time=0.180..4.711 rows=85 loops=1)

3. 0.216 2.128 ↓ 85.0 85 1

Nested Loop Left Join (cost=5.56..31.44 rows=1 width=27,672) (actual time=0.085..2.128 rows=85 loops=1)

4. 0.168 1.912 ↓ 85.0 85 1

Nested Loop Left Join (cost=5.27..31.13 rows=1 width=23,929) (actual time=0.079..1.912 rows=85 loops=1)

5. 0.191 1.744 ↓ 85.0 85 1

Nested Loop Left Join (cost=5.13..30.47 rows=1 width=22,513) (actual time=0.073..1.744 rows=85 loops=1)

6. 0.204 1.553 ↓ 85.0 85 1

Nested Loop Left Join (cost=5.00..29.78 rows=1 width=17,896) (actual time=0.066..1.553 rows=85 loops=1)

7. 0.202 1.349 ↓ 85.0 85 1

Nested Loop Left Join (cost=4.86..29.62 rows=1 width=17,645) (actual time=0.060..1.349 rows=85 loops=1)

8. 0.181 1.147 ↓ 85.0 85 1

Nested Loop Left Join (cost=4.43..21.17 rows=1 width=17,283) (actual time=0.052..1.147 rows=85 loops=1)

9. 0.140 0.626 ↓ 85.0 85 1

Nested Loop Left Join (cost=2.43..18.75 rows=1 width=9,083) (actual time=0.041..0.626 rows=85 loops=1)

10. 0.061 0.061 ↓ 85.0 85 1

Index Scan using idx_ts_card_acl_template_wf_card on ts_card_acl t8 (cost=0.43..8.45 rows=1 width=883) (actual time=0.024..0.061 rows=85 loops=1)

  • Index Cond: (template_id = '4bfa281d-8d28-0312-ab9d-5edd292290ac'::uuid)
  • Filter: (code = 4)
11. 0.085 0.425 ↓ 0.0 0 85

Nested Loop Left Join (cost=2.00..10.28 rows=1 width=8,200) (actual time=0.005..0.005 rows=0 loops=85)

12. 0.000 0.340 ↓ 0.0 0 85

Nested Loop Left Join (cost=1.57..9.79 rows=1 width=6,015) (actual time=0.004..0.004 rows=0 loops=85)

13. 0.085 0.340 ↓ 0.0 0 85

Nested Loop Left Join (cost=1.43..9.63 rows=1 width=4,163) (actual time=0.004..0.004 rows=0 loops=85)

14. 0.085 0.255 ↓ 0.0 0 85

Nested Loop Left Join (cost=1.28..9.46 rows=1 width=4,147) (actual time=0.003..0.003 rows=0 loops=85)

15. 0.000 0.170 ↓ 0.0 0 85

Nested Loop Left Join (cost=1.14..9.31 rows=1 width=3,003) (actual time=0.002..0.002 rows=0 loops=85)

16. 0.085 0.170 ↓ 0.0 0 85

Nested Loop Left Join (cost=1.00..9.15 rows=1 width=2,074) (actual time=0.002..0.002 rows=0 loops=85)

17. 0.085 0.085 ↓ 0.0 0 85

Nested Loop Left Join (cost=0.85..8.98 rows=1 width=1,999) (actual time=0.001..0.001 rows=0 loops=85)

18. 0.000 0.000 ↓ 0.0 0 85

Index Scan using wf_card_pkey on wf_card t0 (cost=0.42..8.44 rows=1 width=824) (actual time=0.000..0.000 rows=0 loops=85)

  • Index Cond: (id = t8.card_id)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using df_doc_pkey on df_doc t1 (cost=0.42..0.54 rows=1 width=1,175) (never executed)

  • Index Cond: (card_id = t0.id)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using df_contract_pkey on df_contract t2 (cost=0.15..0.17 rows=1 width=75) (never executed)

  • Index Cond: (card_id = t0.id)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using tm_task_pkey on tm_task t3 (cost=0.14..0.16 rows=1 width=929) (never executed)

  • Index Cond: (card_id = t0.id)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using df_meeting_doc_pkey on df_meeting_doc t4 (cost=0.14..0.16 rows=1 width=1,144) (never executed)

  • Index Cond: (card_id = t0.id)
23. 0.000 0.000 ↓ 0.0 0

Index Only Scan using df_account_doc_pkey on df_account_doc t5 (cost=0.15..0.17 rows=1 width=16) (never executed)

  • Index Cond: (card_id = t0.id)
  • Heap Fetches: 0
24. 0.000 0.000 ↓ 0.0 0

Index Scan using tm_task_pattern_pkey on tm_task_pattern t6 (cost=0.14..0.16 rows=1 width=1,852) (never executed)

  • Index Cond: (card_id = t0.id)
25. 0.000 0.000 ↓ 0.0 0

Index Scan using df_simple_doc_pkey on df_simple_doc t7 (cost=0.42..0.49 rows=1 width=2,185) (never executed)

  • Index Cond: (card_id = t0.id)
26. 0.000 0.340 ↓ 0.0 0 85

Nested Loop Left Join (cost=2.00..2.41 rows=1 width=8,200) (actual time=0.004..0.004 rows=0 loops=85)

27. 0.085 0.340 ↓ 0.0 0 85

Nested Loop Left Join (cost=1.57..1.92 rows=1 width=6,015) (actual time=0.004..0.004 rows=0 loops=85)

28. 0.085 0.255 ↓ 0.0 0 85

Nested Loop Left Join (cost=1.43..1.77 rows=1 width=4,163) (actual time=0.003..0.003 rows=0 loops=85)

29. 0.000 0.170 ↓ 0.0 0 85

Nested Loop Left Join (cost=1.28..1.59 rows=1 width=4,147) (actual time=0.002..0.002 rows=0 loops=85)

30. 0.085 0.170 ↓ 0.0 0 85

Nested Loop Left Join (cost=1.14..1.44 rows=1 width=3,003) (actual time=0.002..0.002 rows=0 loops=85)

31. 0.000 0.085 ↓ 0.0 0 85

Nested Loop Left Join (cost=1.00..1.28 rows=1 width=2,074) (actual time=0.001..0.001 rows=0 loops=85)

32. 0.085 0.085 ↓ 0.0 0 85

Nested Loop Left Join (cost=0.85..1.11 rows=1 width=1,999) (actual time=0.001..0.001 rows=0 loops=85)

33. 0.000 0.000 ↓ 0.0 0 85

Index Scan using wf_card_pkey on wf_card t9 (cost=0.42..0.57 rows=1 width=824) (actual time=0.000..0.000 rows=0 loops=85)

  • Index Cond: (id = t0.parent_card_id)
34. 0.000 0.000 ↓ 0.0 0

Index Scan using df_doc_pkey on df_doc t10 (cost=0.42..0.54 rows=1 width=1,175) (never executed)

  • Index Cond: (card_id = t9.id)
35. 0.000 0.000 ↓ 0.0 0

Index Scan using df_contract_pkey on df_contract t11 (cost=0.15..0.17 rows=1 width=75) (never executed)

  • Index Cond: (card_id = t9.id)
36. 0.000 0.000 ↓ 0.0 0

Index Scan using tm_task_pkey on tm_task t12 (cost=0.14..0.16 rows=1 width=929) (never executed)

  • Index Cond: (card_id = t9.id)
37. 0.000 0.000 ↓ 0.0 0

Index Scan using df_meeting_doc_pkey on df_meeting_doc t13 (cost=0.14..0.16 rows=1 width=1,144) (never executed)

  • Index Cond: (card_id = t9.id)
38. 0.000 0.000 ↓ 0.0 0

Index Only Scan using df_account_doc_pkey on df_account_doc t14 (cost=0.15..0.17 rows=1 width=16) (never executed)

  • Index Cond: (card_id = t9.id)
  • Heap Fetches: 0
39. 0.000 0.000 ↓ 0.0 0

Index Scan using tm_task_pattern_pkey on tm_task_pattern t15 (cost=0.14..0.16 rows=1 width=1,852) (never executed)

  • Index Cond: (card_id = t9.id)
40. 0.000 0.000 ↓ 0.0 0

Index Scan using df_simple_doc_pkey on df_simple_doc t16 (cost=0.42..0.49 rows=1 width=2,185) (never executed)

  • Index Cond: (card_id = t9.id)
41. 0.000 0.000 ↓ 0.0 0 85

Index Scan using wf_card_role_pkey on wf_card_role t17 (cost=0.43..8.45 rows=1 width=362) (actual time=0.000..0.000 rows=0 loops=85)

  • Index Cond: (id = t8.card_role_id)
42. 0.000 0.000 ↓ 0.0 0 85

Index Scan using wf_proc_role_pkey on wf_proc_role t18 (cost=0.14..0.16 rows=1 width=251) (actual time=0.000..0.000 rows=0 loops=85)

  • Index Cond: (id = t17.proc_role_id)
43. 0.000 0.000 ↓ 0.0 0 85

Index Scan using wf_proc_pkey on wf_proc t19 (cost=0.14..0.62 rows=1 width=4,617) (actual time=0.000..0.000 rows=0 loops=85)

  • Index Cond: (id = t18.proc_id)
44. 0.000 0.000 ↓ 0.0 0 85

Index Scan using sec_role_pkey on sec_role t20 (cost=0.14..0.63 rows=1 width=1,416) (actual time=0.000..0.000 rows=0 loops=85)

  • Index Cond: (id = t18.role_id)
45. 0.000 0.000 ↓ 0.0 0 85

Index Scan using sec_user_pkey on sec_user t21 (cost=0.29..0.31 rows=1 width=3,743) (actual time=0.000..0.000 rows=0 loops=85)

  • Index Cond: (id = t17.user_id)
46. 0.170 2.210 ↑ 1.0 1 85

Nested Loop Left Join (cost=1.86..60.57 rows=1 width=8,200) (actual time=0.025..0.026 rows=1 loops=85)

  • Join Filter: (t29.card_id = t22.id)
47. 0.170 1.870 ↑ 1.0 1 85

Nested Loop Left Join (cost=1.43..52.11 rows=1 width=6,015) (actual time=0.022..0.022 rows=1 loops=85)

  • Join Filter: (t28.card_id = t22.id)
48. 0.085 1.700 ↑ 1.0 1 85

Nested Loop Left Join (cost=1.29..43.94 rows=1 width=4,163) (actual time=0.020..0.020 rows=1 loops=85)

  • Join Filter: (t27.card_id = t22.id)
49. 0.170 1.615 ↑ 1.0 1 85

Nested Loop Left Join (cost=1.14..35.76 rows=1 width=4,147) (actual time=0.018..0.019 rows=1 loops=85)

  • Join Filter: (t26.card_id = t22.id)
50. 0.340 1.360 ↑ 1.0 1 85

Nested Loop Left Join (cost=1.00..27.59 rows=1 width=3,003) (actual time=0.016..0.016 rows=1 loops=85)

  • Join Filter: (t25.card_id = t22.id)
51. 0.085 0.680 ↑ 1.0 1 85

Nested Loop Left Join (cost=1.00..25.08 rows=1 width=2,074) (actual time=0.008..0.008 rows=1 loops=85)

  • Join Filter: (t24.card_id = t22.id)
52. 0.085 0.510 ↑ 1.0 1 85

Nested Loop Left Join (cost=0.85..16.90 rows=1 width=1,999) (actual time=0.006..0.006 rows=1 loops=85)

  • Join Filter: (t23.card_id = t22.id)
53. 0.255 0.255 ↑ 1.0 1 85

Index Scan using wf_card_pkey on wf_card t22 (cost=0.42..8.44 rows=1 width=824) (actual time=0.002..0.003 rows=1 loops=85)

  • Index Cond: (id = '4bfa281d-8d28-0312-ab9d-5edd292290ac'::uuid)
  • Filter: (delete_ts IS NULL)
54. 0.170 0.170 ↑ 1.0 1 85

Index Scan using df_doc_pkey on df_doc t23 (cost=0.42..8.44 rows=1 width=1,175) (actual time=0.002..0.002 rows=1 loops=85)

  • Index Cond: (card_id = '4bfa281d-8d28-0312-ab9d-5edd292290ac'::uuid)
55. 0.085 0.085 ↓ 0.0 0 85

Index Scan using df_contract_pkey on df_contract t24 (cost=0.15..8.17 rows=1 width=75) (actual time=0.001..0.001 rows=0 loops=85)

  • Index Cond: (card_id = '4bfa281d-8d28-0312-ab9d-5edd292290ac'::uuid)
56. 0.340 0.340 ↓ 0.0 0 85

Seq Scan on tm_task t25 (cost=0.00..2.50 rows=1 width=929) (actual time=0.004..0.004 rows=0 loops=85)

  • Filter: (card_id = '4bfa281d-8d28-0312-ab9d-5edd292290ac'::uuid)
  • Rows Removed by Filter: 40
57. 0.085 0.085 ↓ 0.0 0 85

Index Scan using df_meeting_doc_pkey on df_meeting_doc t26 (cost=0.14..8.16 rows=1 width=1,144) (actual time=0.001..0.001 rows=0 loops=85)

  • Index Cond: (card_id = '4bfa281d-8d28-0312-ab9d-5edd292290ac'::uuid)
58. 0.000 0.000 ↓ 0.0 0 85

Index Only Scan using df_account_doc_pkey on df_account_doc t27 (cost=0.15..8.17 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=85)

  • Index Cond: (card_id = '4bfa281d-8d28-0312-ab9d-5edd292290ac'::uuid)
  • Heap Fetches: 0
59. 0.000 0.000 ↓ 0.0 0 85

Index Scan using tm_task_pattern_pkey on tm_task_pattern t28 (cost=0.14..8.16 rows=1 width=1,852) (actual time=0.000..0.000 rows=0 loops=85)

  • Index Cond: (card_id = '4bfa281d-8d28-0312-ab9d-5edd292290ac'::uuid)
60. 0.170 0.170 ↑ 1.0 1 85

Index Scan using df_simple_doc_pkey on df_simple_doc t29 (cost=0.42..8.44 rows=1 width=2,185) (actual time=0.002..0.002 rows=1 loops=85)

  • Index Cond: (card_id = '4bfa281d-8d28-0312-ab9d-5edd292290ac'::uuid)
61. 0.170 0.170 ↑ 1.0 1 85

Index Scan using sec_user_pkey on sec_user t30 (cost=0.29..8.30 rows=1 width=3,743) (actual time=0.002..0.002 rows=1 loops=85)

  • Index Cond: (id = t8.user_id)