By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
315 rows affected
| id | prior | grp | deleted |
|---|---|---|---|
| 4692 | null | 5202 | f |
| 4693 | null | 5203 | f |
| 4694 | null | 5204 | f |
| 4695 | null | 5205 | f |
| 4696 | null | 5206 | f |
| 4697 | null | 5207 | f |
| 4698 | null | 5208 | f |
| 4700 | null | 5209 | f |
| 4701 | null | 5210 | f |
| 4702 | null | 5211 | f |
| 4703 | null | 5212 | f |
| 4720 | null | 5213 | f |
| 4724 | null | 5214 | f |
| 4728 | null | 5215 | f |
| 4729 | null | 5216 | f |
| 4731 | null | 5217 | f |
| 4732 | null | 5218 | f |
| 4733 | null | 5219 | f |
| 4746 | null | 5220 | f |
| 4755 | null | 5221 | f |
| 4756 | null | 5222 | f |
| 4757 | null | 5223 | f |
| 4762 | null | 5224 | f |
| 4763 | null | 5225 | f |
| 4764 | null | 5226 | f |
| 4765 | null | 5227 | f |
| 4766 | null | 5228 | f |
| 4769 | null | 5229 | f |
| 4770 | null | 5230 | f |
| 4771 | null | 5231 | f |
| 4772 | null | 5232 | f |
| 4773 | null | 5233 | f |
| 4774 | null | 5234 | f |
| 4775 | null | 5235 | f |
| 4776 | null | 5236 | f |
| 4778 | null | 5237 | f |
| 4779 | null | 5238 | f |
| 4780 | null | 5239 | f |
| 4782 | null | 5240 | f |
| 4783 | null | 5241 | f |
| 4784 | null | 5242 | f |
| 4785 | null | 5243 | f |
| 4788 | null | 5244 | f |
| 4791 | null | 5245 | f |
| 4792 | null | 5246 | f |
| 4793 | null | 5247 | f |
| 4794 | null | 5248 | f |
| 4795 | null | 5249 | f |
| 4796 | null | 5250 | f |
| 4797 | null | 5251 | f |
| 4799 | null | 5252 | f |
| 4800 | null | 5253 | f |
| 4801 | null | 5254 | f |
| 4802 | null | 5255 | f |
| 4804 | null | 5256 | f |
| 4805 | null | 5257 | f |
| 4806 | null | 5258 | f |
| 4808 | null | 5259 | f |
| 4811 | null | 5260 | f |
| 4813 | null | 5261 | f |
| 4815 | null | 5262 | f |
| 4816 | null | 5263 | f |
| 4817 | null | 5264 | f |
| 4819 | null | 5265 | f |
| 4842 | null | 5267 | f |
| 4848 | null | 5278 | f |
| 4849 | null | 5279 | f |
| 4850 | null | 5280 | f |
| 4851 | null | 5281 | f |
| 4853 | null | 5282 | f |
| 4854 | null | 5283 | f |
| 4855 | null | 5284 | f |
| 4856 | null | 5285 | f |
| 4859 | null | 5287 | f |
| 4862 | null | 5288 | f |
| 4863 | null | 5289 | f |
| 4864 | null | 5290 | f |
| 4865 | null | 5291 | f |
| 4866 | null | 5292 | f |
| 4867 | null | 5293 | f |
| 4868 | null | 5294 | f |
| 4869 | null | 5295 | f |
| 4870 | 4869 | 5295 | f |
| 4879 | null | 5296 | f |
| 4880 | null | 5297 | f |
| 4882 | 4855 | 5284 | f |
| 4884 | null | 5298 | f |
| 4886 | null | 5299 | f |
| 4893 | 4791 | 5245 | f |
| 4994 | 4692 | 5202 | f |
| 5012 | 4700 | 5209 | f |
| 5013 | 4773 | 5233 | f |
| 5020 | 4776 | 5236 | f |
| 5028 | 4701 | 5210 | f |
| 5045 | 4694 | 5204 | f |
| 5046 | 4695 | 5205 | f |
| 5049 | 4696 | 5206 | f |
| 5070 | 5049 | 5206 | f |
| 5074 | 5046 | 5205 | f |
| 5075 | 5045 | 5204 | f |
| 5241 | 5012 | 5209 | f |
| 5253 | 5013 | 5233 | f |
| 5263 | 5020 | 5236 | f |
| 5268 | 5263 | 5236 | f |
| 5273 | 5268 | 5236 | f |
| 5287 | 5241 | 5209 | f |
| 5289 | 5253 | 5233 | f |
| 5302 | 5273 | 5236 | f |
| 5381 | 4994 | 5202 | f |
| 5420 | 5381 | 5202 | f |
| 5549 | 4795 | 5249 | f |
| 5550 | 4851 | 5281 | f |
| 5552 | 4799 | 5252 | f |
| 5553 | 4817 | 5264 | f |
| 5554 | 4850 | 5280 | f |
| 5555 | 4815 | 5262 | f |
| 5556 | 4819 | 5265 | f |
| 5557 | 4816 | 5263 | f |
| 5560 | 4804 | 5256 | f |
| 5589 | 4766 | 5228 | f |
| 5591 | 4868 | 5294 | f |
| 5592 | 4774 | 5234 | f |
| 5593 | 4856 | 5285 | f |
| 5594 | 4854 | 5283 | f |
| 5595 | 4884 | 5298 | f |
| 5604 | 4693 | 5203 | f |
| 5605 | 4801 | 5254 | f |
| 5611 | 4703 | 5212 | f |
| 5612 | 4863 | 5289 | f |
| 5636 | 4702 | 5211 | f |
| 5644 | 4770 | 5230 | f |
| 5645 | 4755 | 5221 | f |
| 5646 | 4772 | 5232 | f |
| 5647 | 4865 | 5291 | f |
| 5648 | 4853 | 5282 | f |
| 5660 | 4724 | 5214 | f |
| 5661 | 4806 | 5258 | f |
| 5687 | 4862 | 5288 | f |
| 5688 | 4785 | 5243 | f |
| 5689 | 4794 | 5248 | f |
| 5703 | 4867 | 5293 | f |
| 5704 | 4756 | 5222 | f |
| 5708 | 4792 | 5246 | f |
| 5717 | 4763 | 5225 | f |
| 5718 | 4784 | 5242 | f |
| 5720 | 4779 | 5238 | f |
| 5721 | 4780 | 5239 | f |
| 5722 | 4775 | 5235 | f |
| 5743 | 4793 | 5247 | f |
| 5790 | 4762 | 5224 | f |
| 5791 | 5790 | 5224 | f |
| 5816 | 5612 | 5289 | f |
| 5875 | 5645 | 5221 | f |
| 5876 | 5644 | 5230 | f |
| 5878 | 5660 | 5214 | f |
| 5910 | 4765 | 5227 | f |
| 5911 | 4757 | 5223 | f |
| 5912 | 4764 | 5226 | f |
| 5913 | 4733 | 5219 | f |
| 5914 | 4732 | 5218 | f |
| 5915 | 4782 | 5240 | f |
| 5916 | 4731 | 5217 | f |
| 5917 | 4783 | 5241 | f |
| 5918 | 4778 | 5237 | f |
| 5919 | 4771 | 5231 | f |
| 5920 | 4866 | 5292 | f |
| 5921 | 4859 | 5287 | f |
| 5922 | 4864 | 5290 | f |
| 5923 | 4879 | 5296 | f |
| 5924 | 4880 | 5297 | f |
| 5948 | 4697 | 5207 | f |
| 5949 | 4698 | 5208 | f |
| 5950 | 4728 | 5215 | f |
| 6021 | 5791 | 5224 | f |
| 6031 | 5816 | 5289 | f |
| 6067 | 5875 | 5221 | f |
| 6068 | 5876 | 5230 | f |
| 6069 | 5878 | 5214 | f |
| 6087 | 6067 | 5221 | f |
| 6092 | 6087 | 5221 | f |
| 6153 | 5948 | 5207 | f |
| 6154 | 5949 | 5208 | f |
| 6170 | 5950 | 5215 | f |
| 6188 | 5549 | 5249 | f |
| 6189 | 5550 | 5281 | f |
| 6193 | 5552 | 5252 | f |
| 6194 | 5553 | 5264 | f |
| 6196 | 5554 | 5280 | f |
| 6197 | 5555 | 5262 | f |
| 6199 | 5556 | 5265 | f |
| 6200 | 5557 | 5263 | f |
| 6206 | 5560 | 5256 | f |
| 6240 | 6153 | 5207 | f |
| 6242 | 6154 | 5208 | f |
| 6256 | 6170 | 5215 | f |
| 6267 | 6188 | 5249 | f |
| 6268 | 6189 | 5281 | f |
| 6269 | 6193 | 5252 | f |
| 6270 | 6194 | 5264 | f |
| 6271 | 6196 | 5280 | f |
| 6272 | 6197 | 5262 | f |
| 6273 | 6199 | 5265 | f |
| 6274 | 6200 | 5263 | f |
| 6278 | 6206 | 5256 | f |
| 6324 | 5911 | 5223 | f |
| 6331 | 5916 | 5217 | f |
| 6333 | 5917 | 5241 | f |
| 6336 | 5918 | 5237 | f |
| 6344 | 5704 | 5222 | f |
| 6379 | 5720 | 5238 | f |
| 6381 | 5287 | 5209 | f |
| 6382 | 6381 | 5209 | f |
| 6383 | 5289 | 5233 | f |
| 6384 | 6383 | 5233 | f |
| 6398 | 5302 | 5236 | f |
| 6399 | 6398 | 5236 | f |
| 6402 | 5420 | 5202 | f |
| 6403 | 6402 | 5202 | f |
| 6414 | 6324 | 5223 | f |
| 6420 | 6331 | 5217 | f |
| 6421 | 6333 | 5241 | f |
| 6424 | 6336 | 5237 | f |
| 6427 | 6344 | 5222 | f |
| 6441 | 6379 | 5238 | f |
| 6467 | 5923 | 5296 | f |
| 6469 | 6399 | 5236 | f |
| 6483 | 6467 | 5296 | f |
| 6486 | 6469 | 5236 | f |
| 6499 | 5703 | 5293 | f |
| 6514 | 5921 | 5287 | f |
| 6531 | 6499 | 5293 | f |
| 6538 | 6514 | 5287 | f |
| 6571 | 5922 | 5290 | f |
| 6572 | 5636 | 5211 | f |
| 6580 | 6384 | 5233 | f |
| 6604 | 5912 | 5226 | f |
| 6621 | 6580 | 5233 | f |
| 6636 | 5743 | 5247 | f |
| 6641 | 6571 | 5290 | f |
| 6642 | 6572 | 5211 | f |
| 6651 | 6604 | 5226 | f |
| 6667 | 6636 | 5247 | f |
| 6673 | 5910 | 5227 | f |
| 6679 | 6673 | 5227 | f |
| 6713 | 5708 | 5246 | f |
| 6716 | 5721 | 5239 | f |
| 6721 | 6651 | 5226 | t |
| 6723 | 6651 | 5226 | f |
| 6730 | 5915 | 5240 | f |
| 6754 | 5717 | 5225 | f |
| 6757 | 6382 | 5209 | f |
| 6831 | 6621 | 5233 | f |
| 6832 | 6831 | 5233 | f |
| 6838 | 6832 | 5233 | f |
| 6856 | 6757 | 5209 | f |
| 6867 | 6838 | 5233 | f |
| 6900 | 6403 | 5202 | f |
| 6907 | 6713 | 5246 | f |
| 6910 | 6716 | 5239 | f |
| 6912 | 6723 | 5226 | f |
| 6913 | 6730 | 5240 | f |
| 6920 | 6754 | 5225 | f |
| 6938 | 6900 | 5202 | f |
| 6981 | 6907 | 5246 | f |
| 6997 | 6910 | 5239 | f |
| 7003 | 6997 | 5239 | f |
| 7011 | 5070 | 5206 | f |
| 7012 | 5075 | 5204 | f |
| 7021 | 5074 | 5205 | f |
| 7042 | 7003 | 5239 | f |
| 7043 | 7042 | 5239 | f |
| 7047 | 6981 | 5246 | f |
| 7054 | 5647 | 5291 | f |
| 7132 | 7054 | 5291 | f |
| 7157 | 5648 | 5282 | f |
| 7191 | 5589 | 5228 | f |
| 7265 | 5592 | 5234 | f |
| 7281 | 7191 | 5228 | f |
| 7293 | 7265 | 5234 | f |
| 7298 | 6427 | 5222 | f |
| 7300 | 7298 | 5222 | f |
| 7390 | 5611 | 5212 | f |
| 7408 | 7021 | 5205 | f |
| 7409 | 7408 | 5205 | f |
| 7410 | 7409 | 5205 | f |
| 7411 | 7012 | 5204 | f |
| 7412 | 7411 | 5204 | f |
| 7413 | 7412 | 5204 | f |
| 7414 | 7011 | 5206 | f |
| 7415 | 7414 | 5206 | f |
| 7416 | 7415 | 5206 | f |
| 7421 | 7416 | 5206 | f |
| 7422 | 7410 | 5205 | f |
| 7423 | 7413 | 5204 | f |
| 7426 | 7423 | 5204 | f |
| 7427 | 7422 | 5205 | f |
| 7429 | 7421 | 5206 | f |
| 7430 | 7426 | 5204 | f |
| 7431 | 7430 | 5204 | f |
| 7440 | 7390 | 5212 | f |
| 7451 | 5688 | 5243 | f |
| 7468 | 7451 | 5243 | f |
| 7470 | 5687 | 5288 | f |
| 7551 | 7468 | 5243 | f |
| 7634 | 6938 | 5202 | f |
| 7635 | 7634 | 5202 | f |
| 7636 | 7635 | 5202 | f |
| 7707 | 7636 | 5202 | f |
| 7711 | 7470 | 5288 | f |
| 7795 | 7551 | 5243 | f |
| 7917 | 7795 | 5243 | f |
| 7919 | 7917 | 5243 | f |
| 7923 | null | 5201 | f |
| 7941 | 7923 | 5201 | f |
| 8018 | 5661 | 5258 | f |
| grp | id | prior | posterior |
|---|---|---|---|
| 5202 | 4692 | null | 4994 |
| 5203 | 4693 | null | 5604 |
| 5204 | 4694 | null | 5045 |
| 5205 | 4695 | null | 5046 |
| 5206 | 4696 | null | 5049 |
| 5207 | 4697 | null | 5948 |
| 5208 | 4698 | null | 5949 |
| 5209 | 4700 | null | 5012 |
| 5210 | 4701 | null | 5028 |
| 5211 | 4702 | null | 5636 |
| 5212 | 4703 | null | 5611 |
| 5213 | 4720 | null | null |
| 5214 | 4724 | null | 5660 |
| 5215 | 4728 | null | 5950 |
| 5216 | 4729 | null | null |
| 5217 | 4731 | null | 5916 |
| 5218 | 4732 | null | 5914 |
| 5219 | 4733 | null | 5913 |
| 5220 | 4746 | null | null |
| 5221 | 4755 | null | 5645 |
| 5222 | 4756 | null | 5704 |
| 5223 | 4757 | null | 5911 |
| 5224 | 4762 | null | 5790 |
| 5225 | 4763 | null | 5717 |
| 5226 | 4764 | null | 5912 |
| 5227 | 4765 | null | 5910 |
| 5228 | 4766 | null | 5589 |
| 5229 | 4769 | null | null |
| 5230 | 4770 | null | 5644 |
| 5231 | 4771 | null | 5919 |
| 5232 | 4772 | null | 5646 |
| 5233 | 4773 | null | 5013 |
| 5234 | 4774 | null | 5592 |
| 5235 | 4775 | null | 5722 |
| 5236 | 4776 | null | 5020 |
| 5237 | 4778 | null | 5918 |
| 5238 | 4779 | null | 5720 |
| 5239 | 4780 | null | 5721 |
| 5240 | 4782 | null | 5915 |
| 5241 | 4783 | null | 5917 |
| 5242 | 4784 | null | 5718 |
| 5243 | 4785 | null | 5688 |
| 5244 | 4788 | null | null |
| 5245 | 4791 | null | 4893 |
| 5246 | 4792 | null | 5708 |
| 5247 | 4793 | null | 5743 |
| 5248 | 4794 | null | 5689 |
| 5249 | 4795 | null | 5549 |
| 5250 | 4796 | null | null |
| 5251 | 4797 | null | null |
| 5252 | 4799 | null | 5552 |
| 5253 | 4800 | null | null |
| 5254 | 4801 | null | 5605 |
| 5255 | 4802 | null | null |
| 5256 | 4804 | null | 5560 |
| 5257 | 4805 | null | null |
| 5258 | 4806 | null | 5661 |
| 5259 | 4808 | null | null |
| 5260 | 4811 | null | null |
| 5261 | 4813 | null | null |
| 5262 | 4815 | null | 5555 |
| 5263 | 4816 | null | 5557 |
| 5264 | 4817 | null | 5553 |
| 5265 | 4819 | null | 5556 |
| 5267 | 4842 | null | null |
| 5278 | 4848 | null | null |
| 5279 | 4849 | null | null |
| 5280 | 4850 | null | 5554 |
| 5281 | 4851 | null | 5550 |
| 5282 | 4853 | null | 5648 |
| 5283 | 4854 | null | 5594 |
| 5284 | 4855 | null | 4882 |
| 5285 | 4856 | null | 5593 |
| 5287 | 4859 | null | 5921 |
| 5288 | 4862 | null | 5687 |
| 5289 | 4863 | null | 5612 |
| 5290 | 4864 | null | 5922 |
| 5291 | 4865 | null | 5647 |
| 5292 | 4866 | null | 5920 |
| 5293 | 4867 | null | 5703 |
| 5294 | 4868 | null | 5591 |
| 5295 | 4869 | null | 4870 |
| 5295 | 4870 | 4869 | null |
| 5296 | 4879 | null | 5923 |
| 5297 | 4880 | null | 5924 |
| 5284 | 4882 | 4855 | null |
| 5298 | 4884 | null | 5595 |
| 5299 | 4886 | null | null |
| 5245 | 4893 | 4791 | null |
| 5202 | 4994 | 4692 | 5381 |
| 5209 | 5012 | 4700 | 5241 |
| 5233 | 5013 | 4773 | 5253 |
| 5236 | 5020 | 4776 | 5263 |
| 5210 | 5028 | 4701 | null |
| 5204 | 5045 | 4694 | 5075 |
| 5205 | 5046 | 4695 | 5074 |
| 5206 | 5049 | 4696 | 5070 |
| 5206 | 5070 | 5049 | 7011 |
| 5205 | 5074 | 5046 | 7021 |
| 5204 | 5075 | 5045 | 7012 |
| 5209 | 5241 | 5012 | 5287 |
| 5233 | 5253 | 5013 | 5289 |
| 5236 | 5263 | 5020 | 5268 |
| 5236 | 5268 | 5263 | 5273 |
| 5236 | 5273 | 5268 | 5302 |
| 5209 | 5287 | 5241 | 6381 |
| 5233 | 5289 | 5253 | 6383 |
| 5236 | 5302 | 5273 | 6398 |
| 5202 | 5381 | 4994 | 5420 |
| 5202 | 5420 | 5381 | 6402 |
| 5249 | 5549 | 4795 | 6188 |
| 5281 | 5550 | 4851 | 6189 |
| 5252 | 5552 | 4799 | 6193 |
| 5264 | 5553 | 4817 | 6194 |
| 5280 | 5554 | 4850 | 6196 |
| 5262 | 5555 | 4815 | 6197 |
| 5265 | 5556 | 4819 | 6199 |
| 5263 | 5557 | 4816 | 6200 |
| 5256 | 5560 | 4804 | 6206 |
| 5228 | 5589 | 4766 | 7191 |
| 5294 | 5591 | 4868 | null |
| 5234 | 5592 | 4774 | 7265 |
| 5285 | 5593 | 4856 | null |
| 5283 | 5594 | 4854 | null |
| 5298 | 5595 | 4884 | null |
| 5203 | 5604 | 4693 | null |
| 5254 | 5605 | 4801 | null |
| 5212 | 5611 | 4703 | 7390 |
| 5289 | 5612 | 4863 | 5816 |
| 5211 | 5636 | 4702 | 6572 |
| 5230 | 5644 | 4770 | 5876 |
| 5221 | 5645 | 4755 | 5875 |
| 5232 | 5646 | 4772 | null |
| 5291 | 5647 | 4865 | 7054 |
| 5282 | 5648 | 4853 | 7157 |
| 5214 | 5660 | 4724 | 5878 |
| 5258 | 5661 | 4806 | 8018 |
| 5288 | 5687 | 4862 | 7470 |
| 5243 | 5688 | 4785 | 7451 |
| 5248 | 5689 | 4794 | null |
| 5293 | 5703 | 4867 | 6499 |
| 5222 | 5704 | 4756 | 6344 |
| 5246 | 5708 | 4792 | 6713 |
| 5225 | 5717 | 4763 | 6754 |
| 5242 | 5718 | 4784 | null |
| 5238 | 5720 | 4779 | 6379 |
| 5239 | 5721 | 4780 | 6716 |
| 5235 | 5722 | 4775 | null |
| 5247 | 5743 | 4793 | 6636 |
| 5224 | 5790 | 4762 | 5791 |
| 5224 | 5791 | 5790 | 6021 |
| 5289 | 5816 | 5612 | 6031 |
| 5221 | 5875 | 5645 | 6067 |
| 5230 | 5876 | 5644 | 6068 |
| 5214 | 5878 | 5660 | 6069 |
| 5227 | 5910 | 4765 | 6673 |
| 5223 | 5911 | 4757 | 6324 |
| 5226 | 5912 | 4764 | 6604 |
| 5219 | 5913 | 4733 | null |
| 5218 | 5914 | 4732 | null |
| 5240 | 5915 | 4782 | 6730 |
| 5217 | 5916 | 4731 | 6331 |
| 5241 | 5917 | 4783 | 6333 |
| 5237 | 5918 | 4778 | 6336 |
| 5231 | 5919 | 4771 | null |
| 5292 | 5920 | 4866 | null |
| 5287 | 5921 | 4859 | 6514 |
| 5290 | 5922 | 4864 | 6571 |
| 5296 | 5923 | 4879 | 6467 |
| 5297 | 5924 | 4880 | null |
| 5207 | 5948 | 4697 | 6153 |
| 5208 | 5949 | 4698 | 6154 |
| 5215 | 5950 | 4728 | 6170 |
| 5224 | 6021 | 5791 | null |
| 5289 | 6031 | 5816 | null |
| 5221 | 6067 | 5875 | 6087 |
| 5230 | 6068 | 5876 | null |
| 5214 | 6069 | 5878 | null |
| 5221 | 6087 | 6067 | 6092 |
| 5221 | 6092 | 6087 | null |
| 5207 | 6153 | 5948 | 6240 |
| 5208 | 6154 | 5949 | 6242 |
| 5215 | 6170 | 5950 | 6256 |
| 5249 | 6188 | 5549 | 6267 |
| 5281 | 6189 | 5550 | 6268 |
| 5252 | 6193 | 5552 | 6269 |
| 5264 | 6194 | 5553 | 6270 |
| 5280 | 6196 | 5554 | 6271 |
| 5262 | 6197 | 5555 | 6272 |
| 5265 | 6199 | 5556 | 6273 |
| 5263 | 6200 | 5557 | 6274 |
| 5256 | 6206 | 5560 | 6278 |
| 5207 | 6240 | 6153 | null |
| 5208 | 6242 | 6154 | null |
| 5215 | 6256 | 6170 | null |
| 5249 | 6267 | 6188 | null |
| 5281 | 6268 | 6189 | null |
| 5252 | 6269 | 6193 | null |
| 5264 | 6270 | 6194 | null |
| 5280 | 6271 | 6196 | null |
| 5262 | 6272 | 6197 | null |
| 5265 | 6273 | 6199 | null |
| 5263 | 6274 | 6200 | null |
| 5256 | 6278 | 6206 | null |
| 5223 | 6324 | 5911 | 6414 |
| 5217 | 6331 | 5916 | 6420 |
| 5241 | 6333 | 5917 | 6421 |
| 5237 | 6336 | 5918 | 6424 |
| 5222 | 6344 | 5704 | 6427 |
| 5238 | 6379 | 5720 | 6441 |
| 5209 | 6381 | 5287 | 6382 |
| 5209 | 6382 | 6381 | 6757 |
| 5233 | 6383 | 5289 | 6384 |
| 5233 | 6384 | 6383 | 6580 |
| 5236 | 6398 | 5302 | 6399 |
| 5236 | 6399 | 6398 | 6469 |
| 5202 | 6402 | 5420 | 6403 |
| 5202 | 6403 | 6402 | 6900 |
| 5223 | 6414 | 6324 | null |
| 5217 | 6420 | 6331 | null |
| 5241 | 6421 | 6333 | null |
| 5237 | 6424 | 6336 | null |
| 5222 | 6427 | 6344 | 7298 |
| 5238 | 6441 | 6379 | null |
| 5296 | 6467 | 5923 | 6483 |
| 5236 | 6469 | 6399 | 6486 |
| 5296 | 6483 | 6467 | null |
| 5236 | 6486 | 6469 | null |
| 5293 | 6499 | 5703 | 6531 |
| 5287 | 6514 | 5921 | 6538 |
| 5293 | 6531 | 6499 | null |
| 5287 | 6538 | 6514 | null |
| 5290 | 6571 | 5922 | 6641 |
| 5211 | 6572 | 5636 | 6642 |
| 5233 | 6580 | 6384 | 6621 |
| 5226 | 6604 | 5912 | 6651 |
| 5233 | 6621 | 6580 | 6831 |
| 5247 | 6636 | 5743 | 6667 |
| 5290 | 6641 | 6571 | null |
| 5211 | 6642 | 6572 | null |
| 5226 | 6651 | 6604 | 6723 |
| 5247 | 6667 | 6636 | null |
| 5227 | 6673 | 5910 | 6679 |
| 5227 | 6679 | 6673 | null |
| 5246 | 6713 | 5708 | 6907 |
| 5239 | 6716 | 5721 | 6910 |
| 5226 | 6723 | 6651 | 6912 |
| 5240 | 6730 | 5915 | 6913 |
| 5225 | 6754 | 5717 | 6920 |
| 5209 | 6757 | 6382 | 6856 |
| 5233 | 6831 | 6621 | 6832 |
| 5233 | 6832 | 6831 | 6838 |
| 5233 | 6838 | 6832 | 6867 |
| 5209 | 6856 | 6757 | null |
| 5233 | 6867 | 6838 | null |
| 5202 | 6900 | 6403 | 6938 |
| 5246 | 6907 | 6713 | 6981 |
| 5239 | 6910 | 6716 | 6997 |
| 5226 | 6912 | 6723 | null |
| 5240 | 6913 | 6730 | null |
| 5225 | 6920 | 6754 | null |
| 5202 | 6938 | 6900 | 7634 |
| 5246 | 6981 | 6907 | 7047 |
| 5239 | 6997 | 6910 | 7003 |
| 5239 | 7003 | 6997 | 7042 |
| 5206 | 7011 | 5070 | 7414 |
| 5204 | 7012 | 5075 | 7411 |
| 5205 | 7021 | 5074 | 7408 |
| 5239 | 7042 | 7003 | 7043 |
| 5239 | 7043 | 7042 | null |
| 5246 | 7047 | 6981 | null |
| 5291 | 7054 | 5647 | 7132 |
| 5291 | 7132 | 7054 | null |
| 5282 | 7157 | 5648 | null |
| 5228 | 7191 | 5589 | 7281 |
| 5234 | 7265 | 5592 | 7293 |
| 5228 | 7281 | 7191 | null |
| 5234 | 7293 | 7265 | null |
| 5222 | 7298 | 6427 | 7300 |
| 5222 | 7300 | 7298 | null |
| 5212 | 7390 | 5611 | 7440 |
| 5205 | 7408 | 7021 | 7409 |
| 5205 | 7409 | 7408 | 7410 |
| 5205 | 7410 | 7409 | 7422 |
| 5204 | 7411 | 7012 | 7412 |
| 5204 | 7412 | 7411 | 7413 |
| 5204 | 7413 | 7412 | 7423 |
| 5206 | 7414 | 7011 | 7415 |
| 5206 | 7415 | 7414 | 7416 |
| 5206 | 7416 | 7415 | 7421 |
| 5206 | 7421 | 7416 | 7429 |
| 5205 | 7422 | 7410 | 7427 |
| 5204 | 7423 | 7413 | 7426 |
| 5204 | 7426 | 7423 | 7430 |
| 5205 | 7427 | 7422 | null |
| 5206 | 7429 | 7421 | null |
| 5204 | 7430 | 7426 | 7431 |
| 5204 | 7431 | 7430 | null |
| 5212 | 7440 | 7390 | null |
| 5243 | 7451 | 5688 | 7468 |
| 5243 | 7468 | 7451 | 7551 |
| 5288 | 7470 | 5687 | 7711 |
| 5243 | 7551 | 7468 | 7795 |
| 5202 | 7634 | 6938 | 7635 |
| 5202 | 7635 | 7634 | 7636 |
| 5202 | 7636 | 7635 | 7707 |
| 5202 | 7707 | 7636 | null |
| 5288 | 7711 | 7470 | null |
| 5243 | 7795 | 7551 | 7917 |
| 5243 | 7917 | 7795 | 7919 |
| 5243 | 7919 | 7917 | null |
| 5201 | 7923 | null | 7941 |
| 5201 | 7941 | 7923 | null |
| 5258 | 8018 | 5661 | null |
| QUERY PLAN |
|---|
| HashAggregate (cost=34813.50..43770.50 rows=200 width=12) (actual time=9.572..13.889 rows=87 loops=1) |
| Group Key: events.grp |
| Batches: 1 Memory Usage: 40kB |
| CTE ev_priorposterior |
| -> Index Scan using events_pkey on events ev (cost=0.15..34778.63 rows=995 width=16) (actual time=0.038..9.319 rows=314 loops=1) |
| Filter: (NOT deleted) |
| Rows Removed by Filter: 1 |
| SubPlan 1 |
| -> Seq Scan on events ev2 (cost=0.00..34.88 rows=5 width=4) (actual time=0.021..0.027 rows=1 loops=314) |
| Filter: ((NOT deleted) AND (prior = ev.id)) |
| Rows Removed by Filter: 314 |
| -> Seq Scan on events (cost=0.00..29.90 rows=1990 width=4) (actual time=0.010..0.030 rows=315 loops=1) |
| SubPlan 3 |
| -> CTE Scan on ev_priorposterior epp (cost=0.00..22.39 rows=1 width=4) (actual time=0.022..0.132 rows=1 loops=87) |
| Filter: ((prior IS NULL) AND (events.grp = grp)) |
| Rows Removed by Filter: 313 |
| SubPlan 4 |
| -> CTE Scan on ev_priorposterior epp_1 (cost=0.00..22.39 rows=1 width=4) (actual time=0.014..0.026 rows=1 loops=87) |
| Filter: ((posterior IS NULL) AND (events.grp = grp)) |
| Rows Removed by Filter: 313 |
| Planning Time: 0.149 ms |
| Execution Time: 13.932 ms |
| QUERY PLAN |
|---|
| GroupAggregate (cost=1373.39..1436.29 rows=200 width=12) (actual time=1.433..1.598 rows=87 loops=1) |
| Group Key: "*SELECT* 1".grp |
| CTE n |
| -> Recursive Union (cost=0.00..560.76 rows=4990 width=16) (actual time=0.011..1.027 rows=314 loops=1) |
| -> Seq Scan on events (cost=0.00..29.90 rows=10 width=16) (actual time=0.010..0.036 rows=87 loops=1) |
| Filter: (prior IS NULL) |
| Rows Removed by Filter: 228 |
| -> Hash Join (cost=3.25..43.11 rows=498 width=16) (actual time=0.048..0.075 rows=19 loops=12) |
| Hash Cond: (t.prior = n_2.id) |
| -> Seq Scan on events t (cost=0.00..29.90 rows=995 width=12) (actual time=0.006..0.040 rows=314 loops=12) |
| Filter: (NOT deleted) |
| Rows Removed by Filter: 1 |
| -> Hash (cost=2.00..2.00 rows=100 width=8) (actual time=0.008..0.008 rows=26 loops=12) |
| Buckets: 1024 Batches: 1 Memory Usage: 12kB |
| -> WorkTable Scan on n n_2 (cost=0.00..2.00 rows=100 width=8) (actual time=0.001..0.003 rows=26 loops=12) |
| -> Merge Append (cost=812.62..870.52 rows=400 width=9) (actual time=1.426..1.555 rows=174 loops=1) |
| Sort Key: "*SELECT* 1".grp |
| -> Subquery Scan on "*SELECT* 1" (cost=406.31..433.26 rows=200 width=9) (actual time=1.263..1.320 rows=87 loops=1) |
| -> Unique (cost=406.31..431.26 rows=200 width=17) (actual time=1.262..1.309 rows=87 loops=1) |
| -> Sort (cost=406.31..418.78 rows=4990 width=17) (actual time=1.262..1.278 rows=314 loops=1) |
| Sort Key: n.grp, n.place |
| Sort Method: quicksort Memory: 39kB |
| -> CTE Scan on n (cost=0.00..99.80 rows=4990 width=17) (actual time=0.012..1.127 rows=314 loops=1) |
| -> Subquery Scan on "*SELECT* 2" (cost=406.31..433.26 rows=200 width=9) (actual time=0.162..0.216 rows=87 loops=1) |
| -> Unique (cost=406.31..431.26 rows=200 width=17) (actual time=0.161..0.206 rows=87 loops=1) |
| -> Sort (cost=406.31..418.78 rows=4990 width=17) (actual time=0.161..0.176 rows=314 loops=1) |
| Sort Key: n_1.grp, n_1.place DESC |
| Sort Method: quicksort Memory: 39kB |
| -> CTE Scan on n n_1 (cost=0.00..99.80 rows=4990 width=17) (actual time=0.001..0.041 rows=314 loops=1) |
| Planning Time: 0.274 ms |
| Execution Time: 1.752 ms |