explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q9vH

Settings
# exclusive inclusive rows x rows loops node
1. 1.859 21,568.039 ↓ 161.0 161 1

Sort (cost=99,777.64..99,777.64 rows=1 width=575) (actual time=21,568.008..21,568.039 rows=161 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: 188kB
2. 1.300 21,566.180 ↓ 161.0 161 1

Nested Loop (cost=87,078.82..99,777.63 rows=1 width=575) (actual time=1,104.960..21,566.180 rows=161 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)))
3. 0.421 21,563.592 ↓ 161.0 161 1

Nested Loop Left Join (cost=87,078.53..99,772.67 rows=1 width=592) (actual time=1,104.928..21,563.592 rows=161 loops=1)

4. 0.573 21,563.010 ↓ 161.0 161 1

Nested Loop Left Join (cost=87,078.11..99,771.70 rows=1 width=593) (actual time=1,104.923..21,563.010 rows=161 loops=1)

5. 1.172 21,560.183 ↓ 161.0 161 1

Nested Loop Left Join (cost=87,077.69..99,771.13 rows=1 width=585) (actual time=1,104.905..21,560.183 rows=161 loops=1)

6. 765.017 21,556.596 ↓ 161.0 161 1

Nested Loop (cost=87,077.54..99,770.95 rows=1 width=572) (actual time=1,104.872..21,556.596 rows=161 loops=1)

  • Join Filter: ((curt.application_id)::text = (authapp.application_id)::text)
  • Rows Removed by Join Filter: 6785828
7. 0.312 5.191 ↓ 161.0 161 1

Nested Loop (cost=11.52..2,209.92 rows=1 width=29) (actual time=0.903..5.191 rows=161 loops=1)

8. 0.354 2.206 ↓ 3.4 243 1

Nested Loop (cost=11.23..2,182.70 rows=72 width=14) (actual time=0.081..2.206 rows=243 loops=1)

9. 0.482 0.528 ↓ 2.0 331 1

Bitmap Heap Scan on assign assign_appr (cost=10.94..1,038.14 rows=163 width=7) (actual time=0.069..0.528 rows=331 loops=1)

  • Recheck Cond: ((assign_to_id)::text = '10238102'::text)
  • Filter: ((part = 'A1'::bpchar) OR (part = 'A2'::bpchar))
  • Rows Removed by Filter: 9
  • Heap Blocks: exact=96
10. 0.046 0.046 ↓ 1.0 340 1

Bitmap Index Scan on idx_assign (cost=0.00..10.89 rows=330 width=0) (actual time=0.046..0.046 rows=340 loops=1)

  • Index Cond: ((assign_to_id)::text = '10238102'::text)
11. 1.324 1.324 ↑ 1.0 1 331

Index Scan using pk_application_flow on application_flow flow_fsar (cost=0.29..7.01 rows=1 width=15) (actual time=0.004..0.004 rows=1 loops=331)

  • Index Cond: (flow_id = assign_appr.flow_id)
  • Filter: (status_id = 'FSAR'::bpchar)
  • Rows Removed by Filter: 0
12. 2.673 2.673 ↑ 1.0 1 243

Index Scan using pk_current_flow_id on current_flow curt (cost=0.29..0.37 rows=1 width=15) (actual time=0.010..0.011 rows=1 loops=243)

  • Index Cond: ((application_id)::text = (flow_fsar.application_id)::text)
  • Filter: (application_status_id = 'WINP'::bpchar)
  • Rows Removed by Filter: 0
13. 2,189.018 20,786.388 ↑ 1.0 42,149 161

Hash Left Join (cost=87,066.02..97,034.12 rows=42,153 width=576) (actual time=6.117..129.108 rows=42,149 loops=161)

  • Hash Cond: ((authapp.application_id)::text = (appr1_flow2.application_id)::text)
14. 2,055.480 18,593.407 ↑ 1.0 42,149 161

Hash Left Join (cost=85,583.17..94,805.75 rows=42,153 width=572) (actual time=6.091..115.487 rows=42,149 loops=161)

  • Hash Cond: (appr1_asg.position_id = appr1_position.position_id)
15. 2,081.881 16,537.920 ↑ 1.0 42,149 161

Hash Left Join (cost=85,534.92..94,177.90 rows=42,153 width=559) (actual time=6.091..102.720 rows=42,149 loops=161)

  • Hash Cond: (apct_asg.position_id = apct_position.position_id)
16. 6,402.723 14,456.029 ↑ 1.0 42,149 161

Hash Right Join (cost=85,486.67..93,550.04 rows=42,153 width=546) (actual time=6.090..89.789 rows=42,149 loops=161)

  • Hash Cond: ((appr1_flow1.application_id)::text = (authapp.application_id)::text)
17. 2,765.069 7,098.329 ↑ 1.0 38,854 161

Hash Right Join (cost=2,467.56..9,994.04 rows=39,020 width=18) (actual time=0.156..44.089 rows=38,854 loops=161)

  • Hash Cond: (appr1_event.flow_id = appr1_flow1.flow_id)
18. 4,315.122 4,315.122 ↑ 1.0 81,325 161

Seq Scan on assign appr1_event (cost=0.00..6,884.94 rows=81,659 width=7) (actual time=0.006..26.802 rows=81,325 loops=161)

  • Filter: (part = 'A1'::bpchar)
  • Rows Removed by Filter: 109054
19. 5.726 18.138 ↑ 1.0 38,854 1

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

  • Buckets: 65536 Batches: 1 Memory Usage: 2486kB
20. 12.412 12.412 ↑ 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.016..12.412 rows=38,854 loops=1)

  • Filter: (status_id = 'FIXD'::bpchar)
  • Rows Removed by Filter: 56171
21. 41.771 954.977 ↑ 1.0 42,149 1

Hash (cost=82,492.19..82,492.19 rows=42,153 width=539) (actual time=954.977..954.977 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 20121kB
22. 46.301 913.206 ↑ 1.0 42,149 1

Hash Right Join (cost=74,938.80..82,492.19 rows=42,153 width=539) (actual time=837.682..913.206 rows=42,149 loops=1)

  • Hash Cond: (appr1_asg.flow_id = fsar.flow_id)
23. 29.336 29.336 ↑ 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.028..29.336 rows=81,325 loops=1)

  • Filter: (part = 'A1'::bpchar)
  • Rows Removed by Filter: 109054
24. 33.316 837.569 ↑ 1.0 42,149 1

Hash (cost=74,411.88..74,411.88 rows=42,153 width=456) (actual time=837.569..837.569 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 16697kB
25. 31.569 804.253 ↑ 1.0 42,149 1

Hash Right Join (cost=67,347.67..74,411.88 rows=42,153 width=456) (actual time=749.438..804.253 rows=42,149 loops=1)

  • Hash Cond: (appr2_asg.flow_id = fsar.flow_id)
26. 23.351 23.351 ↓ 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.021..23.351 rows=23,119 loops=1)

  • Filter: (part = 'A2'::bpchar)
  • Rows Removed by Filter: 167260
27. 34.824 749.333 ↑ 1.0 42,149 1

Hash (cost=66,820.76..66,820.76 rows=42,153 width=369) (actual time=749.333..749.333 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 15727kB
28. 12.775 714.509 ↑ 1.0 42,149 1

Hash Left Join (cost=56,675.78..66,820.76 rows=42,153 width=369) (actual time=591.471..714.509 rows=42,149 loops=1)

  • Hash Cond: (grnt_asg.contract_id = grnt_contract.contract_id)
29. 12.187 701.724 ↑ 1.0 42,149 1

Hash Left Join (cost=56,625.96..66,191.33 rows=42,153 width=357) (actual time=591.437..701.724 rows=42,149 loops=1)

  • Hash Cond: (grnt_asg.position_id = grnt_position.position_id)
30. 11.894 689.528 ↑ 1.0 42,149 1

Hash Join (cost=56,577.71..65,563.48 rows=42,153 width=344) (actual time=591.408..689.528 rows=42,149 loops=1)

  • Hash Cond: (current.application_status_id = status.application_status_id)
31. 11.336 677.624 ↑ 1.0 42,149 1

Hash Join (cost=56,526.98..64,933.15 rows=42,153 width=332) (actual time=591.388..677.624 rows=42,149 loops=1)

  • Hash Cond: (flow_1.status_id = flow_status.status_id)
32. 27.818 666.284 ↑ 1.0 42,149 1

Hash Right Join (cost=56,483.01..64,309.57 rows=42,153 width=315) (actual time=591.376..666.284 rows=42,149 loops=1)

  • Hash Cond: ((fsar.application_id)::text = (authapp.application_id)::text)
33. 20.261 127.855 ↑ 1.0 42,149 1

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

  • Hash Cond: (apct_asg.flow_id = fsar.flow_id)
34. 27.161 27.161 ↑ 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.019..27.161 rows=43,786 loops=1)

  • Filter: (part = 'AP'::bpchar)
  • Rows Removed by Filter: 146593
35. 16.236 80.433 ↑ 1.0 42,149 1

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

  • Buckets: 65536 Batches: 1 Memory Usage: 6100kB
36. 16.462 64.197 ↑ 1.0 42,149 1

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

  • Hash Cond: (grnt_asg.flow_id = fsar.flow_id)
37. 28.471 28.471 ↑ 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.015..28.471 rows=42,149 loops=1)

  • Filter: (part = 'GR'::bpchar)
  • Rows Removed by Filter: 148230
38. 6.381 19.264 ↑ 1.0 42,149 1

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

  • Buckets: 65536 Batches: 1 Memory Usage: 2653kB
39. 12.883 12.883 ↑ 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.019..12.883 rows=42,149 loops=1)

  • Filter: (status_id = 'FSAR'::bpchar)
  • Rows Removed by Filter: 52876
40. 18.299 510.611 ↓ 1.0 42,149 1

Hash (cost=45,691.15..45,691.15 rows=42,113 width=179) (actual time=510.611..510.611 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 8035kB
41. 16.160 492.312 ↓ 1.0 42,149 1

Hash Join (cost=41,889.70..45,691.15 rows=42,113 width=179) (actual time=456.881..492.312 rows=42,149 loops=1)

  • Hash Cond: ((authapp.application_id)::text = (current.application_id)::text)
42. 10.639 425.803 ↓ 1.0 42,149 1

Hash Right Join (cost=37,538.80..40,761.20 rows=42,113 width=142) (actual time=406.453..425.803 rows=42,149 loops=1)

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

Seq Scan on item item6 (cost=0.00..3,125.31 rows=7,061 width=15) (actual time=4.445..13.242 rows=7,608 loops=1)

  • Filter: (item_index = 6)
  • Rows Removed by Filter: 154089
44. 11.880 401.922 ↓ 1.0 42,149 1

Hash (cost=37,012.38..37,012.38 rows=42,113 width=138) (actual time=401.921..401.922 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 6406kB
45. 9.256 390.042 ↓ 1.0 42,149 1

Hash Right Join (cost=33,799.33..37,012.38 rows=42,113 width=138) (actual time=372.302..390.042 rows=42,149 loops=1)

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

Seq Scan on item item8 (cost=0.00..3,125.31 rows=6,381 width=15) (actual time=4.463..13.023 rows=6,157 loops=1)

  • Filter: (item_index = 8)
  • Rows Removed by Filter: 155540
47. 11.183 367.763 ↓ 1.0 42,149 1

Hash (cost=33,272.92..33,272.92 rows=42,113 width=134) (actual time=367.763..367.763 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 6400kB
48. 9.096 356.580 ↓ 1.0 42,149 1

Hash Right Join (cost=30,060.02..33,272.92 rows=42,113 width=134) (actual time=339.005..356.580 rows=42,149 loops=1)

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

Seq Scan on item item9 (cost=0.00..3,125.31 rows=6,370 width=15) (actual time=4.446..13.002 rows=6,157 loops=1)

  • Filter: (item_index = 9)
  • Rows Removed by Filter: 155540
50. 10.848 334.482 ↓ 1.0 42,149 1

Hash (cost=29,533.61..29,533.61 rows=42,113 width=130) (actual time=334.482..334.482 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 6394kB
51. 9.071 323.634 ↓ 1.0 42,149 1

Hash Right Join (cost=26,320.71..29,533.61 rows=42,113 width=130) (actual time=306.015..323.634 rows=42,149 loops=1)

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

Seq Scan on item item7 (cost=0.00..3,125.31 rows=6,370 width=15) (actual time=4.544..13.178 rows=6,233 loops=1)

  • Filter: (item_index = 7)
  • Rows Removed by Filter: 155464
53. 12.468 301.385 ↓ 1.0 42,149 1

Hash (cost=25,794.30..25,794.30 rows=42,113 width=126) (actual time=301.385..301.385 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 6382kB
54. 15.032 288.917 ↓ 1.0 42,149 1

Hash Right Join (cost=22,582.59..25,794.30 rows=42,113 width=126) (actual time=260.558..288.917 rows=42,149 loops=1)

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

Seq Scan on item item10 (cost=0.00..3,125.31 rows=6,283 width=15) (actual time=5.274..18.679 rows=6,157 loops=1)

  • Filter: (item_index = 10)
  • Rows Removed by Filter: 155540
56. 15.343 255.206 ↓ 1.0 42,149 1

Hash (cost=22,056.18..22,056.18 rows=42,113 width=122) (actual time=255.206..255.206 rows=42,149 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 6263kB
57. 14.209 239.863 ↓ 1.0 42,149 1

Hash Join (cost=17,195.59..22,056.18 rows=42,113 width=122) (actual time=170.495..239.863 rows=42,149 loops=1)

  • Hash Cond: (authapp.operation_id = ope.operation_id)
58. 12.252 225.637 ↓ 1.0 42,149 1

Hash Join (cost=17,194.50..21,476.04 rows=42,113 width=114) (actual time=170.469..225.637 rows=42,149 loops=1)

  • Hash Cond: ((authapp.auth_id)::text = (authdef.auth_id)::text)
59. 19.695 213.367 ↓ 1.0 42,149 1

Hash Right Join (cost=17,192.62..20,895.10 rows=42,113 width=60) (actual time=170.445..213.367 rows=42,149 loops=1)

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

Seq Scan on item item1 (cost=0.00..3,125.31 rows=41,976 width=15) (actual time=0.020..23.312 rows=42,114 loops=1)

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

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

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

Hash Right Join (cost=13,210.16..16,666.21 rows=42,113 width=56) (actual time=126.684..159.865 rows=42,149 loops=1)

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

Seq Scan on item item2 (cost=0.00..3,125.31 rows=24,054 width=15) (actual time=0.025..18.478 rows=23,447 loops=1)

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

Hash (cost=12,683.74..12,683.74 rows=42,113 width=52) (actual time=126.591..126.592 rows=42,149 loops=1)

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

Hash Right Join (cost=9,259.82..12,683.74 rows=42,113 width=52) (actual time=90.467..117.548 rows=42,149 loops=1)

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

Seq Scan on item item3 (cost=0.00..3,125.31 rows=21,717 width=15) (actual time=0.901..15.170 rows=21,840 loops=1)

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

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

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

Hash Right Join (cost=5,314.84..8,733.41 rows=42,113 width=48) (actual time=52.592..80.690 rows=42,149 loops=1)

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

Seq Scan on item item4 (cost=0.00..3,125.31 rows=21,328 width=15) (actual time=1.086..15.744 rows=21,419 loops=1)

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

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

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

Hash Right Join (cost=1,382.54..4,788.42 rows=42,113 width=44) (actual time=14.775..42.740 rows=42,149 loops=1)

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

Seq Scan on item item5 (cost=0.00..3,125.31 rows=20,405 width=15) (actual time=0.901..15.895 rows=20,565 loops=1)

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

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

  • Buckets: 65536 Batches: 1 Memory Usage: 3600kB
74. 6.992 6.992 ↓ 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..6.992 rows=42,149 loops=1)

75. 0.006 0.018 ↑ 1.0 39 1

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

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

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

77. 0.004 0.017 ↑ 1.0 4 1

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

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

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

79. 8.822 50.349 ↑ 1.0 42,149 1

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

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

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

  • Hash Cond: (flow_1.flow_id = current.flow_id)
81. 7.483 7.483 ↑ 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.005..7.483 rows=95,025 loops=1)

82. 5.634 11.819 ↑ 1.0 42,149 1

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

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

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

84. 0.001 0.004 ↑ 251.7 6 1

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

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

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

86. 0.004 0.010 ↑ 258.6 7 1

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

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

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

88. 0.002 0.009 ↑ 170.0 10 1

Hash (cost=27.00..27.00 rows=1,700 width=16) (actual time=0.009..0.009 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 grnt_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.010 ↑ 252.9 7 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
91. 0.004 0.004 ↑ 252.9 7 1

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

92. 0.006 0.010 ↑ 170.0 10 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
93. 0.004 0.004 ↑ 170.0 10 1

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

94. 0.004 0.007 ↑ 170.0 10 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
95. 0.003 0.003 ↑ 170.0 10 1

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

96. 1.682 3.963 ↓ 1.0 11,379 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 651kB
97. 1.521 2.281 ↓ 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.793..2.281 rows=11,379 loops=1)

  • Recheck Cond: (status_id = 'SCAR'::bpchar)
  • Heap Blocks: exact=331
98. 0.760 0.760 ↓ 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.759..0.760 rows=11,379 loops=1)

  • Index Cond: (status_id = 'SCAR'::bpchar)
99. 2.415 2.415 ↑ 1.0 1 161

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

  • Index Cond: (appr2_asg.position_id = position_id)
100. 2.254 2.254 ↓ 0.0 0 161

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

  • Index Cond: (((authapp.application_id)::text = (application_id)::text) AND (status_id = 'FIXD'::bpchar))
101. 0.161 0.161 ↓ 0.0 0 161

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

  • Index Cond: ((flow_id = appr2_flow.flow_id) AND (part = 'A2'::bpchar))
  • Heap Fetches: 0
102. 1.288 1.288 ↑ 1.0 1 161

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

  • Index Cond: (flow_id = curt.flow_id)
  • Filter: ((status_id = 'FSAR'::bpchar) OR (status_id = 'SCAR'::bpchar))
Planning time : 16.756 ms
Execution time : 21,569.159 ms