explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KxNM

Settings
# exclusive inclusive rows x rows loops node
1. 1.832 14.460 ↑ 1.0 11,128 1

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

  • Buffers: shared hit=4359 read=121
2. 0.167 0.238 ↑ 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.086..0.238 rows=275 loops=1)

  • Heap Blocks: exact=107
  • Buffers: shared hit=110
3. 0.071 0.071 ↑ 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.071..0.071 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
4. 0.159 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.073..0.22 rows=260 loops=1)

  • Heap Blocks: exact=102
  • Buffers: shared hit=105
5. 0.061 0.061 ↑ 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.061..0.061 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
6. 0.227 0.370 ↑ 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.161..0.37 rows=265 loops=1)

  • Heap Blocks: exact=105
  • Buffers: shared hit=105 read=3
7. 0.143 0.143 ↑ 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.143..0.143 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 read=3
8. 0.163 0.260 ↑ 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.113..0.26 rows=276 loops=1)

  • Heap Blocks: exact=110
  • Buffers: shared hit=110 read=3
9. 0.097 0.097 ↑ 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.097..0.097 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 read=3
10. 0.157 0.241 ↑ 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.098..0.241 rows=284 loops=1)

  • Heap Blocks: exact=114
  • Buffers: shared hit=114 read=3
11. 0.084 0.084 ↑ 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.084..0.084 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 read=3
12. 0.198 0.275 ↑ 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.093..0.275 rows=280 loops=1)

  • Heap Blocks: exact=106
  • Buffers: shared hit=106 read=3
13. 0.077 0.077 ↑ 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.077..0.077 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 read=3
14. 0.176 0.287 ↑ 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.125..0.287 rows=314 loops=1)

  • Heap Blocks: exact=112
  • Buffers: shared hit=112 read=4
15. 0.111 0.111 ↑ 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.111..0.111 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 read=4
16. 0.160 0.237 ↑ 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.089..0.237 rows=244 loops=1)

  • Heap Blocks: exact=101
  • Buffers: shared hit=101 read=3
17. 0.077 0.077 ↑ 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.077..0.077 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 read=3
18. 0.245 0.324 ↑ 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.092..0.324 rows=271 loops=1)

  • Heap Blocks: exact=109
  • Buffers: shared hit=109 read=3
19. 0.079 0.079 ↑ 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.079..0.079 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 read=3
20. 0.199 0.294 ↑ 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.111..0.294 rows=285 loops=1)

  • Heap Blocks: exact=109
  • Buffers: shared hit=109 read=3
21. 0.095 0.095 ↑ 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.095..0.095 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 read=3
22. 0.338 0.455 ↑ 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.138..0.455 rows=321 loops=1)

  • Heap Blocks: exact=111
  • Buffers: shared hit=111 read=3
23. 0.117 0.117 ↑ 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.117..0.117 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 read=3
24. 0.270 0.415 ↑ 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.167..0.415 rows=296 loops=1)

  • Heap Blocks: exact=109
  • Buffers: shared hit=109 read=3
25. 0.145 0.145 ↑ 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.145..0.145 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 read=3
26. 0.361 0.486 ↑ 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.147..0.486 rows=258 loops=1)

  • Heap Blocks: exact=108
  • Buffers: shared hit=108 read=3
27. 0.125 0.125 ↑ 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.125..0.125 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 read=3
28. 0.212 0.342 ↑ 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.146..0.342 rows=246 loops=1)

  • Heap Blocks: exact=95
  • Buffers: shared hit=95 read=4
29. 0.130 0.130 ↑ 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.13..0.13 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 read=4
30. 0.275 0.378 ↑ 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.121..0.378 rows=285 loops=1)

  • Heap Blocks: exact=109
  • Buffers: shared hit=109 read=3
31. 0.103 0.103 ↑ 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.103..0.103 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 read=3
32. 0.158 0.459 ↑ 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.318..0.459 rows=263 loops=1)

  • Heap Blocks: exact=104
  • Buffers: shared hit=104 read=3
33. 0.301 0.301 ↑ 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.301..0.301 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 read=3
34. 0.143 0.219 ↑ 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.089..0.219 rows=279 loops=1)

  • Heap Blocks: exact=108
  • Buffers: shared hit=108 read=3
35. 0.076 0.076 ↑ 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.076..0.076 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 read=3
36. 0.167 0.238 ↑ 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.083..0.238 rows=270 loops=1)

  • Heap Blocks: exact=102
  • Buffers: shared hit=102 read=3
37. 0.071 0.071 ↑ 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.071..0.071 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 read=3
38. 0.183 0.309 ↑ 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.143..0.309 rows=291 loops=1)

  • Heap Blocks: exact=110
  • Buffers: shared hit=110 read=3
39. 0.126 0.126 ↑ 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.126..0.126 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 read=3
40. 0.157 0.233 ↑ 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.088..0.233 rows=256 loops=1)

  • Heap Blocks: exact=107
  • Buffers: shared hit=107 read=3
41. 0.076 0.076 ↑ 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.076..0.076 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 read=3
42. 0.229 0.301 ↑ 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.084..0.301 rows=244 loops=1)

  • Heap Blocks: exact=102
  • Buffers: shared hit=102 read=3
43. 0.072 0.072 ↑ 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.072..0.072 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 read=3
44. 0.162 0.252 ↑ 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.104..0.252 rows=275 loops=1)

  • Heap Blocks: exact=110
  • Buffers: shared hit=110 read=3
45. 0.090 0.090 ↑ 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.09..0.09 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 read=3
46. 0.184 0.264 ↑ 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.094..0.264 rows=275 loops=1)

  • Heap Blocks: exact=109
  • Buffers: shared hit=109 read=3
47. 0.080 0.080 ↑ 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.079..0.08 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 read=3
48. 0.264 0.367 ↑ 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.12..0.367 rows=298 loops=1)

  • Heap Blocks: exact=117
  • Buffers: shared hit=117 read=3
49. 0.103 0.103 ↑ 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.103..0.103 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 read=3
50. 0.207 0.323 ↑ 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.133..0.323 rows=287 loops=1)

  • Heap Blocks: exact=110
  • Buffers: shared hit=110 read=3
51. 0.116 0.116 ↑ 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.116..0.116 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 read=3
52. 0.176 0.267 ↑ 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.107..0.267 rows=221 loops=1)

  • Heap Blocks: exact=91
  • Buffers: shared hit=91 read=4
53. 0.091 0.091 ↑ 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.091..0.091 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 read=4
54. 0.237 0.415 ↑ 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.198..0.415 rows=294 loops=1)

  • Heap Blocks: exact=116
  • Buffers: shared hit=116 read=4
55. 0.178 0.178 ↑ 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.178..0.178 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 read=4
56. 0.227 0.343 ↑ 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.134..0.343 rows=285 loops=1)

  • Heap Blocks: exact=105
  • Buffers: shared hit=105 read=3
57. 0.116 0.116 ↑ 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.116..0.116 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 read=3
58. 0.212 0.306 ↑ 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.109..0.306 rows=300 loops=1)

  • Heap Blocks: exact=112
  • Buffers: shared hit=112 read=3
59. 0.094 0.094 ↑ 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.094..0.094 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 read=3
60. 0.148 0.223 ↑ 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.088..0.223 rows=264 loops=1)

  • Heap Blocks: exact=108
  • Buffers: shared hit=108 read=3
61. 0.075 0.075 ↑ 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.075..0.075 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 read=3
62. 0.139 0.208 ↑ 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.082..0.208 rows=264 loops=1)

  • Heap Blocks: exact=105
  • Buffers: shared hit=105 read=3
63. 0.069 0.069 ↑ 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.069..0.069 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 read=3
64. 0.240 0.328 ↑ 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.141..0.328 rows=284 loops=1)

  • Heap Blocks: exact=104
  • Buffers: shared hit=104 read=3
65. 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 read=3
66. 0.204 0.320 ↑ 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.133..0.32 rows=300 loops=1)

  • Heap Blocks: exact=105
  • Buffers: shared hit=105 read=3
67. 0.116 0.116 ↑ 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.116..0.116 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 read=3
68. 0.187 0.307 ↑ 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.138..0.307 rows=322 loops=1)

  • Heap Blocks: exact=114
  • Buffers: shared hit=114 read=4
69. 0.120 0.120 ↑ 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.12..0.12 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 read=4
70. 0.150 0.270 ↑ 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.136..0.27 rows=252 loops=1)

  • Heap Blocks: exact=105
  • Buffers: shared hit=105 read=3
71. 0.120 0.120 ↑ 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.12..0.12 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 read=3
72. 0.188 0.275 ↑ 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.102..0.275 rows=247 loops=1)

  • Heap Blocks: exact=104
  • Buffers: shared hit=104 read=3
73. 0.087 0.087 ↑ 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.087..0.087 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 read=3
74. 0.225 0.337 ↑ 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.132..0.337 rows=292 loops=1)

  • Heap Blocks: exact=110
  • Buffers: shared hit=110 read=3
75. 0.112 0.112 ↑ 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.112..0.112 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 read=3
76. 0.199 0.337 ↑ 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.154..0.337 rows=253 loops=1)

  • Heap Blocks: exact=101
  • Buffers: shared hit=101 read=3
77. 0.138 0.138 ↑ 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.138..0.138 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 read=3
78. 0.202 0.293 ↑ 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.107..0.293 rows=253 loops=1)

  • Heap Blocks: exact=110
  • Buffers: shared hit=110 read=3
79. 0.091 0.091 ↑ 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.091..0.091 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 read=3
80. 0.239 0.395 ↑ 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.173..0.395 rows=249 loops=1)

  • Heap Blocks: exact=106
  • Buffers: shared hit=106 read=3
81. 0.156 0.156 ↑ 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.156..0.156 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 read=3
82. 0.131 0.196 ↑ 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.077..0.196 rows=150 loops=1)

  • Heap Blocks: exact=64
  • Buffers: shared hit=64 read=2
83. 0.065 0.065 ↑ 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.065..0.065 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 read=2
84. 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
85. 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
86. 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
87. 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
88. 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
89. 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
90. 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 : 2.252 ms
Execution time : 16.228 ms