explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Juub

Settings
# exclusive inclusive rows x rows loops node
1. 784.009 16,656.988 ↓ 1.8 476,553 1

Hash Left Join (cost=72,780.18..4,574,586.03 rows=264,496 width=453) (actual time=1,893.771..16,656.988 rows=476,553 loops=1)

  • Hash Cond: (t_wo_details.wo_detail_status_id = t_wo_detail_status.wo_detail_status_id)
2. 159.567 3,006.036 ↓ 1.8 476,553 1

Hash Left Join (cost=72,779.10..93,030.86 rows=264,496 width=353) (actual time=1,893.535..3,006.036 rows=476,553 loops=1)

  • Hash Cond: (t_wo_details.activity_id = t_activity.activity_id)
3. 219.991 2,846.453 ↓ 1.8 476,553 1

Hash Left Join (cost=72,777.83..89,392.77 rows=264,496 width=325) (actual time=1,893.502..2,846.453 rows=476,553 loops=1)

  • Hash Cond: ((t_user_assign.user_id)::text = (t_users.user_id)::text)
4. 165.037 2,625.606 ↓ 1.8 476,553 1

Hash Left Join (cost=72,708.11..85,686.23 rows=264,496 width=308) (actual time=1,892.625..2,625.606 rows=476,553 loops=1)

  • Hash Cond: (t_wo.sub_program_id = t_sub_program.sub_program_id)
5. 504.614 2,460.475 ↓ 1.8 476,553 1

Hash Right Join (cost=72,703.54..83,080.52 rows=264,496 width=248) (actual time=1,892.500..2,460.475 rows=476,553 loops=1)

  • Hash Cond: ((t_user_assign.wo_detail_id)::text = (t_wo_details.wo_detail_id)::text)
6. 65.137 65.137 ↑ 1.0 358,995 1

Seq Scan on t_user_assign (cost=0.00..7,012.62 rows=361,962 width=24) (actual time=0.010..65.137 rows=358,995 loops=1)

7. 238.615 1,890.724 ↓ 1.4 375,137 1

Hash (cost=69,397.34..69,397.34 rows=264,496 width=240) (actual time=1,890.724..1,890.724 rows=375,137 loops=1)

  • Buckets: 524,288 Batches: 1 Memory Usage: 80,134kB
8. 124.886 1,652.109 ↓ 1.4 375,137 1

Hash Left Join (cost=48,764.38..69,397.34 rows=264,496 width=240) (actual time=938.663..1,652.109 rows=375,137 loops=1)

  • Hash Cond: ((t_wo_detail_designators.designator_id)::text = (t_designators.designator_id)::text)
9. 213.350 1,527.161 ↓ 1.4 375,137 1

Hash Join (cost=48,760.19..65,756.33 rows=264,496 width=176) (actual time=938.582..1,527.161 rows=375,137 loops=1)

  • Hash Cond: ((t_grouping_wo_details.wo_id)::text = (t_wo.wo_id)::text)
10. 329.946 997.427 ↓ 1.4 384,773 1

Hash Join (cost=31,284.89..44,570.82 rows=284,069 width=72) (actual time=621.351..997.427 rows=384,773 loops=1)

  • Hash Cond: ((t_grouping_wo_details.wo_detail_id)::text = (t_wo_details.wo_detail_id)::text)
11. 47.874 47.874 ↓ 1.0 472,438 1

Seq Scan on t_grouping_wo_details (cost=0.00..8,681.17 rows=470,417 width=32) (actual time=0.009..47.874 rows=472,438 loops=1)

12. 130.280 619.607 ↓ 1.3 385,552 1

Hash (cost=27,684.21..27,684.21 rows=288,055 width=56) (actual time=619.607..619.607 rows=385,552 loops=1)

  • Buckets: 524,288 Batches: 1 Memory Usage: 36,006kB
13. 254.367 489.327 ↓ 1.3 385,552 1

Hash Right Join (cost=16,179.41..27,684.21 rows=288,055 width=56) (actual time=200.794..489.327 rows=385,552 loops=1)

  • Hash Cond: ((t_wo_detail_designators.wo_detail_id)::text = (t_wo_details.wo_detail_id)::text)
14. 35.959 35.959 ↓ 1.0 380,356 1

Seq Scan on t_wo_detail_designators (cost=0.00..7,850.84 rows=373,284 width=35) (actual time=0.009..35.959 rows=380,356 loops=1)

15. 80.360 199.001 ↓ 1.0 290,535 1

Hash (cost=12,578.73..12,578.73 rows=288,055 width=37) (actual time=199.001..199.001 rows=290,535 loops=1)

  • Buckets: 524,288 Batches: 1 Memory Usage: 22,712kB
16. 118.641 118.641 ↓ 1.0 290,535 1

Seq Scan on t_wo_details (cost=0.00..12,578.73 rows=288,055 width=37) (actual time=0.010..118.641 rows=290,535 loops=1)

  • Filter: (wo_detail_status_id = 50)
  • Rows Removed by Filter: 193,633
17. 81.753 316.384 ↓ 1.0 185,891 1

Hash (cost=15,197.96..15,197.96 rows=182,187 width=120) (actual time=316.384..316.384 rows=185,891 loops=1)

  • Buckets: 262,144 Batches: 1 Memory Usage: 26,805kB
18. 45.136 234.631 ↓ 1.0 185,891 1

Hash Left Join (cost=297.19..15,197.96 rows=182,187 width=120) (actual time=2.283..234.631 rows=185,891 loops=1)

  • Hash Cond: (t_wo.wo_status_id = t_wo_status.wo_status_id)
19. 50.331 189.486 ↓ 1.0 185,891 1

Hash Left Join (cost=296.12..12,691.82 rows=182,187 width=92) (actual time=2.264..189.486 rows=185,891 loops=1)

  • Hash Cond: (t_wo.loc_id = t_location.loc_id)
20. 46.965 136.959 ↓ 1.0 185,891 1

Hash Left Join (cost=2.40..9,912.33 rows=182,187 width=92) (actual time=0.059..136.959 rows=185,891 loops=1)

  • Hash Cond: (t_wo.loc_group_id = t_location_group.loc_group_id)
21. 89.960 89.960 ↓ 1.0 185,891 1

Seq Scan on t_wo (cost=0.00..7,404.86 rows=182,187 width=83) (actual time=0.017..89.960 rows=185,891 loops=1)

  • Filter: (flag = 1)
  • Rows Removed by Filter: 13,929
22. 0.020 0.034 ↑ 1.0 62 1

Hash (cost=1.62..1.62 rows=62 width=17) (actual time=0.034..0.034 rows=62 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
23. 0.014 0.014 ↑ 1.0 62 1

Seq Scan on t_location_group (cost=0.00..1.62 rows=62 width=17) (actual time=0.002..0.014 rows=62 loops=1)

24. 0.257 2.196 ↑ 1.0 1,499 1

Hash (cost=274.99..274.99 rows=1,499 width=8) (actual time=2.196..2.196 rows=1,499 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 75kB
25. 1.939 1.939 ↑ 1.0 1,499 1

Seq Scan on t_location (cost=0.00..274.99 rows=1,499 width=8) (actual time=0.010..1.939 rows=1,499 loops=1)

26. 0.002 0.009 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=36) (actual time=0.009..0.009 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
27. 0.007 0.007 ↑ 1.0 3 1

Seq Scan on t_wo_status (cost=0.00..1.03 rows=3 width=36) (actual time=0.006..0.007 rows=3 loops=1)

28. 0.023 0.062 ↑ 1.0 53 1

Hash (cost=3.53..3.53 rows=53 width=96) (actual time=0.062..0.062 rows=53 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
29. 0.039 0.039 ↑ 1.0 53 1

Seq Scan on t_designators (cost=0.00..3.53 rows=53 width=96) (actual time=0.014..0.039 rows=53 loops=1)

30. 0.018 0.094 ↑ 1.0 52 1

Hash (cost=3.92..3.92 rows=52 width=68) (actual time=0.094..0.094 rows=52 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
31. 0.028 0.076 ↑ 1.0 52 1

Hash Left Join (cost=1.83..3.92 rows=52 width=68) (actual time=0.055..0.076 rows=52 loops=1)

  • Hash Cond: (t_sub_program.program_id = t_program.program_id)
32. 0.015 0.015 ↑ 1.0 52 1

Seq Scan on t_sub_program (cost=0.00..1.52 rows=52 width=40) (actual time=0.010..0.015 rows=52 loops=1)

33. 0.012 0.033 ↑ 1.0 37 1

Hash (cost=1.37..1.37 rows=37 width=36) (actual time=0.033..0.033 rows=37 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
34. 0.021 0.021 ↑ 1.0 37 1

Seq Scan on t_program (cost=0.00..1.37 rows=37 width=36) (actual time=0.011..0.021 rows=37 loops=1)

35. 0.438 0.856 ↓ 1.0 2,047 1

Hash (cost=44.32..44.32 rows=2,032 width=25) (actual time=0.856..0.856 rows=2,047 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 133kB
36. 0.418 0.418 ↓ 1.0 2,047 1

Seq Scan on t_users (cost=0.00..44.32 rows=2,032 width=25) (actual time=0.005..0.418 rows=2,047 loops=1)

37. 0.004 0.016 ↑ 1.0 12 1

Hash (cost=1.12..1.12 rows=12 width=36) (actual time=0.016..0.016 rows=12 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
38. 0.012 0.012 ↑ 1.0 12 1

Seq Scan on t_activity (cost=0.00..1.12 rows=12 width=36) (actual time=0.008..0.012 rows=12 loops=1)

39. 0.002 0.012 ↑ 1.0 1 1

Hash (cost=1.06..1.06 rows=1 width=36) (actual time=0.012..0.012 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
40. 0.010 0.010 ↑ 1.0 1 1

Seq Scan on t_wo_detail_status (cost=0.00..1.06 rows=1 width=36) (actual time=0.009..0.010 rows=1 loops=1)

  • Filter: (wo_detail_status_id = 50)
  • Rows Removed by Filter: 4
41.          

SubPlan (for Hash Left Join)

42. 476.553 7,624.848 ↑ 1.0 1 476,553

Limit (cost=8.46..8.46 rows=1 width=8) (actual time=0.016..0.016 rows=1 loops=476,553)

43. 476.553 7,148.295 ↑ 1.0 1 476,553

Sort (cost=8.46..8.46 rows=1 width=8) (actual time=0.015..0.015 rows=1 loops=476,553)

  • Sort Key: t_log.created_dtm
  • Sort Method: quicksort Memory: 25kB
44. 6,671.742 6,671.742 ↑ 1.0 1 476,553

Index Scan using indc_tlog_comp1 on t_log (cost=0.43..8.45 rows=1 width=8) (actual time=0.014..0.014 rows=1 loops=476,553)

  • Index Cond: (((wo_detail_id)::text = (t_wo_details.wo_detail_id)::text) AND (wo_detail_status_id = 30))
45. 0.000 5,242.083 ↓ 0.0 0 476,553

Limit (cost=8.46..8.46 rows=1 width=10) (actual time=0.011..0.011 rows=0 loops=476,553)

46. 476.553 5,242.083 ↓ 0.0 0 476,553

Sort (cost=8.46..8.46 rows=1 width=10) (actual time=0.011..0.011 rows=0 loops=476,553)

  • Sort Key: t_wo_detail_attributes.wo_detail_attribute_id
  • Sort Method: quicksort Memory: 25kB
47. 4,765.530 4,765.530 ↓ 0.0 0 476,553

Index Scan using indx_twodetailattributes_comp1 on t_wo_detail_attributes (cost=0.42..8.45 rows=1 width=10) (actual time=0.010..0.010 rows=0 loops=476,553)

  • Index Cond: (((wo_detail_id)::text = (t_wo_details.wo_detail_id)::text) AND ((attribute_name)::text = 'status_postgree'::text))
Planning time : 5.272 ms
Execution time : 16,688.810 ms