explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WDmK

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.170 ↑ 1.0 1 1

Limit (cost=0.00..7.94 rows=1 width=107) (actual time=0.170..0.170 rows=1 loops=1)

2. 0.003 0.168 ↑ 1,008,811,622.0 1 1

Nested Loop (cost=0.00..8,012,704,729.09 rows=1,008,811,622 width=107) (actual time=0.168..0.168 rows=1 loops=1)

3. 0.001 0.034 ↑ 1,008,811,622.0 1 1

Append (cost=0.00..25,161,335.35 rows=1,008,811,622 width=72) (actual time=0.034..0.034 rows=1 loops=1)

4. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on statevalue (cost=0.00..20.00 rows=267 width=72) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
5. 0.032 0.032 ↑ 8,812,778.0 1 1

Seq Scan on statevalue_bcc5b8f80bc446d7bd52e7d594a9473d statevalue (cost=0.00..219,003.62 rows=8,812,778 width=72) (actual time=0.032..0.032 rows=1 loops=1)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
6. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_3b7a59e8be054e31bf93bf7e827c8314 statevalue (cost=0.00..221,533.39 rows=5,256,891 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
7. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_355110c622a244f69e5452f02c4543d0 statevalue (cost=0.00..229,671.09 rows=9,242,053 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
8. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_f44a76b25b1f47cab7f56df79cd63c21 statevalue (cost=0.00..228,536.39 rows=9,196,721 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
9. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_5d988cc4fa9e472cbd1a3f11bbfe4d21 statevalue (cost=0.00..242,612.92 rows=9,762,472 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
10. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_71a78643dda34c388c79396668b4dd47 statevalue (cost=0.00..222,670.70 rows=8,960,209 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
11. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_843eea8793134514bd3c2762ebbea7e0 statevalue (cost=0.00..226,358.16 rows=9,108,871 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
12. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_50e9f9af20464fe2864d2de8cc689150 statevalue (cost=0.00..219,796.41 rows=8,844,678 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
13. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_a6a7124427164e7684d09376772ab468 statevalue (cost=0.00..216,936.19 rows=8,729,631 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
14. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_652cd34fa2bd46c09501c452d7e350f3 statevalue (cost=0.00..224,958.75 rows=9,052,524 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
15. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_9da070132f394dd790bc20cd500a8aa4 statevalue (cost=0.00..215,592.64 rows=8,675,433 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
16. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_84b632ea66ab4816a6a338b52c6577ab statevalue (cost=0.00..222,503.24 rows=8,953,613 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
17. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_ab98d3fa36bd4fcdaaaf958fc6d6b996 statevalue (cost=0.00..226,336.96 rows=9,107,896 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
18. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_12a740c457de4fc4bd49d815f6479b5a statevalue (cost=0.00..208,274.16 rows=8,380,944 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
19. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_e13371f3e60e441c828f617a6856c055 statevalue (cost=0.00..221,224.80 rows=8,902,143 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
20. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_57c19aa4b7914bfc9f5af76ea53cef60 statevalue (cost=0.00..223,889.23 rows=9,009,366 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
21. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_e38602c627ec4f1bb6edec7a61e41b32 statevalue (cost=0.00..200,625.38 rows=8,072,991 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
22. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_4dd38d535bfb4629bea279c5c95a762d statevalue (cost=0.00..178,151.16 rows=7,168,664 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
23. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_5dc2ce0a8ea3467688ec82f296efc61a statevalue (cost=0.00..204,868.86 rows=8,243,893 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
24. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_70ba27c9a5aa492d882af67e5e2d7cbb statevalue (cost=0.00..208,267.46 rows=8,380,728 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
25. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_fb8b406978a149f3b0d255008508f891 statevalue (cost=0.00..206,954.70 rows=8,327,873 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
26. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_a562a1bd19974e7cbc0dc848a3aaaea1 statevalue (cost=0.00..192,436.83 rows=7,743,620 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
27. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_dc897a5eb61e444aa0bbeaf7d1833746 statevalue (cost=0.00..206,254.81 rows=8,299,724 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
28. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_2d5d4c6b1eb742a9a5fb15774bb23186 statevalue (cost=0.00..197,327.51 rows=7,940,456 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
29. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_6a5eff6bc4734b418c6dbbee0cb42497 statevalue (cost=0.00..209,669.90 rows=8,437,237 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
30. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_40c06c7dc13a4347ab319ba5463aa8dd statevalue (cost=0.00..192,576.10 rows=7,749,241 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
31. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_315a945e57cb412c8979ed44edd41ff2 statevalue (cost=0.00..186,092.81 rows=7,488,284 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
32. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_36ec7ff9ea584c739a1dcf1d25b219be statevalue (cost=0.00..189,356.15 rows=7,619,578 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
33. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_15adc7e863ce4f3194f8720cd5763117 statevalue (cost=0.00..173,272.99 rows=6,972,350 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
34. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_5032721d5413464e846b904381d0f024 statevalue (cost=0.00..176,760.15 rows=7,112,589 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
35. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_f0157f5e65a441fca9450c75f15e2ffe statevalue (cost=0.00..189,980.92 rows=7,644,758 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
36. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_c42f53cbcf9145e0a98407dce84bc332 statevalue (cost=0.00..167,576.61 rows=6,742,982 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
37. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_58e1e5d1c43d40fd8529768e475b4413 statevalue (cost=0.00..170,284.54 rows=6,852,085 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
38. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_798993a296894fa4ab6dc5600a6d06b1 statevalue (cost=0.00..169,521.73 rows=6,821,463 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
39. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_e4ed54b8d5c44522bd030275f39b680b statevalue (cost=0.00..169,181.51 rows=6,807,687 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
40. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_d7ce6aa2336e467e9cdde9dcdfd49ec2 statevalue (cost=0.00..183,354.31 rows=7,378,095 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
41. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_3bb49cccfda24f7db4f141d3eb599205 statevalue (cost=0.00..165,567.29 rows=6,662,084 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
42. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_aa9d752650bb4acd9778ca7eafa34a50 statevalue (cost=0.00..173,927.79 rows=6,998,651 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
43. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_95e93715862e46c0aae0c3f3c7d47fce statevalue (cost=0.00..166,467.56 rows=6,698,425 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
44. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_cc1de2bf93674bb999b4e0c1a86bb57d statevalue (cost=0.00..169,588.89 rows=6,823,956 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
45. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_bc0a602bdc8140b6acddbdb3b6e1602a statevalue (cost=0.00..189,628.42 rows=7,630,402 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
46. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_066b38d47460406da76371b0d85ec6c9 statevalue (cost=0.00..180,389.05 rows=7,258,646 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
47. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_f79adfa27b5445509578cdf37dcb2a21 statevalue (cost=0.00..180,439.98 rows=7,260,800 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
48. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_c3b4a58e94454b5f890d3adea337bb5e statevalue (cost=0.00..189,002.65 rows=7,605,300 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
49. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_a308b3a45a0c42ab9ccdf5de4be670b0 statevalue (cost=0.00..181,456.56 rows=7,301,723 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
50. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_b65a3565042f4339962f147d34aec0a2 statevalue (cost=0.00..166,739.59 rows=6,709,463 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
51. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_95af60ed798d4ebfad0f584f11535eaf statevalue (cost=0.00..191,896.96 rows=7,721,953 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
52. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_42816bf47e5e45618fd296098e7dd328 statevalue (cost=0.00..169,485.45 rows=6,819,842 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
53. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_34213ef066454da9a75e3eac93cf9d3d statevalue (cost=0.00..173,022.49 rows=6,961,433 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
54. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_bcc44b0a40fd48a4926f470c91ac9ab5 statevalue (cost=0.00..176,720.59 rows=7,111,024 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
55. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_b519ef7240314bd6869ad74f8e08dc7f statevalue (cost=0.00..187,777.65 rows=7,556,025 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
56. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_00e3db2978f7454cacfae92ffd8167db statevalue (cost=0.00..173,242.50 rows=6,971,190 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
57. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_0fed58997b0e436aa3eae624513315b6 statevalue (cost=0.00..159,620.05 rows=6,422,889 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
58. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_e6db7a657a764567a809abfa7ce19e1f statevalue (cost=0.00..165,251.53 rows=6,649,384 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
59. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_84c8d54b075c4cf5b52e4bb6de12cf98 statevalue (cost=0.00..157,979.46 rows=6,356,848 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
60. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_f96969ee852b43b6b004d416da0fbe9f statevalue (cost=0.00..176,010.46 rows=7,082,457 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
61. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_8752506e4d8e48a2862b061c56d56ed0 statevalue (cost=0.00..159,037.51 rows=6,399,328 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
62. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_e73b03898d304859a24869d443ecd5e5 statevalue (cost=0.00..160,108.95 rows=6,442,559 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
63. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_9d3ac1a3eb86481d8079f7d432125534 statevalue (cost=0.00..180,158.44 rows=7,249,478 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
64. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_34803cc7da6a441993b0642e0e4aa1e7 statevalue (cost=0.00..110,809.44 rows=4,458,314 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
65. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_dd7e2a5e12d84467be7fbb2f72712fb6 statevalue (cost=0.00..157,976.38 rows=6,356,841 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
66. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_890c6a6213b54f46b11108372ac5b5de statevalue (cost=0.00..191,527.74 rows=7,707,057 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
67. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_959a2186e9e54a0682e81f1af5675a9d statevalue (cost=0.00..200,594.56 rows=8,071,886 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
68. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_95a4720f755a461ca593b19c9cd7b85d statevalue (cost=0.00..162,201.70 rows=6,526,771 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
69. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_d9b9ad62ea5349fe9c059ebcb88403c5 statevalue (cost=0.00..188,872.81 rows=7,600,273 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
70. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_ff698d5ffd8643379bfce8814c11157c statevalue (cost=0.00..175,230.50 rows=7,051,183 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
71. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_44b7c3765d7a43bc90fae429bab65cf2 statevalue (cost=0.00..178,030.67 rows=7,163,825 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
72. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_a2b4a333962f49cebb18f2e11c405609 statevalue (cost=0.00..176,996.92 rows=7,122,170 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
73. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_e0c844a927004640918d0a38aae02710 statevalue (cost=0.00..193,653.80 rows=7,792,420 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
74. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_9c88c17067be4a3db46e0e8c30a9a1bc statevalue (cost=0.00..164,458.38 rows=6,617,535 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
75. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_de914466aabf476f90bf4b2a64db7469 statevalue (cost=0.00..177,273.38 rows=7,133,485 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
76. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_ec55d6d6e43a4b00a891667c8a85b28b statevalue (cost=0.00..179,591.92 rows=7,226,559 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
77. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_fa744c18f38c4de09d0a85c4907928fb statevalue (cost=0.00..163,549.73 rows=6,581,087 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
78. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_c06fa44cee8d48f69c3c10ccff030a2f statevalue (cost=0.00..166,067.29 rows=6,682,322 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
79. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_cfc5855b500b41a396c418264ef18a50 statevalue (cost=0.00..171,098.90 rows=6,884,831 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
80. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_2233c8a36f564ad1b0a1bbee9db6ef6e statevalue (cost=0.00..171,083.67 rows=6,884,173 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
81. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_68e02c955f9b43b7aa25b8c51b1725ea statevalue (cost=0.00..168,998.33 rows=6,800,153 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
82. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_618bac69862844bc9c0acd41ec76a315 statevalue (cost=0.00..178,332.35 rows=7,175,878 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
83. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_0fc922451b6347b1af81085d3a7ef657 statevalue (cost=0.00..174,834.25 rows=7,035,084 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
84. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_17098bbea514464c9af6f3988409b97d statevalue (cost=0.00..183,200.81 rows=7,371,896 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
85. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_f646740a4dfb426eb4a1e0e1f3d9d43f statevalue (cost=0.00..170,376.84 rows=6,855,949 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
86. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_348d4a2ddcde40a1956abf991509ce1c statevalue (cost=0.00..177,535.59 rows=7,143,741 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
87. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_2ad12a47b79c46a5a9b6b1aec9d455a5 statevalue (cost=0.00..198,287.36 rows=7,977,885 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
88. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_a397cca7b7db4cba9708c5484f8b9af7 statevalue (cost=0.00..168,923.95 rows=6,797,244 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
89. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_c32bada119524d7ca7d85ddb2732c617 statevalue (cost=0.00..150,097.66 rows=6,039,696 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
90. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_3d01b40d4f7f4a9a93dcec246730c435 statevalue (cost=0.00..182,479.54 rows=7,342,837 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
91. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_065789a3097e4e809ee4244c69a95a10 statevalue (cost=0.00..200,159.88 rows=8,055,113 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
92. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_094bb5ead95442c7a8440b502b08117b statevalue (cost=0.00..156,905.15 rows=6,313,468 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
93. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_a0950cc97f1644aeab1e42e2f4bf3ed8 statevalue (cost=0.00..151,681.62 rows=6,103,446 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
94. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_8c75addc228642e8a278008d3ce02057 statevalue (cost=0.00..164,439.03 rows=6,616,788 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
95. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_87d2f9206b8f437dbd66d0522bdc45ef statevalue (cost=0.00..166,682.74 rows=6,707,076 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
96. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_1c4fc2075b774c9b94abff12c9b105d5 statevalue (cost=0.00..177,040.30 rows=7,124,039 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
97. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_df4cfb81bdf54d89a4751cd37ea60c8b statevalue (cost=0.00..159,198.60 rows=6,405,814 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
98. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_bda8204b65f4434db7e28daa6b4aa045 statevalue (cost=0.00..163,720.11 rows=6,587,917 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
99. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_16ed3399a44d464a8f6cf922504a0210 statevalue (cost=0.00..162,065.23 rows=6,521,213 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
100. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_e0ad1d142209456e9f59ffca39fc4397 statevalue (cost=0.00..169,096.30 rows=6,804,231 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
101. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_a32c58d73ccb40c1af8540152b7468f6 statevalue (cost=0.00..178,958.98 rows=7,201,206 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
102. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_e08654af93ed4dd69266517c518ace4e statevalue (cost=0.00..164,787.16 rows=6,630,797 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
103. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_17f36aaca2c74f968eb9c2c66bffde0f statevalue (cost=0.00..167,572.91 rows=6,743,006 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
104. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_91a0d5c39b464292a1793d2be16f38ea statevalue (cost=0.00..172,258.28 rows=6,931,496 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
105. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_aabd1777536d440f85602cb5d6d23a39 statevalue (cost=0.00..161,033.69 rows=6,478,855 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
106. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_fcaf2a9c14014112aea7005b6a25b408 statevalue (cost=0.00..211,433.01 rows=8,506,856 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
107. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_aa9835e4a69049d8afee8a4e823ad317 statevalue (cost=0.00..178,647.53 rows=7,188,611 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
108. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_e78c39ca961f42fa8e4e9f33994224fd statevalue (cost=0.00..184,213.74 rows=7,412,606 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
109. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_bb185a23d4e64784b0d51ec00dd8cde2 statevalue (cost=0.00..169,516.46 rows=6,821,123 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
110. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_4f5d7e915d7d4075908328cdb5c24d22 statevalue (cost=0.00..174,729.75 rows=7,030,965 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
111. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_3c6c1dbe10cf4ae08de22efe53e8a9be statevalue (cost=0.00..173,706.99 rows=6,989,788 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
112. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_d2d4cda89d92414783b467f2a02e0880 statevalue (cost=0.00..166,350.42 rows=6,693,772 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
113. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_76171b79f0d14a4f8a86ae1f4f15eb58 statevalue (cost=0.00..176,846.62 rows=7,116,306 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
114. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_49528b30ba0843a89c351ccd310bbdf4 statevalue (cost=0.00..184,173.90 rows=7,411,019 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
115. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_f223cc6b2cc7462289928795ff3f5981 statevalue (cost=0.00..164,696.46 rows=6,627,221 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
116. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_b8b9032a372c4f1a99d5df3fb1f898a1 statevalue (cost=0.00..174,986.55 rows=7,041,347 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
117. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_6c6585cb942e40c8b711042c708ec14e statevalue (cost=0.00..177,171.92 rows=7,129,209 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
118. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_15ff0944ec904dcdaed9c3011df23a78 statevalue (cost=0.00..180,667.30 rows=7,270,025 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
119. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_b31d9fd1d52b4c778e7a9e9c1228bfaf statevalue (cost=0.00..174,271.70 rows=7,012,642 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
120. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_5387b558797b4211b9ca94858e001d8d statevalue (cost=0.00..198,397.08 rows=7,982,496 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
121. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_2abc75ad49c74506ab17af1eb855a377 statevalue (cost=0.00..157,790.20 rows=6,349,308 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
122. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_4c59f515957640cf96ba8cf5e0630e84 statevalue (cost=0.00..176,897.09 rows=7,117,866 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
123. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_b2c7e785e4564229b331309b75740dea statevalue (cost=0.00..166,231.79 rows=6,689,002 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
124. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_348c8abf65f5497faaff49d06fffb32b statevalue (cost=0.00..157,178.83 rows=6,324,640 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
125. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_8903455f4f174ce9b44b342b325ef458 statevalue (cost=0.00..149,260.36 rows=6,005,755 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
126. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_fc15d4ae44b04d57aed3d2c5ba85d177 statevalue (cost=0.00..164,758.30 rows=6,629,688 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
127. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_97dc13bed52e4f5890274226794e8e96 statevalue (cost=0.00..198,881.89 rows=8,003,686 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
128. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_7e4cf6aa7df9476e9b30b43c5822baae statevalue (cost=0.00..168,755.58 rows=6,790,734 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
129. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_62efbfad64b644e19a46b9cf01de3d96 statevalue (cost=0.00..194,269.53 rows=7,817,349 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
130. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_b6d1ac853abc4ba4b78186208e856fc6 statevalue (cost=0.00..165,548.33 rows=6,661,527 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
131. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_8635654b9a804aa3ba1db0ee9b462721 statevalue (cost=0.00..162,837.91 rows=6,552,385 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
132. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_030b6adbdefb4ce3ae6130833a0f9521 statevalue (cost=0.00..171,519.35 rows=6,901,745 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
133. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_e7704e8500054f66a9075ade9b0fb44e statevalue (cost=0.00..178,402.41 rows=7,178,683 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
134. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_7a5f9da661e84df2ae47e73c34309c92 statevalue (cost=0.00..164,650.00 rows=6,626,065 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
135. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_d0f989d8bfc64dacb2d3dffe0e8dc5db statevalue (cost=0.00..210,218.74 rows=8,459,143 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
136. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_19753a48e8104e2985c4eea8d08ddb7c statevalue (cost=0.00..236,413.00 rows=9,511,865 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
137. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_a5fc4e3a6cf140aa876beaf938e5825c statevalue (cost=0.00..215,999.67 rows=8,691,834 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
138. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_76ceca39bcd043a48c9a5ffaed4dacd9 statevalue (cost=0.00..210,821.56 rows=8,483,525 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
139. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_604e68c7fad7477780181202bbcfbee4 statevalue (cost=0.00..224,529.21 rows=9,035,122 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
140. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_a6cc18b1712f488b95b77fbe065b1512 statevalue (cost=0.00..223,586.00 rows=8,997,110 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
141. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_339f552c5de2419f9307789c3479ff4b statevalue (cost=0.00..227,635.59 rows=9,160,021 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
142. 0.000 0.000 ↓ 0.0 0

Seq Scan on statevalue_24eb32004eee450eadf5884c6d6c7673 statevalue (cost=0.00..11,703.26 rows=470,375 width=72) (never executed)

  • Filter: (dtstart > '2019-08-20 23:59:59.048511+08'::timestamp with time zone)
143. 0.131 0.131 ↑ 1.0 1 1

Index Scan using state_pkey on state (cost=0.00..7.91 rows=1 width=51) (actual time=0.131..0.131 rows=1 loops=1)

  • Index Cond: (state.objectid = history.statevalue.objectid)
Total runtime : 3.668 ms