explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IL94

Settings
# exclusive inclusive rows x rows loops node
1. 15.707 27.777 ↑ 1.0 11,128 1

Sort (cost=6,265.84..6,293.68 rows=11,136 width=338) (actual time=24.07..27.777 rows=11,128 loops=1)

  • Sort Key: search_experiment_trigram_2017_01.created DESC
  • Sort Method: external merge Disk: 3888kB
  • Buffers: shared hit=4480, temp read=486 written=487
2. 1.503 12.070 ↑ 1.0 11,128 1

Append (cost=11.1..5,517.34 rows=11,136 width=338) (actual time=0.084..12.07 rows=11,128 loops=1)

  • Buffers: shared hit=4480
3. 0.187 0.255 ↑ 1.0 275 1

Bitmap Heap Scan on search_experiment_trigram_2017_01 search_experiment_trigram_2017_01 (cost=11.1..133.22 rows=275 width=338) (actual time=0.082..0.255 rows=275 loops=1)

  • Heap Blocks: exact=107
  • Buffers: shared hit=110
4. 0.068 0.068 ↑ 1.0 275 1

Bitmap Index Scan on search_experiment_trigram_201_merchant_id_payment_method_pa_idx (cost=0..11.03 rows=275 width=0) (actual time=0.068..0.068 rows=275 loops=1)

  • Index Cond: (((search_experiment_trigram_2017_01.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2017_01.payment_amount > 10.0))
  • Buffers: shared hit=3
5. 0.205 0.282 ↑ 1.0 260 1

Bitmap Heap Scan on search_experiment_trigram_2017_02 search_experiment_trigram_2017_02 (cost=10.94..123.84 rows=260 width=339) (actual time=0.092..0.282 rows=260 loops=1)

  • Heap Blocks: exact=102
  • Buffers: shared hit=105
6. 0.077 0.077 ↑ 1.0 260 1

Bitmap Index Scan on search_experiment_trigram_201_merchant_id_payment_method_p_idx1 (cost=0..10.88 rows=260 width=0) (actual time=0.077..0.077 rows=260 loops=1)

  • Index Cond: (((search_experiment_trigram_2017_02.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2017_02.payment_amount > 10.0))
  • Buffers: shared hit=3
7. 0.166 0.238 ↑ 1.0 265 1

Bitmap Heap Scan on search_experiment_trigram_2017_03 search_experiment_trigram_2017_03 (cost=11..131.97 rows=265 width=338) (actual time=0.087..0.238 rows=265 loops=1)

  • Heap Blocks: exact=105
  • Buffers: shared hit=108
8. 0.072 0.072 ↑ 1.0 265 1

Bitmap Index Scan on search_experiment_trigram_201_merchant_id_payment_method_p_idx2 (cost=0..10.93 rows=265 width=0) (actual time=0.072..0.072 rows=265 loops=1)

  • Index Cond: (((search_experiment_trigram_2017_03.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2017_03.payment_amount > 10.0))
  • Buffers: shared hit=3
9. 0.133 0.207 ↑ 1.0 276 1

Bitmap Heap Scan on search_experiment_trigram_2017_04 search_experiment_trigram_2017_04 (cost=11.11..133.25 rows=276 width=338) (actual time=0.089..0.207 rows=276 loops=1)

  • Heap Blocks: exact=110
  • Buffers: shared hit=113
10. 0.074 0.074 ↑ 1.0 276 1

Bitmap Index Scan on search_experiment_trigram_201_merchant_id_payment_method_p_idx3 (cost=0..11.04 rows=276 width=0) (actual time=0.074..0.074 rows=276 loops=1)

  • Index Cond: (((search_experiment_trigram_2017_04.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2017_04.payment_amount > 10.0))
  • Buffers: shared hit=3
11. 0.178 0.236 ↑ 1.0 284 1

Bitmap Heap Scan on search_experiment_trigram_2017_05 search_experiment_trigram_2017_05 (cost=11.19..134.45 rows=284 width=339) (actual time=0.07..0.236 rows=284 loops=1)

  • Heap Blocks: exact=114
  • Buffers: shared hit=117
12. 0.058 0.058 ↑ 1.0 284 1

Bitmap Index Scan on search_experiment_trigram_201_merchant_id_payment_method_p_idx4 (cost=0..11.12 rows=284 width=0) (actual time=0.058..0.058 rows=284 loops=1)

  • Index Cond: (((search_experiment_trigram_2017_05.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2017_05.payment_amount > 10.0))
  • Buffers: shared hit=3
13. 0.129 0.186 ↑ 1.0 280 1

Bitmap Heap Scan on search_experiment_trigram_2017_06 search_experiment_trigram_2017_06 (cost=11.15..131.35 rows=280 width=338) (actual time=0.069..0.186 rows=280 loops=1)

  • Heap Blocks: exact=106
  • Buffers: shared hit=109
14. 0.057 0.057 ↑ 1.0 280 1

Bitmap Index Scan on search_experiment_trigram_201_merchant_id_payment_method_p_idx5 (cost=0..11.08 rows=280 width=0) (actual time=0.057..0.057 rows=280 loops=1)

  • Index Cond: (((search_experiment_trigram_2017_06.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2017_06.payment_amount > 10.0))
  • Buffers: shared hit=3
15. 0.157 0.222 ↑ 1.0 314 1

Bitmap Heap Scan on search_experiment_trigram_2017_07 search_experiment_trigram_2017_07 (cost=11.5..138.21 rows=314 width=339) (actual time=0.076..0.222 rows=314 loops=1)

  • Heap Blocks: exact=112
  • Buffers: shared hit=116
16. 0.065 0.065 ↑ 1.0 314 1

Bitmap Index Scan on search_experiment_trigram_201_merchant_id_payment_method_p_idx6 (cost=0..11.42 rows=314 width=0) (actual time=0.064..0.065 rows=314 loops=1)

  • Index Cond: (((search_experiment_trigram_2017_07.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2017_07.payment_amount > 10.0))
  • Buffers: shared hit=4
17. 0.146 0.200 ↑ 1.0 244 1

Bitmap Heap Scan on search_experiment_trigram_2017_08 search_experiment_trigram_2017_08 (cost=10.78..131.44 rows=244 width=338) (actual time=0.065..0.2 rows=244 loops=1)

  • Heap Blocks: exact=101
  • Buffers: shared hit=104
18. 0.054 0.054 ↑ 1.0 244 1

Bitmap Index Scan on search_experiment_trigram_201_merchant_id_payment_method_p_idx7 (cost=0..10.72 rows=244 width=0) (actual time=0.054..0.054 rows=244 loops=1)

  • Index Cond: (((search_experiment_trigram_2017_08.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2017_08.payment_amount > 10.0))
  • Buffers: shared hit=3
19. 0.184 0.244 ↑ 1.0 271 1

Bitmap Heap Scan on search_experiment_trigram_2017_09 search_experiment_trigram_2017_09 (cost=11.06..133.12 rows=271 width=339) (actual time=0.072..0.244 rows=271 loops=1)

  • Heap Blocks: exact=109
  • Buffers: shared hit=112
20. 0.060 0.060 ↑ 1.0 271 1

Bitmap Index Scan on search_experiment_trigram_201_merchant_id_payment_method_p_idx8 (cost=0..10.99 rows=271 width=0) (actual time=0.06..0.06 rows=271 loops=1)

  • Index Cond: (((search_experiment_trigram_2017_09.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2017_09.payment_amount > 10.0))
  • Buffers: shared hit=3
21. 0.173 0.234 ↑ 1.0 285 1

Bitmap Heap Scan on search_experiment_trigram_2017_10 search_experiment_trigram_2017_10 (cost=11.2..131.48 rows=285 width=338) (actual time=0.073..0.234 rows=285 loops=1)

  • Heap Blocks: exact=109
  • Buffers: shared hit=112
22. 0.061 0.061 ↑ 1.0 285 1

Bitmap Index Scan on search_experiment_trigram_201_merchant_id_payment_method_p_idx9 (cost=0..11.13 rows=285 width=0) (actual time=0.061..0.061 rows=285 loops=1)

  • Index Cond: (((search_experiment_trigram_2017_10.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2017_10.payment_amount > 10.0))
  • Buffers: shared hit=3
23. 0.221 0.288 ↑ 1.0 321 1

Bitmap Heap Scan on search_experiment_trigram_2017_11 search_experiment_trigram_2017_11 (cost=11.57..135.39 rows=321 width=339) (actual time=0.079..0.288 rows=321 loops=1)

  • Heap Blocks: exact=111
  • Buffers: shared hit=114
24. 0.067 0.067 ↑ 1.0 321 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx10 (cost=0..11.49 rows=321 width=0) (actual time=0.067..0.067 rows=321 loops=1)

  • Index Cond: (((search_experiment_trigram_2017_11.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2017_11.payment_amount > 10.0))
  • Buffers: shared hit=3
25. 0.145 0.218 ↑ 1.0 296 1

Bitmap Heap Scan on search_experiment_trigram_2017_12 search_experiment_trigram_2017_12 (cost=11.31..133.75 rows=296 width=338) (actual time=0.086..0.218 rows=296 loops=1)

  • Heap Blocks: exact=109
  • Buffers: shared hit=112
26. 0.073 0.073 ↑ 1.0 296 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx11 (cost=0..11.24 rows=296 width=0) (actual time=0.073..0.073 rows=296 loops=1)

  • Index Cond: (((search_experiment_trigram_2017_12.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2017_12.payment_amount > 10.0))
  • Buffers: shared hit=3
27. 0.137 0.191 ↑ 1.0 258 1

Bitmap Heap Scan on search_experiment_trigram_2018_01 search_experiment_trigram_2018_01 (cost=10.92..134.79 rows=258 width=338) (actual time=0.065..0.191 rows=258 loops=1)

  • Heap Blocks: exact=108
  • Buffers: shared hit=111
28. 0.054 0.054 ↑ 1.0 258 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx12 (cost=0..10.86 rows=258 width=0) (actual time=0.054..0.054 rows=258 loops=1)

  • Index Cond: (((search_experiment_trigram_2018_01.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2018_01.payment_amount > 10.0))
  • Buffers: shared hit=3
29. 0.191 0.301 ↑ 1.0 246 1

Bitmap Heap Scan on search_experiment_trigram_2018_02 search_experiment_trigram_2018_02 (cost=10.8..122.49 rows=246 width=338) (actual time=0.127..0.301 rows=246 loops=1)

  • Heap Blocks: exact=95
  • Buffers: shared hit=99
30. 0.110 0.110 ↑ 1.0 246 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx13 (cost=0..10.74 rows=246 width=0) (actual time=0.11..0.11 rows=246 loops=1)

  • Index Cond: (((search_experiment_trigram_2018_02.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2018_02.payment_amount > 10.0))
  • Buffers: shared hit=4
31. 0.215 0.306 ↑ 1.0 285 1

Bitmap Heap Scan on search_experiment_trigram_2018_03 search_experiment_trigram_2018_03 (cost=11.2..137.48 rows=285 width=339) (actual time=0.108..0.306 rows=285 loops=1)

  • Heap Blocks: exact=109
  • Buffers: shared hit=112
32. 0.091 0.091 ↑ 1.0 285 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx14 (cost=0..11.13 rows=285 width=0) (actual time=0.091..0.091 rows=285 loops=1)

  • Index Cond: (((search_experiment_trigram_2018_03.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2018_03.payment_amount > 10.0))
  • Buffers: shared hit=3
33. 0.223 0.329 ↑ 1.0 263 1

Bitmap Heap Scan on search_experiment_trigram_2018_04 search_experiment_trigram_2018_04 (cost=10.98..125.92 rows=263 width=338) (actual time=0.123..0.329 rows=263 loops=1)

  • Heap Blocks: exact=104
  • Buffers: shared hit=107
34. 0.106 0.106 ↑ 1.0 263 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx15 (cost=0..10.91 rows=263 width=0) (actual time=0.105..0.106 rows=263 loops=1)

  • Index Cond: (((search_experiment_trigram_2018_04.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2018_04.payment_amount > 10.0))
  • Buffers: shared hit=3
35. 0.208 0.297 ↑ 1.0 279 1

Bitmap Heap Scan on search_experiment_trigram_2018_05 search_experiment_trigram_2018_05 (cost=11.14..134.32 rows=279 width=338) (actual time=0.105..0.297 rows=279 loops=1)

  • Heap Blocks: exact=108
  • Buffers: shared hit=111
36. 0.089 0.089 ↑ 1.0 279 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx16 (cost=0..11.07 rows=279 width=0) (actual time=0.088..0.089 rows=279 loops=1)

  • Index Cond: (((search_experiment_trigram_2018_05.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2018_05.payment_amount > 10.0))
  • Buffers: shared hit=3
37. 0.191 0.275 ↑ 1.0 270 1

Bitmap Heap Scan on search_experiment_trigram_2018_06 search_experiment_trigram_2018_06 (cost=11.05..132.1 rows=270 width=339) (actual time=0.098..0.275 rows=270 loops=1)

  • Heap Blocks: exact=102
  • Buffers: shared hit=105
38. 0.084 0.084 ↑ 1.0 270 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx17 (cost=0..10.98 rows=270 width=0) (actual time=0.083..0.084 rows=270 loops=1)

  • Index Cond: (((search_experiment_trigram_2018_06.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2018_06.payment_amount > 10.0))
  • Buffers: shared hit=3
39. 0.247 0.355 ↑ 1.0 291 1

Bitmap Heap Scan on search_experiment_trigram_2018_07 search_experiment_trigram_2018_07 (cost=11.26..137.63 rows=291 width=339) (actual time=0.129..0.355 rows=291 loops=1)

  • Heap Blocks: exact=110
  • Buffers: shared hit=113
40. 0.108 0.108 ↑ 1.0 291 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx18 (cost=0..11.19 rows=291 width=0) (actual time=0.108..0.108 rows=291 loops=1)

  • Index Cond: (((search_experiment_trigram_2018_07.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2018_07.payment_amount > 10.0))
  • Buffers: shared hit=3
41. 0.175 0.256 ↑ 1.0 256 1

Bitmap Heap Scan on search_experiment_trigram_2018_08 search_experiment_trigram_2018_08 (cost=10.9..135.74 rows=256 width=338) (actual time=0.095..0.256 rows=256 loops=1)

  • Heap Blocks: exact=107
  • Buffers: shared hit=110
42. 0.081 0.081 ↑ 1.0 256 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx19 (cost=0..10.84 rows=256 width=0) (actual time=0.081..0.081 rows=256 loops=1)

  • Index Cond: (((search_experiment_trigram_2018_08.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2018_08.payment_amount > 10.0))
  • Buffers: shared hit=3
43. 0.194 0.250 ↑ 1.0 244 1

Bitmap Heap Scan on search_experiment_trigram_2018_09 search_experiment_trigram_2018_09 (cost=10.78..132.44 rows=244 width=338) (actual time=0.066..0.25 rows=244 loops=1)

  • Heap Blocks: exact=102
  • Buffers: shared hit=105
44. 0.056 0.056 ↑ 1.0 244 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx20 (cost=0..10.72 rows=244 width=0) (actual time=0.055..0.056 rows=244 loops=1)

  • Index Cond: (((search_experiment_trigram_2018_09.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2018_09.payment_amount > 10.0))
  • Buffers: shared hit=3
45. 0.290 0.370 ↑ 1.0 275 1

Bitmap Heap Scan on search_experiment_trigram_2018_10 search_experiment_trigram_2018_10 (cost=11.1..136.22 rows=275 width=338) (actual time=0.095..0.37 rows=275 loops=1)

  • Heap Blocks: exact=110
  • Buffers: shared hit=113
46. 0.080 0.080 ↑ 1.0 275 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx21 (cost=0..11.03 rows=275 width=0) (actual time=0.08..0.08 rows=275 loops=1)

  • Index Cond: (((search_experiment_trigram_2018_10.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2018_10.payment_amount > 10.0))
  • Buffers: shared hit=3
47. 0.233 0.306 ↑ 1.0 275 1

Bitmap Heap Scan on search_experiment_trigram_2018_11 search_experiment_trigram_2018_11 (cost=11.1..131.22 rows=275 width=339) (actual time=0.089..0.306 rows=275 loops=1)

  • Heap Blocks: exact=109
  • Buffers: shared hit=112
48. 0.073 0.073 ↑ 1.0 275 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx22 (cost=0..11.03 rows=275 width=0) (actual time=0.072..0.073 rows=275 loops=1)

  • Index Cond: (((search_experiment_trigram_2018_11.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2018_11.payment_amount > 10.0))
  • Buffers: shared hit=3
49. 0.222 0.311 ↑ 1.0 298 1

Bitmap Heap Scan on search_experiment_trigram_2018_12 search_experiment_trigram_2018_12 (cost=11.33..139.8 rows=298 width=339) (actual time=0.105..0.311 rows=298 loops=1)

  • Heap Blocks: exact=117
  • Buffers: shared hit=120
50. 0.089 0.089 ↑ 1.0 298 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx23 (cost=0..11.26 rows=298 width=0) (actual time=0.088..0.089 rows=298 loops=1)

  • Index Cond: (((search_experiment_trigram_2018_12.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2018_12.payment_amount > 10.0))
  • Buffers: shared hit=3
51. 0.192 0.254 ↑ 1.0 287 1

Bitmap Heap Scan on search_experiment_trigram_2019_01 search_experiment_trigram_2019_01 (cost=11.22..141.53 rows=287 width=339) (actual time=0.073..0.254 rows=287 loops=1)

  • Heap Blocks: exact=110
  • Buffers: shared hit=113
52. 0.062 0.062 ↑ 1.0 287 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx24 (cost=0..11.15 rows=287 width=0) (actual time=0.061..0.062 rows=287 loops=1)

  • Index Cond: (((search_experiment_trigram_2019_01.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2019_01.payment_amount > 10.0))
  • Buffers: shared hit=3
53. 0.153 0.207 ↑ 1.0 221 1

Bitmap Heap Scan on search_experiment_trigram_2019_02 search_experiment_trigram_2019_02 (cost=10.55..119.86 rows=221 width=339) (actual time=0.099..0.207 rows=221 loops=1)

  • Heap Blocks: exact=91
  • Buffers: shared hit=95
54. 0.054 0.054 ↑ 1.0 221 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx25 (cost=0..10.49 rows=221 width=0) (actual time=0.053..0.054 rows=221 loops=1)

  • Index Cond: (((search_experiment_trigram_2019_02.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2019_02.payment_amount > 10.0))
  • Buffers: shared hit=4
55. 0.156 0.223 ↑ 1.0 294 1

Bitmap Heap Scan on search_experiment_trigram_2019_03 search_experiment_trigram_2019_03 (cost=11.29..140.7 rows=294 width=338) (actual time=0.079..0.223 rows=294 loops=1)

  • Heap Blocks: exact=116
  • Buffers: shared hit=120
56. 0.067 0.067 ↑ 1.0 294 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx26 (cost=0..11.22 rows=294 width=0) (actual time=0.067..0.067 rows=294 loops=1)

  • Index Cond: (((search_experiment_trigram_2019_03.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2019_03.payment_amount > 10.0))
  • Buffers: shared hit=4
57. 0.201 0.298 ↑ 1.0 285 1

Bitmap Heap Scan on search_experiment_trigram_2019_04 search_experiment_trigram_2019_04 (cost=11.2..129.48 rows=285 width=339) (actual time=0.109..0.298 rows=285 loops=1)

  • Heap Blocks: exact=105
  • Buffers: shared hit=108
58. 0.097 0.097 ↑ 1.0 285 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx27 (cost=0..11.13 rows=285 width=0) (actual time=0.097..0.097 rows=285 loops=1)

  • Index Cond: (((search_experiment_trigram_2019_04.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2019_04.payment_amount > 10.0))
  • Buffers: shared hit=3
59. 0.269 0.347 ↑ 1.0 300 1

Bitmap Heap Scan on search_experiment_trigram_2019_05 search_experiment_trigram_2019_05 (cost=11.35..137.85 rows=300 width=338) (actual time=0.092..0.347 rows=300 loops=1)

  • Heap Blocks: exact=112
  • Buffers: shared hit=115
60. 0.078 0.078 ↑ 1.0 300 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx28 (cost=0..11.28 rows=300 width=0) (actual time=0.078..0.078 rows=300 loops=1)

  • Index Cond: (((search_experiment_trigram_2019_05.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2019_05.payment_amount > 10.0))
  • Buffers: shared hit=3
61. 0.171 0.251 ↑ 1.0 264 1

Bitmap Heap Scan on search_experiment_trigram_2019_06 search_experiment_trigram_2019_06 (cost=10.99..135.95 rows=264 width=338) (actual time=0.094..0.251 rows=264 loops=1)

  • Heap Blocks: exact=108
  • Buffers: shared hit=111
62. 0.080 0.080 ↑ 1.0 264 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx29 (cost=0..10.92 rows=264 width=0) (actual time=0.079..0.08 rows=264 loops=1)

  • Index Cond: (((search_experiment_trigram_2019_06.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2019_06.payment_amount > 10.0))
  • Buffers: shared hit=3
63. 0.227 0.287 ↑ 1.0 264 1

Bitmap Heap Scan on search_experiment_trigram_2019_07 search_experiment_trigram_2019_07 (cost=10.99..131.95 rows=264 width=338) (actual time=0.149..0.287 rows=264 loops=1)

  • Heap Blocks: exact=105
  • Buffers: shared hit=108
64. 0.060 0.060 ↑ 1.0 264 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx30 (cost=0..10.92 rows=264 width=0) (actual time=0.06..0.06 rows=264 loops=1)

  • Index Cond: (((search_experiment_trigram_2019_07.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2019_07.payment_amount > 10.0))
  • Buffers: shared hit=3
65. 0.156 0.244 ↑ 1.0 284 1

Bitmap Heap Scan on search_experiment_trigram_2019_08 search_experiment_trigram_2019_08 (cost=11.19..136.45 rows=284 width=338) (actual time=0.102..0.244 rows=284 loops=1)

  • Heap Blocks: exact=104
  • Buffers: shared hit=107
66. 0.088 0.088 ↑ 1.0 284 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx31 (cost=0..11.12 rows=284 width=0) (actual time=0.088..0.088 rows=284 loops=1)

  • Index Cond: (((search_experiment_trigram_2019_08.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2019_08.payment_amount > 10.0))
  • Buffers: shared hit=3
67. 0.153 0.220 ↑ 1.0 300 1

Bitmap Heap Scan on search_experiment_trigram_2019_09 search_experiment_trigram_2019_09 (cost=11.35..130.85 rows=300 width=339) (actual time=0.079..0.22 rows=300 loops=1)

  • Heap Blocks: exact=105
  • Buffers: shared hit=108
68. 0.067 0.067 ↑ 1.0 300 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx32 (cost=0..11.28 rows=300 width=0) (actual time=0.067..0.067 rows=300 loops=1)

  • Index Cond: (((search_experiment_trigram_2019_09.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2019_09.payment_amount > 10.0))
  • Buffers: shared hit=3
69. 0.229 0.335 ↑ 1.0 322 1

Bitmap Heap Scan on search_experiment_trigram_2019_10 search_experiment_trigram_2019_10 (cost=11.59..138.44 rows=323 width=339) (actual time=0.119..0.335 rows=322 loops=1)

  • Heap Blocks: exact=114
  • Buffers: shared hit=118
70. 0.106 0.106 ↑ 1.0 322 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx33 (cost=0..11.51 rows=323 width=0) (actual time=0.106..0.106 rows=322 loops=1)

  • Index Cond: (((search_experiment_trigram_2019_10.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2019_10.payment_amount > 10.0))
  • Buffers: shared hit=4
71. 0.157 0.218 ↑ 1.0 252 1

Bitmap Heap Scan on search_experiment_trigram_2019_11 search_experiment_trigram_2019_11 (cost=10.86..128.64 rows=252 width=338) (actual time=0.074..0.218 rows=252 loops=1)

  • Heap Blocks: exact=105
  • Buffers: shared hit=108
72. 0.061 0.061 ↑ 1.0 252 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx34 (cost=0..10.8 rows=252 width=0) (actual time=0.061..0.061 rows=252 loops=1)

  • Index Cond: (((search_experiment_trigram_2019_11.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2019_11.payment_amount > 10.0))
  • Buffers: shared hit=3
73. 0.145 0.201 ↑ 1.0 247 1

Bitmap Heap Scan on search_experiment_trigram_2019_12 search_experiment_trigram_2019_12 (cost=10.81..132.52 rows=247 width=338) (actual time=0.068..0.201 rows=247 loops=1)

  • Heap Blocks: exact=104
  • Buffers: shared hit=107
74. 0.056 0.056 ↑ 1.0 247 1

Bitmap Index Scan on search_experiment_trigram_20_merchant_id_payment_method_p_idx35 (cost=0..10.75 rows=247 width=0) (actual time=0.056..0.056 rows=247 loops=1)

  • Index Cond: (((search_experiment_trigram_2019_12.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2019_12.payment_amount > 10.0))
  • Buffers: shared hit=3
75. 0.192 0.253 ↑ 1.0 292 1

Bitmap Heap Scan on search_experiment_trigram_2020_01 search_experiment_trigram_2020_01 (cost=11.27..134.65 rows=292 width=339) (actual time=0.072..0.253 rows=292 loops=1)

  • Heap Blocks: exact=110
  • Buffers: shared hit=113
76. 0.061 0.061 ↑ 1.0 292 1

Bitmap Index Scan on search_experiment_trigram_202_merchant_id_payment_method_pa_idx (cost=0..11.2 rows=292 width=0) (actual time=0.061..0.061 rows=292 loops=1)

  • Index Cond: (((search_experiment_trigram_2020_01.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2020_01.payment_amount > 10.0))
  • Buffers: shared hit=3
77. 0.136 0.197 ↑ 1.0 253 1

Bitmap Heap Scan on search_experiment_trigram_2020_02 search_experiment_trigram_2020_02 (cost=10.87..123.67 rows=253 width=339) (actual time=0.073..0.197 rows=253 loops=1)

  • Heap Blocks: exact=101
  • Buffers: shared hit=104
78. 0.061 0.061 ↑ 1.0 253 1

Bitmap Index Scan on search_experiment_trigram_202_merchant_id_payment_method_p_idx1 (cost=0..10.81 rows=253 width=0) (actual time=0.061..0.061 rows=253 loops=1)

  • Index Cond: (((search_experiment_trigram_2020_02.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2020_02.payment_amount > 10.0))
  • Buffers: shared hit=3
79. 0.198 0.254 ↑ 1.0 253 1

Bitmap Heap Scan on search_experiment_trigram_2020_03 search_experiment_trigram_2020_03 (cost=10.87..134.67 rows=253 width=338) (actual time=0.068..0.254 rows=253 loops=1)

  • Heap Blocks: exact=110
  • Buffers: shared hit=113
80. 0.056 0.056 ↑ 1.0 253 1

Bitmap Index Scan on search_experiment_trigram_202_merchant_id_payment_method_p_idx2 (cost=0..10.81 rows=253 width=0) (actual time=0.056..0.056 rows=253 loops=1)

  • Index Cond: (((search_experiment_trigram_2020_03.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2020_03.payment_amount > 10.0))
  • Buffers: shared hit=3
81. 0.201 0.262 ↑ 1.0 249 1

Bitmap Heap Scan on search_experiment_trigram_2020_04 search_experiment_trigram_2020_04 (cost=10.83..132.57 rows=249 width=338) (actual time=0.076..0.262 rows=249 loops=1)

  • Heap Blocks: exact=106
  • Buffers: shared hit=109
82. 0.061 0.061 ↑ 1.0 249 1

Bitmap Index Scan on search_experiment_trigram_202_merchant_id_payment_method_p_idx3 (cost=0..10.77 rows=249 width=0) (actual time=0.061..0.061 rows=249 loops=1)

  • Index Cond: (((search_experiment_trigram_2020_04.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2020_04.payment_amount > 10.0))
  • Buffers: shared hit=3
83. 0.095 0.141 ↑ 1.0 150 1

Bitmap Heap Scan on search_experiment_trigram_2020_05 search_experiment_trigram_2020_05 (cost=9.81..83.06 rows=150 width=338) (actual time=0.056..0.141 rows=150 loops=1)

  • Heap Blocks: exact=64
  • Buffers: shared hit=66
84. 0.046 0.046 ↑ 1.0 150 1

Bitmap Index Scan on search_experiment_trigram_202_merchant_id_payment_method_p_idx4 (cost=0..9.78 rows=150 width=0) (actual time=0.046..0.046 rows=150 loops=1)

  • Index Cond: (((search_experiment_trigram_2020_05.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2020_05.payment_amount > 10.0))
  • Buffers: shared hit=2
85. 0.005 0.005 ↓ 0.0 0 1

Index Scan using search_experiment_trigram_202_merchant_id_payment_method_p_idx5 on search_experiment_trigram_2020_06 search_experiment_trigram_2020_06 (cost=0.15..8.17 rows=1 width=270) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: (((search_experiment_trigram_2020_06.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2020_06.payment_amount > 10.0))
  • Buffers: shared hit=1
86. 0.003 0.003 ↓ 0.0 0 1

Index Scan using search_experiment_trigram_202_merchant_id_payment_method_p_idx6 on search_experiment_trigram_2020_07 search_experiment_trigram_2020_07 (cost=0.15..8.17 rows=1 width=270) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (((search_experiment_trigram_2020_07.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2020_07.payment_amount > 10.0))
  • Buffers: shared hit=1
87. 0.002 0.002 ↓ 0.0 0 1

Index Scan using search_experiment_trigram_202_merchant_id_payment_method_p_idx7 on search_experiment_trigram_2020_08 search_experiment_trigram_2020_08 (cost=0.15..8.17 rows=1 width=270) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (((search_experiment_trigram_2020_08.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2020_08.payment_amount > 10.0))
  • Buffers: shared hit=1
88. 0.002 0.002 ↓ 0.0 0 1

Index Scan using search_experiment_trigram_202_merchant_id_payment_method_p_idx8 on search_experiment_trigram_2020_09 search_experiment_trigram_2020_09 (cost=0.15..8.17 rows=1 width=270) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (((search_experiment_trigram_2020_09.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2020_09.payment_amount > 10.0))
  • Buffers: shared hit=1
89. 0.002 0.002 ↓ 0.0 0 1

Index Scan using search_experiment_trigram_202_merchant_id_payment_method_p_idx9 on search_experiment_trigram_2020_10 search_experiment_trigram_2020_10 (cost=0.15..8.17 rows=1 width=270) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (((search_experiment_trigram_2020_10.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2020_10.payment_amount > 10.0))
  • Buffers: shared hit=1
90. 0.002 0.002 ↓ 0.0 0 1

Index Scan using search_experiment_trigram_20_merchant_id_payment_method_p_idx36 on search_experiment_trigram_2020_11 search_experiment_trigram_2020_11 (cost=0.15..8.17 rows=1 width=270) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (((search_experiment_trigram_2020_11.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2020_11.payment_amount > 10.0))
  • Buffers: shared hit=1
91. 0.002 0.002 ↓ 0.0 0 1

Index Scan using search_experiment_trigram_20_merchant_id_payment_method_p_idx37 on search_experiment_trigram_2020_12 search_experiment_trigram_2020_12 (cost=0.15..8.17 rows=1 width=270) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (((search_experiment_trigram_2020_12.merchant_id)::text = '1488'::text) AND (search_experiment_trigram_2020_12.payment_amount > 10.0))
  • Buffers: shared hit=1
Planning time : 4.832 ms
Execution time : 30.784 ms