# Result: pjVk : benefits_biliing_detail

Settings

### Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 182,574.441 ↓ 0.0 0 1

(cost=10,638.780..10,683.300 rows=1 width=462) (actual time=182,574.440..182,574.441 rows=0 loops=1)

2. 168.913 182,632.831 ↓ 0.0 0 1

Gather (cost=10,638.780..10,683.300 rows=1 width=462) (actual time=182,574.438..182,632.831 rows=0 loops=1)

• Workers Planned: 2
• Workers Launched: 2
3. 0.001 182,463.918 ↓ 0.0 0 3 / 3

(cost=9,638.780..9,641.360 rows=1 width=334) (actual time=182,463.918..182,463.918 rows=0 loops=3)

4. 0.001 182,463.917 ↓ 0.0 0 3 / 3

(cost=9,638.370..9,640.100 rows=1 width=320) (actual time=182,463.917..182,463.917 rows=0 loops=3)

5. 0.000 182,463.916 ↓ 0.0 0 3 / 3

(cost=9,638.080..9,639.690 rows=1 width=313) (actual time=182,463.916..182,463.916 rows=0 loops=3)

6. 0.001 182,463.916 ↓ 0.0 0 3 / 3

(cost=9,637.800..9,639.340 rows=1 width=314) (actual time=182,463.916..182,463.916 rows=0 loops=3)

7. 0.005 182,463.915 ↓ 0.0 0 3 / 3

(cost=9,637.380..9,638.620 rows=1 width=319) (actual time=182,463.915..182,463.915 rows=0 loops=3)

8. 0.000 182,463.910 ↓ 0.0 0 3 / 3

(cost=9,637.110..9,638.270 rows=1 width=304) (actual time=182,463.910..182,463.910 rows=0 loops=3)

9. 0.001 182,463.910 ↓ 0.0 0 3 / 3

(cost=9,636.690..9,637.500 rows=1 width=299) (actual time=182,463.910..182,463.910 rows=0 loops=3)

10. 0.000 182,463.909 ↓ 0.0 0 3 / 3

(cost=9,636.280..9,636.890 rows=1 width=292) (actual time=182,463.909..182,463.909 rows=0 loops=3)

11. 0.001 182,463.909 ↓ 0.0 0 3 / 3

(cost=9,635.990..9,636.510 rows=1 width=278) (actual time=182,463.909..182,463.909 rows=0 loops=3)

12. 0.001 182,463.908 ↓ 0.0 0 3 / 3

(cost=9,635.710..9,636.120 rows=1 width=266) (actual time=182,463.908..182,463.908 rows=0 loops=3)

13. 0.002 182,463.907 ↓ 0.0 0 3 / 3

(cost=9,635.560..9,635.910 rows=1 width=252) (actual time=182,463.907..182,463.907 rows=0 loops=3)

• Merge Cond: ((romeo_three7kilo_oscar0.charlie_juliet = romeo_three9kilo_oscar0.charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = romeo_three9kilo_oscar0.charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = romeo_three9kilo_oscar0.charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = romeo_three9kilo_oscar0.charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = romeo_three9kilo_oscar0.charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = romeo_three9kilo_oscar0.charlie_juliet) AND (romeo_three7kilo_oscar0.
14. 0.059 182,463.905 ↓ 0.0 0 3 / 3

(cost=9,632.380..9,632.380 rows=1 width=239) (actual time=182,463.905..182,463.905 rows=0 loops=3)

• Sort Key: romeo_three7kilo_oscar0.charlie_juliet, romeo_three7kilo_oscar0.victor_four
• Sort Method: quicksort Memory: 25kB
• Worker 0: Sort Method: quicksort Memory: 25kB
• Worker 1: Sort Method: quicksort Memory: 25kB
15. 0.001 182,463.846 ↓ 0.0 0 3 / 3

(cost=693.480..9,632.370 rows=1 width=239) (actual time=182,463.846..182,463.846 rows=0 loops=3)

16. 0.000 182,463.845 ↓ 0.0 0 3 / 3

(cost=693.060..9,631.740 rows=1 width=190) (actual time=182,463.845..182,463.845 rows=0 loops=3)

17. 0.001 182,463.845 ↓ 0.0 0 3 / 3

(cost=692.780..9,631.350 rows=1 width=164) (actual time=182,463.844..182,463.845 rows=0 loops=3)

18. 105.948 182,463.844 ↓ 0.0 0 3 / 3

(cost=692.360..9,630.800 rows=1 width=138) (actual time=182,463.844..182,463.844 rows=0 loops=3)

19. 200.414 3,627.508 ↓ 20,431.0 20,431 3 / 3

(cost=682.100..9,616.510 rows=1 width=104) (actual time=9.928..3,627.508 rows=20,431 loops=3)

• Join Filter: ((romeo_three5kilo_oscar0.sierra_three = romeo_three1kilo_oscar0.sierra_three) AND (romeo_three2kilo_oscar0.kilo_sierra = romeo_three1kilo_oscar0.kilo_sierra))
20. 234.933 578.382 ↓ 13.9 20,494 3 / 3

(cost=681.680..7,918.060 rows=1,477 width=102) (actual time=9.847..578.382 rows=20,494 loops=3)

• Hash Cond: (romeo_three6kilo_oscar0.sierra_three = romeo_three5kilo_oscar0.sierra_three)
21. 164.033 334.024 ↓ 6.7 20,494 3 / 3

(cost=163.400..7,391.680 rows=3,080 width=64) (actual time=0.404..334.024 rows=20,494 loops=3)

• Hash Cond: (romeo_three6kilo_oscar0.kilo_sierra = romeo_three2kilo_oscar0.kilo_sierra)
22. 169.790 169.790 ↑ 1.3 20,494 3 / 3

Parallel Seq Scan on papa_romeo sierra_four (cost=0.000..7,159.650 rows=26,073 width=27) (actual time=0.078..169.790 rows=20,494 loops=3)

• Filter: (charlie_juliet = 'lima_hotel'::text)
• Rows Removed by Filter: 69713
23. 0.054 0.201 ↑ 1.0 196 3 / 3

(cost=160.950..160.950 rows=196 width=37) (actual time=0.201..0.201 rows=196 loops=3)

• Buckets: 1024 Batches: 1 Memory Usage: 22kB
24. 0.095 0.147 ↑ 1.0 196 3 / 3

Bitmap Heap Scan on delta_delta echo_echo (cost=5.800..160.950 rows=196 width=37) (actual time=0.061..0.147 rows=196 loops=3)

• Recheck Cond: (charlie_juliet = 'lima_hotel'::text)
• Heap Blocks: exact=12
25. 0.052 0.052 ↑ 1.0 196 3 / 3

Bitmap Index Scan on zulu_zulu (cost=0.000..5.750 rows=196 width=0) (actual time=0.052..0.052 rows=196 loops=3)

• Index Cond: (charlie_juliet = 'lima_hotel'::text)
26. 0.220 9.425 ↑ 1.0 897 3 / 3

(cost=507.060..507.060 rows=897 width=38) (actual time=9.424..9.425 rows=897 loops=3)

• Buckets: 1024 Batches: 1 Memory Usage: 73kB
27. 9.205 9.205 ↑ 1.0 897 3 / 3

Seq Scan on five_sierra seven_november (cost=0.000..507.060 rows=897 width=38) (actual time=0.102..9.205 rows=897 loops=3)

• Filter: (charlie_juliet = 'lima_hotel'::text)
• Rows Removed by Filter: 2309
28. 2,848.712 2,848.712 ↑ 1.0 1 61,483 / 3

Index Scan using yankee_lima on uniform_xray lima_victor (cost=0.420..1.130 rows=1 width=28) (actual time=0.139..0.139 rows=1 loops=61,483)

• Index Cond: ((charlie_juliet = 'lima_hotel'::text) AND (sierra_three = romeo_three6kilo_oscar0.sierra_three) AND (hotel_quebec = romeo_three6kilo_oscar0.hotel_quebec) AND (kilo_sierra = romeo_three6kilo_oscar0.kilo_sierra))
29. 51,976.464 178,730.388 ↓ 0.0 0 61,293 / 3

Bitmap Heap Scan on seven_six four (cost=10.260..14.280 rows=1 width=48) (actual time=8.748..8.748 rows=0 loops=61,293)

• Recheck Cond: ((hotel_quebec = romeo_three1kilo_oscar0.hotel_quebec) AND (charlie_juliet = 'lima_hotel'::text) AND (sierra_three = romeo_three1kilo_oscar0.sierra_three))
• Filter: (juliet((echo_five -> 'uniform_three'::text)) > 0)
• Rows Removed by Filter: 56
• Heap Blocks: exact=1151068
30. 1,173.944 126,753.924 ↓ 0.0 0 61,293 / 3

BitmapAnd (cost=10.260..10.260 rows=1 width=0) (actual time=6.204..6.204 rows=0 loops=61,293)

31. 3,657.149 3,657.149 ↓ 1.2 157 61,293 / 3

Bitmap Index Scan on bravo_hotel (cost=0.000..1.930 rows=132 width=0) (actual time=0.179..0.179 rows=157 loops=61,293)

• Index Cond: (hotel_quebec = romeo_three1kilo_oscar0.hotel_quebec)
32. 121,922.831 121,922.831 ↓ 15.6 10,832 61,196 / 3

Bitmap Index Scan on alpha_zulu (cost=0.000..8.080 rows=694 width=0) (actual time=5.977..5.977 rows=10,832 loops=61,196)

• Index Cond: ((charlie_juliet = 'lima_hotel'::text) AND (sierra_three = romeo_three1kilo_oscar0.sierra_three))
33. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using victor_delta on uniform_six papa_xray (cost=0.420..0.550 rows=1 width=33) (never executed)

• Index Cond: ((charlie_juliet = 'lima_hotel'::text) AND (hotel_quebec = romeo_three0kilo_oscar0.hotel_quebec))
34. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using five_alpha on alpha_two xray_zulu (cost=0.280..0.330 rows=1 width=36) (never executed)

• Index Cond: ((romeo_three0kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three0kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three0kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three0kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three0kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three0kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three0kilo_oscar0.charlie_juliet
35. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using mike_hotel on seven_alpha_tango november_uniform (cost=0.420..0.630 rows=1 width=56) (never executed)

• Index Cond: ((romeo_three1kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three1kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three1kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three1kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three1kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three1kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three1kilo_oscar0.charlie_juliet = whiskey_mike
36. 0.000 0.000 ↓ 0.0 0 / 3

(cost=3.180..3.200 rows=8 width=21) (never executed)

• Sort Key: romeo_three9kilo_oscar0.charlie_juliet, romeo_three9kilo_oscar0.victor_four
37. 0.000 0.000 ↓ 0.0 0 / 3

Seq Scan on delta_uniform foxtrot_uniform (cost=0.000..3.060 rows=8 width=21) (never executed)

• Filter: (charlie_juliet = 'lima_hotel'::text)
38. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using hotel_foxtrot on oscar_delta romeo_charlie (cost=0.140..0.200 rows=1 width=24) (never executed)

• Index Cond: ((romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (charlie_juliet =
39. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using alpha_quebec on charlie_seven xray_lima (cost=0.290..0.390 rows=1 width=26) (never executed)

• Index Cond: ((romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (charlie_juliet = 'lima_hotel'
40. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using foxtrot_india on quebec_five romeo_india (cost=0.290..0.380 rows=1 width=29) (never executed)

• Index Cond: ((romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (charlie_juliet = 'lima_hotel'::text
41. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using six_november on seven_alpha_hotel zulu_seven (cost=0.410..0.610 rows=1 width=24) (never executed)

• Index Cond: ((romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (charlie_juliet = 'lima_hotel'::text) AND
42. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using mike_kilo on whiskey_five echo_mike (cost=0.410..0.590 rows=1 width=27) (never executed)

• Index Cond: ((romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (charlie_juliet = 'lima_hotel'::text) AND (romeo_three7kilo_oscar0.
43. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using victor_echo_golf_alpha on kilo_november five_quebec (cost=0.280..0.350 rows=1 width=39) (never executed)

• Index Cond: ((romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (charlie_juliet = 'lima_hotel'::text) AND (romeo_three7kilo_oscar0.two
44. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using uniform_echo on victor_india quebec_lima (cost=0.420..0.720 rows=1 width=18) (never executed)

• Index Cond: ((romeo_three1kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three1kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three1kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three1kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three1kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three1kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three1kilo_oscar0.charlie_juliet = charlie_juliet) AND (charlie_juliet = 'lima_hotel'::text) AND (romeo_three1kilo_oscar0.sierra_three =
45. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using xray_charlie on romeo_oscar sierra_charlie (cost=0.280..0.350 rows=1 width=22) (never executed)

• Index Cond: ((romeo_three15kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three15kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three15kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three15kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three15kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three15kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three15kilo_oscar0.charlie_juliet = charlie_juliet) AND (charlie_juliet = 'lima_hotel'::text) AND (romeo_three15kilo_oscar0.sierra_three
46. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using whiskey_papa on alpha_golf kilo_xray (cost=0.290..0.410 rows=1 width=35) (never executed)

• Index Cond: ((romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three7kilo_oscar0.charlie_juliet = charlie_juliet) AND (charlie_juliet = 'lima_hotel'::text) AND (romeo_three7kilo_oscar0.sierra_three = sierra_three) november_xray
47. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using three on uniform_lima uniform_charlie (cost=0.420..1.250 rows=1 width=38) (never executed)

• Index Cond: ((golf_hotel = 'yankee_alpha'::text) AND (romeo_three3kilo_oscar0.hotel_quebec = hotel_quebec) AND (romeo_three3kilo_oscar0.hotel_quebec = hotel_quebec) AND (romeo_three3kilo_oscar0.hotel_quebec = hotel_quebec) AND (romeo_three3kilo_oscar0.hotel_quebec = hotel_quebec) AND (romeo_three3kilo_oscar0.hotel_quebec = hotel_quebec) AND (romeo_three3kilo_oscar0.hotel_quebec = hotel_quebec) AND (romeo_three
• Filter: ((charlie_juliet = 'lima_hotel'::text) AND (romeo_three3kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three3kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three3kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three3kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three3kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three3kilo_oscar0.charlie_juliet = charlie_juliet) AND (romeo_three3kilo_oscar0.charlie_juliet = charlie_juliet))
48.

SubPlan (for Gather)

49. 0.000 0.000 ↓ 0.0 0

(cost=0.430..10.460 rows=100 width=32) (never executed)

50. 0.000 0.000 ↓ 0.0 0

Index Scan using alpha_zulu on seven_six romeo_three (cost=0.430..8.450 rows=1 width=496) (never executed)

• Index Cond: ((charlie_juliet = romeo_three0kilo_oscar0.charlie_juliet) AND (sierra_three = romeo_three0kilo_oscar0.sierra_three) AND (mike_five = romeo_three0kilo_oscar0.mike_five))
• Filter: (hotel_quebec = romeo_three0kilo_oscar0.hotel_quebec)
51. 0.000 0.000 ↓ 0.0 0

Function Scan on zulu_four golf_yankee (cost=0.010..1.000 rows=100 width=32) (never executed)

52. 0.000 0.000 ↓ 0.0 0

(cost=0.430..10.460 rows=100 width=32) (never executed)

53. 0.000 0.000 ↓ 0.0 0

Index Scan using alpha_zulu on seven_six victor_echo_golf_kilo (cost=0.430..8.450 rows=1 width=496) (never executed)

• Index Cond: ((charlie_juliet = romeo_three0kilo_oscar0.charlie_juliet) AND (sierra_three = romeo_three0kilo_oscar0.sierra_three) AND (mike_five = romeo_three0kilo_oscar0.mike_five))
• Filter: (hotel_quebec = romeo_three0kilo_oscar0.hotel_quebec)
54. 0.000 0.000 ↓ 0.0 0

Function Scan on zulu_four uniform_yankee (cost=0.010..1.000 rows=100 width=32) (never executed)

55. 0.000 0.000 ↓ 0.0 0

(cost=0.430..10.460 rows=100 width=32) (never executed)

56. 0.000 0.000 ↓ 0.0 0

Index Scan using alpha_zulu on seven_six quebec_bravo (cost=0.430..8.450 rows=1 width=496) (never executed)

• Index Cond: ((charlie_juliet = romeo_three0kilo_oscar0.charlie_juliet) AND (sierra_three = romeo_three0kilo_oscar0.sierra_three) AND (mike_five = romeo_three0kilo_oscar0.mike_five))
• Filter: (hotel_quebec = romeo_three0kilo_oscar0.hotel_quebec)
57. 0.000 0.000 ↓ 0.0 0

Function Scan on zulu_four six_foxtrot (cost=0.010..1.000 rows=100 width=32) (never executed)

58. 0.000 0.000 ↓ 0.0 0

(cost=0.430..10.460 rows=100 width=32) (never executed)

59. 0.000 0.000 ↓ 0.0 0

Index Scan using alpha_zulu on seven_six oscar_two (cost=0.430..8.450 rows=1 width=496) (never executed)

• Index Cond: ((charlie_juliet = romeo_three0kilo_oscar0.charlie_juliet) AND (sierra_three = romeo_three0kilo_oscar0.sierra_three) AND (mike_five = romeo_three0kilo_oscar0.mike_five))
• Filter: (hotel_quebec = romeo_three0kilo_oscar0.hotel_quebec)
60. 0.000 0.000 ↓ 0.0 0

Function Scan on zulu_four bravo_quebec (cost=0.010..1.000 rows=100 width=32) (never executed)

Planning time Execution time : 565.469 ms : 182,633.824 ms