explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bugS

Settings
# exclusive inclusive rows x rows loops node
1. 1,270.880 775,350.457 ↑ 3.5 15,575 1

Hash Right Join (cost=47,419,253.46..58,678,195.32 rows=55,098 width=698) (actual time=609,229.796..775,350.457 rows=15,575 loops=1)

  • Hash Cond: (sched1.id_contract = c.id_contract)
2. 43,291.312 371,222.679 ↑ 208.2 512,284 1

Hash Anti Join (cost=7,577,635.89..18,164,031.46 rows=106,681,759 width=16) (actual time=180,603.960..371,222.679 rows=512,284 loops=1)

  • Hash Cond: (sched1.id_contract = sched2.id_contract)
  • Join Filter: (sched2.sched_date < sched1.sched_date)
  • Rows Removed by Join Filter: 106419979
3. 179,076.412 179,076.412 ↑ 12.1 13,240,090 1

Seq Scan on sched sched1 (cost=0.00..4,795,991.91 rows=160,022,638 width=20) (actual time=31,514.176..179,076.412 rows=13,240,090 loops=1)

  • Filter: (zen_code <> 0)
  • Rows Removed by Filter: 6724601
4. 7,419.826 148,854.955 ↑ 12.1 13,239,982 1

Hash (cost=4,795,991.91..4,795,991.91 rows=160,022,638 width=12) (actual time=148,854.955..148,854.955 rows=13,239,982 loops=1)

  • Buckets: 524288 Batches: 64 Memory Usage: 9211kB
5. 141,435.129 141,435.129 ↑ 12.1 13,240,090 1

Seq Scan on sched sched2 (cost=0.00..4,795,991.91 rows=160,022,638 width=12) (actual time=4,291.694..141,435.129 rows=13,240,090 loops=1)

  • Filter: (zen_code <> 0)
  • Rows Removed by Filter: 6724601
6. 81.224 402,856.898 ↓ 5.3 15,575 1

Hash (cost=39,841,581.06..39,841,581.06 rows=2,921 width=690) (actual time=402,856.898..402,856.898 rows=15,575 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 6271kB
7. 47.570 402,775.674 ↓ 5.3 15,575 1

Merge Left Join (cost=3,712,269.22..39,841,581.06 rows=2,921 width=690) (actual time=69,656.652..402,775.674 rows=15,575 loops=1)

  • Merge Cond: (c.id_contract = last_agreement.id_contract)
8. 47.218 401,774.892 ↓ 5.3 15,575 1

Nested Loop Left Join (cost=3,701,925.03..39,831,226.82 rows=2,921 width=686) (actual time=68,713.940..401,774.892 rows=15,575 loops=1)

9. 44.626 373,365.599 ↓ 5.3 15,575 1

Nested Loop Left Join (cost=3,701,924.60..39,788,298.45 rows=2,921 width=616) (actual time=68,702.530..373,365.599 rows=15,575 loops=1)

10. 303,726.218 372,838.148 ↓ 5.3 15,575 1

Nested Loop Left Join (cost=3,701,924.60..39,780,782.11 rows=2,921 width=612) (actual time=68,701.569..372,838.148 rows=15,575 loops=1)

11. 47.320 68,193.005 ↓ 5.3 15,575 1

Merge Left Join (cost=3,689,571.08..3,689,655.37 rows=2,921 width=600) (actual time=68,123.414..68,193.005 rows=15,575 loops=1)

  • Merge Cond: (c.id_contract = next_cycle.id_contract)
12. 64.467 66,686.345 ↓ 5.3 15,575 1

Sort (cost=3,661,845.36..3,661,852.66 rows=2,921 width=588) (actual time=66,673.494..66,686.345 rows=15,575 loops=1)

  • Sort Key: c.id_contract
  • Sort Method: quicksort Memory: 8588kB
13. 65.405 66,621.878 ↓ 5.3 15,575 1

Hash Left Join (cost=2,100,453.03..3,661,677.22 rows=2,921 width=588) (actual time=49,944.353..66,621.878 rows=15,575 loops=1)

  • Hash Cond: (mo.id_customer = other_contracts.id_customer)
14. 38.028 63,400.552 ↓ 5.3 15,575 1

Nested Loop Left Join (cost=1,545,054.94..3,090,320.41 rows=2,921 width=580) (actual time=46,788.394..63,400.552 rows=15,575 loops=1)

15. 3,996.853 61,727.149 ↓ 5.3 15,575 1

Nested Loop Left Join (cost=1,545,054.53..3,082,835.45 rows=2,921 width=572) (actual time=46,787.425..61,727.149 rows=15,575 loops=1)

  • Join Filter: (pp.id_prod = c.id_prod)
  • Rows Removed by Join Filter: 12550765
16. 596.174 50,643.671 ↓ 5.3 15,575 1

Hash Join (cost=1,543,320.48..3,064,211.03 rows=2,921 width=577) (actual time=42,894.371..50,643.671 rows=15,575 loops=1)

  • Hash Cond: (c_1.id_contract = c.id_contract)
17. 2,858.574 47,761.303 ↑ 8.3 680,060 1

Hash Left Join (cost=1,329,058.07..2,814,571.54 rows=5,655,660 width=215) (actual time=39,769.255..47,761.303 rows=680,060 loops=1)

  • Hash Cond: (c_1.dep_int_transfer_id_contract = contracts_1.id_contract)
18. 3,529.486 32,779.892 ↑ 8.3 680,060 1

Hash Left Join (cost=720,856.25..1,663,021.05 rows=5,655,660 width=196) (actual time=27,645.562..32,779.892 rows=680,060 loops=1)

  • Hash Cond: (c_1.int_transfer_out_id_contract = contracts.id_contract)
  • Join Filter: (c_1.int_transfer_in_type = 1)
  • Rows Removed by Join Filter: 149041
19. 491.205 2,424.618 ↑ 8.3 680,060 1

Merge Left Join (cost=112,654.44..521,945.36 rows=5,655,660 width=181) (actual time=819.450..2,424.618 rows=680,060 loops=1)

  • Merge Cond: (c_1.id_contract = co1.id_contract)
20. 732.151 732.151 ↑ 8.3 680,059 1

Index Scan using contr_id_contract_index on contr c_1 (cost=0.43..378,812.25 rows=5,655,660 width=149) (actual time=0.018..732.151 rows=680,059 loops=1)

21. 52.471 1,201.262 ↑ 3.8 72,782 1

Materialize (cost=112,654.01..125,548.10 rows=275,669 width=40) (actual time=819.429..1,201.262 rows=72,782 loops=1)

22. 202.137 1,148.791 ↑ 3.8 72,782 1

Merge Anti Join (cost=112,654.01..124,858.93 rows=275,669 width=40) (actual time=819.426..1,148.791 rows=72,782 loops=1)

  • Merge Cond: (co1.id_contract = co2.id_contract)
  • Join Filter: (co2.priority < co1.priority)
  • Rows Removed by Join Filter: 175917
23. 149.412 698.935 ↑ 2.9 140,482 1

Sort (cost=56,327.00..57,360.76 rows=413,504 width=44) (actual time=645.146..698.935 rows=140,482 loops=1)

  • Sort Key: co1.id_contract
  • Sort Method: quicksort Memory: 17005kB
24. 549.523 549.523 ↑ 2.9 140,482 1

Seq Scan on const_ord co1 (cost=0.00..17,752.16 rows=413,504 width=44) (actual time=0.049..549.523 rows=140,482 loops=1)

  • Filter: (status = 2)
  • Rows Removed by Filter: 112666
25. 152.129 247.719 ↑ 1.7 243,127 1

Sort (cost=56,327.00..57,360.76 rows=413,504 width=12) (actual time=174.260..247.719 rows=243,127 loops=1)

  • Sort Key: co2.id_contract
  • Sort Method: quicksort Memory: 12730kB
26. 95.590 95.590 ↑ 2.9 140,482 1

Seq Scan on const_ord co2 (cost=0.00..17,752.16 rows=413,504 width=12) (actual time=0.017..95.590 rows=140,482 loops=1)

  • Filter: (status = 2)
  • Rows Removed by Filter: 112666
27. 8,055.673 26,825.788 ↑ 1.1 11,862,049 1

Hash (cost=331,272.14..331,272.14 rows=13,633,414 width=35) (actual time=26,825.788..26,825.788 rows=11,862,049 loops=1)

  • Buckets: 262144 Batches: 8 Memory Usage: 104403kB
28. 18,770.115 18,770.115 ↑ 1.1 11,862,049 1

Seq Scan on contracts (cost=0.00..331,272.14 rows=13,633,414 width=35) (actual time=1.108..18,770.115 rows=11,862,049 loops=1)

29. 7,128.841 12,122.837 ↑ 1.1 11,862,049 1

Hash (cost=331,272.14..331,272.14 rows=13,633,414 width=35) (actual time=12,122.837..12,122.837 rows=11,862,049 loops=1)

  • Buckets: 262144 Batches: 8 Memory Usage: 104403kB
30. 4,993.996 4,993.996 ↑ 1.1 11,862,049 1

Seq Scan on contracts contracts_1 (cost=0.00..331,272.14 rows=13,633,414 width=35) (actual time=0.006..4,993.996 rows=11,862,049 loops=1)

31. 24.607 2,286.194 ↓ 5.3 15,575 1

Hash (cost=214,225.89..214,225.89 rows=2,921 width=394) (actual time=2,286.194..2,286.194 rows=15,575 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 5974kB
32. 59.768 2,261.587 ↓ 5.3 15,575 1

Hash Right Join (cost=212,955.96..214,225.89 rows=2,921 width=394) (actual time=2,170.758..2,261.587 rows=15,575 loops=1)

  • Hash Cond: (signatures.id_contract = c.id_contract)
33. 77.164 160.653 ↓ 1.1 51,873 1

HashAggregate (cost=3,258.57..3,742.26 rows=48,369 width=8) (actual time=129.402..160.653 rows=51,873 loops=1)

  • Group Key: signatures.id_contract
34. 83.489 83.489 ↓ 1.0 62,986 1

Seq Scan on signatures (cost=0.00..2,945.58 rows=62,598 width=8) (actual time=0.008..83.489 rows=62,986 loops=1)

  • Filter: (ghost IS FALSE)
  • Rows Removed by Filter: 274
35. 37.008 2,041.166 ↓ 5.3 15,575 1

Hash (cost=209,660.87..209,660.87 rows=2,921 width=386) (actual time=2,041.166..2,041.166 rows=15,575 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 5967kB
36. 20.403 2,004.158 ↓ 5.3 15,575 1

Hash Join (cost=2,163.28..209,660.87 rows=2,921 width=386) (actual time=23.251..2,004.158 rows=15,575 loops=1)

  • Hash Cond: (cev.type = at.type)
37. 23.629 1,983.733 ↓ 5.3 15,575 1

Hash Join (cost=2,161.96..209,619.40 rows=2,921 width=354) (actual time=23.218..1,983.733 rows=15,575 loops=1)

  • Hash Cond: (c.id_prod = p.id_prod)
38. 43.071 1,938.193 ↓ 5.3 15,575 1

Nested Loop (cost=1.72..207,404.39 rows=2,921 width=246) (actual time=1.280..1,938.193 rows=15,575 loops=1)

39. 41.106 851.597 ↓ 5.1 15,575 1

Nested Loop (cost=1.29..199,490.49 rows=3,061 width=205) (actual time=0.077..851.597 rows=15,575 loops=1)

40. 33.840 405.541 ↑ 1.6 15,575 1

Nested Loop (cost=0.86..133,530.88 rows=25,458 width=162) (actual time=0.050..405.541 rows=15,575 loops=1)

41. 44.626 44.626 ↑ 1.6 15,575 1

Index Scan using contr_external_vindication_ghost_index on contr_external_vindication cev (cost=0.43..57,507.05 rows=25,458 width=95) (actual time=0.022..44.626 rows=15,575 loops=1)

  • Index Cond: (ghost = false)
  • Filter: ((NOT ghost) AND (id_external_vindication = 12))
  • Rows Removed by Filter: 19694
42. 327.075 327.075 ↑ 1.0 1 15,575

Index Scan using contr_id_contract_index on contr c (cost=0.43..2.98 rows=1 width=67) (actual time=0.020..0.021 rows=1 loops=15,575)

  • Index Cond: (id_contract = cev.id_contract)
43. 404.950 404.950 ↑ 1.0 1 15,575

Index Scan using contr_debt_id_contract on contr_debt cd (cost=0.42..2.58 rows=1 width=43) (actual time=0.024..0.026 rows=1 loops=15,575)

  • Index Cond: (id_contract = c.id_contract)
44. 1,043.525 1,043.525 ↑ 1.0 1 15,575

Index Scan using modulo_owner_id_contract_index on modulo_owner mo (cost=0.43..2.58 rows=1 width=41) (actual time=0.065..0.067 rows=1 loops=15,575)

  • Index Cond: (id_contract = c.id_contract)
45. 3.214 21.911 ↑ 8.9 4,759 1

Hash (cost=1,628.44..1,628.44 rows=42,544 width=116) (actual time=21.911..21.911 rows=4,759 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 715kB
46. 18.697 18.697 ↑ 8.9 4,759 1

Seq Scan on products p (cost=0.00..1,628.44 rows=42,544 width=116) (actual time=0.527..18.697 rows=4,759 loops=1)

47. 0.007 0.022 ↑ 1.0 14 1

Hash (cost=1.14..1.14 rows=14 width=36) (actual time=0.022..0.022 rows=14 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
48. 0.015 0.015 ↑ 1.0 14 1

Seq Scan on assignment_type at (cost=0.00..1.14 rows=14 width=36) (actual time=0.009..0.015 rows=14 loops=1)

49. 3,194.383 7,086.625 ↓ 806.0 806 15,575

Materialize (cost=1,734.05..18,580.61 rows=1 width=11) (actual time=0.025..0.455 rows=806 loops=15,575)

50. 465.250 3,892.242 ↓ 806.0 806 1

Nested Loop (cost=1,734.05..18,580.60 rows=1 width=11) (actual time=377.511..3,892.242 rows=806 loops=1)

  • Join Filter: (irtp1.id_int_rate = pp.int_overdue_tab)
  • Rows Removed by Join Filter: 1554439
51. 320.439 532.963 ↓ 1,819.0 1,819 1

Merge Left Join (cost=1,733.63..14,882.98 rows=1 width=11) (actual time=10.078..532.963 rows=1,819 loops=1)

  • Merge Cond: (irtp1.id_int_rate = irtp2.id_int_rate)
  • Join Filter: (irtp2.int_date > irtp1.int_date)
  • Rows Removed by Join Filter: 404552
  • Filter: (irtp2.id_int_rate_pos IS NULL)
  • Rows Removed by Filter: 399253
52. 4.990 8.108 ↑ 1.0 5,165 1

Sort (cost=866.81..879.73 rows=5,165 width=19) (actual time=5.527..8.108 rows=5,165 loops=1)

  • Sort Key: irtp1.id_int_rate
  • Sort Method: quicksort Memory: 596kB
53. 3.118 3.118 ↑ 1.0 5,165 1

Seq Scan on interest_rate_tab_pos irtp1 (cost=0.00..548.27 rows=5,165 width=19) (actual time=0.677..3.118 rows=5,165 loops=1)

  • Filter: (id_currency = 1)
  • Rows Removed by Filter: 297
54. 202.070 204.416 ↓ 155.6 803,805 1

Sort (cost=866.81..879.73 rows=5,165 width=24) (actual time=4.541..204.416 rows=803,805 loops=1)

  • Sort Key: irtp2.id_int_rate
  • Sort Method: quicksort Memory: 596kB
55. 2.346 2.346 ↑ 1.0 5,165 1

Seq Scan on interest_rate_tab_pos irtp2 (cost=0.00..548.27 rows=5,165 width=24) (actual time=0.212..2.346 rows=5,165 loops=1)

  • Filter: (id_currency = 1)
  • Rows Removed by Filter: 297
56. 2,894.029 2,894.029 ↑ 1.3 855 1,819

Index Scan using prd_par_index on prd_par pp (cost=0.42..3,684.12 rows=1,080 width=16) (actual time=0.212..1.591 rows=855 loops=1,819)

  • Index Cond: (id_contract = (-1))
  • Filter: (int_overdue_tab IS NOT NULL)
  • Rows Removed by Filter: 3546
57. 1,635.375 1,635.375 ↓ 0.0 0 15,575

Index Scan using cont_reno_index on cont_reno cr (cost=0.41..2.55 rows=1 width=16) (actual time=0.101..0.105 rows=0 loops=15,575)

  • Index Cond: (id_contract = c.id_contract)
  • Filter: (renounciation_status = 3)
  • Rows Removed by Filter: 0
58. 57.866 3,155.921 ↓ 2.9 127,464 1

Hash (cost=554,852.50..554,852.50 rows=43,647 width=24) (actual time=3,155.921..3,155.921 rows=127,464 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 6526kB
59. 67.151 3,098.055 ↓ 2.9 127,464 1

Subquery Scan on other_contracts (cost=553,979.56..554,852.50 rows=43,647 width=24) (actual time=2,948.303..3,098.055 rows=127,464 loops=1)

60. 312.297 3,030.904 ↓ 2.9 127,464 1

HashAggregate (cost=553,979.56..554,416.03 rows=43,647 width=12) (actual time=2,948.302..3,030.904 rows=127,464 loops=1)

  • Group Key: mo_1.id_customer
61. 356.512 2,718.607 ↑ 6.4 211,297 1

Merge Join (cost=46.51..540,403.38 rows=1,357,618 width=12) (actual time=1.135..2,718.607 rows=211,297 loops=1)

  • Merge Cond: (mo_1.id_contract = c_2.id_contract)
62. 992.132 992.132 ↑ 7.9 319,616 1

Index Scan using modulo_owner_id_contract_status_index on modulo_owner mo_1 (cost=0.43..182,573.77 rows=2,535,928 width=16) (actual time=0.919..992.132 rows=319,616 loops=1)

63. 1,369.963 1,369.963 ↑ 8.2 369,269 1

Index Scan using contr_id_contract_index on contr c_2 (cost=0.43..330,347.97 rows=3,027,777 width=12) (actual time=0.021..1,369.963 rows=369,269 loops=1)

  • Filter: (((ref_no)::text !~~ 'SKW%'::text) AND ((ref_no)::text !~~ 'RB\%'::text))
  • Rows Removed by Filter: 310790
64. 18.257 1,459.340 ↓ 1.1 15,355 1

Sort (cost=27,725.72..27,760.53 rows=13,924 width=12) (actual time=1,449.906..1,459.340 rows=15,355 loops=1)

  • Sort Key: next_cycle.id_contract
  • Sort Method: quicksort Memory: 1105kB
65. 7.807 1,441.083 ↓ 1.1 15,364 1

Subquery Scan on next_cycle (cost=26,488.90..26,767.38 rows=13,924 width=12) (actual time=1,425.225..1,441.083 rows=15,364 loops=1)

66. 460.887 1,433.276 ↓ 1.1 15,364 1

HashAggregate (cost=26,488.90..26,628.14 rows=13,924 width=12) (actual time=1,425.223..1,433.276 rows=15,364 loops=1)

  • Group Key: cn_set_cc.id_contract
67. 972.389 972.389 ↑ 1.1 679,964 1

Seq Scan on cn_set_cc (cost=0.00..22,724.60 rows=752,860 width=12) (actual time=0.960..972.389 rows=679,964 loops=1)

68. 0.000 918.925 ↓ 0.0 0 15,575

Index Scan using sched_sched_id_payment_sched_pos_index on sched next_sched (cost=12,353.52..12,355.73 rows=1 width=20) (actual time=0.059..0.059 rows=0 loops=15,575)

  • Index Cond: (id_payment_sched_pos = (SubPlan 1))
69.          

SubPlan (forIndex Scan)

70. 46.725 303,634.625 ↓ 0.0 0 15,575

Limit (cost=12,352.95..12,352.95 rows=1 width=12) (actual time=19.495..19.495 rows=0 loops=15,575)

71. 155.750 303,587.900 ↓ 0.0 0 15,575

Sort (cost=12,352.95..12,359.72 rows=2,708 width=12) (actual time=19.492..19.492 rows=0 loops=15,575)

  • Sort Key: s.sched_date
  • Sort Method: quicksort Memory: 25kB
72. 279,820.450 303,432.150 ↑ 2,708.0 1 15,575

Bitmap Heap Scan on sched s (cost=97.34..12,339.41 rows=2,708 width=12) (actual time=19.423..19.482 rows=1 loops=15,575)

  • Recheck Cond: (id_contract = c.id_contract)
  • Filter: ((id_payment_sched_pos IS NOT NULL) AND (sched_date >= (now())::date))
  • Rows Removed by Filter: 4
  • Heap Blocks: exact=302666
73. 23,611.700 23,611.700 ↑ 186.6 44 15,575

Bitmap Index Scan on sched_sched_id_contract_index (cost=0.00..96.66 rows=8,212 width=0) (actual time=1.516..1.516 rows=44 loops=15,575)

  • Index Cond: (id_contract = c.id_contract)
74. 46.725 303,634.625 ↓ 0.0 0 15,575

Limit (cost=12,352.95..12,352.95 rows=1 width=12) (actual time=19.495..19.495 rows=0 loops=15,575)

75. 155.750 303,587.900 ↓ 0.0 0 15,575

Sort (cost=12,352.95..12,359.72 rows=2,708 width=12) (actual time=19.492..19.492 rows=0 loops=15,575)

  • Sort Key: s.sched_date
  • Sort Method: quicksort Memory: 25kB
76. 279,820.450 303,432.150 ↑ 2,708.0 1 15,575

Bitmap Heap Scan on sched s (cost=97.34..12,339.41 rows=2,708 width=12) (actual time=19.423..19.482 rows=1 loops=15,575)

  • Recheck Cond: (id_contract = c.id_contract)
  • Filter: ((id_payment_sched_pos IS NOT NULL) AND (sched_date >= (now())::date))
  • Rows Removed by Filter: 4
  • Heap Blocks: exact=302666
77. 23,611.700 23,611.700 ↑ 186.6 44 15,575

Bitmap Index Scan on sched_sched_id_contract_index (cost=0.00..96.66 rows=8,212 width=0) (actual time=1.516..1.516 rows=44 loops=15,575)

  • Index Cond: (id_contract = c.id_contract)
78. 62.300 482.825 ↓ 0.0 0 15,575

Append (cost=0.00..2.55 rows=2 width=42) (actual time=0.015..0.031 rows=0 loops=15,575)

79. 15.575 15.575 ↓ 0.0 0 15,575

Seq Scan on contr_reserve cres (cost=0.00..0.00 rows=1 width=72) (actual time=0.001..0.001 rows=0 loops=15,575)

  • Filter: ((ghost IS FALSE) AND (id_contract = c.id_contract))
80. 404.950 404.950 ↓ 0.0 0 15,575

Index Scan using contr_reserve_active_id_contract_index on contr_reserve_active cres_1 (cost=0.42..2.55 rows=1 width=12) (actual time=0.010..0.026 rows=0 loops=15,575)

  • Index Cond: (id_contract = c.id_contract)
  • Filter: (ghost IS FALSE)
81. 28,362.075 28,362.075 ↓ 0.0 0 15,575

Index Scan using comments_index on comments co (cost=0.43..14.69 rows=1 width=78) (actual time=1.821..1.821 rows=0 loops=15,575)

  • Index Cond: (id_contract = c.id_contract)
  • Filter: ((id_comm_category_pos = 742) AND (id_comm_category = 205))
  • Rows Removed by Filter: 2
82. 16.787 953.212 ↓ 21.7 11,892 1

Sort (cost=10,344.19..10,345.56 rows=548 width=12) (actual time=942.692..953.212 rows=11,892 loops=1)

  • Sort Key: last_agreement.id_contract
  • Sort Method: quicksort Memory: 942kB
83. 5.803 936.425 ↓ 21.7 11,892 1

Subquery Scan on last_agreement (cost=10,308.30..10,319.26 rows=548 width=12) (actual time=925.402..936.425 rows=11,892 loops=1)

84. 39.516 930.622 ↓ 21.7 11,892 1

HashAggregate (cost=10,308.30..10,313.78 rows=548 width=12) (actual time=925.400..930.622 rows=11,892 loops=1)

  • Group Key: comments.id_contract
85. 879.287 891.106 ↓ 2.1 16,307 1

Bitmap Heap Scan on comments (cost=92.38..10,270.27 rows=7,606 width=12) (actual time=23.994..891.106 rows=16,307 loops=1)

  • Recheck Cond: (id_comm_category_pos = 1142)
  • Heap Blocks: exact=12050
86. 11.819 11.819 ↓ 2.1 16,314 1

Bitmap Index Scan on comments_id_comm_category_pos_index (cost=0.00..90.48 rows=7,606 width=0) (actual time=11.819..11.819 rows=16,314 loops=1)

  • Index Cond: (id_comm_category_pos = 1142)
Planning time : 12.691 ms
Execution time : 775,356.865 ms