explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 16AW

Settings
# exclusive inclusive rows x rows loops node
1. 0.070 191,247.998 ↓ 3.3 10 1

Limit (cost=12,419.22..22,691.68 rows=3 width=334) (actual time=191,124.476..191,247.998 rows=10 loops=1)

2. 0.114 191,247.928 ↓ 3.3 10 1

Result (cost=12,419.22..22,691.68 rows=3 width=334) (actual time=191,124.475..191,247.928 rows=10 loops=1)

3. 4.096 191,077.364 ↓ 3.3 10 1

Sort (cost=12,419.22..12,419.23 rows=3 width=262) (actual time=191,077.358..191,077.364 rows=10 loops=1)

  • Sort Key: pcy2_.modification_date DESC
  • Sort Method: top-N heapsort Memory: 33kB
4. 4.122 191,073.268 ↓ 656.3 1,969 1

Nested Loop (cost=7.89..12,419.20 rows=3 width=262) (actual time=189,196.756..191,073.268 rows=1,969 loops=1)

5. 137.479 189,336.426 ↓ 656.3 1,969 1

Nested Loop (cost=7.46..12,417.79 rows=3 width=206) (actual time=189,175.722..189,336.426 rows=1,969 loops=1)

  • Join Filter: (pcy2_.product_id = prd4_.id)
  • Rows Removed by Join Filter: 364,265
6. 0.119 0.119 ↑ 1.0 186 1

Seq Scan on prd_product prd4_ (cost=0.00..7.86 rows=186 width=35) (actual time=0.011..0.119 rows=186 loops=1)

7. 31.174 189,198.828 ↓ 656.3 1,969 186

Materialize (cost=7.46..12,401.57 rows=3 width=179) (actual time=58.606..1,017.198 rows=1,969 loops=186)

8. 5.545 189,167.654 ↓ 656.3 1,969 1

Nested Loop Left Join (cost=7.46..12,401.56 rows=3 width=179) (actual time=10,900.590..189,167.654 rows=1,969 loops=1)

9. 780.148 177,143.333 ↓ 656.3 1,969 1

Nested Loop (cost=7.03..12,377.15 rows=3 width=178) (actual time=10,882.157..177,143.333 rows=1,969 loops=1)

10. 359.576 28,846.084 ↓ 220.7 2,137,929 1

Nested Loop (cost=6.60..7,243.78 rows=9,687 width=16) (actual time=59.417..28,846.084 rows=2,137,929 loops=1)

11. 0.281 283.824 ↓ 7.9 79 1

Nested Loop (cost=6.17..977.00 rows=10 width=16) (actual time=39.100..283.824 rows=79 loops=1)

12. 101.539 123.252 ↑ 1.2 79 1

Bitmap Heap Scan on prd_item g3_1_ (cost=5.88..621.47 rows=91 width=8) (actual time=29.191..123.252 rows=79 loops=1)

  • Recheck Cond: ((alias)::text = 'UBEZPIECZAJACY'::text)
  • Filter: (product_id = ANY ('{124,129,171,146,162,165,155,166,153,170,16771,16775,199,169,87,159,113,133,11,56,68,106,161,6,16,46,115,137,98,53,74,79,5,60,49,108,139,29,4,3,88,1,151,131,72,100,64,111,95,118,26,130,27,54,82,91,157,59,89,71,9,173,116,63,12,14,62,127,156,28,117,18,8,76,110,174,201,178,180}'::bigint[]))
  • Rows Removed by Filter: 105
  • Heap Blocks: exact=177
13. 21.713 21.713 ↑ 1.0 184 1

Bitmap Index Scan on idx_product_item_alias (cost=0.00..5.86 rows=192 width=0) (actual time=21.713..21.713 rows=184 loops=1)

  • Index Cond: ((alias)::text = 'UBEZPIECZAJACY'::text)
14. 160.291 160.291 ↑ 1.0 1 79

Index Only Scan using pk_prd_group on prd_group g3_ (cost=0.29..3.91 rows=1 width=8) (actual time=2.029..2.029 rows=1 loops=79)

  • Index Cond: (id = g3_1_.id)
  • Heap Fetches: 79
15. 28,202.684 28,202.684 ↓ 1.3 27,062 79

Index Scan using idx_group_id on pcy_person_value this_ (cost=0.43..416.08 rows=21,060 width=24) (actual time=7.681..356.996 rows=27,062 loops=79)

  • Index Cond: (group_id = g3_.id)
16. 147,517.101 147,517.101 ↓ 0.0 0 2,137,929

Index Scan using pk_pcy_policy on pcy_policy pcy2_ (cost=0.43..0.53 rows=1 width=162) (actual time=0.069..0.069 rows=0 loops=2,137,929)

  • Index Cond: (id = this_.policy_id)
  • Filter: (actual AND (((type)::text = 'POLICY'::text) OR ((type)::text = 'REQUEST'::text) OR ((type)::text = 'PROLONGATION'::text)) AND (((unit)::text = '003462'::text) OR ((user_login)::text = '032389'::text) OR ((owner_unit)::text = '003462'::text) OR ((owner_user_login)::text = '032389'::text)))
  • Rows Removed by Filter: 1
17. 12,018.776 12,018.776 ↑ 1.0 1 1,969

Index Scan using pk_pcy_policy_additional on pcy_policy_additional pcy2_1_ (cost=0.43..8.13 rows=1 width=9) (actual time=6.104..6.104 rows=1 loops=1,969)

  • Index Cond: (pcy2_.id = id)
18. 1,732.720 1,732.720 ↑ 1.0 1 1,969

Index Scan using pk_prs_person on prs_person prs1_ (cost=0.43..0.46 rows=1 width=75) (actual time=0.880..0.880 rows=1 loops=1,969)

  • Index Cond: (id = this_.person_id)
19.          

SubPlan (for Result)

20. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_prs_address on prs_address address (cost=0.43..8.47 rows=1 width=32) (never executed)

  • Index Cond: (id = prs1_.address_addt)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_prs_address on prs_address address_1 (cost=0.43..8.47 rows=1 width=32) (never executed)

  • Index Cond: (id = prs1_.address_perm)
22. 133.370 133.370 ↑ 1.0 1 10

Index Scan using pk_prs_address on prs_address address_2 (cost=0.43..8.47 rows=1 width=32) (actual time=13.335..13.337 rows=1 loops=10)

  • Index Cond: (id = prs1_.address_corr)
23. 0.060 37.000 ↑ 1.0 1 10

Nested Loop (cost=0.72..16.76 rows=1 width=32) (actual time=3.699..3.700 rows=1 loops=10)

24. 0.140 0.140 ↑ 1.0 1 10

Index Scan using pk_pcy_policy on pcy_policy p (cost=0.43..8.45 rows=1 width=7) (actual time=0.013..0.014 rows=1 loops=10)

  • Index Cond: (id = this_.policy_id)
25. 36.800 36.800 ↑ 1.0 1 10

Index Scan using uq_usr_user_login on usr_user u (cost=0.29..8.31 rows=1 width=23) (actual time=3.680..3.680 rows=1 loops=10)

  • Index Cond: ((login)::text = (p.user_login)::text)
  • Filter: ((jsta IS NOT NULL) AND ((jsta)::text <> ''::text))
26. 0.020 0.080 ↓ 0.0 0 10

Nested Loop (cost=0.72..16.76 rows=1 width=32) (actual time=0.008..0.008 rows=0 loops=10)

27. 0.050 0.050 ↑ 1.0 1 10

Index Scan using pk_pcy_policy on pcy_policy p_1 (cost=0.43..8.45 rows=1 width=7) (actual time=0.005..0.005 rows=1 loops=10)

  • Index Cond: (id = this_.policy_id)
28. 0.010 0.010 ↓ 0.0 0 10

Index Scan using uq_usr_user_login on usr_user u_1 (cost=0.29..8.31 rows=1 width=23) (actual time=0.001..0.001 rows=0 loops=10)

  • Index Cond: ((login)::text = (p_1.owner_user_login)::text)
  • Filter: ((jsta IS NOT NULL) AND ((jsta)::text <> ''::text))
29. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=143.49..3,365.19 rows=1 width=8) (never executed)

30. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on prd_item i (cost=16.30..20.31 rows=1 width=8) (never executed)

  • Recheck Cond: (((alias)::text = 'Polisa_Początek_ochrony_ubezpieczeniowej'::text) AND (product_id = prd4_.id))
31. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=16.30..16.30 rows=1 width=0) (never executed)

32. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_product_item_alias (cost=0.00..4.49 rows=9 width=0) (never executed)

  • Index Cond: ((alias)::text = 'Polisa_Początek_ochrony_ubezpieczeniowej'::text)
33. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_prd_item_product_id (cost=0.00..11.56 rows=436 width=0) (never executed)

  • Index Cond: (product_id = prd4_.id)
34. 0.000 0.000 ↓ 0.0 0

Append (cost=127.19..3,344.48 rows=40 width=38) (never executed)

35. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_1 pav (cost=127.19..131.20 rows=1 width=19) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
36. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=127.19..127.19 rows=1 width=0) (never executed)

37. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_1 (cost=0.00..12.29 rows=514 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
38. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_1 (cost=0.00..114.52 rows=6,144 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
39. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_10 pav_1 (cost=93.08..97.10 rows=1 width=31) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
40. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=93.08..93.08 rows=1 width=0) (never executed)

41. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_10 (cost=0.00..13.70 rows=702 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
42. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_10 (cost=0.00..78.95 rows=4,069 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
43. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_11 pav_2 (cost=92.84..96.85 rows=1 width=38) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
44. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=92.84..92.84 rows=1 width=0) (never executed)

45. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_11 (cost=0.00..13.72 rows=704 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
46. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_11 (cost=0.00..78.69 rows=4,034 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
47. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_12 pav_3 (cost=88.14..92.15 rows=1 width=33) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
48. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=88.14..88.14 rows=1 width=0) (never executed)

49. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_12 (cost=0.00..13.63 rows=692 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
50. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_12 (cost=0.00..74.08 rows=3,953 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
51. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_13 pav_4 (cost=87.40..91.42 rows=1 width=36) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
52. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=87.40..87.40 rows=1 width=0) (never executed)

53. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_13 (cost=0.00..13.45 rows=668 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
54. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_13 (cost=0.00..73.54 rows=3,880 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
55. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_14 pav_5 (cost=73.87..77.88 rows=1 width=35) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
56. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=73.87..73.87 rows=1 width=0) (never executed)

57. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_14 (cost=0.00..12.59 rows=553 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
58. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_14 (cost=0.00..60.89 rows=3,261 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
59. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_15 pav_6 (cost=72.95..76.97 rows=1 width=40) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
60. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=72.95..72.95 rows=1 width=0) (never executed)

61. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_15 (cost=0.00..12.61 rows=556 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
62. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_15 (cost=0.00..59.96 rows=3,136 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
63. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_16 pav_7 (cost=79.58..83.60 rows=1 width=40) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
64. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=79.58..79.58 rows=1 width=0) (never executed)

65. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_16 (cost=0.00..12.88 rows=592 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
66. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_16 (cost=0.00..66.31 rows=3,449 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
67. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_17 pav_8 (cost=66.98..70.99 rows=1 width=36) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
68. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=66.98..66.98 rows=1 width=0) (never executed)

69. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_17 (cost=0.00..12.29 rows=514 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
70. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_17 (cost=0.00..54.31 rows=2,916 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
71. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_18 pav_9 (cost=98.48..102.50 rows=1 width=34) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
72. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=98.48..98.48 rows=1 width=0) (never executed)

73. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_18 (cost=0.00..18.02 rows=745 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
74. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_18 (cost=0.00..80.02 rows=4,211 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
75. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_19 pav_10 (cost=73.83..77.85 rows=1 width=39) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
76. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=73.83..73.83 rows=1 width=0) (never executed)

77. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_19 (cost=0.00..12.60 rows=555 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
78. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_19 (cost=0.00..60.84 rows=3,254 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
79. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_2 pav_11 (cost=132.16..136.17 rows=1 width=19) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
80. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=132.16..132.16 rows=1 width=0) (never executed)

81. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_2 (cost=0.00..12.59 rows=553 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
82. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_2 (cost=0.00..119.19 rows=6,233 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
83. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_20 pav_12 (cost=80.06..84.07 rows=1 width=36) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
84. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=80.06..80.06 rows=1 width=0) (never executed)

85. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_20 (cost=0.00..13.17 rows=631 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
86. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_20 (cost=0.00..66.48 rows=3,472 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
87. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_21 pav_13 (cost=66.73..70.75 rows=1 width=39) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
88. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=66.73..66.73 rows=1 width=0) (never executed)

89. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_21 (cost=0.00..13.07 rows=618 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
90. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_21 (cost=0.00..53.26 rows=2,776 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
91. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_22 pav_14 (cost=72.02..76.03 rows=1 width=40) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
92. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=72.02..72.02 rows=1 width=0) (never executed)

93. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_22 (cost=0.00..12.88 rows=592 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
94. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_22 (cost=0.00..58.74 rows=2,974 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
95. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_23 pav_15 (cost=80.25..84.26 rows=1 width=38) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
96. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=80.25..80.25 rows=1 width=0) (never executed)

97. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_23 (cost=0.00..13.48 rows=672 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
98. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_23 (cost=0.00..66.35 rows=3,455 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
99. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_24 pav_16 (cost=80.01..84.03 rows=1 width=44) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
100. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=80.01..80.01 rows=1 width=0) (never executed)

101. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_24 (cost=0.00..13.61 rows=690 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
102. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_24 (cost=0.00..65.97 rows=3,405 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
103. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_25 pav_17 (cost=66.90..70.92 rows=1 width=58) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
104. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=66.90..66.90 rows=1 width=0) (never executed)

105. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_25 (cost=0.00..12.97 rows=605 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
106. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_25 (cost=0.00..53.53 rows=2,812 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
107. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_26 pav_18 (cost=67.28..71.30 rows=1 width=49) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
108. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=67.28..67.28 rows=1 width=0) (never executed)

109. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_26 (cost=0.00..13.26 rows=643 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
110. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_26 (cost=0.00..53.61 rows=2,823 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
111. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_27 pav_19 (cost=68.19..72.21 rows=1 width=46) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
112. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=68.19..68.19 rows=1 width=0) (never executed)

113. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_27 (cost=0.00..13.63 rows=693 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
114. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_27 (cost=0.00..54.13 rows=2,893 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
115. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_28 pav_20 (cost=67.33..71.34 rows=1 width=54) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
116. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=67.33..67.33 rows=1 width=0) (never executed)

117. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_28 (cost=0.00..13.58 rows=686 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
118. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_28 (cost=0.00..53.33 rows=2,785 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
119. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_29 pav_21 (cost=53.43..57.45 rows=1 width=51) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
120. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=53.43..53.43 rows=1 width=0) (never executed)

121. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_29 (cost=0.00..12.59 rows=554 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
122. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_29 (cost=0.00..40.45 rows=2,136 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
123. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_3 pav_22 (cost=120.20..124.21 rows=1 width=19) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
124. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=120.20..120.20 rows=1 width=0) (never executed)

125. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_3 (cost=0.00..12.77 rows=578 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
126. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_3 (cost=0.00..107.03 rows=5,679 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
127. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_30 pav_23 (cost=86.25..90.26 rows=1 width=46) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
128. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=86.25..86.25 rows=1 width=0) (never executed)

129. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_30 (cost=0.00..18.18 rows=766 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
130. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_30 (cost=0.00..67.62 rows=3,625 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
131. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_31 pav_24 (cost=105.64..109.65 rows=1 width=43) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
132. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=105.64..105.64 rows=1 width=0) (never executed)

133. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_31 (cost=0.00..18.64 rows=827 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
134. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_31 (cost=0.00..86.54 rows=4,547 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
135. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_32 pav_25 (cost=79.29..83.30 rows=1 width=52) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
136. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=79.29..79.29 rows=1 width=0) (never executed)

137. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_32 (cost=0.00..13.60 rows=688 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
138. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_32 (cost=0.00..65.27 rows=3,311 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
139. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_33 pav_26 (cost=66.12..70.13 rows=1 width=58) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
140. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=66.12..66.12 rows=1 width=0) (never executed)

141. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_33 (cost=0.00..12.64 rows=561 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
142. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_33 (cost=0.00..53.08 rows=2,753 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
143. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_34 pav_27 (cost=71.65..75.66 rows=1 width=52) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
144. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=71.65..71.65 rows=1 width=0) (never executed)

145. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_34 (cost=0.00..12.71 rows=570 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
146. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_34 (cost=0.00..58.55 rows=2,948 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
147. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_35 pav_28 (cost=81.29..85.31 rows=1 width=46) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
148. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=81.29..81.29 rows=1 width=0) (never executed)

149. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_35 (cost=0.00..13.77 rows=711 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
150. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_35 (cost=0.00..67.09 rows=3,554 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
151. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_36 pav_29 (cost=106.95..110.96 rows=1 width=42) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
152. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=106.95..106.95 rows=1 width=0) (never executed)

153. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_36 (cost=0.00..18.62 rows=824 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
154. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_36 (cost=0.00..87.88 rows=4,725 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
155. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_37 pav_30 (cost=88.30..92.32 rows=1 width=52) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
156. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=88.30..88.30 rows=1 width=0) (never executed)

157. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_37 (cost=0.00..13.63 rows=692 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
158. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_37 (cost=0.00..74.25 rows=3,975 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
159. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_38 pav_31 (cost=4.17..11.29 rows=1 width=40) (never executed)

  • Recheck Cond: (policy_id = pcy2_.id)
  • Filter: (i.id = attribute_id)
160. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_38 (cost=0.00..4.17 rows=3 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
161. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_39 pav_32 (cost=4.17..11.29 rows=1 width=40) (never executed)

  • Recheck Cond: (policy_id = pcy2_.id)
  • Filter: (i.id = attribute_id)
162. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_39 (cost=0.00..4.17 rows=3 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
163. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_4 pav_33 (cost=99.46..103.47 rows=1 width=19) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
164. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=99.46..99.46 rows=1 width=0) (never executed)

165. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_4 (cost=0.00..12.88 rows=593 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
166. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_4 (cost=0.00..86.17 rows=4,498 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
167. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_40 pav_34 (cost=4.17..11.29 rows=1 width=40) (never executed)

  • Recheck Cond: (policy_id = pcy2_.id)
  • Filter: (i.id = attribute_id)
168. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_40 (cost=0.00..4.17 rows=3 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
169. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_5 pav_35 (cost=99.26..103.27 rows=1 width=20) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
170. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=99.26..99.26 rows=1 width=0) (never executed)

171. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_5 (cost=0.00..13.42 rows=664 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
172. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_5 (cost=0.00..85.42 rows=4,398 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
173. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_6 pav_36 (cost=94.87..98.88 rows=1 width=20) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
174. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=94.87..94.87 rows=1 width=0) (never executed)

175. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_6 (cost=0.00..13.27 rows=644 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
176. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_6 (cost=0.00..81.19 rows=4,367 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
177. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_7 pav_37 (cost=92.89..96.91 rows=1 width=22) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
178. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=92.89..92.89 rows=1 width=0) (never executed)

179. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_7 (cost=0.00..13.20 rows=635 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
180. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_7 (cost=0.00..79.28 rows=4,113 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
181. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_8 pav_38 (cost=93.04..97.05 rows=1 width=26) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
182. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=93.04..93.04 rows=1 width=0) (never executed)

183. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_8 (cost=0.00..13.85 rows=722 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
184. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_8 (cost=0.00..78.75 rows=4,042 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
185. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pcy_attribute_value_9 pav_39 (cost=88.16..92.18 rows=1 width=32) (never executed)

  • Recheck Cond: ((policy_id = pcy2_.id) AND (attribute_id = i.id))
186. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=88.16..88.16 rows=1 width=0) (never executed)

187. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_policy_id_9 (cost=0.00..13.49 rows=674 width=0) (never executed)

  • Index Cond: (policy_id = pcy2_.id)
188. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_policy_attribute_value_attribute_id_9 (cost=0.00..74.25 rows=3,975 width=0) (never executed)

  • Index Cond: (attribute_id = i.id)
Planning time : 823.521 ms
Execution time : 191,249.985 ms