explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FEUK

Settings
# exclusive inclusive rows x rows loops node
1. 22.177 34.596 ↑ 1.0 11,128 1

Sort (cost=6,265.84..6,293.68 rows=11,136 width=338) (actual time=30.387..34.596 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.546 12.419 ↑ 1.0 11,128 1

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

  • Buffers: shared hit=4480
3. 0.131 0.195 ↑ 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.077..0.195 rows=275 loops=1)

  • Heap Blocks: exact=107
  • Buffers: shared hit=110
4. 0.064 0.064 ↑ 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.064..0.064 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.166 0.220 ↑ 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.065..0.22 rows=260 loops=1)

  • Heap Blocks: exact=102
  • Buffers: shared hit=105
6. 0.054 0.054 ↑ 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.054..0.054 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.125 0.180 ↑ 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.066..0.18 rows=265 loops=1)

  • Heap Blocks: exact=105
  • Buffers: shared hit=108
8. 0.055 0.055 ↑ 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.055..0.055 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.130 0.186 ↑ 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.067..0.186 rows=276 loops=1)

  • Heap Blocks: exact=110
  • Buffers: shared hit=113
10. 0.056 0.056 ↑ 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.056..0.056 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.171 0.229 ↑ 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.069..0.229 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.127 0.185 ↑ 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.185 rows=280 loops=1)

  • Heap Blocks: exact=106
  • Buffers: shared hit=109
14. 0.058 0.058 ↑ 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.058..0.058 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.131 0.194 ↑ 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.074..0.194 rows=314 loops=1)

  • Heap Blocks: exact=112
  • Buffers: shared hit=116
16. 0.063 0.063 ↑ 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.063..0.063 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.120 0.170 ↑ 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.06..0.17 rows=244 loops=1)

  • Heap Blocks: exact=101
  • Buffers: shared hit=104
18. 0.050 0.050 ↑ 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.05..0.05 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.150 0.206 ↑ 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.068..0.206 rows=271 loops=1)

  • Heap Blocks: exact=109
  • Buffers: shared hit=112
20. 0.056 0.056 ↑ 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.056..0.056 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.133 0.191 ↑ 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.068..0.191 rows=285 loops=1)

  • Heap Blocks: exact=109
  • Buffers: shared hit=112
22. 0.058 0.058 ↑ 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.058..0.058 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.141 0.204 ↑ 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.075..0.204 rows=321 loops=1)

  • Heap Blocks: exact=111
  • Buffers: shared hit=114
24. 0.063 0.063 ↑ 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.063..0.063 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.184 0.244 ↑ 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.07..0.244 rows=296 loops=1)

  • Heap Blocks: exact=109
  • Buffers: shared hit=112
26. 0.060 0.060 ↑ 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.059..0.06 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.144 0.204 ↑ 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.074..0.204 rows=258 loops=1)

  • Heap Blocks: exact=108
  • Buffers: shared hit=111
28. 0.060 0.060 ↑ 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.06..0.06 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.136 0.187 ↑ 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.062..0.187 rows=246 loops=1)

  • Heap Blocks: exact=95
  • Buffers: shared hit=99
30. 0.051 0.051 ↑ 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.051..0.051 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.286 0.348 ↑ 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.073..0.348 rows=285 loops=1)

  • Heap Blocks: exact=109
  • Buffers: shared hit=112
32. 0.062 0.062 ↑ 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.061..0.062 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.153 0.221 ↑ 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.082..0.221 rows=263 loops=1)

  • Heap Blocks: exact=104
  • Buffers: shared hit=107
34. 0.068 0.068 ↑ 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.068..0.068 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.190 0.252 ↑ 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.074..0.252 rows=279 loops=1)

  • Heap Blocks: exact=108
  • Buffers: shared hit=111
36. 0.062 0.062 ↑ 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.062..0.062 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.234 0.361 ↑ 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.145..0.361 rows=270 loops=1)

  • Heap Blocks: exact=102
  • Buffers: shared hit=105
38. 0.127 0.127 ↑ 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.127..0.127 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.233 0.321 ↑ 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.105..0.321 rows=291 loops=1)

  • Heap Blocks: exact=110
  • Buffers: shared hit=113
40. 0.088 0.088 ↑ 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.088..0.088 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.197 0.261 ↑ 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.077..0.261 rows=256 loops=1)

  • Heap Blocks: exact=107
  • Buffers: shared hit=110
42. 0.064 0.064 ↑ 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.064..0.064 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.123 0.178 ↑ 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.065..0.178 rows=244 loops=1)

  • Heap Blocks: exact=102
  • Buffers: shared hit=105
44. 0.055 0.055 ↑ 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.055 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.136 0.192 ↑ 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.067..0.192 rows=275 loops=1)

  • Heap Blocks: exact=110
  • Buffers: shared hit=113
46. 0.056 0.056 ↑ 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.056..0.056 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.134 0.190 ↑ 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.067..0.19 rows=275 loops=1)

  • Heap Blocks: exact=109
  • Buffers: shared hit=112
48. 0.056 0.056 ↑ 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.056..0.056 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.144 0.223 ↑ 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.091..0.223 rows=298 loops=1)

  • Heap Blocks: exact=117
  • Buffers: shared hit=120
50. 0.079 0.079 ↑ 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.079..0.079 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.137 0.195 ↑ 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.068..0.195 rows=287 loops=1)

  • Heap Blocks: exact=110
  • Buffers: shared hit=113
52. 0.058 0.058 ↑ 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.057..0.058 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.113 0.158 ↑ 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.054..0.158 rows=221 loops=1)

  • Heap Blocks: exact=91
  • Buffers: shared hit=95
54. 0.045 0.045 ↑ 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.045..0.045 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.223 0.293 ↑ 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.082..0.293 rows=294 loops=1)

  • Heap Blocks: exact=116
  • Buffers: shared hit=120
56. 0.070 0.070 ↑ 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.07..0.07 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.405 0.471 ↑ 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.079..0.471 rows=285 loops=1)

  • Heap Blocks: exact=105
  • Buffers: shared hit=108
58. 0.066 0.066 ↑ 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.066..0.066 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.370 0.529 ↑ 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.187..0.529 rows=300 loops=1)

  • Heap Blocks: exact=112
  • Buffers: shared hit=115
60. 0.159 0.159 ↑ 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.159..0.159 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.258 0.421 ↑ 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.246..0.421 rows=264 loops=1)

  • Heap Blocks: exact=108
  • Buffers: shared hit=111
62. 0.163 0.163 ↑ 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.163..0.163 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.273 0.348 ↑ 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.09..0.348 rows=264 loops=1)

  • Heap Blocks: exact=105
  • Buffers: shared hit=108
64. 0.075 0.075 ↑ 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.075..0.075 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.196 0.284 ↑ 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.103..0.284 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.233 0.326 ↑ 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.108..0.326 rows=300 loops=1)

  • Heap Blocks: exact=105
  • Buffers: shared hit=108
68. 0.093 0.093 ↑ 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.093..0.093 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.256 0.381 ↑ 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.145..0.381 rows=322 loops=1)

  • Heap Blocks: exact=114
  • Buffers: shared hit=118
70. 0.125 0.125 ↑ 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.125..0.125 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.248 0.336 ↑ 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.106..0.336 rows=252 loops=1)

  • Heap Blocks: exact=105
  • Buffers: shared hit=108
72. 0.088 0.088 ↑ 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.088..0.088 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.248 0.377 ↑ 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.149..0.377 rows=247 loops=1)

  • Heap Blocks: exact=104
  • Buffers: shared hit=107
74. 0.129 0.129 ↑ 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.129..0.129 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.250 0.343 ↑ 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.111..0.343 rows=292 loops=1)

  • Heap Blocks: exact=110
  • Buffers: shared hit=113
76. 0.093 0.093 ↑ 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.093..0.093 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.187 0.292 ↑ 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.122..0.292 rows=253 loops=1)

  • Heap Blocks: exact=101
  • Buffers: shared hit=104
78. 0.105 0.105 ↑ 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.105..0.105 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.193 0.268 ↑ 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.091..0.268 rows=253 loops=1)

  • Heap Blocks: exact=110
  • Buffers: shared hit=113
80. 0.075 0.075 ↑ 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.075..0.075 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.233 0.311 ↑ 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.093..0.311 rows=249 loops=1)

  • Heap Blocks: exact=106
  • Buffers: shared hit=109
82. 0.078 0.078 ↑ 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.078..0.078 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.125 0.175 ↑ 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.061..0.175 rows=150 loops=1)

  • Heap Blocks: exact=64
  • Buffers: shared hit=66
84. 0.050 0.050 ↑ 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.049..0.05 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.006 0.006 ↓ 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.006..0.006 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.003 0.003 ↓ 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.003..0.003 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.003 0.003 ↓ 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.003..0.003 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.003 0.003 ↓ 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.003..0.003 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.003 0.003 ↓ 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.003..0.003 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 : 5.431 ms
Execution time : 37.532 ms