explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r0B5

Settings
# exclusive inclusive rows x rows loops node
1. 11,834.402 1,299,951.441 ↑ 383.9 153 1

Hash Left Join (cost=58,547,236.050..101,471,476.300 rows=58,741 width=98) (actual time=1,288,246.355..1,299,951.441 rows=153 loops=1)

  • Hash Cond: (november_echo.yankee_whiskey = sierra_two.mike_zulu)
  • Join Filter: ((sierra_two.charlie_sierra_quebec <= november_echo.charlie_sierra_quebec) AND (sierra_two.three_hotel > november_echo.charlie_sierra_quebec))
  • Rows Removed by Join Filter: 368
2. 66,495.255 589,313.792 ↑ 61.8 153 1

Hash Right Join (cost=18,291,838.520..53,981,949.110 rows=9,456 width=93) (actual time=290,739.498..589,313.792 rows=153 loops=1)

  • Hash Cond: (foxtrot_romeo.mike_zulu = november_echo.hotel_golf)
  • Join Filter: ((foxtrot_romeo.charlie_sierra_quebec <= november_echo.charlie_sierra_quebec) AND (foxtrot_romeo.three_hotel > november_echo.charlie_sierra_quebec))
  • Rows Removed by Join Filter: 320
3. 68,794.494 256,936.324 ↓ 1.0 1,053,191,259 1

Append (cost=0.000..19,890,993.350 rows=1,053,189,375 width=32) (actual time=444.546..256,936.324 rows=1,053,191,259 loops=1)

4. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on zulu_foxtrot_echo foxtrot_romeo (cost=0.000..0.000 rows=1 width=32) (actual time=0.015..0.015 rows=0 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
5. 22,210.344 22,210.344 ↓ 1.0 105,319,125 1

Foreign Scan on uniform_uniform seven_foxtrot (cost=0.000..1,462,502.070 rows=105,318,621 width=32) (actual time=444.529..22,210.344 rows=105,319,125 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 24678
  • CStore File: /srv/cstore/stdb/2019-07/st_beprov_part0.cstore
  • CStore File Size: 4177641207
6. 18,458.195 18,458.195 ↑ 1.0 105,319,126 1

Foreign Scan on seven_sierra november_lima (cost=0.000..1,462,505.030 rows=105,321,191 width=32) (actual time=41.068..18,458.195 rows=105,319,126 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 24678
  • CStore File: /srv/cstore/stdb/2019-07/st_beprov_part1.cstore
  • CStore File Size: 4177719510
7. 17,913.700 17,913.700 ↓ 1.0 105,319,126 1

Foreign Scan on quebec_november echo_india (cost=0.000..1,462,505.890 rows=105,317,612 width=32) (actual time=41.288..17,913.700 rows=105,319,126 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 24678
  • CStore File: /srv/cstore/stdb/2019-07/st_beprov_part2.cstore
  • CStore File Size: 4177743255
8. 17,783.834 17,783.834 ↑ 1.0 105,319,126 1

Foreign Scan on kilo_november_two mike_three (cost=0.000..1,462,503.600 rows=105,319,929 width=32) (actual time=40.128..17,783.834 rows=105,319,126 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 24678
  • CStore File: /srv/cstore/stdb/2019-07/st_beprov_part3.cstore
  • CStore File Size: 4177679124
9. 18,542.409 18,542.409 ↓ 1.0 105,319,126 1

Foreign Scan on foxtrot_two delta_victor (cost=0.000..1,462,504.740 rows=105,317,926 width=32) (actual time=37.137..18,542.409 rows=105,319,126 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 24678
  • CStore File: /srv/cstore/stdb/2019-07/st_beprov_part4.cstore
  • CStore File Size: 4177713900
10. 17,973.410 17,973.410 ↑ 1.0 105,319,126 1

Foreign Scan on zulu_juliet charlie_alpha (cost=0.000..1,462,504.460 rows=105,319,471 width=32) (actual time=39.562..17,973.410 rows=105,319,126 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 24678
  • CStore File: /srv/cstore/stdb/2019-07/st_beprov_part5.cstore
  • CStore File Size: 4177704713
11. 17,941.638 17,941.638 ↓ 1.0 105,319,126 1

Foreign Scan on quebec_victor romeo_alpha (cost=0.000..1,462,504.740 rows=105,318,736 width=32) (actual time=37.695..17,941.638 rows=105,319,126 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 24678
  • CStore File: /srv/cstore/stdb/2019-07/st_beprov_part6.cstore
  • CStore File Size: 4177711944
12. 19,024.052 19,024.052 ↓ 1.0 105,319,126 1

Foreign Scan on two_mike whiskey_uniform (cost=0.000..1,462,504.740 rows=105,318,033 width=32) (actual time=37.985..19,024.052 rows=105,319,126 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 24678
  • CStore File: /srv/cstore/stdb/2019-07/st_beprov_part7.cstore
  • CStore File Size: 4177711152
13. 19,181.452 19,181.452 ↓ 1.0 105,319,126 1

Foreign Scan on quebec_charlie echo_oscar (cost=0.000..1,462,504.740 rows=105,318,209 width=32) (actual time=37.167..19,181.452 rows=105,319,126 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 24678
  • CStore File: /srv/cstore/stdb/2019-07/st_beprov_part8.cstore
  • CStore File Size: 4177714743
14. 19,112.781 19,112.781 ↑ 1.0 105,319,126 1

Foreign Scan on romeo_zulu delta_seven (cost=0.000..1,462,506.460 rows=105,319,646 width=32) (actual time=38.744..19,112.781 rows=105,319,126 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 24678
  • CStore File: /srv/cstore/stdb/2019-07/st_beprov_part9.cstore
  • CStore File Size: 4177756754
15. 0.111 265,882.213 ↑ 14.3 153 1

Hash (cost=18,291,811.130..18,291,811.130 rows=2,191 width=85) (actual time=265,882.213..265,882.213 rows=153 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 45kB
16. 15,453.478 265,882.102 ↑ 14.3 153 1

Hash Right Join (cost=12,999,570.420..18,291,811.130 rows=2,191 width=85) (actual time=196,104.976..265,882.102 rows=153 loops=1)

  • Hash Cond: (sierra_november.mike_zulu = november_echo.yankee_whiskey)
  • Join Filter: ((sierra_november.charlie_sierra_quebec <= november_echo.charlie_sierra_quebec) AND (sierra_november.three_hotel > november_echo.charlie_sierra_quebec))
  • Rows Removed by Join Filter: 157
17. 15,402.210 60,919.373 ↓ 1.0 242,935,920 1

Append (cost=0.000..4,380,936.180 rows=242,935,676 width=20) (actual time=91.225..60,919.373 rows=242,935,920 loops=1)

18. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on papa_three sierra_november (cost=0.000..0.000 rows=1 width=20) (actual time=0.015..0.015 rows=0 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
19. 5,001.755 5,001.755 ↓ 1.0 26,992,880 1

Foreign Scan on alpha_seven bravo_alpha_six (cost=0.000..351,806.270 rows=26,992,662 width=20) (actual time=91.209..5,001.755 rows=26,992,880 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 5830
  • CStore File: /srv/cstore/stdb/2019-07/st_vertrag_part0.cstore
  • CStore File Size: 1666070207
20. 5,099.325 5,099.325 ↓ 1.0 26,992,880 1

Foreign Scan on kilo_three three_romeo (cost=0.000..351,806.150 rows=26,992,845 width=20) (actual time=89.827..5,099.325 rows=26,992,880 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 5831
  • CStore File: /srv/cstore/stdb/2019-07/st_vertrag_part1.cstore
  • CStore File Size: 1666051910
21. 4,955.057 4,955.057 ↓ 1.0 26,992,880 1

Foreign Scan on alpha_yankee mike_echo (cost=0.000..351,806.220 rows=26,992,672 width=20) (actual time=86.938..4,955.057 rows=26,992,880 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 5831
  • CStore File: /srv/cstore/stdb/2019-07/st_vertrag_part2.cstore
  • CStore File Size: 1666063690
22. 5,143.308 5,143.308 ↑ 1.0 26,992,880 1

Foreign Scan on xray seven_zulu (cost=0.000..351,807.280 rows=26,993,339 width=20) (actual time=94.037..5,143.308 rows=26,992,880 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 5831
  • CStore File: /srv/cstore/stdb/2019-07/st_vertrag_part3.cstore
  • CStore File Size: 1666182541
23. 5,039.655 5,039.655 ↑ 1.0 26,992,880 1

Foreign Scan on juliet_delta golf_two (cost=0.000..351,806.080 rows=26,992,970 width=20) (actual time=87.398..5,039.655 rows=26,992,880 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 5831
  • CStore File: /srv/cstore/stdb/2019-07/st_vertrag_part4.cstore
  • CStore File Size: 1666042114
24. 4,996.308 4,996.308 ↑ 1.0 26,992,880 1

Foreign Scan on delta_three yankee_quebec (cost=0.000..351,807.490 rows=26,992,898 width=20) (actual time=86.335..4,996.308 rows=26,992,880 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 5831
  • CStore File: /srv/cstore/stdb/2019-07/st_vertrag_part5.cstore
  • CStore File Size: 1666204345
25. 5,154.530 5,154.530 ↓ 1.0 26,992,880 1

Foreign Scan on bravo_golf sierra_golf_golf (cost=0.000..351,805.870 rows=26,992,800 width=20) (actual time=94.288..5,154.530 rows=26,992,880 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 5831
  • CStore File: /srv/cstore/stdb/2019-07/st_vertrag_part6.cstore
  • CStore File Size: 1666015385
26. 5,018.989 5,018.989 ↓ 1.0 26,992,880 1

Foreign Scan on sierra_golf_papa golf_bravo (cost=0.000..351,806.080 rows=26,992,629 width=20) (actual time=91.681..5,018.989 rows=26,992,880 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 5831
  • CStore File: /srv/cstore/stdb/2019-07/st_vertrag_part7.cstore
  • CStore File Size: 1666044418
27. 5,108.221 5,108.221 ↓ 1.0 26,992,880 1

Foreign Scan on victor three_alpha (cost=0.000..351,806.340 rows=26,992,860 width=20) (actual time=83.414..5,108.221 rows=26,992,880 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 5830
  • CStore File: /srv/cstore/stdb/2019-07/st_vertrag_part8.cstore
  • CStore File Size: 1666076690
28. 0.049 189,509.251 ↑ 12.1 153 1

Hash (cost=12,999,547.290..12,999,547.290 rows=1,850 width=81) (actual time=189,509.251..189,509.251 rows=153 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 29kB
29. 120.006 189,509.202 ↑ 12.1 153 1

Hash Right Join (cost=12,388,518.520..12,999,547.290 rows=1,850 width=81) (actual time=185,882.558..189,509.202 rows=153 loops=1)

  • Hash Cond: (five_sierra1.mike_zulu = november_echo.yankee_whiskey)
  • Join Filter: ((five_sierra1.charlie_sierra_quebec <= november_echo.charlie_sierra_quebec) AND (five_sierra1.three_hotel > november_echo.charlie_sierra_quebec))
  • Rows Removed by Join Filter: 3
30. 1,024.772 3,754.977 ↑ 1.0 1,585,762 1

Gather (cost=1,000.000..606,067.940 rows=1,588,101 width=24) (actual time=21.579..3,754.977 rows=1,585,762 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
31. 0.000 2,730.205 ↑ 1.3 396,440 4

Parallel Append (cost=0.000..446,257.840 rows=512,290 width=24) (actual time=17.847..2,730.205 rows=396,440 loops=4)

32. 3,623.778 3,623.778 ↑ 1.0 528,587 1

Foreign Scan on papa_victor november_victor (cost=0.000..443,696.390 rows=529,915 width=24) (actual time=25.286..3,623.778 rows=528,587 loops=1)

  • Filter: ((romeo_golf = 'two_sierra'::timestamp without time zone) AND ((charlie_india)::text = 'romeo_november'::text))
  • Rows Removed by Filter: 26666496
  • CStore File: /srv/cstore/stdb/2019-07/st_zuna_k_part0.cstore
  • CStore File Size: 781409574
33. 3,657.004 3,657.004 ↓ 1.0 528,588 1

Foreign Scan on three_delta six_charlie (cost=0.000..443,696.390 rows=528,228 width=24) (actual time=25.428..3,657.004 rows=528,588 loops=1)

  • Filter: ((romeo_golf = 'two_sierra'::timestamp without time zone) AND ((charlie_india)::text = 'romeo_november'::text))
  • Rows Removed by Filter: 26666495
  • CStore File: /srv/cstore/stdb/2019-07/st_zuna_k_part2.cstore
  • CStore File Size: 781407854
34. 3,531.518 3,531.518 ↑ 1.0 528,587 1

Foreign Scan on romeo_kilo whiskey_lima (cost=0.000..443,696.010 rows=529,957 width=24) (actual time=20.667..3,531.518 rows=528,587 loops=1)

  • Filter: ((romeo_golf = 'two_sierra'::timestamp without time zone) AND ((charlie_india)::text = 'romeo_november'::text))
  • Rows Removed by Filter: 26666497
  • CStore File: /srv/cstore/stdb/2019-07/st_zuna_k_part1.cstore
  • CStore File Size: 781400124
35. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on charlie_kilo_charlie seven_charlie (cost=0.000..0.000 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((romeo_golf = 'two_sierra'::timestamp without time zone) AND ((charlie_india)::text = 'romeo_november'::text))
36. 0.056 185,634.219 ↑ 12.1 153 1

Hash (cost=12,387,495.390..12,387,495.390 rows=1,850 width=73) (actual time=185,634.219..185,634.219 rows=153 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 28kB
37. 0.078 185,634.163 ↑ 12.1 153 1

Hash Left Join (cost=11,626,243.880..12,387,495.390 rows=1,850 width=73) (actual time=182,737.249..185,634.163 rows=153 loops=1)

  • Hash Cond: (november_echo.hotel_golf = kilo_foxtrot1.mike_zulu)
  • Join Filter: ((kilo_foxtrot1.charlie_sierra_quebec <= november_echo.charlie_sierra_quebec) AND (kilo_foxtrot1.three_hotel > november_echo.charlie_sierra_quebec))
38. 0.069 178,848.155 ↑ 12.1 153 1

Hash Left Join (cost=11,180,956.960..11,942,152.960 rows=1,850 width=65) (actual time=175,951.298..178,848.155 rows=153 loops=1)

  • Hash Cond: (november_echo.yankee_whiskey = five_tango1.mike_zulu)
  • Join Filter: ((five_tango1.charlie_sierra_quebec <= november_echo.charlie_sierra_quebec) AND (five_tango1.three_hotel > november_echo.charlie_sierra_quebec))
39. 2,168.746 172,104.332 ↑ 12.1 153 1

Hash Right Join (cost=10,735,670.040..11,496,810.530 rows=1,850 width=57) (actual time=169,207.532..172,104.332 rows=153 loops=1)

  • Hash Cond: (echo_foxtrot.hotel_delta = november_echo.hotel_delta)
  • Join Filter: ((echo_foxtrot.charlie_sierra_quebec <= november_echo.charlie_sierra_quebec) AND (echo_foxtrot.three_hotel > november_echo.charlie_sierra_quebec))
  • Rows Removed by Join Filter: 122
40. 2,232.186 9,482.754 ↑ 1.0 34,020,007 1

Append (cost=0.000..633,427.110 rows=34,020,184 width=42) (actual time=19.341..9,482.754 rows=34,020,007 loops=1)

41. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on bravo_alpha_five echo_foxtrot (cost=0.000..0.000 rows=1 width=48) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
42. 7,250.560 7,250.560 ↑ 1.0 34,020,007 1

Foreign Scan on lima papa_delta (cost=0.000..463,326.190 rows=34,020,183 width=42) (actual time=19.331..7,250.560 rows=34,020,007 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 6991
  • CStore File: /srv/cstore/stdb/2019-07/st_fahrzeug_k_part0.cstore
  • CStore File Size: 3384330537
43. 0.085 160,452.832 ↑ 12.1 153 1

Hash (cost=10,735,646.920..10,735,646.920 rows=1,850 width=39) (actual time=160,452.832..160,452.832 rows=153 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 27kB
44. 106.837 160,452.747 ↑ 12.1 153 1

Hash Left Join (cost=9,253,300.970..10,735,646.920 rows=1,850 width=39) (actual time=157,876.403..160,452.747 rows=153 loops=1)

  • Hash Cond: (november_echo.hotel_golf = whiskey_sierra1.mike_zulu)
  • Join Filter: ((whiskey_sierra1.charlie_sierra_quebec <= november_echo.charlie_sierra_quebec) AND (whiskey_sierra1.three_hotel > november_echo.charlie_sierra_quebec))
  • Rows Removed by Join Filter: 2
45. 2,511.542 154,861.080 ↑ 12.1 153 1

Hash Left Join (cost=8,618,075.780..10,091,021.180 rows=1,850 width=31) (actual time=152,369.377..154,861.080 rows=153 loops=1)

  • Hash Cond: ((mike_xray.hotel_delta = november_echo.hotel_delta) AND (mike_xray.charlie_sierra_quebec = november_echo.charlie_sierra_quebec))
46. 0.062 0.062 ↑ 12.1 153 1

Seq Scan on charlie_six mike_xray (cost=0.000..28.500 rows=1,850 width=12) (actual time=0.029..0.062 rows=153 loops=1)

47. 55,139.697 152,349.476 ↑ 1.0 215,073,385 1

Hash (cost=3,921,742.680..3,921,742.680 rows=215,073,540 width=31) (actual time=152,349.476..152,349.476 rows=215,073,385 loops=1)

  • Buckets: 131072 Batches: 4096 Memory Usage: 4193kB
48. 18,854.739 97,209.779 ↑ 1.0 215,073,385 1

Append (cost=0.000..3,921,742.680 rows=215,073,540 width=31) (actual time=162.322..97,209.779 rows=215,073,385 loops=1)

49. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on quebec_hotel november_echo (cost=0.000..0.000 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
50. 8,708.997 8,708.997 ↓ 1.0 26,884,173 1

Foreign Scan on romeo_papa romeo_five (cost=0.000..355,796.660 rows=26,884,039 width=31) (actual time=162.319..8,708.997 rows=26,884,173 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 4984
  • CStore File: /srv/cstore/stdb/2019-07/stdm_police_k_part0.cstore
  • CStore File Size: 7658735723
51. 9,122.330 9,122.330 ↑ 1.0 26,884,173 1

Foreign Scan on juliet_xray five_bravo (cost=0.000..355,797.650 rows=26,884,175 width=31) (actual time=149.402..9,122.330 rows=26,884,173 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 4985
  • CStore File: /srv/cstore/stdb/2019-07/stdm_police_k_part1.cstore
  • CStore File Size: 7659116835
52. 10,587.576 10,587.576 ↑ 1.0 26,884,173 1

Foreign Scan on five_golf zulu_foxtrot_romeo (cost=0.000..355,796.810 rows=26,884,193 width=31) (actual time=160.921..10,587.576 rows=26,884,173 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 4985
  • CStore File: /srv/cstore/stdb/2019-07/stdm_police_k_part2.cstore
  • CStore File Size: 7658787776
53. 9,211.882 9,211.882 ↑ 1.0 26,884,173 1

Foreign Scan on uniform_delta mike_papa (cost=0.000..355,796.480 rows=26,884,462 width=31) (actual time=145.503..9,211.882 rows=26,884,173 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 4985
  • CStore File: /srv/cstore/stdb/2019-07/stdm_police_k_part3.cstore
  • CStore File Size: 7658657983
54. 9,713.229 9,713.229 ↑ 1.0 26,884,173 1

Foreign Scan on hotel_foxtrot papa_uniform (cost=0.000..355,796.370 rows=26,884,345 width=31) (actual time=172.106..9,713.229 rows=26,884,173 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 4985
  • CStore File: /srv/cstore/stdb/2019-07/stdm_police_k_part4.cstore
  • CStore File Size: 7658612452
55. 10,403.648 10,403.648 ↑ 1.0 26,884,173 1

Foreign Scan on seven_four india_seven (cost=0.000..355,796.410 rows=26,884,228 width=31) (actual time=163.001..10,403.648 rows=26,884,173 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 4985
  • CStore File: /srv/cstore/stdb/2019-07/stdm_police_k_part5.cstore
  • CStore File Size: 7658627684
56. 9,098.014 9,098.014 ↓ 1.0 26,884,173 1

Foreign Scan on seven_yankee six_quebec (cost=0.000..355,797.440 rows=26,883,869 width=31) (actual time=698.685..9,098.014 rows=26,884,173 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 4985
  • CStore File: /srv/cstore/stdb/2019-07/stdm_police_k_part6.cstore
  • CStore File Size: 7659030163
57. 11,509.362 11,509.362 ↑ 1.0 26,884,174 1

Foreign Scan on six_india_tango six_india_xray (cost=0.000..355,797.150 rows=26,884,228 width=31) (actual time=149.425..11,509.362 rows=26,884,174 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 4984
  • CStore File: /srv/cstore/stdb/2019-07/stdm_police_k_part7.cstore
  • CStore File Size: 7658917380
58. 229.443 5,484.830 ↑ 1.0 1,585,762 1

Hash (cost=606,067.940..606,067.940 rows=1,588,101 width=24) (actual time=5,484.829..5,484.830 rows=1,585,762 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 6452kB
59. 1,422.060 5,255.387 ↑ 1.0 1,585,762 1

Gather (cost=1,000.000..606,067.940 rows=1,588,101 width=24) (actual time=60.979..5,255.387 rows=1,585,762 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
60. 0.000 3,833.327 ↑ 1.3 396,440 4

Parallel Append (cost=0.000..446,257.840 rows=512,290 width=24) (actual time=47.066..3,833.327 rows=396,440 loops=4)

61. 5,074.182 5,074.182 ↑ 1.0 528,587 1

Foreign Scan on papa_victor quebec_alpha (cost=0.000..443,696.390 rows=529,915 width=24) (actual time=56.704..5,074.182 rows=528,587 loops=1)

  • Filter: ((romeo_golf = 'two_sierra'::timestamp without time zone) AND ((charlie_india)::text = 'romeo_november'::text))
  • Rows Removed by Filter: 26666496
  • CStore File: /srv/cstore/stdb/2019-07/st_zuna_k_part0.cstore
  • CStore File Size: 781409574
62. 5,131.134 5,131.134 ↓ 1.0 528,588 1

Foreign Scan on three_delta juliet_zulu (cost=0.000..443,696.390 rows=528,228 width=24) (actual time=71.592..5,131.134 rows=528,588 loops=1)

  • Filter: ((romeo_golf = 'two_sierra'::timestamp without time zone) AND ((charlie_india)::text = 'romeo_november'::text))
  • Rows Removed by Filter: 26666495
  • CStore File: /srv/cstore/stdb/2019-07/st_zuna_k_part2.cstore
  • CStore File Size: 781407854
63. 5,018.622 5,018.622 ↑ 1.0 528,587 1

Foreign Scan on romeo_kilo charlie_sierra_two (cost=0.000..443,696.010 rows=529,957 width=24) (actual time=59.959..5,018.622 rows=528,587 loops=1)

  • Filter: ((romeo_golf = 'two_sierra'::timestamp without time zone) AND ((charlie_india)::text = 'romeo_november'::text))
  • Rows Removed by Filter: 26666497
  • CStore File: /srv/cstore/stdb/2019-07/st_zuna_k_part1.cstore
  • CStore File Size: 781400124
64. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on charlie_kilo_charlie mike_juliet (cost=0.000..0.000 rows=1 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: ((romeo_golf = 'two_sierra'::timestamp without time zone) AND ((charlie_india)::text = 'romeo_november'::text))
65. 0.639 6,743.754 ↓ 1.0 5,294 1

Hash (cost=445,222.230..445,222.230 rows=5,175 width=24) (actual time=6,743.754..6,743.754 rows=5,294 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 354kB
66. 4,141.227 6,743.115 ↓ 1.0 5,294 1

Gather (cost=1,000.000..445,222.230 rows=5,175 width=24) (actual time=108.102..6,743.115 rows=5,294 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
67. 0.000 2,601.888 ↑ 1.3 1,324 4

Parallel Append (cost=0.000..443,704.730 rows=1,669 width=24) (actual time=84.838..2,601.888 rows=1,324 loops=4)

68. 3,549.670 3,549.670 ↓ 1.0 1,765 1

Foreign Scan on papa_victor quebec_oscar (cost=0.000..443,696.390 rows=1,731 width=24) (actual time=115.719..3,549.670 rows=1,765 loops=1)

  • Filter: ((romeo_golf = 'two_sierra'::timestamp without time zone) AND ((charlie_india)::text = 'four_bravo'::text))
  • Rows Removed by Filter: 27193318
  • CStore File: /srv/cstore/stdb/2019-07/st_zuna_k_part0.cstore
  • CStore File Size: 781409574
69. 3,574.526 3,574.526 ↑ 1.1 1,765 1

Foreign Scan on three_delta bravo_three (cost=0.000..443,696.390 rows=1,930 width=24) (actual time=116.444..3,574.526 rows=1,765 loops=1)

  • Filter: ((romeo_golf = 'two_sierra'::timestamp without time zone) AND ((charlie_india)::text = 'four_bravo'::text))
  • Rows Removed by Filter: 27193318
  • CStore File: /srv/cstore/stdb/2019-07/st_zuna_k_part2.cstore
  • CStore File Size: 781407854
70. 3,282.985 3,282.985 ↓ 1.2 1,764 1

Foreign Scan on romeo_kilo echo_november (cost=0.000..443,696.010 rows=1,513 width=24) (actual time=107.181..3,282.985 rows=1,764 loops=1)

  • Filter: ((romeo_golf = 'two_sierra'::timestamp without time zone) AND ((charlie_india)::text = 'four_bravo'::text))
  • Rows Removed by Filter: 27193320
  • CStore File: /srv/cstore/stdb/2019-07/st_zuna_k_part1.cstore
  • CStore File Size: 781400124
71. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on charlie_kilo_charlie mike_bravo (cost=0.000..0.000 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((romeo_golf = 'two_sierra'::timestamp without time zone) AND ((charlie_india)::text = 'four_bravo'::text))
72. 0.570 6,785.930 ↓ 1.0 5,294 1

Hash (cost=445,222.230..445,222.230 rows=5,175 width=24) (actual time=6,785.930..6,785.930 rows=5,294 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 354kB
73. 4,175.807 6,785.360 ↓ 1.0 5,294 1

Gather (cost=1,000.000..445,222.230 rows=5,175 width=24) (actual time=111.800..6,785.360 rows=5,294 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
74. 0.000 2,609.553 ↑ 1.3 1,324 4

Parallel Append (cost=0.000..443,704.730 rows=1,669 width=24) (actual time=85.237..2,609.553 rows=1,324 loops=4)

75. 3,539.094 3,539.094 ↓ 1.0 1,765 1

Foreign Scan on papa_victor seven_quebec (cost=0.000..443,696.390 rows=1,731 width=24) (actual time=114.491..3,539.094 rows=1,765 loops=1)

  • Filter: ((romeo_golf = 'two_sierra'::timestamp without time zone) AND ((charlie_india)::text = 'four_bravo'::text))
  • Rows Removed by Filter: 27193318
  • CStore File: /srv/cstore/stdb/2019-07/st_zuna_k_part0.cstore
  • CStore File Size: 781409574
76. 3,570.537 3,570.537 ↑ 1.1 1,765 1

Foreign Scan on three_delta echo_sierra (cost=0.000..443,696.390 rows=1,930 width=24) (actual time=115.674..3,570.537 rows=1,765 loops=1)

  • Filter: ((romeo_golf = 'two_sierra'::timestamp without time zone) AND ((charlie_india)::text = 'four_bravo'::text))
  • Rows Removed by Filter: 27193318
  • CStore File: /srv/cstore/stdb/2019-07/st_zuna_k_part2.cstore
  • CStore File Size: 781407854
77. 3,328.213 3,328.213 ↓ 1.2 1,764 1

Foreign Scan on romeo_kilo tango (cost=0.000..443,696.010 rows=1,513 width=24) (actual time=110.774..3,328.213 rows=1,764 loops=1)

  • Filter: ((romeo_golf = 'two_sierra'::timestamp without time zone) AND ((charlie_india)::text = 'four_bravo'::text))
  • Rows Removed by Filter: 27193320
  • CStore File: /srv/cstore/stdb/2019-07/st_zuna_k_part1.cstore
  • CStore File Size: 781400124
78. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on charlie_kilo_charlie juliet_india (cost=0.000..0.000 rows=1 width=24) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: ((romeo_golf = 'two_sierra'::timestamp without time zone) AND ((charlie_india)::text = 'four_bravo'::text))
79. 292,632.246 698,803.247 ↓ 1.0 1,053,191,259 1

Hash (cost=19,890,993.350..19,890,993.350 rows=1,053,189,375 width=32) (actual time=698,803.246..698,803.247 rows=1,053,191,259 loops=1)

  • Buckets: 131072 Batches: 16384 Memory Usage: 5252kB
80. 96,159.653 406,171.001 ↓ 1.0 1,053,191,259 1

Append (cost=0.000..19,890,993.350 rows=1,053,189,375 width=32) (actual time=62.245..406,171.001 rows=1,053,191,259 loops=1)

81. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on zulu_foxtrot_echo sierra_two (cost=0.000..0.000 rows=1 width=32) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
82. 26,384.376 26,384.376 ↓ 1.0 105,319,125 1

Foreign Scan on uniform_uniform seven_kilo (cost=0.000..1,462,502.070 rows=105,318,621 width=32) (actual time=62.240..26,384.376 rows=105,319,125 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 24678
  • CStore File: /srv/cstore/stdb/2019-07/st_beprov_part0.cstore
  • CStore File Size: 4177641207
83. 32,457.858 32,457.858 ↑ 1.0 105,319,126 1

Foreign Scan on seven_sierra zulu_tango (cost=0.000..1,462,505.030 rows=105,321,191 width=32) (actual time=1,431.212..32,457.858 rows=105,319,126 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 24678
  • CStore File: /srv/cstore/stdb/2019-07/st_beprov_part1.cstore
  • CStore File Size: 4177719510
84. 31,745.406 31,745.406 ↓ 1.0 105,319,126 1

Foreign Scan on quebec_november kilo_november_whiskey (cost=0.000..1,462,505.890 rows=105,317,612 width=32) (actual time=436.730..31,745.406 rows=105,319,126 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 24678
  • CStore File: /srv/cstore/stdb/2019-07/st_beprov_part2.cstore
  • CStore File Size: 4177743255
85. 31,078.344 31,078.344 ↑ 1.0 105,319,126 1

Foreign Scan on kilo_november_two delta_golf (cost=0.000..1,462,503.600 rows=105,319,929 width=32) (actual time=439.996..31,078.344 rows=105,319,126 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 24678
  • CStore File: /srv/cstore/stdb/2019-07/st_beprov_part3.cstore
  • CStore File Size: 4177679124
86. 31,723.407 31,723.407 ↓ 1.0 105,319,126 1

Foreign Scan on foxtrot_two juliet_two (cost=0.000..1,462,504.740 rows=105,317,926 width=32) (actual time=505.994..31,723.407 rows=105,319,126 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 24678
  • CStore File: /srv/cstore/stdb/2019-07/st_beprov_part4.cstore
  • CStore File Size: 4177713900
87. 30,616.097 30,616.097 ↑ 1.0 105,319,126 1

Foreign Scan on zulu_juliet india_oscar (cost=0.000..1,462,504.460 rows=105,319,471 width=32) (actual time=434.203..30,616.097 rows=105,319,126 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 24678
  • CStore File: /srv/cstore/stdb/2019-07/st_beprov_part5.cstore
  • CStore File Size: 4177704713
88. 31,114.761 31,114.761 ↓ 1.0 105,319,126 1

Foreign Scan on quebec_victor four_papa (cost=0.000..1,462,504.740 rows=105,318,736 width=32) (actual time=433.059..31,114.761 rows=105,319,126 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 24678
  • CStore File: /srv/cstore/stdb/2019-07/st_beprov_part6.cstore
  • CStore File Size: 4177711944
89. 31,662.167 31,662.167 ↓ 1.0 105,319,126 1

Foreign Scan on two_mike charlie_kilo_papa (cost=0.000..1,462,504.740 rows=105,318,033 width=32) (actual time=442.449..31,662.167 rows=105,319,126 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 24678
  • CStore File: /srv/cstore/stdb/2019-07/st_beprov_part7.cstore
  • CStore File Size: 4177711152
90. 31,804.257 31,804.257 ↓ 1.0 105,319,126 1

Foreign Scan on quebec_charlie two_delta (cost=0.000..1,462,504.740 rows=105,318,209 width=32) (actual time=452.852..31,804.257 rows=105,319,126 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 24678
  • CStore File: /srv/cstore/stdb/2019-07/st_beprov_part8.cstore
  • CStore File Size: 4177714743
91. 31,424.671 31,424.671 ↑ 1.0 105,319,126 1

Foreign Scan on romeo_zulu india_quebec (cost=0.000..1,462,506.460 rows=105,319,646 width=32) (actual time=433.021..31,424.671 rows=105,319,126 loops=1)

  • Filter: (romeo_golf = 'two_sierra'::timestamp without time zone)
  • Rows Removed by Filter: 24678
  • CStore File: /srv/cstore/stdb/2019-07/st_beprov_part9.cstore
  • CStore File Size: 4177756754
Planning time : 361.251 ms
Execution time : 1,300,036.922 ms