explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rI3b

Settings
# exclusive inclusive rows x rows loops node
1. 1.845 17.373 ↑ 1.0 11,128 1

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

  • Buffers: shared hit=4353 read=120
2. 0.195 0.280 ↑ 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.107..0.28 rows=275 loops=1)

  • Filter: (search_experiment_trigram_2017_01.payment_amount > 10.0)
  • Heap Blocks: exact=107
  • Buffers: shared hit=107 read=3
3. 0.085 0.085 ↑ 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.085..0.085 rows=275 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_01.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
4. 0.170 0.207 ↑ 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.05..0.207 rows=260 loops=1)

  • Filter: (search_experiment_trigram_2017_02.payment_amount > 10.0)
  • Heap Blocks: exact=102
  • Buffers: shared hit=102 read=3
5. 0.037 0.037 ↑ 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.037..0.037 rows=260 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_02.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
6. 0.205 0.241 ↑ 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.049..0.241 rows=265 loops=1)

  • Filter: (search_experiment_trigram_2017_03.payment_amount > 10.0)
  • Heap Blocks: exact=105
  • Buffers: shared hit=105 read=3
7. 0.036 0.036 ↑ 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.036..0.036 rows=265 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_03.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
8. 0.239 0.286 ↑ 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.062..0.286 rows=276 loops=1)

  • Filter: (search_experiment_trigram_2017_04.payment_amount > 10.0)
  • Heap Blocks: exact=110
  • Buffers: shared hit=110 read=3
9. 0.047 0.047 ↑ 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.047..0.047 rows=276 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_04.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
10. 0.214 0.262 ↑ 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.062..0.262 rows=284 loops=1)

  • Filter: (search_experiment_trigram_2017_05.payment_amount > 10.0)
  • Heap Blocks: exact=114
  • Buffers: shared hit=114 read=3
11. 0.048 0.048 ↑ 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.048..0.048 rows=284 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_05.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
12. 0.198 0.240 ↑ 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.055..0.24 rows=280 loops=1)

  • Filter: (search_experiment_trigram_2017_06.payment_amount > 10.0)
  • Heap Blocks: exact=106
  • Buffers: shared hit=106 read=3
13. 0.042 0.042 ↑ 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.042..0.042 rows=280 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_06.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
14. 0.313 0.346 ↑ 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.046..0.346 rows=314 loops=1)

  • Filter: (search_experiment_trigram_2017_07.payment_amount > 10.0)
  • Heap Blocks: exact=112
  • Buffers: shared hit=112 read=2
15. 0.033 0.033 ↑ 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.033..0.033 rows=314 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_07.merchant_id)::text = '1488'::text)
  • Buffers: shared read=2
16. 0.244 0.304 ↑ 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.077..0.304 rows=244 loops=1)

  • Filter: (search_experiment_trigram_2017_08.payment_amount > 10.0)
  • Heap Blocks: exact=101
  • Buffers: shared hit=101 read=3
17. 0.060 0.060 ↑ 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.06..0.06 rows=244 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_08.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
18. 0.295 0.359 ↑ 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.082..0.359 rows=271 loops=1)

  • Filter: (search_experiment_trigram_2017_09.payment_amount > 10.0)
  • Heap Blocks: exact=109
  • Buffers: shared hit=109 read=3
19. 0.064 0.064 ↑ 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.064..0.064 rows=271 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_09.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
20. 0.225 0.284 ↑ 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.076..0.284 rows=285 loops=1)

  • Filter: (search_experiment_trigram_2017_10.payment_amount > 10.0)
  • Heap Blocks: exact=109
  • Buffers: shared hit=109 read=3
21. 0.059 0.059 ↑ 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.059..0.059 rows=285 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_10.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
22. 0.313 0.364 ↑ 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.068..0.364 rows=321 loops=1)

  • Filter: (search_experiment_trigram_2017_11.payment_amount > 10.0)
  • Heap Blocks: exact=111
  • Buffers: shared hit=111 read=3
23. 0.051 0.051 ↑ 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.051..0.051 rows=321 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_11.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
24. 0.373 0.550 ↑ 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.205..0.55 rows=296 loops=1)

  • Filter: (search_experiment_trigram_2017_12.payment_amount > 10.0)
  • Heap Blocks: exact=109
  • Buffers: shared hit=109 read=3
25. 0.177 0.177 ↑ 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.177..0.177 rows=296 loops=1)

  • Index Cond: ((search_experiment_trigram_2017_12.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
26. 0.332 0.414 ↑ 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.104..0.414 rows=258 loops=1)

  • Filter: (search_experiment_trigram_2018_01.payment_amount > 10.0)
  • Heap Blocks: exact=108
  • Buffers: shared hit=108 read=3
27. 0.082 0.082 ↑ 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.082..0.082 rows=258 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_01.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
28. 0.177 0.341 ↑ 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.183..0.341 rows=246 loops=1)

  • Filter: (search_experiment_trigram_2018_02.payment_amount > 10.0)
  • Heap Blocks: exact=95
  • Buffers: shared hit=95 read=3
29. 0.164 0.164 ↑ 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.164..0.164 rows=246 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_02.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
30. 0.200 0.242 ↑ 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.056..0.242 rows=285 loops=1)

  • Filter: (search_experiment_trigram_2018_03.payment_amount > 10.0)
  • Heap Blocks: exact=109
  • Buffers: shared hit=109 read=3
31. 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.041..0.042 rows=285 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_03.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
32. 0.222 0.300 ↑ 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.119..0.3 rows=263 loops=1)

  • Filter: (search_experiment_trigram_2018_04.payment_amount > 10.0)
  • Heap Blocks: exact=104
  • Buffers: shared hit=104 read=3
33. 0.078 0.078 ↑ 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.078..0.078 rows=263 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_04.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
34. 0.213 0.285 ↑ 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.088..0.285 rows=279 loops=1)

  • Filter: (search_experiment_trigram_2018_05.payment_amount > 10.0)
  • Heap Blocks: exact=108
  • Buffers: shared hit=108 read=3
35. 0.072 0.072 ↑ 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.072..0.072 rows=279 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_05.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
36. 0.193 0.236 ↑ 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.058..0.236 rows=270 loops=1)

  • Filter: (search_experiment_trigram_2018_06.payment_amount > 10.0)
  • Heap Blocks: exact=102
  • Buffers: shared hit=102 read=3
37. 0.043 0.043 ↑ 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.043..0.043 rows=270 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_06.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
38. 0.228 0.273 ↑ 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.058..0.273 rows=291 loops=1)

  • Filter: (search_experiment_trigram_2018_07.payment_amount > 10.0)
  • Heap Blocks: exact=110
  • Buffers: shared hit=110 read=3
39. 0.045 0.045 ↑ 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.044..0.045 rows=291 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_07.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
40. 0.210 0.305 ↑ 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.112..0.305 rows=256 loops=1)

  • Filter: (search_experiment_trigram_2018_08.payment_amount > 10.0)
  • Heap Blocks: exact=107
  • Buffers: shared hit=107 read=3
41. 0.095 0.095 ↑ 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.095..0.095 rows=256 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_08.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
42. 0.382 0.427 ↑ 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.059..0.427 rows=244 loops=1)

  • Filter: (search_experiment_trigram_2018_09.payment_amount > 10.0)
  • Heap Blocks: exact=102
  • Buffers: shared hit=102 read=3
43. 0.045 0.045 ↑ 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.045..0.045 rows=244 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_09.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
44. 0.307 0.391 ↑ 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.105..0.391 rows=275 loops=1)

  • Filter: (search_experiment_trigram_2018_10.payment_amount > 10.0)
  • Heap Blocks: exact=110
  • Buffers: shared hit=110 read=3
45. 0.084 0.084 ↑ 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.084..0.084 rows=275 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_10.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
46. 0.295 0.365 ↑ 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.09..0.365 rows=275 loops=1)

  • Filter: (search_experiment_trigram_2018_11.payment_amount > 10.0)
  • Heap Blocks: exact=109
  • Buffers: shared hit=109 read=3
47. 0.070 0.070 ↑ 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.07..0.07 rows=275 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_11.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
48. 0.389 0.500 ↑ 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.131..0.5 rows=298 loops=1)

  • Filter: (search_experiment_trigram_2018_12.payment_amount > 10.0)
  • Heap Blocks: exact=117
  • Buffers: shared hit=117 read=3
49. 0.111 0.111 ↑ 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.111..0.111 rows=298 loops=1)

  • Index Cond: ((search_experiment_trigram_2018_12.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
50. 0.440 0.522 ↑ 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.103..0.522 rows=287 loops=1)

  • Filter: (search_experiment_trigram_2019_01.payment_amount > 10.0)
  • Heap Blocks: exact=110
  • Buffers: shared hit=110 read=3
51. 0.082 0.082 ↑ 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.082..0.082 rows=287 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_01.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
52. 0.240 0.364 ↑ 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.144..0.364 rows=221 loops=1)

  • Filter: (search_experiment_trigram_2019_02.payment_amount > 10.0)
  • Heap Blocks: exact=91
  • Buffers: shared hit=91 read=3
53. 0.124 0.124 ↑ 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.124..0.124 rows=221 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_02.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
54. 0.389 0.455 ↑ 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.085..0.455 rows=294 loops=1)

  • Filter: (search_experiment_trigram_2019_03.payment_amount > 10.0)
  • Heap Blocks: exact=116
  • Buffers: shared hit=116 read=2
55. 0.066 0.066 ↑ 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.066..0.066 rows=294 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_03.merchant_id)::text = '1488'::text)
  • Buffers: shared read=2
56. 0.309 0.384 ↑ 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.095..0.384 rows=285 loops=1)

  • Filter: (search_experiment_trigram_2019_04.payment_amount > 10.0)
  • Heap Blocks: exact=105
  • Buffers: shared hit=105 read=3
57. 0.075 0.075 ↑ 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.075..0.075 rows=285 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_04.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
58. 0.329 0.397 ↑ 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.089..0.397 rows=300 loops=1)

  • Filter: (search_experiment_trigram_2019_05.payment_amount > 10.0)
  • Heap Blocks: exact=112
  • Buffers: shared hit=112 read=3
59. 0.068 0.068 ↑ 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.068..0.068 rows=300 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_05.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
60. 0.293 0.348 ↑ 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.073..0.348 rows=264 loops=1)

  • Filter: (search_experiment_trigram_2019_06.payment_amount > 10.0)
  • Heap Blocks: exact=108
  • Buffers: shared hit=108 read=3
61. 0.055 0.055 ↑ 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.055..0.055 rows=264 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_06.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
62. 0.256 0.313 ↑ 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.074..0.313 rows=264 loops=1)

  • Filter: (search_experiment_trigram_2019_07.payment_amount > 10.0)
  • Heap Blocks: exact=105
  • Buffers: shared hit=105 read=3
63. 0.057 0.057 ↑ 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.057..0.057 rows=264 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_07.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
64. 0.316 0.368 ↑ 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.069..0.368 rows=284 loops=1)

  • Filter: (search_experiment_trigram_2019_08.payment_amount > 10.0)
  • Heap Blocks: exact=104
  • Buffers: shared hit=104 read=3
65. 0.052 0.052 ↑ 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.052..0.052 rows=284 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_08.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
66. 0.274 0.332 ↑ 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.074..0.332 rows=300 loops=1)

  • Filter: (search_experiment_trigram_2019_09.payment_amount > 10.0)
  • Heap Blocks: exact=105
  • Buffers: shared hit=105 read=3
67. 0.058 0.058 ↑ 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.058..0.058 rows=300 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_09.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
68. 0.454 0.514 ↑ 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.078..0.514 rows=322 loops=1)

  • Filter: (search_experiment_trigram_2019_10.payment_amount > 10.0)
  • Heap Blocks: exact=114
  • Buffers: shared hit=114 read=3
69. 0.060 0.060 ↑ 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.06..0.06 rows=323 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_10.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
70. 0.358 0.446 ↑ 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.113..0.446 rows=252 loops=1)

  • Filter: (search_experiment_trigram_2019_11.payment_amount > 10.0)
  • Heap Blocks: exact=105
  • Buffers: shared hit=105 read=3
71. 0.088 0.088 ↑ 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.088..0.088 rows=252 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_11.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
72. 0.555 0.635 ↑ 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.177..0.635 rows=247 loops=1)

  • Filter: (search_experiment_trigram_2019_12.payment_amount > 10.0)
  • Heap Blocks: exact=104
  • Buffers: shared hit=104 read=3
73. 0.080 0.080 ↑ 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.08..0.08 rows=247 loops=1)

  • Index Cond: ((search_experiment_trigram_2019_12.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
74. 0.440 0.560 ↑ 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.141..0.56 rows=292 loops=1)

  • Filter: (search_experiment_trigram_2020_01.payment_amount > 10.0)
  • Heap Blocks: exact=110
  • Buffers: shared hit=110 read=3
75. 0.120 0.120 ↑ 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.12..0.12 rows=292 loops=1)

  • Index Cond: ((search_experiment_trigram_2020_01.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
76. 0.419 0.626 ↑ 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.237..0.626 rows=253 loops=1)

  • Filter: (search_experiment_trigram_2020_02.payment_amount > 10.0)
  • Heap Blocks: exact=101
  • Buffers: shared hit=101 read=3
77. 0.207 0.207 ↑ 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.207..0.207 rows=253 loops=1)

  • Index Cond: ((search_experiment_trigram_2020_02.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
78. 0.443 0.569 ↑ 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.153..0.569 rows=253 loops=1)

  • Filter: (search_experiment_trigram_2020_03.payment_amount > 10.0)
  • Heap Blocks: exact=110
  • Buffers: shared hit=110 read=3
79. 0.126 0.126 ↑ 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.126..0.126 rows=253 loops=1)

  • Index Cond: ((search_experiment_trigram_2020_03.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
80. 0.426 0.505 ↑ 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.1..0.505 rows=249 loops=1)

  • Filter: (search_experiment_trigram_2020_04.payment_amount > 10.0)
  • Heap Blocks: exact=106
  • Buffers: shared hit=106 read=3
81. 0.079 0.079 ↑ 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.079..0.079 rows=249 loops=1)

  • Index Cond: ((search_experiment_trigram_2020_04.merchant_id)::text = '1488'::text)
  • Buffers: shared read=3
82. 0.281 0.334 ↑ 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.07..0.334 rows=150 loops=1)

  • Filter: (search_experiment_trigram_2020_05.payment_amount > 10.0)
  • Heap Blocks: exact=64
  • Buffers: shared hit=64 read=2
83. 0.053 0.053 ↑ 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.053..0.053 rows=150 loops=1)

  • Index Cond: ((search_experiment_trigram_2020_05.merchant_id)::text = '1488'::text)
  • Buffers: shared read=2
84. 0.014 0.014 ↓ 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.014..0.014 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
85. 0.005 0.005 ↓ 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.005..0.005 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
86. 0.009 0.009 ↓ 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.008..0.009 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
87. 0.008 0.008 ↓ 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.008..0.008 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
88. 0.005 0.005 ↓ 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.005..0.005 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
89. 0.007 0.007 ↓ 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.007..0.007 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
90. 0.006 0.006 ↓ 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.006..0.006 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 : 11.254 ms
Execution time : 18.929 ms