explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xbr1

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.382 ↑ 1.0 1 1

Limit (cost=5.97..23.98 rows=1 width=112) (actual time=0.382..0.382 rows=1 loops=1)

2. 0.004 0.381 ↑ 868.0 1 1

Result (cost=5.97..15,636.00 rows=868 width=112) (actual time=0.381..0.381 rows=1 loops=1)

3. 0.001 0.185 ↑ 868.0 1 1

Append (cost=5.97..3,293.41 rows=868 width=104) (actual time=0.185..0.185 rows=1 loops=1)

4. 0.008 0.008 ↓ 0.0 0 1

Index Scan using message_partition_2020_12_device_time_idx on message_partition_2020_12 m_34 (cost=0.15..8.18 rows=1 width=104) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
5. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2020_11_device_time_idx on message_partition_2020_11 m_33 (cost=0.15..8.18 rows=1 width=104) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
6. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2020_10_device_time_idx on message_partition_2020_10 m_32 (cost=0.15..8.18 rows=1 width=104) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
7. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2020_09_device_time_idx on message_partition_2020_09 m_31 (cost=0.15..8.18 rows=1 width=104) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
8. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2020_08_device_time_idx on message_partition_2020_08 m_30 (cost=0.14..8.17 rows=1 width=104) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
9. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2020_07_device_time_idx on message_partition_2020_07 m_29 (cost=0.14..8.17 rows=1 width=104) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
10. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2020_06_device_time_idx on message_partition_2020_06 m_28 (cost=0.15..8.18 rows=1 width=104) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
11. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2020_05_device_time_idx on message_partition_2020_05 m_27 (cost=0.15..8.18 rows=1 width=104) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
12. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2020_04_device_time_idx on message_partition_2020_04 m_26 (cost=0.15..8.18 rows=1 width=104) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
13. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2020_03_device_time_idx on message_partition_2020_03 m_25 (cost=0.15..8.18 rows=1 width=104) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
14. 0.004 0.004 ↓ 0.0 0 1

Index Scan using message_partition_2020_02_device_time_idx on message_partition_2020_02 m_24 (cost=0.15..8.18 rows=1 width=104) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
15. 0.004 0.004 ↓ 0.0 0 1

Index Scan using message_partition_2020_01_device_time_idx on message_partition_2020_01 m_23 (cost=0.15..8.18 rows=1 width=104) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
16. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2019_12_device_time_idx on message_partition_2019_12 m_22 (cost=0.15..8.18 rows=1 width=104) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
17. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2019_11_device_time_idx on message_partition_2019_11 m_21 (cost=0.15..8.18 rows=1 width=104) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
18. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2019_10_device_time_idx on message_partition_2019_10 m_20 (cost=0.14..8.17 rows=1 width=104) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
19. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2019_09_device_time_idx on message_partition_2019_09 m_19 (cost=0.15..8.18 rows=1 width=104) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
20. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2019_08_device_time_idx on message_partition_2019_08 m_18 (cost=0.15..8.18 rows=1 width=104) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
21. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2019_07_device_time_idx on message_partition_2019_07 m_17 (cost=0.15..8.18 rows=1 width=104) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
22. 0.004 0.004 ↓ 0.0 0 1

Index Scan using message_partition_2019_06_device_time_idx on message_partition_2019_06 m_16 (cost=0.15..8.18 rows=1 width=104) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
23. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2019_05_device_time_idx on message_partition_2019_05 m_15 (cost=0.15..8.18 rows=1 width=104) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
24. 0.004 0.004 ↓ 0.0 0 1

Index Scan using message_partition_2019_04_device_time_idx on message_partition_2019_04 m_14 (cost=0.15..8.18 rows=1 width=104) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
25. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2019_03_device_time_idx on message_partition_2019_03 m_13 (cost=0.15..8.18 rows=1 width=104) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
26. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2019_02_device_time_idx on message_partition_2019_02 m_12 (cost=0.15..8.18 rows=1 width=104) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
27. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2019_01_device_time_idx on message_partition_2019_01 m_11 (cost=0.15..8.18 rows=1 width=104) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
28. 0.004 0.004 ↓ 0.0 0 1

Index Scan using message_partition_2018_11_device_time_idx on message_partition_2018_11 m_10 (cost=0.15..8.18 rows=1 width=104) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
29. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2018_09_device_time_idx on message_partition_2018_09 m_9 (cost=0.15..8.18 rows=1 width=104) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
30. 0.004 0.004 ↓ 0.0 0 1

Index Scan using message_partition_2018_07_device_time_idx on message_partition_2018_07 m_8 (cost=0.15..8.18 rows=1 width=104) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
31. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2018_05_device_time_idx on message_partition_2018_05 m_7 (cost=0.15..8.18 rows=1 width=104) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
32. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2018_03_device_time_idx on message_partition_2018_03 m_6 (cost=0.15..8.18 rows=1 width=104) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
33. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2018_01_device_time_idx on message_partition_2018_01 m_5 (cost=0.15..8.18 rows=1 width=104) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
34. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2017_10_device_time_idx on message_partition_2017_10 m_4 (cost=0.15..8.18 rows=1 width=104) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
35. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2017_07_device_time_idx on message_partition_2017_07 m_3 (cost=0.15..8.18 rows=1 width=104) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
36. 0.004 0.004 ↓ 0.0 0 1

Index Scan using message_partition_2017_01_device_time_idx on message_partition_2017_01 m_2 (cost=0.15..8.18 rows=1 width=104) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (device = 493)
  • Filter: (message_type = 'PARAMETERS'::text)
37. 0.023 0.023 ↑ 297.0 1 1

Index Scan Backward using message_partition_2016_01_pkey on message_partition_2016_01 m_1 (cost=0.56..1,181.45 rows=297 width=104) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: ((device = 493) AND (message_type = 'PARAMETERS'::text))
38. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using message_partition_1970_01_pkey on message_partition_1970_01 m (cost=0.56..1,837.85 rows=538 width=104) (never executed)

  • Index Cond: ((device = 493) AND (message_type = 'PARAMETERS'::text))
39.          

SubPlan (for Result)

40. 0.002 0.192 ↓ 0.0 0 1

Limit (cost=5.97..14.20 rows=1 width=8) (actual time=0.192..0.192 rows=0 loops=1)

41. 0.016 0.190 ↓ 0.0 0 1

Append (cost=5.97..343.29 rows=41 width=8) (actual time=0.190..0.190 rows=0 loops=1)

42. 0.006 0.006 ↓ 0.0 0 1

Index Scan using message_partition_2020_12_device_time_idx on message_partition_2020_12 lmpm_34 (cost=0.15..8.17 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
43. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2020_11_device_time_idx on message_partition_2020_11 lmpm_33 (cost=0.15..8.17 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
44. 0.004 0.004 ↓ 0.0 0 1

Index Scan using message_partition_2020_10_device_time_idx on message_partition_2020_10 lmpm_32 (cost=0.15..8.17 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
45. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2020_09_device_time_idx on message_partition_2020_09 lmpm_31 (cost=0.15..8.17 rows=1 width=8) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
46. 0.004 0.004 ↓ 0.0 0 1

Index Scan using message_partition_2020_08_device_time_idx on message_partition_2020_08 lmpm_30 (cost=0.14..8.16 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
47. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2020_07_device_time_idx on message_partition_2020_07 lmpm_29 (cost=0.14..8.16 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
48. 0.004 0.004 ↓ 0.0 0 1

Index Scan using message_partition_2020_06_device_time_idx on message_partition_2020_06 lmpm_28 (cost=0.15..8.17 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
49. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2020_05_device_time_idx on message_partition_2020_05 lmpm_27 (cost=0.15..8.17 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
50. 0.004 0.004 ↓ 0.0 0 1

Index Scan using message_partition_2020_04_device_time_idx on message_partition_2020_04 lmpm_26 (cost=0.15..8.17 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
51. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2020_03_device_time_idx on message_partition_2020_03 lmpm_25 (cost=0.15..8.17 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
52. 0.004 0.004 ↓ 0.0 0 1

Index Scan using message_partition_2020_02_device_time_idx on message_partition_2020_02 lmpm_24 (cost=0.15..8.17 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
53. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2020_01_device_time_idx on message_partition_2020_01 lmpm_23 (cost=0.15..8.17 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
54. 0.004 0.004 ↓ 0.0 0 1

Index Scan using message_partition_2019_12_device_time_idx on message_partition_2019_12 lmpm_22 (cost=0.15..8.17 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
55. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2019_11_device_time_idx on message_partition_2019_11 lmpm_21 (cost=0.15..8.17 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
56. 0.004 0.004 ↓ 0.0 0 1

Index Scan using message_partition_2019_10_device_time_idx on message_partition_2019_10 lmpm_20 (cost=0.14..8.17 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
57. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2019_09_device_time_idx on message_partition_2019_09 lmpm_19 (cost=0.15..8.17 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
58. 0.009 0.009 ↓ 0.0 0 1

Index Scan using message_partition_2019_08_device_time_idx on message_partition_2019_08 lmpm_18 (cost=0.15..8.17 rows=1 width=8) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
59. 0.004 0.004 ↓ 0.0 0 1

Index Scan using message_partition_2019_07_device_time_idx on message_partition_2019_07 lmpm_17 (cost=0.15..8.17 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
60. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2019_06_device_time_idx on message_partition_2019_06 lmpm_16 (cost=0.15..8.17 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
61. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2019_05_device_time_idx on message_partition_2019_05 lmpm_15 (cost=0.15..8.17 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
62. 0.004 0.004 ↓ 0.0 0 1

Index Scan using message_partition_2019_04_device_time_idx on message_partition_2019_04 lmpm_14 (cost=0.15..8.17 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
63. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2019_03_device_time_idx on message_partition_2019_03 lmpm_13 (cost=0.15..8.17 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
64. 0.004 0.004 ↓ 0.0 0 1

Index Scan using message_partition_2019_02_device_time_idx on message_partition_2019_02 lmpm_12 (cost=0.15..8.17 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
65. 0.007 0.007 ↓ 0.0 0 1

Index Scan using message_partition_2019_01_device_time_idx on message_partition_2019_01 lmpm_11 (cost=0.15..8.17 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
66. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2018_11_device_time_idx on message_partition_2018_11 lmpm_10 (cost=0.15..8.17 rows=1 width=8) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
67. 0.011 0.011 ↓ 0.0 0 1

Index Scan using message_partition_2018_09_device_time_idx on message_partition_2018_09 lmpm_9 (cost=0.15..8.17 rows=1 width=8) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
68. 0.004 0.004 ↓ 0.0 0 1

Index Scan using message_partition_2018_07_device_time_idx on message_partition_2018_07 lmpm_8 (cost=0.15..8.17 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
69. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2018_05_device_time_idx on message_partition_2018_05 lmpm_7 (cost=0.15..8.17 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
70. 0.004 0.004 ↓ 0.0 0 1

Index Scan using message_partition_2018_03_device_time_idx on message_partition_2018_03 lmpm_6 (cost=0.15..8.17 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
71. 0.004 0.004 ↓ 0.0 0 1

Index Scan using message_partition_2018_01_device_time_idx on message_partition_2018_01 lmpm_5 (cost=0.15..8.17 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
72. 0.004 0.004 ↓ 0.0 0 1

Index Scan using message_partition_2017_10_device_time_idx on message_partition_2017_10 lmpm_4 (cost=0.15..8.17 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
73. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2017_07_device_time_idx on message_partition_2017_07 lmpm_3 (cost=0.15..8.17 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
74. 0.005 0.005 ↓ 0.0 0 1

Index Scan using message_partition_2017_01_device_time_idx on message_partition_2017_01 lmpm_2 (cost=0.15..8.17 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time""))
  • Filter: (message_type = 'PARAMETERS_MINIMUM'::text)
75. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan Backward using message_partition_2016_01_pkey on message_partition_2016_01 lmpm_1 (cost=0.56..43.23 rows=7 width=8) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time"") AND (message_type = 'PARAMETERS_MINIMUM'::text))
  • Heap Fetches: 0
76. 0.000 0.000 ↓ 0.0 0

Index Only Scan Backward using message_partition_1970_01_pkey on message_partition_1970_01 lmpm (cost=0.56..30.26 rows=1 width=8) (never executed)

  • Index Cond: ((device = 493) AND (""time"" > m_34.""time"") AND (message_type = 'PARAMETERS_MINIMUM'::text))
  • Heap Fetches: 0
Planning time : 10.127 ms
Execution time : 0.954 ms