explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S3KB

Settings
# exclusive inclusive rows x rows loops node
1. 1.900 54.677 ↑ 1.0 11,128 1

Append (cost=0..6,438.03 rows=11,136 width=338) (actual time=0.04..54.677 rows=11,128 loops=1)

  • Buffers: shared hit=4784
2. 1.610 1.610 ↑ 1.0 275 1

Seq Scan on search_experiment_trigram_2017_01 search_experiment_trigram_2017_01 (cost=0..154.91 rows=275 width=338) (actual time=0.039..1.61 rows=275 loops=1)

  • Filter: ((search_experiment_trigram_2017_01.payment_amount > 10.0) AND ((search_experiment_trigram_2017_01.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=118
3. 1.952 1.952 ↑ 1.0 260 1

Seq Scan on search_experiment_trigram_2017_02 search_experiment_trigram_2017_02 (cost=0..143.12 rows=260 width=339) (actual time=0.036..1.952 rows=260 loops=1)

  • Filter: ((search_experiment_trigram_2017_02.payment_amount > 10.0) AND ((search_experiment_trigram_2017_02.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=109
4. 1.172 1.172 ↑ 1.0 265 1

Seq Scan on search_experiment_trigram_2017_03 search_experiment_trigram_2017_03 (cost=0..153.8 rows=265 width=338) (actual time=0.035..1.172 rows=265 loops=1)

  • Filter: ((search_experiment_trigram_2017_03.payment_amount > 10.0) AND ((search_experiment_trigram_2017_03.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=117
5. 0.863 0.863 ↑ 1.0 276 1

Seq Scan on search_experiment_trigram_2017_04 search_experiment_trigram_2017_04 (cost=0..154.97 rows=276 width=338) (actual time=0.014..0.863 rows=276 loops=1)

  • Filter: ((search_experiment_trigram_2017_04.payment_amount > 10.0) AND ((search_experiment_trigram_2017_04.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=118
6. 0.947 0.947 ↑ 1.0 284 1

Seq Scan on search_experiment_trigram_2017_05 search_experiment_trigram_2017_05 (cost=0..156.34 rows=284 width=339) (actual time=0.015..0.947 rows=284 loops=1)

  • Filter: ((search_experiment_trigram_2017_05.payment_amount > 10.0) AND ((search_experiment_trigram_2017_05.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=119
7. 0.928 0.928 ↑ 1.0 280 1

Seq Scan on search_experiment_trigram_2017_06 search_experiment_trigram_2017_06 (cost=0..152.27 rows=280 width=338) (actual time=0.011..0.928 rows=280 loops=1)

  • Filter: ((search_experiment_trigram_2017_06.payment_amount > 10.0) AND ((search_experiment_trigram_2017_06.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=116
8. 0.914 0.914 ↑ 1.0 314 1

Seq Scan on search_experiment_trigram_2017_07 search_experiment_trigram_2017_07 (cost=0..160.35 rows=314 width=339) (actual time=0.013..0.914 rows=314 loops=1)

  • Filter: ((search_experiment_trigram_2017_07.payment_amount > 10.0) AND ((search_experiment_trigram_2017_07.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=122
9. 2.787 2.787 ↑ 1.0 244 1

Seq Scan on search_experiment_trigram_2017_08 search_experiment_trigram_2017_08 (cost=0..153.62 rows=244 width=338) (actual time=0.011..2.787 rows=244 loops=1)

  • Filter: ((search_experiment_trigram_2017_08.payment_amount > 10.0) AND ((search_experiment_trigram_2017_08.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=117
10. 2.177 2.177 ↑ 1.0 271 1

Seq Scan on search_experiment_trigram_2017_09 search_experiment_trigram_2017_09 (cost=0..154.99 rows=271 width=339) (actual time=0.037..2.177 rows=271 loops=1)

  • Filter: ((search_experiment_trigram_2017_09.payment_amount > 10.0) AND ((search_experiment_trigram_2017_09.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=118
11. 1.712 1.712 ↑ 1.0 285 1

Seq Scan on search_experiment_trigram_2017_10 search_experiment_trigram_2017_10 (cost=0..152.31 rows=285 width=338) (actual time=0.024..1.712 rows=285 loops=1)

  • Filter: ((search_experiment_trigram_2017_10.payment_amount > 10.0) AND ((search_experiment_trigram_2017_10.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=116
12. 1.656 1.656 ↑ 1.0 321 1

Seq Scan on search_experiment_trigram_2017_11 search_experiment_trigram_2017_11 (cost=0..156.47 rows=321 width=339) (actual time=0.026..1.656 rows=321 loops=1)

  • Filter: ((search_experiment_trigram_2017_11.payment_amount > 10.0) AND ((search_experiment_trigram_2017_11.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=119
13. 1.186 1.186 ↑ 1.0 296 1

Seq Scan on search_experiment_trigram_2017_12 search_experiment_trigram_2017_12 (cost=0..155 rows=296 width=338) (actual time=0.027..1.186 rows=296 loops=1)

  • Filter: ((search_experiment_trigram_2017_12.payment_amount > 10.0) AND ((search_experiment_trigram_2017_12.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=118
14. 0.897 0.897 ↑ 1.0 258 1

Seq Scan on search_experiment_trigram_2018_01 search_experiment_trigram_2018_01 (cost=0..157.5 rows=258 width=338) (actual time=0.022..0.897 rows=258 loops=1)

  • Filter: ((search_experiment_trigram_2018_01.payment_amount > 10.0) AND ((search_experiment_trigram_2018_01.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=120
15. 0.810 0.810 ↑ 1.0 246 1

Seq Scan on search_experiment_trigram_2018_02 search_experiment_trigram_2018_02 (cost=0..141.9 rows=246 width=338) (actual time=0.009..0.81 rows=246 loops=1)

  • Filter: ((search_experiment_trigram_2018_02.payment_amount > 10.0) AND ((search_experiment_trigram_2018_02.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=108
16. 0.915 0.915 ↑ 1.0 285 1

Seq Scan on search_experiment_trigram_2018_03 search_experiment_trigram_2018_03 (cost=0..160.24 rows=285 width=339) (actual time=0.009..0.915 rows=285 loops=1)

  • Filter: ((search_experiment_trigram_2018_03.payment_amount > 10.0) AND ((search_experiment_trigram_2018_03.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=122
17. 1.013 1.013 ↑ 1.0 263 1

Seq Scan on search_experiment_trigram_2018_04 search_experiment_trigram_2018_04 (cost=0..145.78 rows=263 width=338) (actual time=0.009..1.013 rows=263 loops=1)

  • Filter: ((search_experiment_trigram_2018_04.payment_amount > 10.0) AND ((search_experiment_trigram_2018_04.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=111
18. 0.881 0.881 ↑ 1.0 279 1

Seq Scan on search_experiment_trigram_2018_05 search_experiment_trigram_2018_05 (cost=0..156.34 rows=279 width=338) (actual time=0.024..0.881 rows=279 loops=1)

  • Filter: ((search_experiment_trigram_2018_05.payment_amount > 10.0) AND ((search_experiment_trigram_2018_05.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=119
19. 0.831 0.831 ↑ 1.0 270 1

Seq Scan on search_experiment_trigram_2018_06 search_experiment_trigram_2018_06 (cost=0..153.56 rows=270 width=339) (actual time=0.016..0.831 rows=270 loops=1)

  • Filter: ((search_experiment_trigram_2018_06.payment_amount > 10.0) AND ((search_experiment_trigram_2018_06.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=117
20. 1.110 1.110 ↑ 1.0 291 1

Seq Scan on search_experiment_trigram_2018_07 search_experiment_trigram_2018_07 (cost=0..160.25 rows=291 width=339) (actual time=0.016..1.11 rows=291 loops=1)

  • Filter: ((search_experiment_trigram_2018_07.payment_amount > 10.0) AND ((search_experiment_trigram_2018_07.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=122
21. 0.930 0.930 ↑ 1.0 256 1

Seq Scan on search_experiment_trigram_2018_08 search_experiment_trigram_2018_08 (cost=0..159 rows=256 width=338) (actual time=0.013..0.93 rows=256 loops=1)

  • Filter: ((search_experiment_trigram_2018_08.payment_amount > 10.0) AND ((search_experiment_trigram_2018_08.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=121
22. 1.496 1.496 ↑ 1.0 244 1

Seq Scan on search_experiment_trigram_2018_09 search_experiment_trigram_2018_09 (cost=0..154.99 rows=244 width=338) (actual time=0.025..1.496 rows=244 loops=1)

  • Filter: ((search_experiment_trigram_2018_09.payment_amount > 10.0) AND ((search_experiment_trigram_2018_09.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=118
23. 1.636 1.636 ↑ 1.0 275 1

Seq Scan on search_experiment_trigram_2018_10 search_experiment_trigram_2018_10 (cost=0..159.01 rows=275 width=338) (actual time=0.041..1.636 rows=275 loops=1)

  • Filter: ((search_experiment_trigram_2018_10.payment_amount > 10.0) AND ((search_experiment_trigram_2018_10.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=121
24. 0.945 0.945 ↑ 1.0 275 1

Seq Scan on search_experiment_trigram_2018_11 search_experiment_trigram_2018_11 (cost=0..152.42 rows=275 width=339) (actual time=0.013..0.945 rows=275 loops=1)

  • Filter: ((search_experiment_trigram_2018_11.payment_amount > 10.0) AND ((search_experiment_trigram_2018_11.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=116
25. 0.917 0.917 ↑ 1.0 298 1

Seq Scan on search_experiment_trigram_2018_12 search_experiment_trigram_2018_12 (cost=0..163 rows=298 width=339) (actual time=0.011..0.917 rows=298 loops=1)

  • Filter: ((search_experiment_trigram_2018_12.payment_amount > 10.0) AND ((search_experiment_trigram_2018_12.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=124
26. 0.980 0.980 ↑ 1.0 287 1

Seq Scan on search_experiment_trigram_2019_01 search_experiment_trigram_2019_01 (cost=0..165.39 rows=287 width=339) (actual time=0.007..0.98 rows=287 loops=1)

  • Filter: ((search_experiment_trigram_2019_01.payment_amount > 10.0) AND ((search_experiment_trigram_2019_01.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=126
27. 1.013 1.013 ↑ 1.0 221 1

Seq Scan on search_experiment_trigram_2019_02 search_experiment_trigram_2019_02 (cost=0..139.18 rows=221 width=339) (actual time=0.013..1.013 rows=221 loops=1)

  • Filter: ((search_experiment_trigram_2019_02.payment_amount > 10.0) AND ((search_experiment_trigram_2019_02.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=106
28. 1.465 1.465 ↑ 1.0 294 1

Seq Scan on search_experiment_trigram_2019_03 search_experiment_trigram_2019_03 (cost=0..164.22 rows=294 width=338) (actual time=0.021..1.465 rows=294 loops=1)

  • Filter: ((search_experiment_trigram_2019_03.payment_amount > 10.0) AND ((search_experiment_trigram_2019_03.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=125
29. 1.326 1.326 ↑ 1.0 285 1

Seq Scan on search_experiment_trigram_2019_04 search_experiment_trigram_2019_04 (cost=0..149.67 rows=285 width=339) (actual time=0.024..1.326 rows=285 loops=1)

  • Filter: ((search_experiment_trigram_2019_04.payment_amount > 10.0) AND ((search_experiment_trigram_2019_04.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=114
30. 1.078 1.078 ↑ 1.0 300 1

Seq Scan on search_experiment_trigram_2019_05 search_experiment_trigram_2019_05 (cost=0..160.13 rows=300 width=338) (actual time=0.02..1.078 rows=300 loops=1)

  • Filter: ((search_experiment_trigram_2019_05.payment_amount > 10.0) AND ((search_experiment_trigram_2019_05.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=122
31. 0.902 0.902 ↑ 1.0 264 1

Seq Scan on search_experiment_trigram_2019_06 search_experiment_trigram_2019_06 (cost=0..158.81 rows=264 width=338) (actual time=0.01..0.902 rows=264 loops=1)

  • Filter: ((search_experiment_trigram_2019_06.payment_amount > 10.0) AND ((search_experiment_trigram_2019_06.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=121
32. 0.842 0.842 ↑ 1.0 264 1

Seq Scan on search_experiment_trigram_2019_07 search_experiment_trigram_2019_07 (cost=0..153.72 rows=264 width=338) (actual time=0.013..0.842 rows=264 loops=1)

  • Filter: ((search_experiment_trigram_2019_07.payment_amount > 10.0) AND ((search_experiment_trigram_2019_07.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=117
33. 0.957 0.957 ↑ 1.0 284 1

Seq Scan on search_experiment_trigram_2019_08 search_experiment_trigram_2019_08 (cost=0..158.81 rows=284 width=338) (actual time=0.01..0.957 rows=284 loops=1)

  • Filter: ((search_experiment_trigram_2019_08.payment_amount > 10.0) AND ((search_experiment_trigram_2019_08.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=121
34. 1.101 1.101 ↑ 1.0 300 1

Seq Scan on search_experiment_trigram_2019_09 search_experiment_trigram_2019_09 (cost=0..151.07 rows=300 width=339) (actual time=0.014..1.101 rows=300 loops=1)

  • Filter: ((search_experiment_trigram_2019_09.payment_amount > 10.0) AND ((search_experiment_trigram_2019_09.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=115
35. 2.205 2.205 ↑ 1.0 322 1

Seq Scan on search_experiment_trigram_2019_10 search_experiment_trigram_2019_10 (cost=0..160.18 rows=323 width=339) (actual time=0.031..2.205 rows=322 loops=1)

  • Filter: ((search_experiment_trigram_2019_10.payment_amount > 10.0) AND ((search_experiment_trigram_2019_10.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=122
36. 2.463 2.463 ↑ 1.0 252 1

Seq Scan on search_experiment_trigram_2019_11 search_experiment_trigram_2019_11 (cost=0..149.88 rows=252 width=338) (actual time=0.038..2.463 rows=252 loops=1)

  • Filter: ((search_experiment_trigram_2019_11.payment_amount > 10.0) AND ((search_experiment_trigram_2019_11.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=114
37. 2.280 2.280 ↑ 1.0 247 1

Seq Scan on search_experiment_trigram_2019_12 search_experiment_trigram_2019_12 (cost=0..155.16 rows=247 width=338) (actual time=0.116..2.28 rows=247 loops=1)

  • Filter: ((search_experiment_trigram_2019_12.payment_amount > 10.0) AND ((search_experiment_trigram_2019_12.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=118
38. 1.433 1.433 ↑ 1.0 292 1

Seq Scan on search_experiment_trigram_2020_01 search_experiment_trigram_2020_01 (cost=0..156.31 rows=292 width=339) (actual time=0.021..1.433 rows=292 loops=1)

  • Filter: ((search_experiment_trigram_2020_01.payment_amount > 10.0) AND ((search_experiment_trigram_2020_01.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=119
39. 1.339 1.339 ↑ 1.0 253 1

Seq Scan on search_experiment_trigram_2020_02 search_experiment_trigram_2020_02 (cost=0..143.34 rows=253 width=339) (actual time=0.031..1.339 rows=253 loops=1)

  • Filter: ((search_experiment_trigram_2020_02.payment_amount > 10.0) AND ((search_experiment_trigram_2020_02.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=109
40. 1.384 1.384 ↑ 1.0 253 1

Seq Scan on search_experiment_trigram_2020_03 search_experiment_trigram_2020_03 (cost=0..157.74 rows=253 width=338) (actual time=0.017..1.384 rows=253 loops=1)

  • Filter: ((search_experiment_trigram_2020_03.payment_amount > 10.0) AND ((search_experiment_trigram_2020_03.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=120
41. 1.080 1.080 ↑ 1.0 249 1

Seq Scan on search_experiment_trigram_2020_04 search_experiment_trigram_2020_04 (cost=0..155.02 rows=249 width=338) (actual time=0.025..1.08 rows=249 loops=1)

  • Filter: ((search_experiment_trigram_2020_04.payment_amount > 10.0) AND ((search_experiment_trigram_2020_04.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=118
42. 0.621 0.621 ↑ 1.0 150 1

Seq Scan on search_experiment_trigram_2020_05 search_experiment_trigram_2020_05 (cost=0..93.23 rows=150 width=338) (actual time=0.017..0.621 rows=150 loops=1)

  • Filter: ((search_experiment_trigram_2020_05.payment_amount > 10.0) AND ((search_experiment_trigram_2020_05.merchant_id)::text = '1488'::text))
  • Buffers: shared hit=71
43. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on search_experiment_trigram_2020_06 search_experiment_trigram_2020_06 (cost=0..14.05 rows=1 width=270) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: ((search_experiment_trigram_2020_06.payment_amount > 10.0) AND ((search_experiment_trigram_2020_06.merchant_id)::text = '1488'::text))
44. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on search_experiment_trigram_2020_07 search_experiment_trigram_2020_07 (cost=0..14.05 rows=1 width=270) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((search_experiment_trigram_2020_07.payment_amount > 10.0) AND ((search_experiment_trigram_2020_07.merchant_id)::text = '1488'::text))
45. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on search_experiment_trigram_2020_08 search_experiment_trigram_2020_08 (cost=0..14.05 rows=1 width=270) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((search_experiment_trigram_2020_08.payment_amount > 10.0) AND ((search_experiment_trigram_2020_08.merchant_id)::text = '1488'::text))
46. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on search_experiment_trigram_2020_09 search_experiment_trigram_2020_09 (cost=0..14.05 rows=1 width=270) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((search_experiment_trigram_2020_09.payment_amount > 10.0) AND ((search_experiment_trigram_2020_09.merchant_id)::text = '1488'::text))
47. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on search_experiment_trigram_2020_10 search_experiment_trigram_2020_10 (cost=0..14.05 rows=1 width=270) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((search_experiment_trigram_2020_10.payment_amount > 10.0) AND ((search_experiment_trigram_2020_10.merchant_id)::text = '1488'::text))
48. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on search_experiment_trigram_2020_11 search_experiment_trigram_2020_11 (cost=0..14.05 rows=1 width=270) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((search_experiment_trigram_2020_11.payment_amount > 10.0) AND ((search_experiment_trigram_2020_11.merchant_id)::text = '1488'::text))
49. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on search_experiment_trigram_2020_12 search_experiment_trigram_2020_12 (cost=0..14.05 rows=1 width=270) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((search_experiment_trigram_2020_12.payment_amount > 10.0) AND ((search_experiment_trigram_2020_12.merchant_id)::text = '1488'::text))
Planning time : 3.76 ms
Execution time : 55.993 ms