explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6JLp

Settings
# exclusive inclusive rows x rows loops node
1. 0.204 4.426 ↓ 85.0 85 1

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

2. 0.376 4.052 ↓ 85.0 85 1

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

3. 0.176 1.806 ↓ 85.0 85 1

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

4. 0.166 1.630 ↓ 85.0 85 1

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

5. 0.160 1.464 ↓ 85.0 85 1

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

6. 0.158 1.304 ↓ 85.0 85 1

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

7. 0.155 1.146 ↓ 85.0 85 1

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

8. 0.144 0.991 ↓ 85.0 85 1

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

9. 0.126 0.507 ↓ 85.0 85 1

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

10. 0.041 0.041 ↓ 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.016..0.041 rows=85 loops=1)

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

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

12. 0.085 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.255 ↓ 0.0 0 85

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

14. 0.000 0.170 ↓ 0.0 0 85

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

15. 0.085 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.000 0.085 ↓ 0.0 0 85

Nested Loop Left Join (cost=1.00..9.15 rows=1 width=2,074) (actual time=0.001..0.001 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.085 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.000 0.255 ↓ 0.0 0 85

Nested Loop Left Join (cost=1.57..1.92 rows=1 width=6,015) (actual time=0.003..0.003 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 1.870 ↑ 1.0 1 85

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Join Filter: (t23.card_id = t22.id)
53. 0.170 0.170 ↑ 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.002 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.000 0.000 ↓ 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.000..0.000 rows=0 loops=85)

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

Seq Scan on tm_task t25 (cost=0.00..2.50 rows=1 width=929) (actual time=0.003..0.003 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.085 0.085 ↑ 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.001..0.001 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)