explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gbSm

Settings
# exclusive inclusive rows x rows loops node
1. 2.485 1,331.010 ↓ 15.6 250 1

Sort (cost=99,472.55..99,472.59 rows=16 width=575) (actual time=1,330.969..1,331.010 rows=250 loops=1)

  • Sort Key: authdef.auth_name, grnt_asg.assign_to_id, item1.item_value, item2.item_value, item3.item_value, item4.item_value, item5.item_value, item6.item_value, item7.item_value, item8.item_value, item9.item_value, item10.item_value, authapp.start_date, authapp.application_id
  • Sort Method: quicksort Memory: 278kB
2. 0.264 1,328.525 ↓ 15.6 250 1

Nested Loop Left Join (cost=88,157.39..99,472.23 rows=16 width=575) (actual time=1,310.713..1,328.525 rows=250 loops=1)

3. 0.189 1,328.261 ↓ 15.6 250 1

Nested Loop Left Join (cost=88,156.97..99,456.50 rows=16 width=586) (actual time=1,310.700..1,328.261 rows=250 loops=1)

4. 0.182 1,326.822 ↓ 15.6 250 1

Nested Loop Left Join (cost=88,156.55..99,447.45 rows=16 width=578) (actual time=1,310.690..1,326.822 rows=250 loops=1)

5. 0.054 1,326.390 ↓ 15.6 250 1

Nested Loop (cost=88,156.40..99,444.53 rows=16 width=565) (actual time=1,310.680..1,326.390 rows=250 loops=1)

  • Join Filter: (((flow.status_id = 'FSAR'::bpchar) AND (assign_appr.part = 'A1'::bpchar)) OR ((flow.status_id = 'SCAR'::bpchar) AND (assign_appr.part = 'A2'::bpchar)))
  • Rows Removed by Join Filter: 213
6. 0.000 1,325.410 ↓ 11.6 463 1

Nested Loop (cost=88,156.10..99,246.68 rows=40 width=572) (actual time=1,310.621..1,325.410 rows=463 loops=1)

7. 0.074 1,322.952 ↓ 1.0 621 1

Nested Loop (cost=88,155.68..98,640.69 rows=616 width=573) (actual time=1,310.597..1,322.952 rows=621 loops=1)

8. 4.515 1,318.531 ↓ 1.0 621 1

Hash Join (cost=88,155.27..98,292.93 rows=615 width=591) (actual time=1,310.561..1,318.531 rows=621 loops=1)

  • Hash Cond: ((authapp.application_id)::text = (curt.application_id)::text)
9. 16.641 1,309.089 ↑ 1.0 42,149 1

Hash Left Join (cost=87,267.72..97,240.81 rows=42,245 width=576) (actual time=1,170.949..1,309.089 rows=42,149 loops=1)

  • Hash Cond: ((authapp.application_id)::text = (appr1_flow2.application_id)::text)
10. 13.323 1,286.678 ↑ 1.0 42,149 1

Hash Left Join (cost=85,784.86..95,010.82 rows=42,245 width=572) (actual time=1,165.115..1,286.678 rows=42,149 loops=1)

  • Hash Cond: (appr1_asg.position_id = appr1_position.position_id)
11. 13.356 1,273.347 ↑ 1.0 42,149 1

Hash Left Join (cost=85,736.61..94,381.71 rows=42,245 width=559) (actual time=1,165.092..1,273.347 rows=42,149 loops=1)

  • Hash Cond: (apct_asg.position_id = apct_position.position_id)
12. 43.808 1,259.980 ↑ 1.0 42,149 1

Hash Right Join (cost=85,688.36..93,752.59 rows=42,245 width=546) (actual time=1,165.061..1,259.980 rows=42,149 loops=1)

  • Hash Cond: ((appr1_flow1.application_id)::text = (authapp.application_id)::text)
13. 22.871 80.468 ↑ 1.0 38,854 1

Hash Right Join (cost=2,467.56..9,994.04 rows=39,020 width=18) (actual time=29.274..80.468 rows=38,854 loops=1)

  • Hash Cond: (appr1_event.flow_id = appr1_flow1.flow_id)
14. 28.673 28.673 ↑ 1.0 81,325 1

Seq Scan on assign appr1_event (cost=0.00..6,884.94 rows=81,659 width=7) (actual time=0.019..28.673 rows=81,325 loops=1)

  • Filter: (part = 'A1'::bpchar)
  • Rows Removed by Filter: 109054
15. 8.885 28.924 ↑ 1.0 38,854 1

Hash (cost=1,979.81..1,979.81 rows=39,020 width=19) (actual time=28.924..28.924 rows=38,854 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2486kB
16. 20.039 20.039 ↑ 1.0 38,854 1

Seq Scan on application_flow appr1_flow1 (cost=0.00..1,979.81 rows=39,020 width=19) (actual time=0.030..20.039 rows=38,854 loops=1)

  • Filter: (status_id = 'FIXD'::bpchar)
  • Rows Removed by Filter: 56171
17. 47.670 1,135.704 ↑ 1.0 42,149 1

Hash (cost=82,692.74..82,692.74 rows=42,245 width=539) (actual time=1,135.704..1,135.704 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 20121kB
18. 54.368 1,088.034 ↑ 1.0 42,149 1

Hash Right Join (cost=75,138.55..82,692.74 rows=42,245 width=539) (actual time=1,000.489..1,088.034 rows=42,149 loops=1)

  • Hash Cond: (appr1_asg.flow_id = fsar.flow_id)
19. 33.292 33.292 ↑ 1.0 81,325 1

Seq Scan on assign appr1_asg (cost=0.00..6,884.94 rows=81,659 width=91) (actual time=0.029..33.292 rows=81,325 loops=1)

  • Filter: (part = 'A1'::bpchar)
  • Rows Removed by Filter: 109054
20. 32.511 1,000.374 ↑ 1.0 42,149 1

Hash (cost=74,610.49..74,610.49 rows=42,245 width=456) (actual time=1,000.374..1,000.374 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 16697kB
21. 32.574 967.863 ↑ 1.0 42,149 1

Hash Right Join (cost=67,546.06..74,610.49 rows=42,245 width=456) (actual time=912.120..967.863 rows=42,149 loops=1)

  • Hash Cond: (appr2_asg.flow_id = fsar.flow_id)
22. 23.291 23.291 ↓ 1.1 23,119 1

Seq Scan on assign appr2_asg (cost=0.00..6,884.94 rows=21,900 width=91) (actual time=0.031..23.291 rows=23,119 loops=1)

  • Filter: (part = 'A2'::bpchar)
  • Rows Removed by Filter: 167260
23. 45.162 911.998 ↑ 1.0 42,149 1

Hash (cost=67,018.00..67,018.00 rows=42,245 width=369) (actual time=911.998..911.998 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 15727kB
24. 16.432 866.836 ↑ 1.0 42,149 1

Hash Join (cost=56,869.57..67,018.00 rows=42,245 width=369) (actual time=707.448..866.836 rows=42,149 loops=1)

  • Hash Cond: (current.application_status_id = status.application_status_id)
25. 15.735 850.392 ↑ 1.0 42,149 1

Hash Join (cost=56,818.85..66,386.41 rows=42,245 width=357) (actual time=707.423..850.392 rows=42,149 loops=1)

  • Hash Cond: (flow_1.status_id = flow_status.status_id)
26. 37.203 834.651 ↑ 1.0 42,149 1

Hash Right Join (cost=56,774.88..65,761.56 rows=42,245 width=340) (actual time=707.407..834.651 rows=42,149 loops=1)

  • Hash Cond: ((fsar.application_id)::text = (authapp.application_id)::text)
27. 12.464 191.295 ↑ 1.0 42,149 1

Hash Left Join (cost=10,363.52..18,769.68 rows=42,153 width=172) (actual time=101.175..191.295 rows=42,149 loops=1)

  • Hash Cond: (grnt_asg.contract_id = grnt_contract.contract_id)
28. 12.993 178.819 ↑ 1.0 42,149 1

Hash Left Join (cost=10,313.69..18,140.26 rows=42,153 width=160) (actual time=101.141..178.819 rows=42,149 loops=1)

  • Hash Cond: (grnt_asg.position_id = grnt_position.position_id)
29. 28.127 165.809 ↑ 1.0 42,149 1

Hash Right Join (cost=10,265.44..17,512.40 rows=42,153 width=147) (actual time=101.100..165.809 rows=42,149 loops=1)

  • Hash Cond: (apct_asg.flow_id = fsar.flow_id)
30. 36.844 36.844 ↑ 1.0 43,786 1

Seq Scan on assign apct_asg (cost=0.00..6,884.94 rows=44,224 width=51) (actual time=0.029..36.844 rows=43,786 loops=1)

  • Filter: (part = 'AP'::bpchar)
  • Rows Removed by Filter: 146593
31. 20.133 100.838 ↑ 1.0 42,149 1

Hash (cost=9,738.53..9,738.53 rows=42,153 width=100) (actual time=100.838..100.838 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 6100kB
32. 23.236 80.705 ↑ 1.0 42,149 1

Hash Right Join (cost=2,506.72..9,738.53 rows=42,153 width=100) (actual time=22.346..80.705 rows=42,149 loops=1)

  • Hash Cond: (grnt_asg.flow_id = fsar.flow_id)
33. 35.368 35.368 ↑ 1.0 42,149 1

Seq Scan on assign grnt_asg (cost=0.00..6,884.94 rows=42,373 width=85) (actual time=0.023..35.368 rows=42,149 loops=1)

  • Filter: (part = 'GR'::bpchar)
  • Rows Removed by Filter: 148230
34. 7.272 22.101 ↑ 1.0 42,149 1

Hash (cost=1,979.81..1,979.81 rows=42,153 width=19) (actual time=22.101..22.101 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2653kB
35. 14.829 14.829 ↑ 1.0 42,149 1

Seq Scan on application_flow fsar (cost=0.00..1,979.81 rows=42,153 width=19) (actual time=0.028..14.829 rows=42,149 loops=1)

  • Filter: (status_id = 'FSAR'::bpchar)
  • Rows Removed by Filter: 52876
36. 0.009 0.017 ↑ 170.0 10 1

Hash (cost=27.00..27.00 rows=1,700 width=16) (actual time=0.017..0.017 rows=10 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
37. 0.008 0.008 ↑ 170.0 10 1

Seq Scan on job_position grnt_position (cost=0.00..27.00 rows=1,700 width=16) (actual time=0.006..0.008 rows=10 loops=1)

38. 0.004 0.012 ↑ 252.9 7 1

Hash (cost=27.70..27.70 rows=1,770 width=14) (actual time=0.012..0.012 rows=7 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
39. 0.008 0.008 ↑ 252.9 7 1

Seq Scan on contract grnt_contract (cost=0.00..27.70 rows=1,770 width=14) (actual time=0.005..0.008 rows=7 loops=1)

40. 18.324 606.153 ↑ 1.0 42,149 1

Hash (cost=45,883.79..45,883.79 rows=42,205 width=179) (actual time=606.153..606.153 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 8035kB
41. 16.279 587.829 ↑ 1.0 42,149 1

Hash Join (cost=42,063.37..45,883.79 rows=42,205 width=179) (actual time=551.783..587.829 rows=42,149 loops=1)

  • Hash Cond: ((authapp.application_id)::text = (current.application_id)::text)
42. 11.045 517.508 ↑ 1.0 42,149 1

Hash Right Join (cost=37,712.47..40,952.58 rows=42,205 width=142) (actual time=497.659..517.508 rows=42,149 loops=1)

  • Hash Cond: ((item6.application_id)::text = (authapp.application_id)::text)
43. 13.400 13.400 ↓ 1.1 7,608 1

Seq Scan on item item6 (cost=0.00..3,142.34 rows=7,099 width=15) (actual time=4.505..13.400 rows=7,608 loops=1)

  • Filter: (item_index = 6)
  • Rows Removed by Filter: 154089
44. 12.872 493.063 ↑ 1.0 42,149 1

Hash (cost=37,184.90..37,184.90 rows=42,205 width=138) (actual time=493.063..493.063 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 6406kB
45. 10.792 480.191 ↑ 1.0 42,149 1

Hash Right Join (cost=33,954.22..37,184.90 rows=42,205 width=138) (actual time=458.892..480.191 rows=42,149 loops=1)

  • Hash Cond: ((item8.application_id)::text = (authapp.application_id)::text)
46. 15.752 15.752 ↑ 1.0 6,157 1

Seq Scan on item item8 (cost=0.00..3,142.34 rows=6,415 width=15) (actual time=5.155..15.752 rows=6,157 loops=1)

  • Filter: (item_index = 8)
  • Rows Removed by Filter: 155540
47. 11.885 453.647 ↑ 1.0 42,149 1

Hash (cost=33,426.66..33,426.66 rows=42,205 width=134) (actual time=453.647..453.647 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 6400kB
48. 10.986 441.762 ↑ 1.0 42,149 1

Hash Right Join (cost=30,196.11..33,426.66 rows=42,205 width=134) (actual time=420.760..441.762 rows=42,149 loops=1)

  • Hash Cond: ((item9.application_id)::text = (authapp.application_id)::text)
49. 14.806 14.806 ↑ 1.0 6,157 1

Seq Scan on item item9 (cost=0.00..3,142.34 rows=6,405 width=15) (actual time=4.704..14.806 rows=6,157 loops=1)

  • Filter: (item_index = 9)
  • Rows Removed by Filter: 155540
50. 10.788 415.970 ↑ 1.0 42,149 1

Hash (cost=29,668.55..29,668.55 rows=42,205 width=130) (actual time=415.970..415.970 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 6394kB
51. 9.737 405.182 ↑ 1.0 42,149 1

Hash Right Join (cost=26,438.00..29,668.55 rows=42,205 width=130) (actual time=386.694..405.182 rows=42,149 loops=1)

  • Hash Cond: ((item7.application_id)::text = (authapp.application_id)::text)
52. 13.382 13.382 ↑ 1.0 6,233 1

Seq Scan on item item7 (cost=0.00..3,142.34 rows=6,405 width=15) (actual time=4.547..13.382 rows=6,233 loops=1)

  • Filter: (item_index = 7)
  • Rows Removed by Filter: 155464
53. 11.402 382.063 ↑ 1.0 42,149 1

Hash (cost=25,910.44..25,910.44 rows=42,205 width=126) (actual time=382.062..382.063 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 6382kB
54. 15.324 370.661 ↑ 1.0 42,149 1

Hash Right Join (cost=22,681.09..25,910.44 rows=42,205 width=126) (actual time=346.170..370.661 rows=42,149 loops=1)

  • Hash Cond: ((item10.application_id)::text = (authapp.application_id)::text)
55. 13.851 13.851 ↑ 1.0 6,157 1

Seq Scan on item item10 (cost=0.00..3,142.34 rows=6,318 width=15) (actual time=4.598..13.851 rows=6,157 loops=1)

  • Filter: (item_index = 10)
  • Rows Removed by Filter: 155540
56. 18.132 341.486 ↑ 1.0 42,149 1

Hash (cost=22,153.53..22,153.53 rows=42,205 width=122) (actual time=341.486..341.486 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 6263kB
57. 15.029 323.354 ↑ 1.0 42,149 1

Hash Join (cost=17,270.24..22,153.53 rows=42,205 width=122) (actual time=245.729..323.354 rows=42,149 loops=1)

  • Hash Cond: (authapp.operation_id = ope.operation_id)
58. 13.261 308.311 ↑ 1.0 42,149 1

Hash Join (cost=17,269.15..21,572.12 rows=42,205 width=114) (actual time=245.705..308.311 rows=42,149 loops=1)

  • Hash Cond: ((authapp.auth_id)::text = (authdef.auth_id)::text)
59. 23.881 295.026 ↑ 1.0 42,149 1

Hash Right Join (cost=17,267.27..20,989.92 rows=42,205 width=60) (actual time=245.673..295.026 rows=42,149 loops=1)

  • Hash Cond: ((item1.application_id)::text = (authapp.application_id)::text)
60. 25.585 25.585 ↑ 1.0 42,114 1

Seq Scan on item item1 (cost=0.00..3,142.34 rows=42,205 width=15) (actual time=0.031..25.585 rows=42,114 loops=1)

  • Filter: (item_index = 1)
  • Rows Removed by Filter: 119583
61. 13.975 245.560 ↓ 1.0 42,149 1

Hash (cost=16,740.86..16,740.86 rows=42,113 width=56) (actual time=245.560..245.560 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 4144kB
62. 19.410 231.585 ↓ 1.0 42,149 1

Hash Right Join (cost=13,265.97..16,740.86 rows=42,113 width=56) (actual time=185.951..231.585 rows=42,149 loops=1)

  • Hash Cond: ((item2.application_id)::text = (authapp.application_id)::text)
63. 26.341 26.341 ↑ 1.0 23,447 1

Seq Scan on item item2 (cost=0.00..3,142.34 rows=24,185 width=15) (actual time=0.032..26.341 rows=23,447 loops=1)

  • Filter: (item_index = 2)
  • Rows Removed by Filter: 138250
64. 17.009 185.834 ↓ 1.0 42,149 1

Hash (cost=12,739.56..12,739.56 rows=42,113 width=52) (actual time=185.834..185.834 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 4048kB
65. 21.791 168.825 ↓ 1.0 42,149 1

Hash Right Join (cost=9,296.99..12,739.56 rows=42,113 width=52) (actual time=119.436..168.825 rows=42,149 loops=1)

  • Hash Cond: ((item3.application_id)::text = (authapp.application_id)::text)
66. 29.615 29.615 ↓ 1.0 21,840 1

Seq Scan on item item3 (cost=0.00..3,142.34 rows=21,835 width=15) (actual time=1.930..29.615 rows=21,840 loops=1)

  • Filter: (item_index = 3)
  • Rows Removed by Filter: 139857
67. 15.889 117.419 ↓ 1.0 42,149 1

Hash (cost=8,770.58..8,770.58 rows=42,113 width=48) (actual time=117.419..117.419 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3742kB
68. 21.534 101.530 ↓ 1.0 42,149 1

Hash Right Join (cost=5,333.39..8,770.58 rows=42,113 width=48) (actual time=54.190..101.530 rows=42,149 loops=1)

  • Hash Cond: ((item4.application_id)::text = (authapp.application_id)::text)
69. 26.787 26.787 ↑ 1.0 21,419 1

Seq Scan on item item4 (cost=0.00..3,142.34 rows=21,444 width=15) (actual time=0.893..26.787 rows=21,419 loops=1)

  • Filter: (item_index = 4)
  • Rows Removed by Filter: 140278
70. 9.127 53.209 ↓ 1.0 42,149 1

Hash (cost=4,806.98..4,806.98 rows=42,113 width=44) (actual time=53.209..53.209 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3642kB
71. 14.499 44.082 ↓ 1.0 42,149 1

Hash Right Join (cost=1,382.54..4,806.98 rows=42,113 width=44) (actual time=15.897..44.082 rows=42,149 loops=1)

  • Hash Cond: ((item5.application_id)::text = (authapp.application_id)::text)
72. 14.652 14.652 ↓ 1.0 20,565 1

Seq Scan on item item5 (cost=0.00..3,142.34 rows=20,516 width=15) (actual time=0.881..14.652 rows=20,565 loops=1)

  • Filter: (item_index = 5)
  • Rows Removed by Filter: 141132
73. 7.546 14.931 ↓ 1.0 42,149 1

Hash (cost=856.13..856.13 rows=42,113 width=40) (actual time=14.931..14.931 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3600kB
74. 7.385 7.385 ↓ 1.0 42,149 1

Seq Scan on authority_application authapp (cost=0.00..856.13 rows=42,113 width=40) (actual time=0.007..7.385 rows=42,149 loops=1)

75. 0.008 0.024 ↑ 1.0 39 1

Hash (cost=1.39..1.39 rows=39 width=62) (actual time=0.024..0.024 rows=39 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
76. 0.016 0.016 ↑ 1.0 39 1

Seq Scan on authority_definition authdef (cost=0.00..1.39 rows=39 width=62) (actual time=0.007..0.016 rows=39 loops=1)

77. 0.003 0.014 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=11) (actual time=0.014..0.014 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
78. 0.011 0.011 ↑ 1.0 4 1

Seq Scan on application_operation ope (cost=0.00..1.04 rows=4 width=11) (actual time=0.011..0.011 rows=4 loops=1)

79. 9.230 54.042 ↑ 1.0 42,149 1

Hash (cost=3,823.04..3,823.04 rows=42,229 width=37) (actual time=54.042..54.042 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3476kB
80. 24.652 44.812 ↑ 1.0 42,149 1

Hash Join (cost=1,302.15..3,823.04 rows=42,229 width=37) (actual time=13.170..44.812 rows=42,149 loops=1)

  • Hash Cond: (flow_1.flow_id = current.flow_id)
81. 7.085 7.085 ↑ 1.0 95,025 1

Seq Scan on application_flow flow_1 (cost=0.00..1,742.25 rows=95,025 width=13) (actual time=0.006..7.085 rows=95,025 loops=1)

82. 6.365 13.075 ↑ 1.0 42,149 1

Hash (cost=774.29..774.29 rows=42,229 width=28) (actual time=13.075..13.075 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3147kB
83. 6.710 6.710 ↑ 1.0 42,149 1

Seq Scan on current_flow current (cost=0.00..774.29 rows=42,229 width=28) (actual time=0.008..6.710 rows=42,149 loops=1)

84. 0.001 0.006 ↑ 251.7 6 1

Hash (cost=25.10..25.10 rows=1,510 width=22) (actual time=0.006..0.006 rows=6 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
85. 0.005 0.005 ↑ 251.7 6 1

Seq Scan on flow_status (cost=0.00..25.10 rows=1,510 width=22) (actual time=0.004..0.005 rows=6 loops=1)

86. 0.003 0.012 ↑ 258.6 7 1

Hash (cost=28.10..28.10 rows=1,810 width=17) (actual time=0.012..0.012 rows=7 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
87. 0.009 0.009 ↑ 258.6 7 1

Seq Scan on application_status status (cost=0.00..28.10 rows=1,810 width=17) (actual time=0.008..0.009 rows=7 loops=1)

88. 0.004 0.011 ↑ 170.0 10 1

Hash (cost=27.00..27.00 rows=1,700 width=16) (actual time=0.011..0.011 rows=10 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
89. 0.007 0.007 ↑ 170.0 10 1

Seq Scan on job_position apct_position (cost=0.00..27.00 rows=1,700 width=16) (actual time=0.004..0.007 rows=10 loops=1)

90. 0.006 0.008 ↑ 170.0 10 1

Hash (cost=27.00..27.00 rows=1,700 width=16) (actual time=0.008..0.008 rows=10 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
91. 0.002 0.002 ↑ 170.0 10 1

Seq Scan on job_position appr1_position (cost=0.00..27.00 rows=1,700 width=16) (actual time=0.001..0.002 rows=10 loops=1)

92. 2.277 5.770 ↓ 1.0 11,379 1

Hash (cost=1,341.47..1,341.47 rows=11,311 width=15) (actual time=5.770..5.770 rows=11,379 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 651kB
93. 2.555 3.493 ↓ 1.0 11,379 1

Bitmap Heap Scan on application_flow appr1_flow2 (cost=408.08..1,341.47 rows=11,311 width=15) (actual time=0.973..3.493 rows=11,379 loops=1)

  • Recheck Cond: (status_id = 'SCAR'::bpchar)
  • Heap Blocks: exact=331
94. 0.938 0.938 ↓ 1.0 11,379 1

Bitmap Index Scan on idx_application_flow (cost=0.00..405.25 rows=11,311 width=0) (actual time=0.938..0.938 rows=11,379 loops=1)

  • Index Cond: (status_id = 'SCAR'::bpchar)
95. 0.090 4.927 ↓ 1.0 621 1

Hash (cost=879.86..879.86 rows=615 width=15) (actual time=4.927..4.927 rows=621 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 38kB
96. 4.837 4.837 ↓ 1.0 621 1

Seq Scan on current_flow curt (cost=0.00..879.86 rows=615 width=15) (actual time=0.141..4.837 rows=621 loops=1)

  • Filter: (application_status_id = 'WINP'::bpchar)
  • Rows Removed by Filter: 41528
97. 4.347 4.347 ↑ 1.0 1 621

Index Scan using ak_application_flow on application_flow flow_fsar (cost=0.42..0.56 rows=1 width=15) (actual time=0.007..0.007 rows=1 loops=621)

  • Index Cond: (((application_id)::text = (authapp.application_id)::text) AND (status_id = 'FSAR'::bpchar))
98. 2.484 2.484 ↑ 1.0 1 621

Index Scan using idx_assign on assign assign_appr (cost=0.42..0.97 rows=1 width=7) (actual time=0.003..0.004 rows=1 loops=621)

  • Index Cond: (((assign_to_id)::text = '20275075'::text) AND (flow_id = flow_fsar.flow_id))
  • Filter: ((part = 'A1'::bpchar) OR (part = 'A2'::bpchar))
99. 0.926 0.926 ↑ 1.0 1 463

Index Scan using pk_application_flow on application_flow flow (cost=0.29..4.93 rows=1 width=9) (actual time=0.001..0.002 rows=1 loops=463)

  • Index Cond: (flow_id = curt.flow_id)
  • Filter: ((status_id = 'FSAR'::bpchar) OR (status_id = 'SCAR'::bpchar))
100. 0.250 0.250 ↑ 1.0 1 250

Index Scan using pk_job_position on job_position appr2_position (cost=0.15..0.17 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=250)

  • Index Cond: (appr2_asg.position_id = position_id)
101. 1.250 1.250 ↓ 0.0 0 250

Index Scan using ak_application_flow on application_flow appr2_flow (cost=0.42..0.56 rows=1 width=19) (actual time=0.005..0.005 rows=0 loops=250)

  • Index Cond: (((authapp.application_id)::text = (application_id)::text) AND (status_id = 'FIXD'::bpchar))
102. 0.000 0.000 ↓ 0.0 0 250

Index Only Scan using pk_assign on assign appr2_event (cost=0.42..0.96 rows=1 width=7) (actual time=0.000..0.000 rows=0 loops=250)

  • Index Cond: ((flow_id = appr2_flow.flow_id) AND (part = 'A2'::bpchar))
  • Heap Fetches: 0
Planning time : 16.584 ms
Execution time : 1,332.124 ms