explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7wna

Settings
# exclusive inclusive rows x rows loops node
1. 21.660 36.712 ↑ 1.0 11,128 1

Sort (cost=6,166.02..6,193.86 rows=11,136 width=338) (actual time=33.729..36.712 rows=11,128 loops=1)

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

Append (cost=10.41..5,417.51 rows=11,136 width=338) (actual time=0.079..15.052 rows=11,128 loops=1)

  • Buffers: shared hit=4473
3. 0.293 0.343 ↑ 1.0 275 1

Bitmap Heap Scan on search_experiment_trigram_2017_01 search_experiment_trigram_2017_01 (cost=10.41..132.54 rows=275 width=338) (actual time=0.077..0.343 rows=275 loops=1)

  • Filter: (search_experiment_trigram_2017_01.payment_amount > 10.0)
  • Heap Blocks: exact=107
  • Buffers: shared hit=110
4. 0.050 0.050 ↑ 1.0 275 1

Bitmap Index Scan on search_experiment_trigram_2017_01_merchant_id_idx (cost=0..10.34 rows=275 width=0) (actual time=0.05..0.05 rows=275 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_01.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
5. 0.242 0.280 ↑ 1.0 260 1

Bitmap Heap Scan on search_experiment_trigram_2017_02 search_experiment_trigram_2017_02 (cost=10.29..123.2 rows=260 width=339) (actual time=0.056..0.28 rows=260 loops=1)

  • Filter: (search_experiment_trigram_2017_02.payment_amount > 10.0)
  • Heap Blocks: exact=102
  • Buffers: shared hit=105
6. 0.038 0.038 ↑ 1.0 260 1

Bitmap Index Scan on search_experiment_trigram_2017_02_merchant_id_idx (cost=0..10.23 rows=260 width=0) (actual time=0.038..0.038 rows=260 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_02.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
7. 0.229 0.271 ↑ 1.0 265 1

Bitmap Heap Scan on search_experiment_trigram_2017_03 search_experiment_trigram_2017_03 (cost=6.33..127.31 rows=265 width=338) (actual time=0.059..0.271 rows=265 loops=1)

  • Filter: (search_experiment_trigram_2017_03.payment_amount > 10.0)
  • Heap Blocks: exact=105
  • Buffers: shared hit=108
8. 0.042 0.042 ↑ 1.0 265 1

Bitmap Index Scan on search_experiment_trigram_2017_03_merchant_id_idx (cost=0..6.27 rows=265 width=0) (actual time=0.042..0.042 rows=265 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_03.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
9. 0.240 0.354 ↑ 1.0 276 1

Bitmap Heap Scan on search_experiment_trigram_2017_04 search_experiment_trigram_2017_04 (cost=10.42..132.56 rows=276 width=338) (actual time=0.135..0.354 rows=276 loops=1)

  • Filter: (search_experiment_trigram_2017_04.payment_amount > 10.0)
  • Heap Blocks: exact=110
  • Buffers: shared hit=113
10. 0.114 0.114 ↑ 1.0 276 1

Bitmap Index Scan on search_experiment_trigram_2017_04_merchant_id_idx (cost=0..10.35 rows=276 width=0) (actual time=0.114..0.114 rows=276 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_04.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
11. 0.306 0.341 ↑ 1.0 284 1

Bitmap Heap Scan on search_experiment_trigram_2017_05 search_experiment_trigram_2017_05 (cost=10.48..133.74 rows=284 width=339) (actual time=0.083..0.341 rows=284 loops=1)

  • Filter: (search_experiment_trigram_2017_05.payment_amount > 10.0)
  • Heap Blocks: exact=114
  • Buffers: shared hit=117
12. 0.035 0.035 ↑ 1.0 284 1

Bitmap Index Scan on search_experiment_trigram_2017_05_merchant_id_idx (cost=0..10.41 rows=284 width=0) (actual time=0.035..0.035 rows=284 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_05.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
13. 0.205 0.237 ↑ 1.0 280 1

Bitmap Heap Scan on search_experiment_trigram_2017_06 search_experiment_trigram_2017_06 (cost=10.45..130.65 rows=280 width=338) (actual time=0.046..0.237 rows=280 loops=1)

  • Filter: (search_experiment_trigram_2017_06.payment_amount > 10.0)
  • Heap Blocks: exact=106
  • Buffers: shared hit=109
14. 0.032 0.032 ↑ 1.0 280 1

Bitmap Index Scan on search_experiment_trigram_2017_06_merchant_id_idx (cost=0..10.38 rows=280 width=0) (actual time=0.032..0.032 rows=280 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_06.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
15. 0.239 0.269 ↑ 1.0 314 1

Bitmap Heap Scan on search_experiment_trigram_2017_07 search_experiment_trigram_2017_07 (cost=10.71..137.42 rows=314 width=339) (actual time=0.044..0.269 rows=314 loops=1)

  • Filter: (search_experiment_trigram_2017_07.payment_amount > 10.0)
  • Heap Blocks: exact=112
  • Buffers: shared hit=114
16. 0.030 0.030 ↑ 1.0 314 1

Bitmap Index Scan on search_experiment_trigram_2017_07_merchant_id_idx (cost=0..10.63 rows=314 width=0) (actual time=0.03..0.03 rows=314 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_07.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=2
17. 0.301 0.334 ↑ 1.0 244 1

Bitmap Heap Scan on search_experiment_trigram_2017_08 search_experiment_trigram_2017_08 (cost=6.17..126.83 rows=244 width=338) (actual time=0.048..0.334 rows=244 loops=1)

  • Filter: (search_experiment_trigram_2017_08.payment_amount > 10.0)
  • Heap Blocks: exact=101
  • Buffers: shared hit=104
18. 0.033 0.033 ↑ 1.0 244 1

Bitmap Index Scan on search_experiment_trigram_2017_08_merchant_id_idx (cost=0..6.11 rows=244 width=0) (actual time=0.033..0.033 rows=244 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_08.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
19. 0.302 0.345 ↑ 1.0 271 1

Bitmap Heap Scan on search_experiment_trigram_2017_09 search_experiment_trigram_2017_09 (cost=6.38..128.45 rows=271 width=339) (actual time=0.062..0.345 rows=271 loops=1)

  • Filter: (search_experiment_trigram_2017_09.payment_amount > 10.0)
  • Heap Blocks: exact=109
  • Buffers: shared hit=112
20. 0.043 0.043 ↑ 1.0 271 1

Bitmap Index Scan on search_experiment_trigram_2017_09_merchant_id_idx (cost=0..6.31 rows=271 width=0) (actual time=0.043..0.043 rows=271 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_09.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
21. 0.222 0.260 ↑ 1.0 285 1

Bitmap Heap Scan on search_experiment_trigram_2017_10 search_experiment_trigram_2017_10 (cost=10.49..130.76 rows=285 width=338) (actual time=0.057..0.26 rows=285 loops=1)

  • Filter: (search_experiment_trigram_2017_10.payment_amount > 10.0)
  • Heap Blocks: exact=109
  • Buffers: shared hit=112
22. 0.038 0.038 ↑ 1.0 285 1

Bitmap Index Scan on search_experiment_trigram_2017_10_merchant_id_idx (cost=0..10.42 rows=285 width=0) (actual time=0.038..0.038 rows=285 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_10.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
23. 0.301 0.354 ↑ 1.0 321 1

Bitmap Heap Scan on search_experiment_trigram_2017_11 search_experiment_trigram_2017_11 (cost=10.77..134.58 rows=321 width=339) (actual time=0.067..0.354 rows=321 loops=1)

  • Filter: (search_experiment_trigram_2017_11.payment_amount > 10.0)
  • Heap Blocks: exact=111
  • Buffers: shared hit=114
24. 0.053 0.053 ↑ 1.0 321 1

Bitmap Index Scan on search_experiment_trigram_2017_11_merchant_id_idx (cost=0..10.69 rows=321 width=0) (actual time=0.053..0.053 rows=321 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_11.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
25. 0.295 0.387 ↑ 1.0 296 1

Bitmap Heap Scan on search_experiment_trigram_2017_12 search_experiment_trigram_2017_12 (cost=10.57..133.01 rows=296 width=338) (actual time=0.113..0.387 rows=296 loops=1)

  • Filter: (search_experiment_trigram_2017_12.payment_amount > 10.0)
  • Heap Blocks: exact=109
  • Buffers: shared hit=112
26. 0.092 0.092 ↑ 1.0 296 1

Bitmap Index Scan on search_experiment_trigram_2017_12_merchant_id_idx (cost=0..10.5 rows=296 width=0) (actual time=0.092..0.092 rows=296 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_12.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
27. 0.249 0.287 ↑ 1.0 258 1

Bitmap Heap Scan on search_experiment_trigram_2018_01 search_experiment_trigram_2018_01 (cost=6.28..130.15 rows=258 width=338) (actual time=0.08..0.287 rows=258 loops=1)

  • Filter: (search_experiment_trigram_2018_01.payment_amount > 10.0)
  • Heap Blocks: exact=108
  • Buffers: shared hit=111
28. 0.038 0.038 ↑ 1.0 258 1

Bitmap Index Scan on search_experiment_trigram_2018_01_merchant_id_idx (cost=0..6.21 rows=258 width=0) (actual time=0.038..0.038 rows=258 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_01.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
29. 0.225 0.254 ↑ 1.0 246 1

Bitmap Heap Scan on search_experiment_trigram_2018_02 search_experiment_trigram_2018_02 (cost=6.19..117.88 rows=246 width=338) (actual time=0.042..0.254 rows=246 loops=1)

  • Filter: (search_experiment_trigram_2018_02.payment_amount > 10.0)
  • Heap Blocks: exact=95
  • Buffers: shared hit=98
30. 0.029 0.029 ↑ 1.0 246 1

Bitmap Index Scan on search_experiment_trigram_2018_02_merchant_id_idx (cost=0..6.12 rows=246 width=0) (actual time=0.029..0.029 rows=246 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_02.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
31. 0.349 0.391 ↑ 1.0 285 1

Bitmap Heap Scan on search_experiment_trigram_2018_03 search_experiment_trigram_2018_03 (cost=10.49..136.76 rows=285 width=339) (actual time=0.062..0.391 rows=285 loops=1)

  • Filter: (search_experiment_trigram_2018_03.payment_amount > 10.0)
  • Heap Blocks: exact=109
  • Buffers: shared hit=112
32. 0.042 0.042 ↑ 1.0 285 1

Bitmap Index Scan on search_experiment_trigram_2018_03_merchant_id_idx (cost=0..10.42 rows=285 width=0) (actual time=0.042..0.042 rows=285 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_03.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
33. 0.293 0.331 ↑ 1.0 263 1

Bitmap Heap Scan on search_experiment_trigram_2018_04 search_experiment_trigram_2018_04 (cost=10.32..125.26 rows=263 width=338) (actual time=0.056..0.331 rows=263 loops=1)

  • Filter: (search_experiment_trigram_2018_04.payment_amount > 10.0)
  • Heap Blocks: exact=104
  • Buffers: shared hit=107
34. 0.038 0.038 ↑ 1.0 263 1

Bitmap Index Scan on search_experiment_trigram_2018_04_merchant_id_idx (cost=0..10.25 rows=263 width=0) (actual time=0.038..0.038 rows=263 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_04.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
35. 0.203 0.235 ↑ 1.0 279 1

Bitmap Heap Scan on search_experiment_trigram_2018_05 search_experiment_trigram_2018_05 (cost=10.44..133.63 rows=279 width=338) (actual time=0.047..0.235 rows=279 loops=1)

  • Filter: (search_experiment_trigram_2018_05.payment_amount > 10.0)
  • Heap Blocks: exact=108
  • Buffers: shared hit=111
36. 0.032 0.032 ↑ 1.0 279 1

Bitmap Index Scan on search_experiment_trigram_2018_05_merchant_id_idx (cost=0..10.37 rows=279 width=0) (actual time=0.032..0.032 rows=279 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_05.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
37. 0.186 0.212 ↑ 1.0 270 1

Bitmap Heap Scan on search_experiment_trigram_2018_06 search_experiment_trigram_2018_06 (cost=6.37..127.42 rows=270 width=339) (actual time=0.041..0.212 rows=270 loops=1)

  • Filter: (search_experiment_trigram_2018_06.payment_amount > 10.0)
  • Heap Blocks: exact=102
  • Buffers: shared hit=105
38. 0.026 0.026 ↑ 1.0 270 1

Bitmap Index Scan on search_experiment_trigram_2018_06_merchant_id_idx (cost=0..6.31 rows=270 width=0) (actual time=0.026..0.026 rows=270 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_06.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
39. 0.246 0.274 ↑ 1.0 291 1

Bitmap Heap Scan on search_experiment_trigram_2018_07 search_experiment_trigram_2018_07 (cost=10.54..136.9 rows=291 width=339) (actual time=0.042..0.274 rows=291 loops=1)

  • Filter: (search_experiment_trigram_2018_07.payment_amount > 10.0)
  • Heap Blocks: exact=110
  • Buffers: shared hit=113
40. 0.028 0.028 ↑ 1.0 291 1

Bitmap Index Scan on search_experiment_trigram_2018_07_merchant_id_idx (cost=0..10.46 rows=291 width=0) (actual time=0.028..0.028 rows=291 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_07.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
41. 0.240 0.271 ↑ 1.0 256 1

Bitmap Heap Scan on search_experiment_trigram_2018_08 search_experiment_trigram_2018_08 (cost=6.26..131.1 rows=256 width=338) (actual time=0.046..0.271 rows=256 loops=1)

  • Filter: (search_experiment_trigram_2018_08.payment_amount > 10.0)
  • Heap Blocks: exact=107
  • Buffers: shared hit=110
42. 0.031 0.031 ↑ 1.0 256 1

Bitmap Index Scan on search_experiment_trigram_2018_08_merchant_id_idx (cost=0..6.2 rows=256 width=0) (actual time=0.031..0.031 rows=256 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_08.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
43. 0.232 0.258 ↑ 1.0 244 1

Bitmap Heap Scan on search_experiment_trigram_2018_09 search_experiment_trigram_2018_09 (cost=6.17..127.83 rows=244 width=338) (actual time=0.039..0.258 rows=244 loops=1)

  • Filter: (search_experiment_trigram_2018_09.payment_amount > 10.0)
  • Heap Blocks: exact=102
  • Buffers: shared hit=105
44. 0.026 0.026 ↑ 1.0 244 1

Bitmap Index Scan on search_experiment_trigram_2018_09_merchant_id_idx (cost=0..6.11 rows=244 width=0) (actual time=0.026..0.026 rows=244 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_09.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
45. 0.219 0.253 ↑ 1.0 275 1

Bitmap Heap Scan on search_experiment_trigram_2018_10 search_experiment_trigram_2018_10 (cost=6.41..131.54 rows=275 width=338) (actual time=0.049..0.253 rows=275 loops=1)

  • Filter: (search_experiment_trigram_2018_10.payment_amount > 10.0)
  • Heap Blocks: exact=110
  • Buffers: shared hit=113
46. 0.034 0.034 ↑ 1.0 275 1

Bitmap Index Scan on search_experiment_trigram_2018_10_merchant_id_idx (cost=0..6.34 rows=275 width=0) (actual time=0.034..0.034 rows=275 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_10.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
47. 0.254 0.285 ↑ 1.0 275 1

Bitmap Heap Scan on search_experiment_trigram_2018_11 search_experiment_trigram_2018_11 (cost=10.41..130.54 rows=275 width=339) (actual time=0.048..0.285 rows=275 loops=1)

  • Filter: (search_experiment_trigram_2018_11.payment_amount > 10.0)
  • Heap Blocks: exact=109
  • Buffers: shared hit=112
48. 0.031 0.031 ↑ 1.0 275 1

Bitmap Index Scan on search_experiment_trigram_2018_11_merchant_id_idx (cost=0..10.34 rows=275 width=0) (actual time=0.031..0.031 rows=275 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_11.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
49. 0.293 0.326 ↑ 1.0 298 1

Bitmap Heap Scan on search_experiment_trigram_2018_12 search_experiment_trigram_2018_12 (cost=10.59..139.06 rows=298 width=339) (actual time=0.048..0.326 rows=298 loops=1)

  • Filter: (search_experiment_trigram_2018_12.payment_amount > 10.0)
  • Heap Blocks: exact=117
  • Buffers: shared hit=120
50. 0.033 0.033 ↑ 1.0 298 1

Bitmap Index Scan on search_experiment_trigram_2018_12_merchant_id_idx (cost=0..10.51 rows=298 width=0) (actual time=0.033..0.033 rows=298 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_12.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
51. 0.242 0.278 ↑ 1.0 287 1

Bitmap Heap Scan on search_experiment_trigram_2019_01 search_experiment_trigram_2019_01 (cost=10.5..140.81 rows=287 width=339) (actual time=0.056..0.278 rows=287 loops=1)

  • Filter: (search_experiment_trigram_2019_01.payment_amount > 10.0)
  • Heap Blocks: exact=110
  • Buffers: shared hit=113
52. 0.036 0.036 ↑ 1.0 287 1

Bitmap Index Scan on search_experiment_trigram_2019_01_merchant_id_idx (cost=0..10.43 rows=287 width=0) (actual time=0.036..0.036 rows=287 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_01.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
53. 0.353 0.380 ↑ 1.0 221 1

Bitmap Heap Scan on search_experiment_trigram_2019_02 search_experiment_trigram_2019_02 (cost=5.99..115.31 rows=221 width=339) (actual time=0.04..0.38 rows=221 loops=1)

  • Filter: (search_experiment_trigram_2019_02.payment_amount > 10.0)
  • Heap Blocks: exact=91
  • Buffers: shared hit=94
54. 0.027 0.027 ↑ 1.0 221 1

Bitmap Index Scan on search_experiment_trigram_2019_02_merchant_id_idx (cost=0..5.94 rows=221 width=0) (actual time=0.027..0.027 rows=221 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_02.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
55. 0.371 0.425 ↑ 1.0 294 1

Bitmap Heap Scan on search_experiment_trigram_2019_03 search_experiment_trigram_2019_03 (cost=10.56..139.97 rows=294 width=338) (actual time=0.074..0.425 rows=294 loops=1)

  • Filter: (search_experiment_trigram_2019_03.payment_amount > 10.0)
  • Heap Blocks: exact=116
  • Buffers: shared hit=118
56. 0.054 0.054 ↑ 1.0 294 1

Bitmap Index Scan on search_experiment_trigram_2019_03_merchant_id_idx (cost=0..10.48 rows=294 width=0) (actual time=0.054..0.054 rows=294 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_03.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=2
57. 0.597 0.647 ↑ 1.0 285 1

Bitmap Heap Scan on search_experiment_trigram_2019_04 search_experiment_trigram_2019_04 (cost=10.49..128.76 rows=285 width=339) (actual time=0.072..0.647 rows=285 loops=1)

  • Filter: (search_experiment_trigram_2019_04.payment_amount > 10.0)
  • Heap Blocks: exact=105
  • Buffers: shared hit=108
58. 0.050 0.050 ↑ 1.0 285 1

Bitmap Index Scan on search_experiment_trigram_2019_04_merchant_id_idx (cost=0..10.42 rows=285 width=0) (actual time=0.05..0.05 rows=285 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_04.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
59. 0.353 0.402 ↑ 1.0 300 1

Bitmap Heap Scan on search_experiment_trigram_2019_05 search_experiment_trigram_2019_05 (cost=10.6..137.1 rows=300 width=338) (actual time=0.068..0.402 rows=300 loops=1)

  • Filter: (search_experiment_trigram_2019_05.payment_amount > 10.0)
  • Heap Blocks: exact=112
  • Buffers: shared hit=115
60. 0.049 0.049 ↑ 1.0 300 1

Bitmap Index Scan on search_experiment_trigram_2019_05_merchant_id_idx (cost=0..10.53 rows=300 width=0) (actual time=0.049..0.049 rows=300 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_05.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
61. 0.276 0.317 ↑ 1.0 264 1

Bitmap Heap Scan on search_experiment_trigram_2019_06 search_experiment_trigram_2019_06 (cost=6.33..131.29 rows=264 width=338) (actual time=0.059..0.317 rows=264 loops=1)

  • Filter: (search_experiment_trigram_2019_06.payment_amount > 10.0)
  • Heap Blocks: exact=108
  • Buffers: shared hit=111
62. 0.041 0.041 ↑ 1.0 264 1

Bitmap Index Scan on search_experiment_trigram_2019_06_merchant_id_idx (cost=0..6.26 rows=264 width=0) (actual time=0.041..0.041 rows=264 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_06.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
63. 0.287 0.325 ↑ 1.0 264 1

Bitmap Heap Scan on search_experiment_trigram_2019_07 search_experiment_trigram_2019_07 (cost=6.33..127.29 rows=264 width=338) (actual time=0.055..0.325 rows=264 loops=1)

  • Filter: (search_experiment_trigram_2019_07.payment_amount > 10.0)
  • Heap Blocks: exact=105
  • Buffers: shared hit=108
64. 0.038 0.038 ↑ 1.0 264 1

Bitmap Index Scan on search_experiment_trigram_2019_07_merchant_id_idx (cost=0..6.26 rows=264 width=0) (actual time=0.038..0.038 rows=264 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_07.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
65. 0.282 0.323 ↑ 1.0 284 1

Bitmap Heap Scan on search_experiment_trigram_2019_08 search_experiment_trigram_2019_08 (cost=10.48..135.74 rows=284 width=338) (actual time=0.058..0.323 rows=284 loops=1)

  • Filter: (search_experiment_trigram_2019_08.payment_amount > 10.0)
  • Heap Blocks: exact=104
  • Buffers: shared hit=107
66. 0.041 0.041 ↑ 1.0 284 1

Bitmap Index Scan on search_experiment_trigram_2019_08_merchant_id_idx (cost=0..10.41 rows=284 width=0) (actual time=0.041..0.041 rows=284 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_08.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
67. 0.296 0.340 ↑ 1.0 300 1

Bitmap Heap Scan on search_experiment_trigram_2019_09 search_experiment_trigram_2019_09 (cost=10.6..130.1 rows=300 width=339) (actual time=0.06..0.34 rows=300 loops=1)

  • Filter: (search_experiment_trigram_2019_09.payment_amount > 10.0)
  • Heap Blocks: exact=105
  • Buffers: shared hit=108
68. 0.044 0.044 ↑ 1.0 300 1

Bitmap Index Scan on search_experiment_trigram_2019_09_merchant_id_idx (cost=0..10.53 rows=300 width=0) (actual time=0.044..0.044 rows=300 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_09.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
69. 0.326 0.373 ↑ 1.0 322 1

Bitmap Heap Scan on search_experiment_trigram_2019_10 search_experiment_trigram_2019_10 (cost=10.78..137.63 rows=323 width=339) (actual time=0.066..0.373 rows=322 loops=1)

  • Filter: (search_experiment_trigram_2019_10.payment_amount > 10.0)
  • Heap Blocks: exact=114
  • Buffers: shared hit=117
70. 0.047 0.047 ↑ 1.0 323 1

Bitmap Index Scan on search_experiment_trigram_2019_10_merchant_id_idx (cost=0..10.7 rows=323 width=0) (actual time=0.047..0.047 rows=323 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_10.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
71. 0.289 0.328 ↑ 1.0 252 1

Bitmap Heap Scan on search_experiment_trigram_2019_11 search_experiment_trigram_2019_11 (cost=6.23..124.01 rows=252 width=338) (actual time=0.056..0.328 rows=252 loops=1)

  • Filter: (search_experiment_trigram_2019_11.payment_amount > 10.0)
  • Heap Blocks: exact=105
  • Buffers: shared hit=108
72. 0.039 0.039 ↑ 1.0 252 1

Bitmap Index Scan on search_experiment_trigram_2019_11_merchant_id_idx (cost=0..6.17 rows=252 width=0) (actual time=0.039..0.039 rows=252 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_11.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
73. 0.307 0.347 ↑ 1.0 247 1

Bitmap Heap Scan on search_experiment_trigram_2019_12 search_experiment_trigram_2019_12 (cost=6.19..127.9 rows=247 width=338) (actual time=0.058..0.347 rows=247 loops=1)

  • Filter: (search_experiment_trigram_2019_12.payment_amount > 10.0)
  • Heap Blocks: exact=104
  • Buffers: shared hit=107
74. 0.040 0.040 ↑ 1.0 247 1

Bitmap Index Scan on search_experiment_trigram_2019_12_merchant_id_idx (cost=0..6.13 rows=247 width=0) (actual time=0.04..0.04 rows=247 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_12.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
75. 0.329 0.374 ↑ 1.0 292 1

Bitmap Heap Scan on search_experiment_trigram_2020_01 search_experiment_trigram_2020_01 (cost=10.54..133.92 rows=292 width=339) (actual time=0.064..0.374 rows=292 loops=1)

  • Filter: (search_experiment_trigram_2020_01.payment_amount > 10.0)
  • Heap Blocks: exact=110
  • Buffers: shared hit=113
76. 0.045 0.045 ↑ 1.0 292 1

Bitmap Index Scan on search_experiment_trigram_2020_01_merchant_id_idx (cost=0..10.47 rows=292 width=0) (actual time=0.045..0.045 rows=292 loops=1)

  • Index Cond: ((search_experiment_trigram_2020_01.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
77. 0.290 0.329 ↑ 1.0 253 1

Bitmap Heap Scan on search_experiment_trigram_2020_02 search_experiment_trigram_2020_02 (cost=6.24..119.04 rows=253 width=339) (actual time=0.056..0.329 rows=253 loops=1)

  • Filter: (search_experiment_trigram_2020_02.payment_amount > 10.0)
  • Heap Blocks: exact=101
  • Buffers: shared hit=104
78. 0.039 0.039 ↑ 1.0 253 1

Bitmap Index Scan on search_experiment_trigram_2020_02_merchant_id_idx (cost=0..6.18 rows=253 width=0) (actual time=0.039..0.039 rows=253 loops=1)

  • Index Cond: ((search_experiment_trigram_2020_02.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
79. 0.283 0.322 ↑ 1.0 253 1

Bitmap Heap Scan on search_experiment_trigram_2020_03 search_experiment_trigram_2020_03 (cost=6.24..130.04 rows=253 width=338) (actual time=0.057..0.322 rows=253 loops=1)

  • Filter: (search_experiment_trigram_2020_03.payment_amount > 10.0)
  • Heap Blocks: exact=110
  • Buffers: shared hit=113
80. 0.039 0.039 ↑ 1.0 253 1

Bitmap Index Scan on search_experiment_trigram_2020_03_merchant_id_idx (cost=0..6.18 rows=253 width=0) (actual time=0.039..0.039 rows=253 loops=1)

  • Index Cond: ((search_experiment_trigram_2020_03.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
81. 0.294 0.333 ↑ 1.0 249 1

Bitmap Heap Scan on search_experiment_trigram_2020_04 search_experiment_trigram_2020_04 (cost=6.21..127.94 rows=249 width=338) (actual time=0.056..0.333 rows=249 loops=1)

  • Filter: (search_experiment_trigram_2020_04.payment_amount > 10.0)
  • Heap Blocks: exact=106
  • Buffers: shared hit=109
82. 0.039 0.039 ↑ 1.0 249 1

Bitmap Index Scan on search_experiment_trigram_2020_04_merchant_id_idx (cost=0..6.15 rows=249 width=0) (actual time=0.039..0.039 rows=249 loops=1)

  • Index Cond: ((search_experiment_trigram_2020_04.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=3
83. 0.157 0.198 ↑ 1.0 150 1

Bitmap Heap Scan on search_experiment_trigram_2020_05 search_experiment_trigram_2020_05 (cost=5.44..78.69 rows=150 width=338) (actual time=0.054..0.198 rows=150 loops=1)

  • Filter: (search_experiment_trigram_2020_05.payment_amount > 10.0)
  • Heap Blocks: exact=64
  • Buffers: shared hit=66
84. 0.041 0.041 ↑ 1.0 150 1

Bitmap Index Scan on search_experiment_trigram_2020_05_merchant_id_idx (cost=0..5.4 rows=150 width=0) (actual time=0.041..0.041 rows=150 loops=1)

  • Index Cond: ((search_experiment_trigram_2020_05.merchant_id)::text = '1488'::text)
  • Buffers: shared hit=2
85. 0.007 0.007 ↓ 0.0 0 1

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

  • Index Cond: ((search_experiment_trigram_2020_06.merchant_id)::text = '1488'::text)
  • Filter: (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_2020_07_merchant_id_idx 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)
  • Filter: (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_2020_08_merchant_id_idx 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)
  • Filter: (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_2020_09_merchant_id_idx 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)
  • Filter: (search_experiment_trigram_2020_09.payment_amount > 10.0)
  • Buffers: shared hit=1
89. 0.003 0.003 ↓ 0.0 0 1

Index Scan using search_experiment_trigram_2020_10_merchant_id_idx on search_experiment_trigram_2020_10 search_experiment_trigram_2020_10 (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_10.merchant_id)::text = '1488'::text)
  • Filter: (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_2020_11_merchant_id_idx 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)
  • Filter: (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_2020_12_merchant_id_idx 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)
  • Filter: (search_experiment_trigram_2020_12.payment_amount > 10.0)
  • Buffers: shared hit=1
Planning time : 5.187 ms
Execution time : 40.061 ms